DBIF_DSQL2_SQL_ERROR in APO system
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
SQL error "-10709" occurred while executing Native SQL.
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
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