Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Crystal reports lock database

Posted on 2008-10-10
8
Medium Priority
?
2,274 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
[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
8 Comments
 
LVL 101

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 101

Expert Comment

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

mlmcc
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

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

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

718 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