GetConnection from Datasource Gives Exception

[former_member626074]

Dear All

We are facing below error when we are trying to getConnection to access DB by using Datasource.

ResourceException in method ConnectionFactoryImpl.getConnection():

com.sap.engine.services.connector.exceptions.BaseResourceException: "ConnectionManager" is closed.

Possible reasons:

1) connector "<Datasource Name>" is stopped or not started,

2) Connector service is stopped or has not been started.

System is on EP 7.0, DB is Oracle.

We have implemented below solutions but these are not permanent fixes

1) Increase the number of Connections associated to this Data Source.

2) In NWA go to the Administration > application > and restart the application which is using this Datas source.

Above two seems to be not helpful as when applications are running on Prod Server.

Can any one please provide the Permanent Fix.

Thank you.

Regards

Raghavendra

[former_member626074]

Can any one please respond on this issue.

Thank you.

Regards

Raghavendra

[former_member190358]

Hi Raghavendra,

First you will have to determine which connection type you are using. SAP has release a note for this problem. Please go through 1600085. Addition to this also go through below sdn posts. Might be some help for you.

and below link

http://help.sap.com/saphelp_nw04/helpdata/en/5c/2f2c4142aef623e10000000a155106/content.htm

Regards,

Ravi Maheshwari