SCM system copy with livecache post steps

[Former Member]

Hello,

I am trying to create a new SCM quality system by making a copy of production system using backup/restore. I am a basis person and this is my first time working on SCM system. Please note that we want to copy both SCM database and also the data in livecache database. The SIDs for both SCM and Live cache instance are changing. I have read multiple notes (1015489, 886103, 877203, 457425, 1030857, 1349272 etc) and some GREAT POSTS in this forum BY NATALIA KHLOPINA. Thanks to this info, I have done the following so far:

SCM version is 7.0 SP 11 and Livecache version is 7.7.7.

I first copied over the SCM database using backup restore.

Installed the SCM target system with the new SID

Installed Livecache instance for target system (on a separate host than SCM) using swpm

Then I initialized the maxdb instance via DB manager

then I did restore and initialize using the full backup that I had taken of source livecache system via DBM GUI (pretty much steps in note 457425)

Then ran the following command : load_systab -u superdba,admin

(ran into some issues in between but resolved one by one like upgrading kernel, re-restored the db afer change default_code to Unicode etc )

Then in LC10, LCA -  I registered LCAPPS

Then in LC10, I did the integration configuration for LCA connection (it was blank due to some reason after the copy). Also reentered the u/p for LDA and LEA connections.

The LC10 connections are coming up green to livecache

Firstly, can you verify the steps above are correct so far ?

Secondly, I am trying to follow the notes 1015489, 886103, 877203, 457425 and 1030857, 1073954 to do post copy steps and have the following issues/questions:

1) In note 1015489 (connection problems after system copy),  it says to run report SLCA_GET_SYSNAME to get system name in livecache. When I do so, It says "Table for system names does not yet exist". Is that normal ( I am on scm 7.0 SP11) ? If I go to dbmcli and try to drop table APPSYSPARAM or APPSYSNAME, it says table does not exist ?? How do I verify if correct system name is registered in livecache?

2) Note 886103 (system landscape copy for SCM) -- It says to change logical system name in /SAPAPO/ORDMAP but this table is not active in my dictionary !! same for table CIFRFCDES and table /sapapo/cifdistr does not exist ??

3) Note 886103 says that if you want to rename the user SAPR3 to SAPEL1, you run some dbmcli commands. Is this necessary ?? my Livecache id is changing from LIP to LIQ, so shall I change it ? The domain.users currently shows control , superdba and also SAPLIP user and SAPLIQ user (SAPLIQ user only started showing up after I registered LC APPS ). Do I need to do anything else or verify something ?

4) Note 877203 once again talks about SAPEL1 user and I am not sure if I need to run these steps or not

5) Note 1030857 tells to run this report zz_update_acckey to correct the external keys. Is this necessary even if we run BDLS ? Shall I ask the SCM functional person ?

6) Note 1073954 (effects of changing the standard livecache user) -- How do I know if I need to run this ? my livecache tables like /sapapo/ordmap are stil owned by SAP<OLDSID> but  in LC10 connections I have changed the three connections to use SAP<NEWSID> user and the connetions are green and connection tests in db59 are also successful !!.

The note says that "Only change the standard liveCache user if the system does not contain any data or if you initialize the liveCache directly after the change"

My copied over livecache does contain data and If I initialize the livecache after changing this user id, I guess I will loose the data. So, Can I skip this step as long as connections in LC10 and db59 are working okay ?

7 ) How can I verify that APO optimizer is also installed in Production system. I thought it was optional to install it and I don't know if this client is using it ?

Sorry for this long long post. Hope someone out there has patience to clarify my doubts.

Thanks

BV

[former_member229109 · Accepted solution]

Hello BV,

1) note 1015489 (connection problems after system copy),

Check which user is the owner of the liveCache application table.

select * from tables where Tablename='APPSYSPARAM'

You need to apply the 2), 3) first.

2) Note 886103 (system landscape copy for SCM) -- It says to change logical system name in /SAPAPO/ORDMAP but this table is not active in my dictionary !! same for table CIFRFCDES and table /sapapo/cifdistr does not exist ??

- It's the liveCache table! See Note 877203, 1.

3) Note 886103 says that "Let the 'SAPR3' user is the Standard liveCache user of the source liveCache with the default password 'sap', and the 'SAPEL1' user is the Standard liveCache user

of the target liveCache."

And in your case:

SAPLIP user and SAPLIQ user (SAPLIQ user only started showing up after I registered LC APPS ).

Replase the SAPR3 user by SAPLIP and SAPEL1 by SAPLIQ in the solution section of note.

If something left unclear => create SAP message & get SAP support.

4) Note 877203 once again talks about SAPEL1 user and I am not sure if I need to run these steps or not

SAPEL1 user should be replaced by  SAPLIQ, as explained in 2).

5) Note 1030857 tells to run this report zz_update_acckey to correct the external keys. Is this necessary even if we run BDLS ? Shall I ask the SCM functional person ?

- Yes, you could. Run first 2), 3) & 1)

6) Note 1073954 (effects of changing the standard livecache user) -- How do I know if I need to run this ? my livecache tables like /sapapo/ordmap are stil owned by SAP<OLDSID> but  in LC10 connections I have changed the three connections to use SAP<NEWSID> user and the connetions are green and connection tests in db59 are also successful !!.

The note says that "Only change the standard liveCache user if the system does not contain any data or if you initialize the liveCache directly after the change"

My copied over livecache does contain data and If I initialize the livecache after changing this user id, I guess I will loose the data. So, Can I skip this step as long as connections in LC10 and db59 are working okay ?

- See Note 877203 or create the SAP message and get SAP support.

7 ) How can I verify that APO optimizer is also installed in Production system. I thought it was optional to install it and I don't know if this client is using it ?

- Check with application team or check if the RFC connections are configured in /nsm59 on production system < TCP/IP Connection -  OPTSERVER_*, if they configured correctly & installed- test run successfully & you will see the server, where the optimizer egine intalled >

Regards, Natalia Khlopina

[Former Member · Accepted solution]

Thank you Natalia. One follow up question:

instead of renaming SAPLIP to SAPLIQ, can I configure LCA, LDA and LEA connections to use SAPLIP for "standard livecache user instead" ?? That's what my colleagues are saying they have done in the past. Does that sound a possible workaround ?

If I rename SAPLIP to SAPLIQ, wouldn't I loose the data in livecache ?

Thanks

BV

[Former Member · Accepted solution]

can anyone share their experience on this please ? what do you do after QA refresh from production of SCM/livecache ? Do you rename the SAP<sourcesid> user to SAP<targetsid> user at database level in Livecache or Do you configure LCA, LEA and LDA connections to use the SAP<sourceid> user ?

or u don't nothing ?

[former_member229109 · Accepted solution]

Hello BV,

You have the option to create the SAP message & get the SAP support.

"instead of renaming SAPLIP to SAPLIQ, can I configure LCA, LDA and LEA connections to use SAPLIP for "standard livecache user instead" ?? That's what my colleagues are saying they have done in the past. Does that sound a possible workaround ?"

-> Yes, you can use the same liveCache user on the production & a copy SCM system.

    Just to be sure that the LCA/LDA/LEA connections on a copy system changed to a copy liveCache server/liveCache name. Saved. Application server restarted & liveCache restarted in LC10, check lcinit.log.

Then run solution from note 1015489 (connection problems after system copy).

And skip the rename of liveCache user in the liveCache copy after the restore of the production backups.

And you still have to run further post SCM copy steps.

"If I rename SAPLIP to SAPLIQ, wouldn't I loose the data in livecache ?"

-> May be, if you run already APO applications as SAPLIQ user.

    Has to be checked if you have any data ownered by SAPLIQ user before to drop it.

"can anyone share their experience on this please ? what do you do after QA refresh from production of SCM/livecache ? Do you rename the SAP<sourcesid> user to SAP<targetsid> user at database level in Livecache or Do you configure LCA, LEA and LDA connections to use the SAP<sourceid> user ?"

-> Both options are used by customers.

Regards, Natalia Khlopina

[Former Member · Accepted solution]

Hello Natalia,

I'm doing a migration of LVC but have the following error:

B Wed May 21 14:51:02 2014

B  Connect to LCA+ as CONTROL with @DBM:PENTS16-LCA

C  Try to connect as CONTROL/<pwd>@DBM:PENTS16-LCA on connection 2 ...

C 

C Wed May 21 14:51:03 2014

C  *** ERROR => Connect to DBM server failed, rc = -10709 (Connection failed (RTE:[-10107] Authentication failed (Receive failed:Connection down: [1] Connection broken to))

[dbsdbsql.cpp 299]

C  {root-id=00505693780D1EE3B8A3CACBFE881316}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BY2=> sql error -10709     performing CON        [dbds         879]

B  ***LOG BY0=> Connection failed (RTE:[-10107] Authentication failed (Receive failed:Connection down: [1] Connection broken to) [dbds         879]

B  *** ERROR => Could not get a shared connection for CONNAME = LCA+: rc=-1

[dbacds.c     767]

I configured the LC10. In DBA Cockpit, the LCAADM user (Standard livecache User) connect but not CONTROL user (DBM Operator).

SQL access is possible: Yes

DBM access is possible: No

Helpme please

Regards, Luis

[former_member229109 · Accepted solution]

Hello Luis,

1. Delete the LCA connection in LC10, Integration, and recreate it again in LC10, Integration, if you use the liveCache on MAXDB.

2. Create the SAP message & get SAP support, if it will not help you.

Regards, Natalia Khlopina

[Former Member]

HI,

Let me know if you resolved live cache connectivity issues? we did scm 7.1 system copy with out any issues. so i may help you if you have any issues.

Regards, Kasi