No SQL connection is possible, despite state ONLINE (LCA)

[Former Member]

hi all,

i'm getting the following error "No SQL connection is possible, despite state ONLINE (LCA)"

in ta sm21 i get this :

Database error -10709 at CON

> Connection failed (RTE:[2] task limit)

SQL Statement Execution Instance ONLINE, but no SQL access possible

1. Connect. test with "dbmcli db_state" Successful

2. Connect. test with command mode "dbmrfc db_state" Successful

3. Connect. test with session mode "dbmrfc db_state" Successful

4. Connect. test with "native SQL" ( LCA ) No connection

SQL Code: 10709

Connection failed (RTE:[2] task limit)

For detailed information, see the developer trace for work process: 0

-> st11

• ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:[2] task limit))

king regards

[former_member229109]

Hello,

1. You are SAP customer.

Did you create the SAP message to get SAP support on this issue?

2. To get clear on the reported issue, please update the message with following information:

• What is the version of your system?

• What is the version of the liveCache database instance?

• What is the value of the MAXUSERTASKS liveCache parameter and what is the number of WPs on the system?

• Please run the following commands on the liveCache server & update with output:

dbmcli db_enum

dbmcli inst_enum

x_cons <liveCache SID> show active

Regards, Natalia Khlopina

[Former Member]

Hello,

What is the version of your system? -> SAP SCM 7.0

What is the version of the liveCache database instance? -> KernelVersion KERNEL 7.7.04 BUILD 029-123-196-543 Version of the database installation

What is the value of the MAXUSERTASKS liveCache parameter and what is the number of WPs on the system? -> MAXUSERTASKS : 55

dbmcli db_enum :

OK

CMT /sapdb/CMT/db 7.7.04.29 fast running

CMT /sapdb/CMT/db 7.7.04.29 quick offline

CMT /sapdb/CMT/db 7.7.04.29 slow offline

CMT /sapdb/CMT/db 7.7.04.29 test offline

dbmcli inst_enum :

OK

7.7.04.29 /sapdb/CMT/db

Regards

[former_member229109]

Hello,

1. You are SAP customer.

Did you create the SAP message to get SAP support on this issue?

2. What is the value of the MAXUSERTASKS liveCache parameter and what is the number of WPs on the system?

MAXUSERTASKS - 55

But what is the number of WPs on the system? < run //om13 -> checks >

Regards, Natalia Khlopina