Solved

Crystal reports lock database

Posted on 2008-10-10
8
2,130 Views
Last Modified: 2013-11-15
Hi everyone, I need help .

I have crystal reports XI install on a citrix server. Users launch the application and run reports, however, the reports are locking the database. I was asked to change the IsolationLevel key on the citrix servers where crystal is installed, but there is no such key.

Does anyone know how I can fix this locking issue?

thank you
0
Comment
Question by:VNRHelp
  • 3
  • 3
8 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 22688186
Crystal shouldn't be locking the database since it is read-only.

How are you connecting to the database?

Are you using tables, views, or stored procedures?

mlmcc
0
 

Author Comment

by:VNRHelp
ID: 22688977
Using ODBC connection... While the report is running, no one can do anything on the database....
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22689624
Check the  ODBC definition to make sure it isn't locking the database

mlmcc
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:VNRHelp
ID: 22701877
what do you mean by the "ODBC definition?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22702340
WHen you created the ODBC connection you set properties for the connection.  It may be that the connection is locking the database.

mlmcc
0
 

Author Comment

by:VNRHelp
ID: 22703208
I have looked at the ODBC connections and there is no setting that would indicate to me that that is what is locking the database... I also ran into this article>>>>  although it did not help...

Symptom

How do you apply isoloation levels for ODBC?



Resolution

To set a different isolation level for ODBC when using Crystal Reports XI, set the registry entry:

HKEY_CURRENT_USER(or HKEY_LOCAL_MACHINE)\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\Database\ODBC

If the registry entry is not available, create the key by performing the following steps:
Close Crystal Reports XI if it is already running.
Create a new text file with the following text:
[HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\11.0\Crystal Reports\Database\ODBC]
"IsolationLevel"=dword:00000004
Save the file as "isolationlevel.reg" on your desktop and close the file.
Go to your desktop and double-click on the file isolationlevel.reg. A message will appear asking you to confirm whether you want to save modifications to your registry.
Click Yes. Another message will appear saying that the registry has been modified successfully.
Finally, open Crystal Reports XI and create a report using the ODBC connection.  
NOTE
 You can change the IsolationLevel value to 1 (Read Uncommitted), 2(Read Committed), 4 (Readable Read) or 8 (Serializable) according to your isolation level requirement.
 
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22967570
PAQed with points refunded (300)

Computer101
EE Admin
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now