Runtime error DBIF_DSQL2_SQL_ERROR during local clien copy

[Former Member]

During local client copy I got runtime error DBIF_DSQL2_SQL_ERROR. The error occured at post processing phase.

I wanted to create new client as a copy of 000 client. System was S/4HANA Best Practice 1809.

Here are first few lines from ST22:

Category Installation error Runtime Errors DBIF_DSQL2_SQL_ERROR Except. CX_SY_NATIVE_SQL_ERROR Date and Time 07.08.2019 09:24:33 Short Text SQL error 423 occurred while executing Native SQL. What happened? Error 423 has occurred on the current database connection "DEFAULT". Database error text: AFL error: OmsTerminate: error=-28530, liveCache tExcept 30708 in APS_MLEVEL_ATP_PROT_DEL# liveCache ERROR 30708 in APS_MLEVEL_ATP_PROT_DEL: SessionGlobals::isMarkedForTerminate(h) is true!!! . Triggering SQL statement: "EXECUTE PROCEDURE "APS_MLEVEL_ATP_PROT_DEL""

Thank you in advance.

Bogdan Savic

[bharathyp]

Hi Bogdan.

Is this a TDI or HANA Appliance?

Usually for a simple client copy you shouldn't face this issue IF it is a HANA Appliance as the vendor usually fine tunes the parameters accordingly before delivering it.

If it is a TDI, couple of things you can do is use the hw check tool and also run sql mini checks and correct them accordingly if needed.

Best Regards,

Bharath.