0 Replies Latest reply on Oct 27, 2016 5:10 PM by 1504052

    Fusion Middleware - java.sql.SQLTimeoutException: ORA-01013

    1504052

      Hi Experts,

       

                    Need your help to figure out the root cause of below error. There is a fusion process which is fetching from one view from different database. View returns 100K records after 10 min if we select from any sql tool. But, when fusion process is selecting it's running for more than 20 mins and eventually timing out after 1743 seconds. Also, this was working fine for last several years and all of a sudden it's consistently failing with same error message from last few days. Which parameters we should check which can result into slow processing/selecting the records from different database? Thanks in advance.

       

      [2016-10-26T22:06:04.733-07:00] [WLS_SOA1] [ERROR] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-19] [userId: <anonymous>] [ecid: 005Fx5AH0kzD^aM5qNh8iY000381001450,1:4133124] [APP: soa-infra] [composite_name: SyncGlobalERPtoTrackingSystem] [component_name: SyncGlobalERPtoTrackingSystem] [component_instance_id: 167726613] [URI: /soa-infra/services/IClickSupport/SyncGlobalERPtoTrackingSystem/client] JCABinding=>  SyncGlobalERPtoTrackingSystem:readTrackingService [ readTrackingService_ptt::readTrackingService(readTrackingServiceInput_msg,readTrackingServiceOutputCollection) ]  Could not invoke operation 'readTrackingService' against the 'Database Adapter' due to: [[

      BINDING.JCA-11633

      Pure SQL Exception.

      Pure SQL Execute of SELECT * FROM XXEA_EPO_LOCALISATION_POS_V failed.

      Caused by java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

      .

      The Pure SQL option is for border use cases only and provides simple yet minimal functionality.  Possibly try the "Perform an operation on a table" option instead.  This exception is considered retriable, likely due to a communication failure.  Because the global transaction is rolling back the invoke must be retried in a new transaction, restarting from the place of the last transaction commit.  To classify it as non-retriable instead add property nonRetriableErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml).

       

      ]]

      [2016-10-26T22:06:04.734-07:00] [WLS_SOA1] [NOTIFICATION] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-19] [userId: <anonymous>] [ecid: 005Fx5AH0kzD^aM5qNh8iY000381001450,1:4133124] [APP: soa-infra] [composite_name: SyncGlobalERPtoTrackingSystem] [component_name: SyncGlobalERPtoTrackingSystem] [component_instance_id: 167726613] [URI: /soa-infra/services/IClickSupport/SyncGlobalERPtoTrackingSystem/client] JCABinding=>  SyncGlobalERPtoTrackingSystem:readTrackingService [ readTrackingService_ptt::readTrackingService(readTrackingServiceInput_msg,readTrackingServiceOutputCollection) ]  Change logging level to TRACE:n to see full error stack

      [2016-10-26T22:06:04.787-07:00] [WLS_SOA1] [ERROR] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-19] [userId: <anonymous>] [ecid: 005Fx5AH0kzD^aM5qNh8iY000381001450,1:4133124] [APP: soa-infra] [composite_name: SyncGlobalERPtoTrackingSystem] [component_name: SyncGlobalERPtoTrackingSystem] [component_instance_id: 167726613] [URI: /soa-infra/services/IClickSupport/SyncGlobalERPtoTrackingSystem/client] JCABinding=>  [IClickSupport/SyncGlobalERPtoTrackingSystem!1.0*soa_6c9362d7-85f5-4073-a9df-950913a66abf.readTrackingService]:readTrackingService  Two-way operation readTrackingService() failed

      [2016-10-26T22:06:04.788-07:00] [WLS_SOA1] [ERROR] [] [oracle.soa.bpel.engine.ws] [tid: orabpel.invoke.pool-4.thread-19] [userId: <anonymous>] [ecid: 005Fx5AH0kzD^aM5qNh8iY000381001450,1:4133124] [APP: soa-infra] [composite_name: SyncGlobalERPtoTrackingSystem] [component_name: SyncGlobalERPtoTrackingSystem] [component_instance_id: 167726613] [URI: /soa-infra/services/IClickSupport/SyncGlobalERPtoTrackingSystem/client] got FabricInvocationException[[

      java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

       

      [2016-10-26T22:06:04.813-07:00] [WLS_SOA1] [ERROR] [] [oracle.soa.bpel.engine.dispatch] [tid: orabpel.invoke.pool-4.thread-19] [userId: <anonymous>] [ecid: 005Fx5AH0kzD^aM5qNh8iY000381001450,1:4133124] [APP: soa-infra] [URI: /soa-infra/services/IClickSupport/SyncGlobalERPtoTrackingSystem/client] Failed to handle dispatch message ... exception ORABPEL-05002[[

       

      Message handle error.

      error while attempting to process the message "com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessage"; the reported exception is: Transaction Rolledback.: weblogic.transaction.internal.TimedOutException: Transaction timed out after 1743 seconds