OGG Replicat on Sybase db reports "Database error 12205..SERVER level wait period" and "SQL error 12205 mapping..Could not acquire a lock within the specified wait period" (Doc ID 1479763.1)

Last updated on AUGUST 11, 2012

Applies to:

Oracle GoldenGate - Version 11.1.1.1.1 and later
Information in this document applies to any platform.

Symptoms

Replicat report shows following message

2012-07-15 13:55:58 WARNING OGG-00869 Database error 16843163 (ct_results(): user api layer: external error:
This routine cannot be called when the command structure is idle.).

2012-07-15 13:55:58 WARNING OGG-01004 Aborted grouped transaction on 'dbo.TBSW1027',
Database error 12205 (Could not acquire a lock within the specified wait period.
SERVER level wait period=4 seconds, spid=6556, lock type=exclusive row, dbid=12, objid=1721109222, pageno=8448103, rowno=0. Aborting the transaction).

2012-07-15 13:56:07 WARNING OGG-01154 SQL error 12205 mapping dbo.TBSW1027 to dbo.TBSW1027
Could not acquire a lock within the specified wait period. SERVER level wait period=4 seconds,
spid=6556, lock type=exclusive row, dbid=12, objid=1721109222, pageno=8448103, rowno=0. Aborting the transaction.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms