How to avoid DB Lock errors in BusinessConnect

How to avoid DB Lock errors in BusinessConnect

book

Article ID: KB0084333

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect 6.2.1, 6.3.0

Description

I am using multiple interior BusinessConnect Servers/instances in my environment. I can see DB lock errors in my interior BusinessConnect logs. How can I fix these errors?

Issue/Introduction

I can see db lock errors in BusinessConnect interior server log. How can i avoid these errors?

Environment

Product: TIBCO BusinessConnect Version: 6.2.1, 6.3.0 OS: All Supported Operating Systems

Resolution

BC 6.2.1 and BC 6.3 have a system setting that needs to be enabled in multi-engine environments.  Go to Administrator>BusinessConnect>System Settings>Install Protocol Plug-ins and Properties>BC and set the java.property.bc.useFLock to false.

In addition BC 6.3 hotfix 2 has an additional property that must be used in high performance environments.  This property must be added to all deployed engine files:

java.property.bc.DBLock.strongMode.enable=true

Please refer to the hotfix readme for details.