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 AUGUST 11, 2023

Applies to:

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

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