Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Multi Engine Shared Var Impl - Locking Error on SQL Server 2005


Recommended Posts

Hello All,

 

I have been trying to implement Shared variable accessible to process instances across multiple BW engines. Care has been taken to define

 

1. Shared Variable and Lock Object with Multi engine Option checked

.2. Wrapping Set/Get Variable calls within a Critical Section configured with Multi Group Scope andpreviously defined lock object resource for synchronization.

 

Intially when the project was executed against an Oracle Test Engine DB, the Set & Get activities worked perfectly fine. However when the SQL Server 2005 is used as Test DB, the Setter and Getter processes simply hang at the Set/Get Activities inside the critical section group and flag the following error

"Failed to get lock for /Shared Configurations/Shared Variable.sharedvariable - timeout"

Request you to pen your suggestions and guide me in resolving this issue. Why is that BW is not able to attain lock against SQL Server 2005 DB resource

Any pointers on the above will be highly appreciated :)

 

Regards,

Vaibhav Dutt Sharma

Link to comment
Share on other sites

  • 9 years later...
×
×
  • Create New...