SQL Server Lock Request Timeouts in SOA Managed Server Log Files
Last updated on JULY 27, 2017
Applies to:Oracle SOA Suite - Version 18.104.22.168.0 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).
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