cancel
Showing results for 
Search instead for 
Did you mean: 

Explorer in PROD refuses to Index - works in DEV

Former Member
0 Kudos

Hi everyone.  This is stumping me and could use your thoughts on the matter.

We're using a BEX query in PROD to feed a unv to run a Bus Explorer. 

After promotion it generates the error below.  I attempted to save and export to PROD with same results.

The DEV and PROD universes are both using the BEX query from PROD so no connection changes is needed.

So the BEX is common, the Connection is common.  Restarted the Explorer services as well.

Any thoughts on the matter that I'm missing?

Prompt response is very helpful as you can imagine being a production issue.

Thanks all.

------------------

Server, XXX.ExplorerIndexingServer, generated the following messages:

Index Creation Failed (

The execution of the specified analysis query failed. -The database SQL generation parameters file could not be loaded (SAP Business Warehouse, SAP BAPI) .

The database SQL generation parameters file could not be loaded (SAP Business warehouse, SAP BAPI) .)

------------------

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos
Former Member
0 Kudos

Thanks.  Unfortunately the link doesn't seem to point to an existing page.

Former Member
0 Kudos

Hi,

Please try this: https://i7p.wdf.sap.corp/sap/support/notes/1882516

Regards,
Amine.

Former Member
0 Kudos

Thanks Amine.

I still receive

"This Page Can't Be Displayed"

with clicking the link, copy pasting etc.

Former Member
0 Kudos

In order to be able to open the KBA you need to have access account to Home | SAP Support Portal

Anyway, in major cases the issue is due to the fact that during the initial BI server install some DLL files did not get registered.

In order to resolve the issue you need to perform a repair on the main BI Platform installation from Control Panel -> Programs and Features.

Former Member
0 Kudos

AH!  Thanks Amine.  I see the note and will be performing a CMS backup and run an install repair later in the week.

Former Member
0 Kudos

Following up.

We did the repair install and it has fixed the problem.

Thank you Amine.

Answers (0)