Hmm did the reports actually fail? I got that once on a report which refreshed successfully but the viewing optimisation failed with the message you gave.
You may want to delete the Universe from your BCA server. Occasionally, these do not get updated properly on the BCA server from the repository following a recent export, and if you delete it, you can resolve this issue.
Hi. I understand that this issue is long since solved. however, for the benefit of others, I’m replying to point out another case where this problem happens.
The error message “Error: 0x80010105, The server threw an exception.” from the BCA will also occur if the BUSOBJ.EXE assigned to process the task takes too long, such that the BOManager times it out and kills it.
If you have a BO full client report which has a macro with external references, then you MUST ENSURE that the DLLs or OCX’s or whatever which that report references are also present and registered on the machine where the BCA runs – regardless of whether the actions of the task actually cause VBA code to run or not.
If the externally referenced file is not present or not registered on the BCA machine, the BUSOBJ.EXE process assigned to run the task will “freeze”, it will not use any CPU and it will not actually do anything, until it times out and is killed.
In my case, I couldn’t even get the BCA to do a “Save as TXT” action on a 1-line report – the BUSOBJ.EXE process sat there for 2 hours using no CPU, until the BOMgr came along and killed it.
This is also true, even if you delete all the VBA code from the report. Removing the code apparently does not remove the dependency on this external reference, so if you are using a template as the starting point of your report, and it has such an external reference then you’ll have this problem with all reports you build using this template – even if you delete all the VBA code when you write the report.
I am working on BO and getting the exception error on BCA when the report refreshing. I tried all the options that you all are porvided still it fails. Could you please give me solution for me.