cancel
Showing results for 
Search instead for 
Did you mean: 

Issue after deleting table APPSYSNAME - refresh

Former Member
0 Kudos

Hi Experts,

My SCM version is 7.0 EHP3. We have built a new develoment system after restoring database from our current development. Livecache also has been restored & started successfully from target livecache database. I am doing a post steps now & facing an issue while that.

I had run sql command DROP TABLE APPSYSNAME as per note  1015489 and restarted SAP & livecache.

Not I am running a report SLCA_GET_SYSNAME (which was showing source SCM SID before DROP activity). & it is showing 'Table for system names does not yet exist'. Please let me know how I can resolve this.

I have also changed logsys name in /SAPAPO/ORDMAP as per note  .877203

Kindly help me with this as I am stuck up in between due to this.

Thanks

Amar.

Accepted Solutions (0)

Answers (1)

Answers (1)

yashwanthkumar_kethineed
Active Participant
0 Kudos

Hello Amar,

1) Which user did you use to run the sql command 'DROP TABLE APPSYSNAME' ?

2) Post the result of sql command "sql_execute select * from tables where owner = 'SAP<SID>'
3) What is the version of liveCache/LCAPPS installed ?

4) Did you restart liveCache after dropping the table APPSYSNAME ? This is required for liveCache to adapt to the new sysid.

Regards, Yashwanth

Former Member
0 Kudos

Hi Yashwanth,

After running first SCM job which connects to LCA the new SID started reflecting so the issue has been resolved. Thanks for your suport.

Thanks

Amar.