IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

ART114505 Error while invoking adapter service comwmadapterwmjdbcservicesStoredProcedure

  • 1.  ART114505 Error while invoking adapter service comwmadapterwmjdbcservicesStoredProcedure

    Posted Thu December 04, 2003 05:02 PM

    Hi,

    I have built a small business process using webMethods modeler. Each of the steps uses adapter service flows (select, stored procedure)…

    I have tested each of the generated flow services individually from developer and it works fine but when the service is used in a process it is failing. When I do check the pipeline in WmMonitor, all the data is there, nothing is missing but it seems line either the data is not taken into account). It is the first time I try to use modeler to generate process to take advantage of the monitoring capabilities and test the re-submit functionality.

    Any thoughts about that error?

    For more information: I am using SQL server 2000 + SP3
    JDBC Adapter 6.0.2
    IS 6.0.1 + SP2
    Developer 6.0.1 + SP1
    Modeler 6.0.1 + SP1

    Thanks,

    Kacem

    com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service HAYS:UpdateStatusFromTransporter. [ART.114.505] Error while invoking adapter service com.wm.adapter.wmjdbc.services.StoredProcedure. com.wm.adk.cci.record.WmRecord at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:125) at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:116) at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:103) at com.wm.pkg.art.ns.AdapterServiceNode.invokeService(AdapterServiceNode.java:649) at com.wm.pkg.art.ns.ARTNSService.baseInvoke(ARTNSService.java:47) at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:344) at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:153) at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:324) at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:577) at com.wm.lang.flow.FlowState.step(FlowState.java:435) at com.wm.lang.flow.FlowState.invoke(FlowState.java:400) at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1740) at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:344) at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:104) at com.wm.app.b2b.server.Service.doInvoke(Service.java:605) at com.wm.app.b2b.server.Service.doInvoke(Service.java:554) at com.wm.app.prt.IntegrationServer.invoke(IntegrationServer.java:55) at com.wm.app.prt.IntegrationServer.invokeWrapper(IntegrationServer.java:41) at com.wm.app.prt.StepDispatcherAgent.runStep(StepDispatcherAgent.java:479) at com.wm.app.prt.StepDispatcherAgent.execute(StepDispatcherAgent.java:388) at com.wm.app.prt.StepDispatcherAgent.synchRun(StepDispatcherAgent.java:75) at com.wm.app.prt.StepDispatcherAgent.synchRun(StepDispatcherAgent.java:84) at com.wm.app.prt.StepDispatcherAgent.synchRun(StepDispatcherAgent.java:84) at


    #webMethods
    #Flow-and-Java-services
    #Integration-Server-and-ESB