IBM Support

IBM Business Process Manager (BPM) V7.5 with a Microsoft SQL database throws a lock request time out period exceeded error

Troubleshooting


Problem

The business process definitions (BPD) for IBM Business Process Manager V7.5 products and other actions fail in a Microsoft SQL database due to a bad driver lock timeout.

Symptom

The following failure error message is seen: com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded

Cause

The wrong lockTimeout value is provided during installation.

Resolving The Problem

In the administrative console, complete the following steps:

  1. Click Resources > JDBC > JDBC Providers.

  2. Select the JDBC provider.

  3. Select the data source and click Custom properties.

  4. Change the lockTimeout value from 2000 to a larger value. A value of 30000 to 60000 is enough in most cases.


    Note: This value is a lock timeout that is specified in milliseconds.This tuning parameter depends on your application usage and design; it might add more lock contention into your application. Through testing you can determine whether errors occur during your normal processing. If you use a Microsoft SQL Server, then the default value is 2000 milliseconds, which is too low. However, for most other database types, default value is between 30 and 60 seconds. Consider setting the timeout value to between 30 and 60 seconds for the IBM Business Process Manager V7.5 products. Value of -1 means there is no timeout.

  5. Repeat the previous 2 steps for each of the data sources.

[{"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Component":"Databases","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.5.1;7.5","Edition":""},{"Product":{"code":"SSFTBX","label":"IBM Business Process Manager Express"},"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Component":"Databases","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.5.1;7.5","Edition":""},{"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Component":"Databases","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"","label":"Linux zSeries"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"7.5.1;7.5","Edition":""}]

Product Alias/Synonym

BPM

Document Information

Modified date:
15 June 2018

UID

swg21516235