Problem while Using Batch SQL statement - Websphere

This is a discussion on Problem while Using Batch SQL statement - Websphere ; {PaymentConf_RetrieveAll_E1MM}E1_JDBCSRC_001.impor t Handler: com/ibm/ws/sca/internal/j2c/handler/J2CImportHandler (com.ibm.ws.sca.internal.j2c.handler.J2CImportHand ler,com/ibm/wsspi/sca/extensions/ImportBindingGroup2) Wrapped by: com.ibm.websphere.sca.ServiceRuntimeException: The fault selector returned a null or blank native fault name or fault OBJECT_NOTFOUND_EXCEPTION does not exist in the list of fault bindings and there is no fault data handler setup ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: Problem while Using Batch SQL statement

  1. Problem while Using Batch SQL statement

    {PaymentConf_RetrieveAll_E1MM}E1_JDBCSRC_001.impor t
    Handler: com/ibm/ws/sca/internal/j2c/handler/J2CImportHandler (com.ibm.ws.sca.internal.j2c.handler.J2CImportHand ler,com/ibm/wsspi/sca/extensions/ImportBindingGroup2)

    Wrapped by:
    com.ibm.websphere.sca.ServiceRuntimeException: The fault selector returned a null or blank native fault name or fault OBJECT_NOTFOUND_EXCEPTION does not exist in the list of fault bindings and there is no fault data handler setup on operation or the binding to deal with this fault data.: caused by: java.lang.Exception: com.ibm.j2ca.dbadapter.core.runtime.exception.Obje ctNotFoundException: Business Object not found in database - No rows updated
    at com.ibm.ws.sca.internal.j2c.J2CMethodBindingImpl.g etFaultDataObject(J2CMethodBindingImpl.java:1280)
    at com.ibm.ws.sca.internal.j2c.J2CMethodBindingImpl.h andleFault(J2CMethodBindingImpl.java:1197)
    at com.ibm.ws.sca.internal.j2c.J2CMethodBindingImpl.c reateFaultObject(J2CMethodBindingImpl.java:717)
    at com.ibm.ws.sca.internal.j2c.J2CMethodBindingImpl.i nvoke(J2CMethodBindingImpl.java:419)
    at com.ibm.ws.sca.internal.j2c.J2CInterfaceBindingImp l.invoke(J2CInterfaceBindingImpl.java:118)
    at com.ibm.ws.sca.internal.j2c.handler.J2CImportHandl er.invokeDynamicImport(J2CImportHandler.java:1293)
    at com.ibm.ws.sca.internal.j2c.handler.J2CImportHandl er.processMessage(J2CImportHandler.java:411)
    at com.ibm.ws.sca.internal.message.impl.MessageDispat cherImpl.processMessageWithPCI(MessageDispatcherIm pl.java:726)
    at com.ibm.ws.sca.internal.message.impl.MessageDispat cherImpl.processMessage(MessageDispatcherImpl.java :1167)
    at com.ibm.ws.sca.internal.message.impl.ManagedMessag eImpl.process(ManagedMessageImpl.java:843)
    at com.ibm.wsspi.sca.ejb.module.impl.ModuleSessionBea n.processUOWMessage(ModuleSessionBean.java:336)
    at com.ibm.wsspi.sca.ejb.module.impl.ModuleSessionBea n.transactionNotSupportedActivitySessionNotSupport ed(ModuleSessionBean.java:291)
    at com.ibm.wsspi.sca.ejb.module.EJSLocalStatelessModu le_43132892.transactionNotSupportedActivitySession NotSupported(EJSLocalStatelessModule_43132892.java :131)
    at com.ibm.ws.sca.internal.uow.handler.UOWStrategyImp l.transactionLocalActivitySessionFalse(UOWStrategy Impl.java:386)
    at com.ibm.ws.sca.internal.uow.handler.JoinUOWHandler .processMessage(JoinUOWHandler.java:131)
    at com.ibm.ws.sca.internal.message.impl.MessageDispat cherImpl.processMessageWithPCI(MessageDispatcherIm pl.java:726)
    at com.ibm.ws.sca.internal.message.impl.MessageDispat cherImpl.processMessage(MessageDispatcherImpl.java :1167)
    at com.ibm.ws.sca.internal.message.impl.ManagedMessag eImpl.process(ManagedMessageImpl.java:834)
    at com.ibm.ws.sibx.mediation.flowaction.impl.sca.SCAI nvocationAction.invokeSync(SCAInvocationAction.jav a:548)
    at com.ibm.ws.sibx.mediation.flowaction.impl.sca.Retr yControl.invokeByStyle(RetryControl.java:348)
    at com.ibm.ws.sibx.mediation.flowaction.impl.sca.Retr yControl.invokeWithRetry(RetryControl.java:239)
    at com.ibm.ws.sibx.mediation.flowaction.impl.sca.Serv iceInvocation.complete(ServiceInvocation.java:124)
    at com.ibm.ws.sibx.mediation.flowaction.impl.sca.Flow ActionFactoryImpl.create(FlowActionFactoryImpl.jav a:696)
    at com.ibm.ws.sibx.mediation.primitives.serviceinvoke .ServiceInvokeMediation.invokeFlowAction(ServiceIn vokeMediation.java:524)
    at com.ibm.ws.sibx.mediation.primitives.serviceinvoke .ServiceInvokeMediation.mediate(ServiceInvokeMedia tion.java:446)
    at com.ibm.ws.sibx.scax.mediation.engine.JavaMediatio nPrimitive.performInvocation(JavaMediationPrimitiv e.java:622)
    at com.ibm.ws.sibx.scax.mediation.engine.JavaMediatio nPrimitive.invoke(JavaMediationPrimitive.java:344)
    at com.ibm.ws.sibx.scax.mediation.engine.SIBXJavaMedi ationPrimitive.invoke(SIBXJavaMediationPrimitive.j ava:105)
    at com.ibm.ws.sibx.scax.mediation.engine.MediationPri mitive.invokeConnections(MediationPrimitive.java:3 28)
    at com.ibm.ws.sibx.scax.mediation.engine.JavaMediatio nPrimitive.fireOutputTerminals(JavaMediationPrimit ive.java:720)
    at com.ibm.ws.sibx.scax.mediation.engine.JavaMediatio nPrimitive.performInvocation(JavaMediationPrimitiv e.java:642)
    at com.ibm.ws.sibx.scax.mediation.engine.JavaMediatio nPrimitive.invoke(JavaMediationPrimitive.java:344)
    at com.ibm.ws.sibx.scax.mediation.engine.MediationPri mitive.invokeConnections(MediationPrimitive.java:3 28)
    at com.ibm.ws.sibx.scax.mediation.engine.Input.invoke (Input.java:138)
    at com.ibm.ws.sibx.scax.mediation.engine.RequestFlow. invokeFlow(RequestFlow.java:132)
    at com.ibm.ws.sibx.scax.mediation.engine.MediationFlo w.invokeRequestFlow(MediationFlow.java:146)
    at com.ibm.wsspi.sibx.mediation.flow.ejb.MediationFlo wBean.invokeRequestFlow(MediationFlowBean.java:231 )
    at com.ibm.wsspi.sibx.mediation.flow.ejb.EJSLocalStat elessPaymentConf_RetrieveAll_E1Flow_ec26a6f7.invok eRequestFlow(EJSLocalStatelessPaymentConf_Retrieve All_E1Flow_ec26a6f7.java:127)
    at com.ibm.ws.sibx.scax.mediation.component.ejb.EJBMe diationFlowComponentImpl.invokeRequestFlow(EJBMedi ationFlowComponentImpl.java:223)
    at com.ibm.ws.sibx.scax.runtime.handler.MFCImplementa tionHandler.processMessage(MFCImplementationHandle r.java:200)
    at com.ibm.ws.sca.internal.message.impl.MessageDispat cherImpl.processMessageWithPCI(MessageDispatcherIm pl.java:715)
    at com.ibm.ws.sca.internal.message.impl.MessageDispat cherImpl.processMessage(MessageDispatcherImpl.java :1167)
    at com.ibm.ws.sca.internal.message.impl.ManagedMessag eImpl.process(ManagedMessageImpl.java:843)
    at com.ibm.wsspi.sca.ejb.module.impl.ModuleSessionBea n.processUOWMessage(ModuleSessionBean.java:336)
    at com.ibm.wsspi.sca.ejb.module.impl.ModuleSessionBea n.transactionRequiredActivitySessionNotSupported(M oduleSessionBean.java:315)
    at com.ibm.wsspi.sca.ejb.module.EJSLocalStatelessModu le_43132892.transactionRequiredActivitySessionNotS upported(EJSLocalStatelessModule_43132892.java:233 )
    at com.ibm.ws.sca.internal.uow.handler.UOWStrategyImp l.transactionGlobalActivitySessionFalse(UOWStrateg yImpl.java:311)
    at com.ibm.ws.sca.internal.uow.handler.JoinUOWHandler .processMessage(JoinUOWHandler.java:165)
    at com.ibm.ws.sca.internal.message.impl.MessageDispat cherImpl.processMessageWithPCI(MessageDispatcherIm pl.java:726)
    at com.ibm.ws.sca.internal.message.impl.MessageDispat cherImpl.processMessage(MessageDispatcherImpl.java :1167)
    at com.ibm.ws.sca.internal.message.impl.ManagedMessag eImpl.process(ManagedMessageImpl.java:834)
    at com.ibm.wsspi.sca.ejb.module.impl.ModuleSessionBea n.processMessage(ModuleSessionBean.java:153)
    at com.ibm.wsspi.sca.ejb.module.EJSLocalStatelessModu le_43132892.processMessage(EJSLocalStatelessModule _43132892.java:97)
    at com.ibm.wbit.comptest.controller.invocation.impl.A dhocInvoker.processMessage(AdhocInvoker.java:72)
    at com.ibm.wbit.comptest.controller.invocation.impl.I nvoker.managedInvoke(Invoker.java:284)
    at com.ibm.wbit.comptest.controller.invocation.impl.I nvoker.invoke(Invoker.java:175)
    at com.ibm.wbit.comptest.controller.invocation.impl.B aseInvocationHandler.invoke(BaseInvocationHandler. java:64)
    at com.ibm.wbit.comptest.controller.invocation.impl.I nvocationManager.doInvoke(InvocationManager.java:6 7)
    at com.ibm.wbit.comptest.controller.invocation.impl.I nvocationManager$1.run(InvocationManager.java:48)
    at java.security.AccessController.doPrivileged(Access Controller.java:219)
    at javax.security.auth.Subject.doAs(Subject.java:495)
    at com.ibm.websphere.security.auth.WSSubject.doAs(WSS ubject.java:118)
    at com.ibm.wbit.comptest.controller.invocation.impl.I nvocationManager.invoke(InvocationManager.java:42)
    at com.ibm.wbit.comptest.controller.command.impl.Base InteractiveEventHandler.processEvent(BaseInteracti veEventHandler.java:37)
    at com.ibm.wbit.comptest.controller.command.impl.Base CommandHandler.doCommand(BaseCommandHandler.java:1 06)
    at com.ibm.wbit.comptest.controller.command.impl.Comm andProcessor.doCommand(CommandProcessor.java:70)
    at com.ibm.wbit.comptest.controller.command.impl.Comm andProcessor.doCommand(CommandProcessor.java:42)
    at com.ibm.wbit.comptest.controller.servlet.TestContr ollerServlet.process(TestControllerServlet.java:16 3)
    at com.ibm.wbit.comptest.controller.servlet.TestContr ollerServlet.doPost(TestControllerServlet.java:125 )
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:763)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:1149)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:591)
    at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.h andleRequest(ServletWrapper.java:481)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrappe r.handleRequest(CacheServletWrapper.java:90)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest (WebContainer.java:748)
    at com.ibm.ws.wswebcontainer.WebContainer.handleReque st(WebContainer.java:1466)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.read y(WCChannelLink.java:119)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleDiscrimination(HttpInboundLink.java:458)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleNewInformation(HttpInboundLink.java:387)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.ready(HttpInboundLink.java:267)
    at com.ibm.ws.tcp.channel.impl.NewConnectionInitialRe adCallback.sendToDiscriminators(NewConnectionIniti alReadCallback.java:214)
    at com.ibm.ws.tcp.channel.impl.NewConnectionInitialRe adCallback.complete(NewConnectionInitialReadCallba ck.java:113)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListe ner.futureCompleted(AioReadCompletionListener.java :165)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallbac k(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletion Actions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture .java:136)
    at com.ibm.io.async.ResultHandler.complete(ResultHand ler.java:196)
    at com.ibm.io.async.ResultHandler.runEventProcessingL oop(ResultHandler.java:751)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler .java:881)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:1473)
    Caused by: java.lang.Exception: com.ibm.j2ca.dbadapter.core.runtime.exception.Obje ctNotFoundException: Business Object not found in database - No rows updated
    ... 91 more

  2. Re: Problem while Using Batch SQL statement

    bzzt, not a MQ problem, you probably won't get a response in this forum.

+ Reply to Thread