Skip to Content

DBIF_DSQL2_SQL_ERROR in APO system

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 07, 2015 at 08:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded