1 Reply Latest reply: Aug 4, 2010 2:40 AM by wilson.t RSS

    JCA Transport Database Errors catching/understanding.

    782468
      Hello,

      I'm using OSB 11g.
      Is there possibility to get some more understandable error code or message instead of big stacktrace when DB timeout error or PLSQL exception occurs?

      For instance, now when calling business service and timeout error occurs in response I see: (looks a bit messy:))

      The invocation resulted in an error: Invoke JCA outbound service failed with connection error, exception: com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/WSDL/JCADBTransportTest/wsdl/DBTimeoutedProc [ DBTimeoutedProc_ptt::DBTimeoutedProc(InputParameters) ] - WSIF JCA Execute of operation 'DBTimeoutedProc' failed due to: Stored procedure invocation error.
      Error while trying to prepare and execute the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API.
      An error occurred while preparing and executing the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API. Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER", line 2
      ORA-04088: error during execution of trigger 'SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER'
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC", line 5
      ORA-06512: at line 1

      ; nested exception is:
      BINDING.JCA-11811
      Stored procedure invocation error.
      Error while trying to prepare and execute the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API.
      An error occurred while preparing and executing the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API. Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER", line 2
      ORA-04088: error during execution of trigger 'SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER'
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC", line 5
      ORA-06512: at line 1

      Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.

      com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/WSDL/JCADBTransportTest/wsdl/DBTimeoutedProc [ DBTimeoutedProc_ptt::DBTimeoutedProc(InputParameters) ] - WSIF JCA Execute of operation 'DBTimeoutedProc' failed due to: Stored procedure invocation error.
      Error while trying to prepare and execute the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API.
      An error occurred while preparing and executing the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API. Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER", line 2
      ORA-04088: error during execution of trigger 'SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER'
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC", line 5
      ORA-06512: at line 1

      ; nested exception is:
      BINDING.JCA-11811
      Stored procedure invocation error.
      Error while trying to prepare and execute the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API.
      An error occurred while preparing and executing the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API. Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER", line 2
      ORA-04088: error during execution of trigger 'SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER'
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC", line 5
      ORA-06512: at line 1

      Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.

      at com.bea.wli.sb.transports.jca.binding.JCATransportOutboundOperationBindingServiceImpl.invokeOneWay(JCATransportOutboundOperationBindingServiceImpl.java:112)
      at com.bea.wli.sb.transports.jca.JCATransportEndpoint.sendOneWay(JCATransportEndpoint.java:191)
      at com.bea.wli.sb.transports.jca.JCATransportEndpoint.send(JCATransportEndpoint.java:168)
      at com.bea.wli.sb.transports.jca.JCATransportProvider.sendMessageAsync(JCATransportProvider.java:571)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at com.bea.wli.sb.transports.Util$1.invoke(Util.java:83)
      at $Proxy125.sendMessageAsync(Unknown Source)
      at com.bea.wli.sb.transports.LoadBalanceFailoverListener.sendMessageAsync(LoadBalanceFailoverListener.java:148)
      at com.bea.wli.sb.transports.LoadBalanceFailoverListener.sendMessageToServiceAsync(LoadBalanceFailoverListener.java:603)
      at com.bea.wli.sb.transports.LoadBalanceFailoverListener.sendMessageToService(LoadBalanceFailoverListener.java:538)
      at com.bea.wli.sb.transports.TransportManagerImpl.sendMessageToService(TransportManagerImpl.java:558)
      at com.bea.wli.sb.transports.TransportManagerImpl.sendMessageAsync(TransportManagerImpl.java:426)
      at com.bea.wli.sb.test.service.ServiceMessageSender.send0(ServiceMessageSender.java:377)
      at com.bea.wli.sb.test.service.ServiceMessageSender.access$000(ServiceMessageSender.java:76)
      at com.bea.wli.sb.test.service.ServiceMessageSender$1.run(ServiceMessageSender.java:134)
      at com.bea.wli.sb.test.service.ServiceMessageSender$1.run(ServiceMessageSender.java:132)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
      at com.bea.wli.sb.security.WLSSecurityContextService.runAs(WLSSecurityContextService.java:55)
      at com.bea.wli.sb.test.service.ServiceMessageSender.send(ServiceMessageSender.java:137)
      at com.bea.wli.sb.test.service.ServiceProcessor.invoke(ServiceProcessor.java:454)
      at com.bea.wli.sb.test.TestServiceImpl.invoke(TestServiceImpl.java:172)
      at com.bea.wli.sb.test.client.ejb.TestServiceEJBBean.invoke(TestServiceEJBBean.java:167)
      at com.bea.wli.sb.test.client.ejb.TestService_sqr59p_EOImpl.invoke(TestService_sqr59p_EOImpl.java:353)
      at com.bea.wli.sb.test.client.ejb.TestService_sqr59p_EOImpl_WLSkel.invoke(Unknown Source)
      at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:174)
      at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:345)
      at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259)
      at com.bea.wli.sb.test.client.ejb.TestService_sqr59p_EOImpl_1033_WLStub.invoke(Unknown Source)
      at com.bea.alsb.console.test.TestServiceClient.invoke(TestServiceClient.java:174)
      at com.bea.alsb.console.test.actions.DefaultRequestAction.invoke(DefaultRequestAction.java:117)
      at com.bea.alsb.console.test.actions.DefaultRequestAction.execute(DefaultRequestAction.java:70)
      at com.bea.alsb.console.test.actions.ServiceRequestAction.execute(ServiceRequestAction.java:143)
      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
      at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:97)
      at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2044)
      at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:91)
      at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2116)
      at com.bea.alsb.console.common.base.SBConsoleRequestProcessor.processActionPerform(SBConsoleRequestProcessor.java:91)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
      at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:556)
      at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:853)
      at com.bea.alsb.console.common.base.SBConsoleRequestProcessor.process(SBConsoleRequestProcessor.java:191)
      at org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:631)
      at org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:158)
      at com.bea.console.internal.ConsoleActionServlet.process(ConsoleActionServlet.java:256)
      at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
      at com.bea.console.internal.ConsoleActionServlet.doGet(ConsoleActionServlet.java:133)
      at com.bea.alsb.console.common.base.SBConsoleActionServlet.doGet(SBConsoleActionServlet.java:49)
      at org.apache.beehive.netui.pageflow.PageFlowUtils.strutsLookup(PageFlowUtils.java:1199)
      at org.apache.beehive.netui.pageflow.PageFlowUtils.strutsLookup(PageFlowUtils.java:1129)
      at com.bea.portlet.adapter.scopedcontent.ScopedContentCommonSupport.executeAction(ScopedContentCommonSupport.java:687)
      at com.bea.portlet.adapter.scopedcontent.ScopedContentCommonSupport.processActionInternal(ScopedContentCommonSupport.java:142)
      at com.bea.portlet.adapter.scopedcontent.StrutsStubImpl.processAction(StrutsStubImpl.java:76)
      at com.bea.portlet.adapter.NetuiActionHandler.raiseScopedAction(NetuiActionHandler.java:111)
      at com.bea.netuix.servlets.controls.content.NetuiContent.raiseScopedAction(NetuiContent.java:181)
      at com.bea.netuix.servlets.controls.content.NetuiContent.raiseScopedAction(NetuiContent.java:167)
      at com.bea.netuix.servlets.controls.content.NetuiContent.handlePostbackData(NetuiContent.java:225)
      at com.bea.netuix.nf.ControlLifecycle$2.visit(ControlLifecycle.java:180)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:324)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
      at com.bea.netuix.nf.ControlTreeWalker.walk(ControlTreeWalker.java:130)
      at com.bea.netuix.nf.Lifecycle.processLifecycles(Lifecycle.java:395)
      at com.bea.netuix.nf.Lifecycle.processLifecycles(Lifecycle.java:361)
      at com.bea.netuix.nf.Lifecycle.processLifecycles(Lifecycle.java:352)
      at com.bea.netuix.nf.Lifecycle.runInbound(Lifecycle.java:184)
      at com.bea.netuix.nf.Lifecycle.run(Lifecycle.java:159)
      at com.bea.netuix.servlets.manager.UIServlet.runLifecycle(UIServlet.java:388)
      at com.bea.netuix.servlets.manager.UIServlet.doPost(UIServlet.java:258)
      at com.bea.netuix.servlets.manager.UIServlet.service(UIServlet.java:199)
      at com.bea.netuix.servlets.manager.SingleFileServlet.service(SingleFileServlet.java:251)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      at weblogic.servlet.AsyncInitServlet.service(AsyncInitServlet.java:130)
      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.dms.wls.DMSServletFilter.doFilter(DMSServletFilter.java:330)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3684)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)
      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
      Caused by: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/WSDL/JCADBTransportTest/wsdl/DBTimeoutedProc [ DBTimeoutedProc_ptt::DBTimeoutedProc(InputParameters) ] - WSIF JCA Execute of operation 'DBTimeoutedProc' failed due to: Stored procedure invocation error.
      Error while trying to prepare and execute the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API.
      An error occurred while preparing and executing the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API. Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER", line 2
      ORA-04088: error during execution of trigger 'SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER'
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC", line 5
      ORA-06512: at line 1

      ; nested exception is:
      BINDING.JCA-11811
      Stored procedure invocation error.
      Error while trying to prepare and execute the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API.
      An error occurred while preparing and executing the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API. Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER", line 2
      ORA-04088: error during execution of trigger 'SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER'
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC", line 5
      ORA-06512: at line 1

      Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.

      at oracle.tip.adapter.sa.impl.JCABindingReferenceImpl.post(JCABindingReferenceImpl.java:201)
      at com.bea.wli.sb.transports.jca.binding.JCATransportOutboundOperationBindingServiceImpl.invokeOneWay(JCATransportOutboundOperationBindingServiceImpl.java:109)
      ... 117 more
      Caused by: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/WSDL/JCADBTransportTest/wsdl/DBTimeoutedProc [ DBTimeoutedProc_ptt::DBTimeoutedProc(InputParameters) ] - WSIF JCA Execute of operation 'DBTimeoutedProc' failed due to: Stored procedure invocation error.
      Error while trying to prepare and execute the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API.
      An error occurred while preparing and executing the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API. Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER", line 2
      ORA-04088: error during execution of trigger 'SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER'
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC", line 5
      ORA-06512: at line 1

      ; nested exception is:
      BINDING.JCA-11811
      Stored procedure invocation error.
      Error while trying to prepare and execute the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API.
      An error occurred while preparing and executing the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API. Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER", line 2
      ORA-04088: error during execution of trigger 'SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER'
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC", line 5
      ORA-06512: at line 1

      Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.

      at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.performOperation(WSIFOperation_JCA.java:667)
      at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.executeOperation(WSIFOperation_JCA.java:357)
      at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.executeRequestResponseOperation(WSIFOperation_JCA.java:316)
      at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.executeInputOnlyOperation(WSIFOperation_JCA.java:295)
      at oracle.tip.adapter.sa.impl.JCABindingReferenceImpl.invokeWsifProvider(JCABindingReferenceImpl.java:354)
      at oracle.tip.adapter.sa.impl.JCABindingReferenceImpl.post(JCABindingReferenceImpl.java:199)
      ... 118 more
      Caused by: BINDING.JCA-11811
      Stored procedure invocation error.
      Error while trying to prepare and execute the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API.
      An error occurred while preparing and executing the SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC API. Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER", line 2
      ORA-04088: error during execution of trigger 'SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER'
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC", line 5
      ORA-06512: at line 1

      Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.

      at oracle.tip.adapter.db.exceptions.DBResourceException.createRetriableException(DBResourceException.java:647)
      at oracle.tip.adapter.db.exceptions.DBResourceException.createEISException(DBResourceException.java:616)
      at oracle.tip.adapter.db.sp.SPUtil.createResourceException(SPUtil.java:174)
      at oracle.tip.adapter.db.sp.AbstractStoredProcedure.execute(AbstractStoredProcedure.java:130)
      at oracle.tip.adapter.db.sp.SPInteraction.executeStoredProcedure(SPInteraction.java:141)
      at oracle.tip.adapter.db.DBInteraction.executeStoredProcedure(DBInteraction.java:1134)
      at oracle.tip.adapter.db.DBInteraction.execute(DBInteraction.java:248)
      at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.performOperation(WSIFOperation_JCA.java:534)
      ... 123 more
      Caused by: java.sql.SQLException: ORA-01013: user requested cancel of current operation
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER", line 2
      ORA-04088: error during execution of trigger 'SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER'
      ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC", line 5
      ORA-06512: at line 1

      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:423)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1095)
      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:201)
      at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1036)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1379)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3568)
      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3739)
      at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:8150)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
      at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
      at oracle.tip.adapter.db.sp.AbstractStoredProcedure.execute(AbstractStoredProcedure.java:122)
      ... 127 more

      Edited by: pikach00 on Jul 21, 2010 5:16 AM