Today our schedules are failing all of a sudden and when I try to run a report or create a report using any universe/FHSQL, it throws the following error. However if I run the reports using Rich Client application, the report runs fine.
I am using Admin credentials. This was working all good till today. I have also restarted the server manually, so it restarts all the services as well, but still no luck. Please advise…
SAP BusinessObjects BI Platform 4.2 Support Pack 8 Patch 7
Version: 14.2.8.3708
I would check to make sure your database permissions are still working. You could also try running your SQL directly in the database to see if there is anything that could have chanced in the database.
Since it seems you have access to the server, check your Web Intelligence logs. Using the Support Log Assistant to analyze your log files might be helpful as well.
If you refresh the report manually in Bi Launchpad, does the report work?
If you view the SQL in the query and select custom SQL and validate, do you see errors?