PM32792: SERVICE INTEGRATION BUS MESSAGING ENGINE FAILS TO ACQUIRE ITS DATA STORE LOCK DUE TO SQLEXCEPTION "ORA-30006: RESOURCE BUSY"

Fixes are available

APAR status

Closed as program error.

Error description

When a Service Integration Bus messaging engine using a data
store is starting up, it must access the tables in the database
to establish an exclusive lock.  During this period, if an
Oracle database throws a SQLException with code "ORA-30006:
resource busy; acquire with WAIT timeout expired", the
messaging engine will generate an ffdc file with the exception
text and fail to start.  The SystemOut.log file will show error
CWSIS1546I ("The messaging engine has lost an existing lock or
failed to gain an initial lock on the data store").

Local fix

Problem summary

****************************************************************
* USERS AFFECTED:  Users of the default messaging provider for *
*                  IBM WebSphere Application Server            *
****************************************************************
* PROBLEM DESCRIPTION: The messaging engine loses its lock     *
*                      on the SIBOWNER table when the          *
*                      database reports a transient error,     *
*                      and doesn't attempt to regain the lock. *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
When the messaging engine is running it will keep a lock on
the SIBOWNER table to ensure exclusive access. If an
SQLException occurs (other than a StaleConnectionConnection)
then the messaging engine is stopped and will not regain its
lock automatically. The messaging engine will also not fail
over to any other server.

In the case where the database is currently busy and can't
service the request then messaging engine should still keep
running until the database can service the request. This is
different to a StaleConnectionException as in this scenario
the connection is still valid.

An example of a transient error from the database is the
following from an Oracle database:

ORA-30006: resource busy; acquire with WAIT timeout expired

Problem conclusion

This APAR allows the messaging engine to stay running when a
transient error is received from the database.

The fix for this APAR is currently targeted for inclusion in
fix pack 6.1.0.39 and 7.0.0.19.  Please refer to the
Recommended Updates page for delivery information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

Temporary fix

Comments

APAR Information

APAR number
PM32792
Reported component name
PLAT MSG COM
Reported component ID
620600101
Reported release
200
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-02-15
Closed date
2011-03-31
Last modified date
2011-03-31

APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name
PLAT MSG COM
Fixed component ID
620600101

Applicable component levels

R200 PSY
UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
27 October 2021

Tips

PM32792: SERVICE INTEGRATION BUS MESSAGING ENGINE FAILS TO ACQUIRE ITS DATA STORE LOCK DUE TO SQLEXCEPTION "ORA-30006: RESOURCE BUSY"

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R200 PSY

Document Information

Share your feedback

Need support?