My Oracle Support Banner

SOA Servers going to WARNING state with STUCK threads when processing more than one 997 from the same partner for a single outgoing message. (Doc ID 2732947.1)

Last updated on NOVEMBER 30, 2020

Applies to:

Oracle SOA Suite - Version 11.1.1.7.8 and later
Information in this document applies to any platform.

Goal

On : 12.2.1.4, B2B Engine.

SOA Servers going to WARNING state with STUCK threads when processing more than one 997 from the same partner for a single outgoing message.

Following queries are seen for each such blocking query when 997s are being attempted to consolidate. More than one soa server is trying to get row lock correlating incoming 997. Since duplicate 997s are arriving where each soa server gets one, hence leading to row lock contention.

<Warning> <oracle.soa.b2b.repository> <BEA-000000> <
Internal Exception: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

Error Code: 1013
Call: SELECT ID, JOB_ID, ACK_MODE, LABEL, ACK_TYPE, ATTRIBUTE1, MESSAGE_ID, ATTRIBUTE3, MESSAGE_TYPE, ATTRIBUTE5, MODIFIED, CONTENT_TYPE, NATIVE_MSG_SIZE, CORRELATION_FROM_XPATH_VALUE, PAYLOAD_NAME, CORRELATION_TO_XPATH_NAME, RECEIVER_ID_TYPE, CORRELATION_TO_XPATH_XPR, RECEIVER_ID_VALUE, CPST_INST_CREATED_TIME, RECEIVER_NAME, LAST_RESUBMITTED_TIME_STAMP, RECEIVE_TIMESTAMP, LAST_VIEWED_TIME_STAMP, REFER_TO_MESSAGE_ID, ORIGINAL_STATE, RESPONSE_MODE, DIRECTION, RESUBMIT_COUNT, DOC_PROTOCOL_NAME, SENDER_ID_TYPE, DOC_REMAINING_RETRY, SENDER_ID_VALUE, DOCTYPE_NAME, SENDER_NAME, DOC_EVENT, SEND_TIMESTAMP, ATTRIBUTE4, STATE, CORRELATION_FROM_XPATH_NAME, TIME_TO_ACK, CORRELATION_TO_XPATH_VALUE, TPA_ID, LAST_RESUBMITTED_USER_NAME, TPA_NAME, CHANNEL_NAME, TRANSLATED_MSG_SIZE, DOC_ATTEMPT_COUNT, XPATH_EXPRESSION1, DOC_RETRY_INTERVAL, XPATH_EXPRESSION2, ATTRIBUTE2, XPATH_EXPRESSION3, CORRELATION_FROM_XPATH_XPR, XPATH_NAME1, LAST_VIEWED_USER_NAME, XPATH_NAME2, DOC_PROTOCOL_VERSION, XPATH_NAME3, BATCH_ID, XPATH_VALUE1, USER_COMMENT, XPATH_VALUE2, CREATED, XPATH_VALUE3, DOCUMENT_DEFINITION, MESSAGE_STATUS, APP_MESSAGE, WIRE_MESSAGE, EXT_BUSINESS_MESSAGE, TRANSLATED_DATA_STORAGE, PAYLOAD_STORAGE, NATIVE_DATA_STORAGE, ATTACHMENT_STORAGE, RESUBMIT_REF_TO FROM B2B_BUSINESS_MESSAGE WHERE (MESSAGE_ID = ?) ORDER BY SEND_TIMESTAMP DESC FOR UPDATE


 

Solution

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
Goal
Solution
References


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