Solved

Crystal Reports

Posted on 2014-03-21
10
1,314 Views
Last Modified: 2014-04-23
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
0
Comment
Question by:ProjNet
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 3
  • +1
10 Comments
 
LVL 23

Expert Comment

by:Ido Millet
ID: 39944872
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
 
LVL 23

Expert Comment

by:Ido Millet
ID: 39944876
If the machine running the report is a laptop, make sure Network Settings (control panel) don't have battery saving mode turned on.
0
 
LVL 23

Expert Comment

by:Ido Millet
ID: 39944880
If the Crystal reports use Xcelsius, use Task Manager, Processes tab to find the Xcelsius process and set its priority as 'high'.
0
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 

Author Comment

by:ProjNet
ID: 39944954
Hi -

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

Thanks
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39945142
Are you viewing through the developer ide or do you have an application that views the reports?

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39945147
Did you install an CR2008 on a machine that had a previous version of Crystal installed?

mlmcc
0
 

Author Comment

by:ProjNet
ID: 39945165
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
 
LVL 18

Expert Comment

by:vasto
ID: 39945232
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
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39945367
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
 

Author Closing Comment

by:ProjNet
ID: 40016894
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question