If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

locking issue...

Started by Maple, 10 May 2007 10:48:18 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Maple

10 May 2007 10:48:18 AM
We are experiencing numerous deadlocking issues on the DB SQL Server 2000. When ever we run any report in cognos then the multiple processes started under user ids and they don't go away until we don't kill the processes manually. Our database loads are failed to run due to this locking issues. Is there any one who can help me with this issue...

COGNOiSe administrator

#1
10 May 2007 07:14:28 PM
Try changing isolation level on your database connection.

Maple

#2
11 May 2007 09:13:58 AM
Can you please let me know how to change the Isolation level....i'm kind a new to SQL Server

COGNOiSe administrator

#3
11 May 2007 09:29:01 AM
In Cognos Connection - Directory - Data Source, check your connection properties. One of the will be related to isolation levels.
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite