LCA03 generates short dump: DBIF_DSQL2_SQL_ERROR

[tj_wilkinson2]

This dump occurs in procedure "/SAPAPO/OM_SIMSESSION_GET_ALL".

If I look at the logs in LC10, it says:

SIM_SIMSESSION_GET_ALL

Invalid app server: SCX

expected: SCP

We recently completed (or thought we did - seems like we missed a step) a refresh of our sandbox SCM and livecache systems from production.

SCX is the sandbox system and SCP is the production system. This message makes me think that the new sandbox livecache copy is still trying to point to the production SCM system. Has anyone seen this before? Is there something I need to change within the livecache database?

I found a note (877203) that mentions changing the logical system name in /SAPAPO/PRDMAP to the target system, but when I run through the steps to do that, the command: select LOGSYS, count(*) from "SAPR3"."/SAPAPO/PRDMAP" group by logsys returns zero results - thus I didn't think I had to change anything.

I appreciate any feedback.

~TJ

[former_member229109 · Accepted solution]

Hello TJ Wilkinson,

-> You are SAP customer. Please create the OSS ticket to the component 'BC-DB-LCA',

therefore we could logon & take a look closer on the reported issue.

-> Please review the SAP Note No. 1015489 with 'Reason and Prerequisites':

"You want to access the liveCache from the application server. However, the system name does not match the one specified in the liveCache. This may happen after a homogeneous system copy."

Did you run the homogeneous system copy?

What is the version of your system?

What is the version/build of the liveCache and LCA on the system?

What LCA/database error reported in the ABAP dump?

Thank you and best regards, Natalia Khlopina