Some Nodes of Communication Channel in error

[Former Member]

Hi All,

I am working with a JDBC receiver channel. There are 5 nodes altogether out of which two are in error. The rest 3 are running fine and green. The error showing up in the channel log is "Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://xxx.xxx.xxx.xxx:1433;DatabaseName=xxxxxx': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket."

Kindly help me to solve this situation.

Thanks,

Janeef

[dharamveer_gaur2]

Hi,

Could you check Maximum concurrency of JDBC adapter, is it "0" .

This pooled resource error comes somtimes due to max concurrency of database 0 and at a time more than 1 connection try to create. To increase concurrency read point 28 of SAP Note 831162

[Former Member]

Hi Dharamveer,

The Max Concurrency is set to 2.

Thanks,

Janeef

[Former Member]

Hi Janeef,

Please check the connection string for the JDBC.

Check whether the IP/Hostname is correct and also the database name.

Also, if there is any firewall, check for the connectivity also using Ping/Telnet commands.

-Supriya.

[Former Member]

Hi Supriya,

The connection string is fine. Also, 3 server nodes of the communication channel are green and processing messages also. ONLY two is having issues. We tried ping and tracert as well. It is also ok.

Thanks,

Janeef