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
ProjNetAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
I found an article in the SAP/Crystal knowledge base that addresses thhe error

http://search.sap.com/ui/notes?id=0001263344&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64653D3939382669765F7361706E6F7465735F6E756D6265723D30303031323633333434&ssocompatible

According to the article the issue occurs because the older version is still in the registry and there are conflicts.
From the article

Cause

After the successful installation of Crystal Reports, still this error occurs as the "registry key" entries of the previous version of Crystal Reports still remains on the machine.


To solve you have to manually uninstall Crystal then clean the registry of all references to Crystal and Business Objects.  The article is for CR XI but may still apply.

mlmcc
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
What software is used to run the report?  Crystal Reports Designer?  3rd-party viewer app? Your own viewer app?

The reports tested use a UFL (User Function Library)?
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
If the machine running the report is a laptop, make sure Network Settings (control panel) don't have battery saving mode turned on.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
If the Crystal reports use Xcelsius, use Task Manager, Processes tab to find the Xcelsius process and set its priority as 'high'.
0
 
ProjNetAuthor Commented:
Hi -

The software being used is Crystal Reports 2008 to view the reports

Thanks
0
 
mlmccCommented:
Are you viewing through the developer ide or do you have an application that views the reports?

mlmcc
0
 
mlmccCommented:
Did you install an CR2008 on a machine that had a previous version of Crystal installed?

mlmcc
0
 
ProjNetAuthor Commented:
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
0
 
vastoCommented:
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.
0
 
ProjNetAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.