Submitting Orders In Siebel Are Not Progressing To AIA. (Doc ID 1343411.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Communications Integration Pack for Order to Billing - Version 2.5 to 2.5 [Release 2.5]
Information in this document applies to any platform.

Symptoms

When Siebel triggers (submits) an order, the connection to AIA is not happening. Checking BPEL console does not list any triggered events from BPEL. Integration was working before although the result was a fault. Now there is no response from the BPEL Console instance at all.
In reviewing the log files the following can be seen in the log.xml:

Internal Exception: java.sql.SQLException: javax.resource.ResourceException: SystemException: Failed to add the resource due to error in the resource : oracle.jdbc.xa.OracleXAException errorcode : -7Error Code: 0

Call:select * from ESB_group_status where destination_system_guid='96DD76C0971311DABF1A87858E4395A7' and error=0 and DUMMY1='0' and lockConId='77CF7261ADD811E09F5DB96004E3CD96' and (service_guid, group_id) in (select service_guid, group_id from esb_message_map where status=0) order by lockTime for update

Query:ReadAllQuery(oracle.tip.esb.server.resequencer.GroupStatus)]

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