Cannot connect to jdbc:sapdb://<host>/<DB> [Time out]

[Former Member]

Hello experts,

while starting the SAP-System (CE 7.1, local AS Java) in the default trace several errors occurs. The error message is "Cannot connect to jdbc:sapdb://<host>/<DB> [Time out]". With the command line tool I'am able to access the database. It's also possible to start the configtool. But if I try to access NWA, error 503 appears.

=========================================================================

#2.0 #2013 05 01 21:38:21:718#0-700#Error#com.sap.jms#

#BC-JAS-JMS#jms#0050569C4F4103B70000000200000664#4087050000089607##com.sap.jms.server.dc.CleanupTask#Guest#0##DDDB6CC2B0CF11E292F70050569C4F41#dddb6cc2b0cf11e292f70050569c4f41#dddb6cc2b0cf11e292f70050569c4f41#0#Thread[JMS (14140) Cleanup Task, type = 1, dstId = 6,5,Managed_Application_Thread]#Plain##

com.sap.jms.server.dc.pm.PersistencyException:

    at com.sap.jms.server.dc.pm.jdbc.JdbcBasePersistenceManager.deletePreviousMessages(JdbcBasePersistenceManager.java:826)

    at com.sap.jms.server.dc.consumer.TopicDestinationManager.cleanup(TopicDestinationManager.java:186)

    at com.sap.jms.server.dc.CleanupTask.deleteAcknowledgedMessagesOnTopic(CleanupTask.java:138)

    at com.sap.jms.server.dc.CleanupTask.execute(CleanupTask.java:96)

    at com.sap.jms.server.dc.Command.run(Command.java:28)

    at com.sap.engine.core.thread.execution.Executable.run(Executable.java:109)

    at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:314)

Caused by: com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.dbtech.jdbc.exceptions.JDBCDriverException: Cannot connect to jdbc:sapdb://<host>/<db> [Task limit].

    at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:59)

    at com.sap.jms.server.dc.pm.jdbc.JdbcBasePersistenceManager.getConnection(JdbcBasePersistenceManager.java:1074)

    at com.sap.jms.server.dc.pm.jdbc.JdbcBasePersistenceManager.deletePreviousMessages(JdbcBasePersistenceManager.java:795)

    ... 6 more

Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.dbtech.jdbc.exceptions.JDBCDriverException: Cannot connect to jdbc:sapdb://devsapnw01/ND1 [Task limit].

    at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:156)

    at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:216)

    at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:283)

    at com.sap.engine.services.connector.jca.ShareableConnectionManager.allocateConnection(ShareableConnectionManager.java:54)

    at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:51)

    ... 8 more

Caused by: com.sap.dbtech.jdbc.exceptions.JDBCDriverException: Cannot connect to jdbc:sapdb://<host>/<db> [Task limit].

    at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:237)

    at com.sap.sql.connect.factory.DriverPooledConnectionFactory.createVendorConnection(DriverPooledConnectionFactory.java:50)

    at com.sap.sql.connect.factory.DriverPooledConnectionFactory.getPooledConnection(DriverPooledConnectionFactory.java:37)

    at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnection(DBDataSourceImpl.java:674)

    at com.sap.sql.connect.datasource.DBDataSourcePoolImpl.matchPool(DBDataSourcePoolImpl.java:1065)

    at com.sap.sql.connect.datasource.DBDataSourcePoolImpl.matchPooledConnection(DBDataSourcePoolImpl.java:880)

    at com.sap.sql.connect.datasource.DBDataSourcePoolImpl.getConnection(DBDataSourcePoolImpl.java:65)

    at com.sap.engine.core.database.impl.DatabaseDataSourceImpl.getConnection(DatabaseDataSourceImpl.java:36)

    at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:121)

    ... 12 more

=========================================================================

Any idea, how to solve this problem?

Many thanks and best regards,

Max

[Former Member · Accepted solution]

Hey experts,

I solved the problem by my own. I raised the MaxDB Parameter MaxUserTasks from the default value "5" to value "20". Now it worksfine.

Kind regards,

Max