We are facing an issue while deploying adapter services from one environment to the other in webMethods
JDBC Adapter Version: 6.5
Procedure followed to deploy adapter services/connections in new environment:
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
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.
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.
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!