DBIF_DSQL2_SQL_ERROR in APO system

[former_member204080]

Hi All,

We have recently performed APO refresh (from Prod to test system) .Livecache seems to be unstable

There are multiple connection issues .We are also getting lot of DBIF_DSQL2_SQL_ERROR dumps

Below are programs where dump is coming

SAPLSLCAPPS_LCK

/SAPAPO/SAPLOM_PLANNINGTABLE

/SAPAPO/SAPLOM_PLANNING

/SAPAPO/SAPLOM_CORE

Dump details:

SQL error "-10709" occurred while executing Native SQL.

What  happened?

Error "-10709" has occurred on the current database connection "LCA".

Database error text: Connection failed (RTE:task limit)

Triggering SQL statement: "commit work"

Connection to livecache seems to be dropping constantly

Has anyone faced this issue .We have checked few notes but didnt help

Regards,

Murali

[former_member204080 · Accepted solution]

Hi All,

Issue got resolved after increasing the MAXUSERTASKS parameter .There were very less number of LC sessions available and most of them were occupied hence when new user were trying to run the t-codes it was giving the dump

We have increased the parameter according to Formula and restarted livecache

MaXUsertask=No of Work process *3 +4

Regards,

Murali