My Oracle Support Banner

SQL Server Lock Request Timeouts in SOA Managed Server Log Files (Doc ID 1617473.1)

Last updated on JANUARY 07, 2020

Applies to:

Oracle SOA Suite - Version and later
Information in this document applies to any platform.
*** Checked for relevance on 27-JUL-2017 ***


 "[SQLServer]Lock request time out period exceeded" messages are being seen and are being logged in the SOA managed server log files.

Is there a way to prevent the "Lock request time out period exceeded" exception from being logged in SOA managed server log file? 

Encountered a fatal exception while polling. Will continue polling but with minimal logging. Please investigate the fault and manually stop polling from the console if in development and this appears to be a modeling mistake. BINDING.JCA-11624
DBActivationSpec Polling Exception.
Query name: [reqNirMeasurementMOSelect], Descriptor name: [table]. Polling the database for events failed on this iteration.
Caused by java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Lock request time out period exceeded..
 This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-1222" to your deployment descriptor (i.e. weblogic-ra.xml). This polling process will shut down, unless the fault is related to processing a particular row, in which case polling will continue but the row will be rejected (faulted).


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.