TVAS Report failing with Error ResourceException occurred in method ConnectionFactoryImpl.getConnection(): javax.resource.ResourceException: (Failed in component: dbpool, BC-JAS-TRH) Cannot create connection

Problem

TVAS log displays:

ResourceException occurred in method ConnectionFactoryImpl.getConnection(): javax.resource.ResourceException: (Failed in component: dbpool, BC-JAS-TRH) Cannot create connection. Possible reasons:

1)Maximum allowed connections to DB or EIS is reached. You can apply CSN Note 719778 in order to check and resolve connection leaks.

2) Configuration to DB/EIS is wrong or DB/EIS is temporary unreachable.

3) Connections are not enough for current load.

Solution:

In Netweaver administrator, go to site map->Application Resources-> choose JDBC Custom DataSources from Show dropdown list. The Maximum Connections is under the Connection Pooling tab.

As a possible workaround, have the user wait a few minutes and try to execute the report again.