ART114505 Error while invoking adapter service comwmadapterwmjdbcservicesStoredProcedure

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