Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2405
  • Last Modified:

Crystal reports lock database

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
VNRHelp
Asked:
VNRHelp
  • 3
  • 3
1 Solution
 
mlmccCommented:
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
 
VNRHelpAuthor Commented:
Using ODBC connection... While the report is running, no one can do anything on the database....
0
 
mlmccCommented:
Check the  ODBC definition to make sure it isn't locking the database

mlmcc
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
VNRHelpAuthor Commented:
what do you mean by the "ODBC definition?
0
 
mlmccCommented:
WHen you created the ODBC connection you set properties for the connection.  It may be that the connection is locking the database.

mlmcc
0
 
VNRHelpAuthor Commented:
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
 
Computer101Commented:
PAQed with points refunded (300)

Computer101
EE Admin
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.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now