BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Launch Works 
Launch Works (Opens a new window)  

General Notice: No events within the next 45 days.

Instance of SQLServer Database Engine cannot obtain a lock


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
althatichandrashekar
Senior Member
Senior Member



Joined: 05 Mar 2009

Posts: 70
Location: INDIA


flag
PostPosted: Mon Jun 20, 2011 10:11 pm 
Post subject: Instance of SQLServer Database Engine cannot obtain a lock

Hi,

We are using BODS 14.0.0.0 and SQL Server 2008. We have devloped around 30 Jobs. When we are running those jobs in parallel, we are facing the below issue.

[Microsoft][SQL Server Native Client 10.0][SQL Server]The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.

Can anyone help me in solving this problem.

Thanks
Chandrashekar
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0088 seconds using 17 queries. (SQL 0.0021 Parse 0.0002 Other 0.0065)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo