JDBC Adapter services Issue(6.5)

We are facing an issue while deploying adapter services from one environment to the other in webMethods

JDBC Adapter Version: 6.5

Fixes: JDBC_6-5_Fix4

Procedure followed to deploy adapter services/connections in new environment:

  1.   We have the JDBC adapter connections and adapter services maintained in separate packages. 

a. Across environments (Dev, QA) we have the same JDBC adapter connection name and DB schema name. Therefore upon deployment, we edit the application server name, password for the adapter connection and enable the connection. Connection looks fine.

b. Install the adapter services package and check references for all adapter services.(storedProcedureWithSignature). All services have correct references to the adapter connection

The Issue

  1.   When the adapter service (configured for storedProcedureWithSignature) is executed I get the following error:

Could not run .com.wm.app.b2b.server.ServiceException: [ART.117.4021] Adapter Runtime (Adapter Service): Unable to invoke adapter service cox.cns.eventprocessor.services.adapter:hasOtherActiveServices. Unable to get adapter service template.
[ART.114.72] Adapter Runtime: Unable to set JavaBean properties.
[ART.114.542] could not set property “resultSetInfo” in class “com.wm.adapter.wmjdbc.services.ProcedureSignature”.
Method not found: getResultSetInfo
Also on subsequent execution of the service , null exception is thrown.

  1.   Though once the adapter service is saved and executed, the service runs successfully. No major changes made to the adapter service when it is saved. 
  2.   This is not the right approach and therefore looking for a solution to this strange problem.

If anyone has experienced such issues or has any insights on the above condition, please send in your comments. Any suggestion would be helpful!

I could find the below from troubleshoot guide.


ART.0117.4021E Adapter Runtime (Adapter Service): Unable to invoke
adapter service template.
Explanation: [/b][/size][/font]WmART failed to create an instance of the specified [FONT=ArialNarrow,Bold][SIZE=2]Recommended Action: [/size][/font][FONT=PalatinoLinotype][SIZE=2][FONT=PalatinoLinotype][SIZE=2]
Ensure that the implementation class for the adapter service is installed correctly in the package. Call Technical Services if the problem persists.