JDBC adaptor service throwing an error while calling stored procedure

, ,
1

Hi All,

I am getting the below error when an adapter service calls a stored procedure.
I can run all other sql statements select, insert and update without any issues.

com.wm.pkg.art.error.DetailedServiceException:[ART.117.4002}Adapter Runtime(Adapter Service): Unable to invoke adapter service TEST.adapters:wm_test [ART.114.505 ] Error while invoking adapter service com.wm.adapter.emjdbc.services.StoredProcedure.null at com.wm.pkg.art.error.DetaileServiceException.create

Database used : SQL server 2000.
webMethods server : 6.5 with SP1

Also placed the three jar files and restarted the server.
1.mssqlserver.jar
2.msutil.jar
3.msbase.jar

Still seeing the same issue.

Please help me.

Thanks!!!
Renuka

2

Check if you can execute strored proc directly from passing input directly. If it is giving proper results ?