we have upgraded webMethods 6.0.1 to 6.5 recently. Everything was fine. But when interacting with the Database it was giving the following error.
[ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service IFC_OIL.Oracle:getOutboundTransaction.
[ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter service. Error occurred when connecting to resource IFCJDBCAdapters:OracleEAI.
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource IFCJDBCAdapters:OracleEAI.
A connection was not available for request in pool IFCJDBCAdapters:OracleEAI
The interesting this is when i was executing a dynamic SQL it was working perfect. But we were executing a stored procedure. Hence it was giving this error…
I really appreciate if anyone helps me regarding this…