[Webi 4.x] Fatal Exception error on change of source

building reports webintelligence
1

Dear all,

We are facing an issue, and need your help to resolve it.

We are on BI 4.1 SP4

We have a webi report based on BEX Universe. We need to re-point it to another BEX universe. Both the queries are identical (same structure). Only the data source is different.

First of all, if we try to change source from launchpad, everything works out fine until we run the query. As soon as we hit the “Run Query” button, we get the error saying, “Your session timed out. Close the Java interface and log on again.”. We changed all sorts of time-out settings in CMC for Webintelligence Processing Server, but the error still persists. Also tried to schedule refresh, and this time the error says:

exception raised: com.businessobjects.sdk.core.CoreException

On the other hand, when we do the same changes in Webi Rich Client, it works perfectly fine, and we are also able to refresh the report after making the source change. But when we export the same report to launchpad and try to refresh it from there, again we get the error, although a different one this time, saying:

"FatalException occured. The cause was :

com.businessobjects.corba.generic.container.proxy.internal.DependencyFailoverCallbackImpl$FailoverFatalException:

Prepare failover failed (Error: INF)"

Has anyone ever faced such an issue earlier? Can someone please guide how to resolve it?

Building the whole new report from the scratch is the least feasible option, as there are 7 tabs with complex table structures that would need to be reproduced.

Thanks,
Isha M

mehak83 (BOB member since 2011-06-28)

2

Have you tried exporting as a different file name, save as then export.

Mak 1 :uk: (BOB member since 2005-01-06)

3

Thank you for the reply, Mak1.
Yes, we are exporting as different file name (that’s part of the requirement), and at a different path as well. But still the same result.
I have received a response from SCN forum saying that "The error is happening because your WIReportServer.exe is crashing behind the scenes. The failover message is happening because there are no other WIReportServers available for the failover.
This will be something you will need to open an incident for. A code correction may be needed as the WIRS should not be crashing.
"
So, we’ll be opening an incident with SAP now. Shall keep you posted with the update.

Thanks,
Isha

mehak83 (BOB member since 2011-06-28)

4

Ah, OK. so not something you can deal with by assigning more Java heap size or amount of memory allocated to the WIRS?

Mak 1 :uk: (BOB member since 2005-01-06)