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

  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!

Hi Ramani,

please check your Fixes for WmART, WmDeployer as well as the used JDBC-Drivers.

Which database are we talking about?

How do you modify the connections parameters during deployment?
Substitutions in DeployerMaps? or are you editing the connections manually.