Did you open the problematic report on the BCA server and then run the report? Did it run? Is all the five reports based on the same universe? Did you try deleting the Universe Cache file from the BCA Server?
Did you open the problematic report on the BCA server and then run the report? Did it run? Is all the five reports based on the same universe? Did you try deleting the Universe Cache file from the BCA Server?
How did you open the report in BCA Server? Through BO full client you mean. NO ! We didn’t install the full client on BCA server.
We run the report manually on the workstation and it works fine and published and scheduled in BCA.
Did you try deleting the Universe Cache file from the BCA Server?
How to delete the universe cache file from the BCA server. please explain me in detail.
When you installed BCA, you installed a copy of the full client. Run it out of C:\Program Files\Business Objects\BusinessObjects Enterprise 6\bin\busobj.exe
Log in as the BCA service ID (whatever that is). Open your problematic report and refresh it. If this succeeds, your problem is not with your document. If it doesn’t, it’s a problem in your report.
I did with the service account ID to refresh the reports and it works fine locally on the server, but when we scheduled in BCA and run the report the BCA throws exception error.
What is the userid you are using to schedule the report? Did you try logging in as the user in question to see if the report refreshes using his id? Can you post us the exact error message that you get from the scheduler?
Hello Guys sorry for the late update. I fixed the problem.
The problem for the BCA reports are fixed and it works fine now.
Resolution.
Login to server A and verified the E:\Business Objects\nodes\A\A_mycluster\universes\Universe\
and also in local version of the universe.
C:\Documents and Settings\User ID(login)\Application Data\Business Objects\Business Objects 6.0\universes\Universe\
are different Revision Code.
The Revision code and the size of the universe are different in all the cluster node of all the servers. Its not sync with the repository.
To make it sync with the cache, I copied the cache universe to separate location and open the matrix report and refreshed it manual on the server, BO automatically downloads the recent version of the universe on the cache on the cluster node. I went and open the universe and verified the Revision ID.
I did all the above steps for all the three servers using Service account user ID.