Error when using Search in Explorer

[Former Member]

We are currently on BWA 7.20 Revision 17, BW 7.3 SP3, and BusinessObjects Explorer 4.0 SP2.  We recently started experiencing problems with the search functionality in Explorer.  The users can still navigate through the information space, create filters and charts.  However, when they attempt to use the search while navigating through the Information Space they will receive the below error....

Failed to retrieve a new chart from the server.

It is not possible to generate the chart. (PS 50002).

2007:Index does not exist;index=_trexlib:4ff187b7a422568be1000000c0a8c4f1_index,scripted search: function 'ps_others.search'.

We haven't experienced this error before so obviously we are thinking it has something to do with the connection or the data contained in the index itself.  We've tried re-indexing the snapshot index, re-indexing the infospace, rebooting the Explorer servers in the CMC and we even shutdown and restarted one of the blades...all to no avail.  Anyone have any ideas as to what might be going on?

Thank you.

Josh Dunlap

[former_member235179 · Accepted solution]

Hi Josh,

We don't have that error listed against our Developer database, so I would advise first of all that you log a message with SAP Support for a thorough investigation.

If you wanrt to investigate further on your own, please double check that the the BWA indexes have completed and are all showing green, i.e. no errors in RSDDTPS.

Also check what search terems are the users using when this error is thrown, it could be they are searching for a facet containing an unsupported search character i.e. a period(.) as in this Note:

1598180 - Explorer 3.2 search does not return the expected result when data contains dot symbol (.)

Alternatively you can use the TREXADMIN tool.

From there you can use Python TREXAdmin tool -> Index Mining to check the type of object being searched for in your BWA system, and use Python TREXAdmin tool -> Index Search to test the search function.

Probably best to search against BWA as Explorer uses the Apache Lucene text search engine library. At least this will tell you if the search against the BWA index source is valid, if it is then it points to a possible bug in Explorer.

I hope this is helpful.

Kind regards,

John

[Former Member · Accepted solution]

John,

Thank you for your reply.  We did indeed open a message with SAP Support, however we have not heard anything back as of yet.

The indexes all look good in RSDDTPS (green lights).

This issue is not related to note 1598180as I have tried searching in the infospace myself using simple words/phrases without any unsupported characters as I still receive the error.

I did find note 1703161 regarding traces via the TREXadmin tool so we are going to try running a python trace today.

The interesting thing about this error is that we have not experienced it before, rather it just started occurring a few days ago.  We haven't made any changes to BOE, BW, BWA so we are quite perplexed as to why this is occurring now.

[former_member235179 · Accepted solution]

Hi Josh,

One thing to test with would be a later Patch level for BI 4.0, SP04 is just out, and there have been a number of fixes in relation to Explorer. It may help. Otherwise attach the Python trace when you have it and I will take a look.

Kind regards,

John

[Former Member · Accepted solution]

John,

We will at some point move to SP04 because of the FP3 enhancements, however that may not happen for a few weeks.  The need to fix this error is urgent.

Can I email you the trace?  It's quite lengthy and it's in PDF format.

Thank you for your help.

[Former Member · Accepted solution]

John,

I have the trace in .txt format so I can copy/paste into the forum.  However, as I said before the trace is huge (almost 1100 lines).  Is there any specific that you need to see?  It's interesting though, I don't see anything indicative of an error anywhere in the trace.

Thanks,

Josh