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 :
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.