What is the cause & solution for batch job being stuck on "Other DB Action/TREXviaDBSL" task?

[wounky]

Hi,

In BW on HANA we are experiencing planning sequence jobs being stuck on "Other DB Action/TREXviaDBSL" task and never moving forward. Standard PLSEQ execution time should be aroud 15minutes, once it gets stuck it never ends.

Main PLSEQ job is scheaduling 3 ones:

One of the three is getting stuck:

On the process:

And it never ends. It happens daily and interrupts main nightly process chains.

Could you please tell how to fix it or how to check what could be wrong?

We have managed to find one not however not sure if its accurate.

2280288 - TREXviaDBSL and TREXviaDBSLWithParameter Statements can Remain Open with Status 'SUSPENDED...

Thanks and kind regards,

Sebastian

[wounky · Accepted solution]

Hello,

The cause was system parameter for HANA DB job timeout being set to 20minutes.

Resolution from the note: "2308459 - Troubleshooting '10108' + '9300' errors in relation to SAP HANA" has been applied.

&

Cube compression like in the link .

Both combined helped.

Kind regards,

Sebastian

[wounky]

Hi Ashish,

No solution yet, current solution attempt for the upcoming weekend is lowering down the number of records in the cube processed by PLSEQ by removing the audit and aggregating the data for historical transactions.

If you happen to find the solution, please let us know.

Thanks in advance,

Sebastian

[former_member210696]

Hi Sebastian,

Greetings

I am facing the same issue. Did you manage to find a solution.

I am facing this issue when I am executing a step (Fox Code) in my planning sequence. in SM51, it gets stuck in

DB-PROC SYS.TREXviaDBSL

The same FOX code gets successfully executed in ABAP (Trace mode).

Regards

Amogh

[wounky]

Tried to run the trace on workprocess however one never knows which process out of the three will hang and if it will at all (small chance) and the one run on the process thats already hanging does not provide any info.

Anyone has some ideas?

[wounky]

Implementing parameters from the note '2280288 - TREXviaDBSL and TREXviaDBSLWithParameter Statements can Remain Open with Status 'SUSPENDED... did not help.