LiveCache Short Dump post System copy – LCA03 (DBIF_DSQL2_SQL_ERROR)

Posted by Faisal Tuesday, January 28, 2014 5:04 AM 0 comments
Labels: , , , , , , , , ,

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.
dbmcli -d DBSID -n DBHOST -u superdba,PASSWORD -uSQL SAPSID,PASSWORD

In the above command, replace with following

 DBSID = Livecache Database SID
DBHOST= Live Cache Database hostname
PASSWORD = With appropriate password
SAPSID = User with SQL access to database.

Subscribe to: Posts (Atom)