Report failed to refresh in BO XI Infoview
Can someone help me deal with the following problem :
We have built a DESKI report (.rep) which refreshes very well in BO XI Desktop Intelligence.
This same report fails to refresh in the Infoview interface and generates the following error message :
"Error related to the connection or SQL : ...State: 42000..." (message truncated)
I have no idea on how to resolve this problem, and I am not a business objects expert.
Thanks in advance
I guess the problem is with your connection.
As you say that the other universes work fine, try to import the universe which is not, and then
edit the connection till the finish button. Save and export, and try the reports again.
If this does not work, try to create a new connection, and save and export the universe.
Otherwise you can copy paste the objects and the universe structure into a new universe, and edit the report to point to the new universe, and try again.