LiveCache Short Dump post System copy – LCA03 (DBIF_DSQL2_SQL_ERROR)
Error:
After System copy of LiveCache Database to test system, you get DBIF_DSQL2_SQL_ERROR shortdump when you run consistency check of LCA03.
Shortdump include the following:
SIM_SIMSESSION
SIM_SIMSESSION_GET_ALL
CX_SY_NATIVE_SQL_ERROR
/SAPAPO/OM_SIMSESSION_GET_ALL
POS(1) Work rolled back: tExpect nnnnn in SIM_SIMSESSION
/SAPAPO/SAPLOM_CORE
Solution:
Execute following dbmcli command to remove production entries from the table.
DBSID = Livecache Database SID
DBHOST= Live Cache Database hostname
PASSWORD = With appropriate password
SAPSID = User with SQL access to database.
After System copy of LiveCache Database to test system, you get DBIF_DSQL2_SQL_ERROR shortdump when you run consistency check of LCA03.
Shortdump include the following:
SIM_SIMSESSION
SIM_SIMSESSION_GET_ALL
CX_SY_NATIVE_SQL_ERROR
/SAPAPO/OM_SIMSESSION_GET_ALL
POS(1) Work rolled back: tExpect nnnnn in SIM_SIMSESSION
/SAPAPO/SAPLOM_CORE
Solution:
Execute following dbmcli command to remove production entries from the table.
dbmcli -d DBSID -n DBHOST -u superdba,PASSWORD -uSQL
SAPSID,PASSWORD
In the above command, replace with following
DBSID = Livecache Database SID
