The Resource Pool has already been destroyed - File to JDBC Scenario

[Former Member]

Hi,

Error : "Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: The resource pool has already been destroyed"

Scenario : This error is occurring for the File to JDBC Scenario .

Could you please let me know why am getting this error and solution to resolve this error..

Thanks in Advance!!

Regards,

Sekhar

[baskar_gopalakrishnan2]

This could be due to few reasons. Due to invalid login credentials, the connections to jdbc might have lost or locked completely or the connection pool of database is completely used due to connection leaks and no more exist to use. You can stop and reactivate the channel and see the behaviour. Also I want you to talk with dba about connection pool issue.

[Former Member]

Set the Maximum Concurrency parameter to 1, then set the pollWaitingTime parameter as described on the OSS note #831162, under question "28. Effect of setting Maximum Concurrency and poolWaitingTime".

[Former Member]

Hi ,

Thanks for the replies..

Just to add to have more clarity on the error for the scenario

Scenario : This error is occurring for the File to JDBC Scenario

The Scenario has a BPM involved.The synchronous send step within the BPMsends the data to the JDBC receiver adapter.The response from the JDBC

adapter is throwing the below error.

Thanks,

Sekhar