Solved

Crystal reports lock database

Posted on 2008-10-10
8
2,159 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

856 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