/SAPAPO/OM13: DBIF_DSQL2_SQL_ERROR

Symptom

You are performing the MaxDB live cache backup/restore system copy/refresh. During the post checks, you have execute command /SAPAPO/OM13 to analyze liveCache and LCA Objects. But, during the execution, the program terminated with below error.

Category               Installation Errors
Runtime Errors         DBIF_DSQL2_SQL_ERROR
Except.                CX_SY_NATIVE_SQL_ERROR
Date and Time          30.01.2012 00:05:50

Short text
SQL error 600 occurred when executing Native SQL.

What happened?
The error 600 occurred in the current database connection "XXX".
Error Text of Database: "POS(1) Work rolled back: tExcept 30708 in
APS_TIME_GET# "
SQL Statement Responsible:"EXECUTE PROCEDURE "APS_TIME_GET""

Solution

You need to refer to SAP Note 1015489 for details.

1. Access to the MaxDB DBMCLI and execute as per below,

LCA Release 6.0 to LCA Release 7.0 LCA Build 04

dbmcli -d LC-INSTANCE -n LC-SERVER -u DBM-USER,PASSWORD -uSQL
LC-USER,PASSWORD sql_execute DROP TABLE APPSYSNAME

LCA Release 7.0 as of LCA Build 05 and higher

dbmcli -d LC-INSTANCE -n LC-SERVER -u DBM-USER,PASSWORD -uSQL
LC-USER,PASSWORD sql_execute DROP TABLE APPSYSPARAM

2. Restart the liveCache.