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

Last updated on JULY 27, 2017

Applies to:

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

Symptoms


 "[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? 

ERROR
-----------------------
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).

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