Question Re: Runtime error DBIF_DSQL2_SQL_ERROR during local clien copy in Technology Q&A

Runtime error DBIF_DSQL2_SQL_ERROR during local clien copy

Former Member — Wed, 07 Aug 2019 08:10:02 GMT

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

Re: Runtime error DBIF_DSQL2_SQL_ERROR during local clien copy

Shabeer — Wed, 07 Aug 2019 10:54:26 GMT

Check this SAP note: 2508724 - liveCache on HANA - DBIF_DSQL2_SQL_ERROR - OmsTerminate: error=-28530

Best Regards,

Shabeer

Re: Runtime error DBIF_DSQL2_SQL_ERROR during local clien copy

bharathyp — Wed, 07 Aug 2019 13:52:09 GMT

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.

Re: Runtime error DBIF_DSQL2_SQL_ERROR during local clien copy

former_member229109 — Tue, 03 Mar 2020 19:56:46 GMT

Hello Bogdan,

you got the liveCache tExcept 30708 in APS_MLEVEL_ATP_PROT_DEL. This

error code 30708 states that there is an attempt to access the liveCache from another system that is different from the one whose name is defined in the liveCache. This may happen after a homogeneous system copy.

See the details in SAP note - 1015489 - Connection problems after system copy