Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #1 

Fatal Deadlock in SQL Server

Last edited: 23 Apr 2003


The information in this article applies to product: e-Work - all versions with Engine running on Windows 2000

Issue

  • There is a persistent Blocking/Blocked situation between two or more SPIDs in SQL Server. The Engine stops responding to user requests and must be restarted, sometimes requiring a reboot of the server.

    To check for SPID problems, use Enterprise Manager and navigate from Console Root to Management > Current Activity > Locks/Process ID.

Resolution

  • This issue typically occurs when an inline script is being run, and there is a delay in an external call from this script.
  • A configuration issue with Microsoft's COM+ components can cause the e-Work engine to experience a deadlock or "Deadly Embrace". This occurs because of a default setting in the COM+ components for e-Work. It can affect any e-Work installation where the engine is running on a Windows 2000 server; however, the configuration can be changed easily.
  • Using the Component Services manager in Control Panel/Administrative tools, expand the Component Services tree until the four Metastorm e-Work Engine components are visible.                                         For each of these, view its properties dialog and select the "Concurrency" tab. The default setting for "Synchronization Support" is "Disabled". Changing this to "Required" should remove the conflict. Restart the engine to make this change effective.
  • There are no reports of any failures when the engine is running on Windows NT or Windows XP.


Keywords: kb406


__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!