ProjNet
asked on
Crystal Reports
When trying to access some reports in Crystal Reports we constantly get the error message
"This action cannot be completed because the other program is busy. Choose "Switch To" to activate the busy program and correct the problem"
This error is affecting multiple users at various times of the day and I've tried many things to resolve. If the users are persistent, they will eventually get into the report - however time of day doesn't seem to be a factor, as this happens at multiple time of the working day, as well as when the user has tried out of hours.
We've ensured that no other programs are running at the same time as accessing the report.
We've ensured that only 1 user is accessing the report at the time
We have checked that there isn't the issue with the updater program running in the background
We have checked the SQL database that this is accessing and there are no issues there
After searching online for a while now, I can't seem to catch a break with this issue.
Would appreciate any help that I can get
"This action cannot be completed because the other program is busy. Choose "Switch To" to activate the busy program and correct the problem"
This error is affecting multiple users at various times of the day and I've tried many things to resolve. If the users are persistent, they will eventually get into the report - however time of day doesn't seem to be a factor, as this happens at multiple time of the working day, as well as when the user has tried out of hours.
We've ensured that no other programs are running at the same time as accessing the report.
We've ensured that only 1 user is accessing the report at the time
We have checked that there isn't the issue with the updater program running in the background
We have checked the SQL database that this is accessing and there are no issues there
After searching online for a while now, I can't seem to catch a break with this issue.
Would appreciate any help that I can get
If the machine running the report is a laptop, make sure Network Settings (control panel) don't have battery saving mode turned on.
If the Crystal reports use Xcelsius, use Task Manager, Processes tab to find the Xcelsius process and set its priority as 'high'.
ASKER
Hi -
The software being used is Crystal Reports 2008 to view the reports
Thanks
The software being used is Crystal Reports 2008 to view the reports
Thanks
Are you viewing through the developer ide or do you have an application that views the reports?
mlmcc
mlmcc
Did you install an CR2008 on a machine that had a previous version of Crystal installed?
mlmcc
mlmcc
ASKER
Hi mlmcc
It's possible that there was a previous version of CR on the laptop. I'm not sure and the user isn't either
Thanks
It's possible that there was a previous version of CR on the laptop. I'm not sure and the user isn't either
Thanks
Is this happening for specific reports or it is random ?
If it is for specific reports, try to find if multiple users are using them or at the same time somebody is retrieving data. The behavior you are describing is typical for a database lock. It happens when one user is trying to read data which was not committed and waiting for another user to finish a transaction, but the second user needs to access data used by the first user. As a result both users are waiting for each other and cannot read the data. Try to run the report when it is not likely other users to use it and if it works fine then you need to check why multiple users a locking it.
If it is for specific reports, try to find if multiple users are using them or at the same time somebody is retrieving data. The behavior you are describing is typical for a database lock. It happens when one user is trying to read data which was not committed and waiting for another user to finish a transaction, but the second user needs to access data used by the first user. As a result both users are waiting for each other and cannot read the data. Try to run the report when it is not likely other users to use it and if it works fine then you need to check why multiple users a locking it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi all - this solution was the one that fixed it in the end. It appears that the current version of Crystal was upgraded on top of an older version, following this managed to resolve this issue.
The reports tested use a UFL (User Function Library)?