Unable to view report for the first time every morning.
When we log into crystal enterprise and try to view a report we get the following error every time:
There was an error retrieving data from the server: The Page Server cannot logon to the CMS. This is due to invalid security credentials. Please verify your user ID and password
Once you click to refresh the screen or got back and then forward to view the report, it works fine until the next morning. It appears that the nightly process is disconnecting the link to the page server either by services being restarted or a timeout due to inactivity.
This is a major issue for us because our users are complaining.
Try to start your CMS first, put a sleep for 60/90 seconds after starting the CMS and then start the other services.
If windows, you ll need the Resource Kit for the sleep command to be valid.
It will give a chance to the CMS to fully initialize before other BO services get registered.
On Unix, if integrated in the startservers script, it also permits to get rid of most (mind you: not all) of the "Registration failure" errors you can find in the var/log/messages (or equivalent depending on the flavour)
For the different services' name, check in your Windows services console.
The script should look like this:
REM @ECHO off (remove the REM when the script is fully functionnal)
NET START "Central Management Server"
NET START "Crystal Reports Page Server"
pause (For testing only, to make sure you don't get any error around service naming or registration)
Also, when stopping the services, stop the CMS last:
NET STOP "Crystal Reports Page Server"
NET STOP "Central Management Server"
./ccm.sh -start cms
./ccm.sh -start pageserver
./ccm.sh -start webi
Unix services names are based on the first bit before LAUNCH in the ccm.config (e.g.: pageserverLAUNCH= webiLAUNCH=)
Hope this helps.
Edited by: Romain Anselin on Sep 8, 2008 1:58 PM