Client copy from Prod to SandBox

[Former Member]

Dear all ,

i want to make Client copy from Production to Sandbox .

Production Configuration :

AIX , ECC6.0 , Oracle 10g.

SnadBox Configuratuioon:

Win2003 , ECC6.0 , oracle 10g.

Kindly Advise me

[sunny_pahuja2 · Accepted solution]

Hi,

You can perform remote client copy. Log on to your production system and export client via transaction SCC8. for this make sure that you have sufficient space in /usr/sap/trans.

Once export is finished. Then import these transports via STMS. Once transport will be imported successfully. Then perform SCC7 for post processing of client copy.

Thanks

Sunny

[Former Member · Accepted solution]

Hi Sunny ,

thanks for your mail

landscape Detail

Dev>Qa->prod

and Sandbox is standalone server .

how can i make Client Export/ import

can u suggest me

Regards

[former_member524429 · Accepted solution]

Hi,

If your Source Client is very large in size then , you can perform System Copy instead of doing Client Export/Import from your PRD system to Sandbox System (stand alone system).

As an alternative, Please refer the following useful links for your requirement.

[Note 118823 - CC-ADMIN: Size of a client|https://service.sap.com/sap/support/notes/118823] -- This SAP Note will be helpful in determining the size of your source Client.

[Transporting Clients Between Systems using Client Export/Import Procedure|http://help.sap.com/saphelp_sm32/helpdata/en/69/c24c824ba111d189750000e8322d00/content.htm]

[Client-Export-Import|http://www.scribd.com/doc/7000136/Client-Export-Import]

Regards,

Bhavik G. Shroff

Edited by: Bhavik G. Shroff on Jan 25, 2010 2:31 PM

[sunny_pahuja2 · Accepted solution]

Hi,

When you will export client from production, it will make datafile and cofile in /usr/sap/trans (data and cofiles directory). Then copy these files to respective location in sandbox server. Then import transport via STMS in sandbox. After that perform SCC7 for client import post processing.

Thanks

Sunny

[former_member204746 · Accepted solution]

if your PRd system is too big, consider an heterogeneous system copy.

guides can be found at http://service.sap.com/systemcopy

and... it's about time you read the following topic if you want more help:

/people/mark.finnern/blog/2004/08/03/announcing-the-contributor-recognition-program

[Former Member · Accepted solution]

Hi

kindly find below datadabe size

Database

Name DEFAULT Filling degree:

DB system: ORA

Size: 141,89 GB Total size: 410,16 GB

Free Size: 14,45 GB Total free size: 282,72 GB

Used: 90 % Total used: 31 %

doing client copy is there any prerequistics ?

kindly suggest me

[former_member524429 · Accepted solution]

Hi,

You can select Remote Client Copy (SCC9) or Client Export/Import (SCC8,SCC7).

Prerequisites:

1. Clear requirement about Client Copy Profile

1. In both the system (source and target), Same SAP Solution installed with same release level.

2. All components including installed Add-Ons must have same development class

3. Sufficient Storage Space at Target system

4. Sufficient Work processes with enough work process time.

Please refer "[Copying Clients Between Systems|http://help.sap.com/saphelp_nw04/helpdata/en/69/c24c684ba111d189750000e8322d00/content.htm]" and "[Transporting Clients Between Systems|http://help.sap.com/saphelp_nw04/helpdata/en/69/c24c824ba111d189750000e8322d00/content.htm]" to get more information.

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Dear all,

Client copy test run terminates , kindly check the below log and kindly suggest me

Diagnosis

The table definitions differ between the systems. These differences mean

that a copy of the data can cause a data loss and system

inconsistencies.

Differences occur when further developments were not transported or were

copied between different maintenance levels.

System Response

A client copy cannot be made between the systems.

Procedure

Transport all the developments of table structures between the systems

using the Transport Organizer and bring your system to the same

development level.

[former_member524429 · Accepted solution]

Hi,

Analyze the Test Run log using SCC3. And compare the things like what are missing in Source Client and What are missing in Target Client. and Do the adjustment accordingly by transporting the differences where they are required.

Regards,

Bhavik G. Shroff

[markus_doehr2 · Accepted solution]

> The table definitions differ between the systems. These differences mean

> that a copy of the data can cause a data loss and system

> inconsistencies.

Client copies can only be done on identical systems, means, DDIC (tables) and repository (support packages) must be the same on both systems, otherwise the copy can't be made and you get such errors.

Markus

[Former Member · Accepted solution]

Hi Sunny,

i copied Data file & cofile in the respective location in Sandbox server now how can i import the Request through STMS . and i tried to copy the request to F:\usr\sap\trans\bin directory.

(NOTE : SANDbox is windows server and how to add this request IRPKO00019, IRPKX00019, IRPKT00019 manully in STMS.)

F:\usr\sap\trans\bin>tp pf=TPPARAM addtobuffer "IRPKO00019" ECC u18

initial value of NLS_LANG: 'AMERICAN_AMERICA.UTF8'

This is tp version 372.04.78 (release 700, unicode enabled)

E-TPPARAM could not be opened.

EXIT

Error in TPPARAM: transdir not set.

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0208

tp finished with return code: 208

meaning:

error in transportprofil (param missing, unknown,...)

F:\usr\sap\trans\bin>

and i cant able to import through SCC7.

kindly advise to me to do client copy

Regards

[markus_doehr2 · Accepted solution]

> i copied Data file & cofile in the respective location in Sandbox server now how can i import the Request through STMS . and i tried to copy the request to F:\usr\sap\trans\bin directory.

"the request" are two files K.<SID> and R.<SID>. Both must be copied, the K* file to the "cofiles" directory and the R* file to the data directory. Then you have to call tp as

tp addtobuffer <transport> <target> u18 pf=<full-path-to-profile>

don't use "tpparam" but use the correct transport profile.

Markus

[former_member524429 · Accepted solution]

Hi,

Copy Data Files and Co-Files of those 3 Trans Req. to data and cofile directory on target system.

Execute these TP command at operating system level, under <SID>adm user.

tp addtobuffer IRPKO00019 <SID> pf=F:\usr\sap\trans\bin\TP_DOMAIN_<SID>.PFL

tp addtobuffer IRPKX00019 <SID> pf=F:\usr\sap\trans\bin\TP_DOMAIN_<SID>.PFL

tp addtobuffer IRPKT00019 <SID> pf=F:\usr\sap\trans\bin\TP_DOMAIN_<SID>.PFL

->Log on to the New Target Client using SAP* user with pass as password.

-> Execute STMS_IMPORT T-Code

-> Refresh Queue (Press F5)

->Search for the Trans. Requests, which u recently add using TP command.

-> Now, Select any one request and Import it (as the remaining Requests will be imported automatically). Wait for the completion of successful IMPORT.

After the import process has completed, perform post-import activities using SCC7.

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

HI Markus/Bhavik G. Shroff,

i have one more query .currently i have 4 GB Space in usr/sap/trans.

5 months back Client export /import has been done . and the following requests also exist in usr/sap/trans directory.

IRPKO00015

IRPKT00015

IRPKX00015

if i delete the Existing above requests any thing wil happen.

kindly advise me

[former_member524429 · Accepted solution]

Hi,

Backup them and then Delete them from usr/sap/trans , if they are old.

Regards,

Bhavik G Shroff

[former_member204746 · Accepted solution]

if you delete these files, you will not be able to re-import there contents, which is probably OK.

Only you can decide if you will ever need those files.

[Former Member · Accepted solution]

Hi Bhavik G. Shroff/ Eric

i had below request to buffer

IRPKO00019

IRPKT00019

IRPKX00019

and IRPKO00019 request has been successfully imported and remaining 2 request still its show running IRPKT00019

IRPKX00019 almost more that 15 hours .

kindly advise me

Regards

[Former Member · Accepted solution]

Hi Bhavik G. Shroff/ Eric

is nt possible to revert back what i have done .

kindly advise me

regards

[markus_doehr2 · Accepted solution]

> and IRPKO00019 request has been successfully imported and remaining 2 request still its show running IRPKT00019

> IRPKX00019 almost more that 15 hours .

Depending on the size of the source client and the number of parallel processes you have (if configured) this can take a huge amount of time.

How big was your client? Is the import still running? Check on OS level the latest logfiles and the activity.

Markus

[Former Member · Accepted solution]

Hi Markus,

still import process is running . i had checked SM50 .

Datafile Size :

RO00019.IRP -

---

> 447,219 KB

RT00019.IRP -

---

> 1,621,794 KB

RX00019.IRP -

---

> 11,373 KB

kindly advise

[markus_doehr2 · Accepted solution]

> RO00019.IRP -

---

> 447,219 KB

> kindly advise

quite BIG import. This will run some time - depending on the speed of your system. There's nothing you can do but wait.

Markus

[Former Member · Accepted solution]

Hi Marcus

During the import process (STMS) suddenly System got down . then i made sap up & i had check the STMS its shows still import .

Note: almost 7 days the import process is running

kindly advise

[markus_doehr2 · Accepted solution]

Check the latest logs in \usr\sap\trans\tmp and \usr\sap\trans

Markus

[former_member204746 · Accepted solution]

kill TP and R3TRANS if they are still running.

then check status of files in /usr/sap/trans/tmp

[Former Member · Accepted solution]

Hi

how to kill TP and R3trans

kindly advise

[markus_doehr2 · Accepted solution]

> how to kill TP and R3trans

use the task manager.

Markus

[former_member204746 · Accepted solution]

try this link: http://www.microsoft.com/windowsserver2003/techinfo/training/default.mspx

[Former Member · Accepted solution]

HI marcus

i had cheched the taskmanager . the is no process running regarding TP & R3trans .

kindly advise me

[Former Member · Accepted solution]

Dear all,

i had checked from STMS (Environment-->TMS alert -->TMS Alert Viewer)

i got below Errors and warnign . form the date of imported to till date .

22.02.10 12:07:09 S2K_BASIS TMS_TP_IMPORT CREATE_ENQUEUE_FAILED ECC 130

22.02.10 12:06:58 S2K_BASIS TMS_CC_READ_CCCFLOW_OF_TRKORR UNKNOWN_SYSTEM ECC 130

22.02.10 12:06:58 S2K_BASIS TMS_CI_GET_RFCDEST UNKNOWN_SYSTEM ECC 130

18.02.10 15:16:57 S2K_BASIS TMS_WBO_READ_REQUEST READ_DOCU_FAILED ECC 130

18.02.10 14:10:35 S2K_BASIS TMS_TP_IMPORT CREATE_ENQUEUE_FAILED ECC 130

18.02.10 14:10:17 DDIC TMS_CC_READ_CCCFLOW_OF_TRKORR UNKNOWN_SYSTEM ECC 000

18.02.10 14:10:17 DDIC TMS_CI_GET_RFCDEST UNKNOWN_SYSTEM ECC 000

18.02.10 14:10:01 DDIC TMS_CC_READ_CCCFLOW_OF_TRKORR UNKNOWN_SYSTEM ECC 000

18.02.10 14:10:01 DDIC TMS_CI_GET_RFCDEST UNKNOWN_SYSTEM ECC 000

16.02.10 23:18:00 S2K_BASIS TMS_TP_IMPORT CREATE_ENQUEUE_FAILED ECC 130

16.02.10 23:17:48 S2K_BASIS TMS_CC_READ_CCCFLOW_OF_TRKORR UNKNOWN_SYSTEM ECC 130

16.02.10 23:17:48 S2K_BASIS TMS_CI_GET_RFCDEST UNKNOWN_SYSTEM ECC 130

16.02.10 13:18:56 S2K_BASIS TMS_TP_IMPORT CREATE_ENQUEUE_FAILED ECC 130

16.02.10 13:18:31 S2K_BASIS TMS_CC_READ_CCCFLOW_OF_TRKORR UNKNOWN_SYSTEM ECC 130

16.02.10 13:18:31 S2K_BASIS TMS_CI_GET_RFCDEST UNKNOWN_SYSTEM ECC 130

16.02.10 11:32:07 S2K_BASIS TMS_CC_READ_CCCFLOW_OF_TRKORR UNKNOWN_SYSTEM ECC 000

16.02.10 11:32:07 S2K_BASIS TMS_CI_GET_RFCDEST UNKNOWN_SYSTEM ECC 000

16.02.10 11:31:54 S2K_BASIS TMS_TP_IMPORT CREATE_ENQUEUE_FAILED ECC 130

16.02.10 11:31:39 S2K_BASIS TMS_CC_READ_CCCFLOW_OF_TRKORR UNKNOWN_SYSTEM ECC 000

16.02.10 11:31:39 S2K_BASIS TMS_CI_GET_RFCDEST UNKNOWN_SYSTEM ECC 000

13.02.10 13:13:06 S2K_BASIS TMS_TP_IMPORT CREATE_ENQUEUE_FAILED ECC 130

13.02.10 13:12:53 S2K_BASIS TMS_CC_READ_CCCFLOW_OF_TRKORR UNKNOWN_SYSTEM ECC 130

13.02.10 13:12:53 S2K_BASIS TMS_CI_GET_RFCDEST UNKNOWN_SYSTEM ECC 130

11.02.10 22:20:26 S2K_BASIS TMS_TP_IMPORT CREATE_ENQUEUE_FAILED ECC 130

11.02.10 22:20:10 S2K_BASIS TMS_CC_READ_CCCFLOW_OF_TRKORR UNKNOWN_SYSTEM ECC 130

11.02.10 22:20:10 S2K_BASIS TMS_CI_GET_RFCDEST UNKNOWN_SYSTEM ECC 130

11.02.10 21:52:03 S2K_BASIS TMS_TP_IMPORT CREATE_ENQUEUE_FAILED ECC 130

11.02.10 21:51:38 S2K_BASIS TMS_CC_READ_CCCFLOW_OF_TRKORR UNKNOWN_SYSTEM ECC 130

11.02.10 21:51:38 S2K_BASIS TMS_CI_GET_RFCDEST UNKNOWN_SYSTEM ECC 130

11.02.10 20:58:06 S2K_BASIS TMS_TP_SHOW_BUFFER RFC_COMMUNICATION_FAILURE ECC 130

kindly advise me

Regards

[Former Member · Accepted solution]

Dear All,

i killed TP.exe from taskmanager

Latest SLOG1008.ECC

WARNING:
SAPDEV\sapmnt\trans\tmp\IRPKKT00019.ECC is already in use (24330), I'm waiting 4 sec (20100223115659). My name: pid 4108 on SAPDEV (APServiceECC)

WARNING:
SAPDEV\sapmnt\trans\tmp\IRPKKT00019.ECC is already in use (24340), I'm waiting 2 sec (20100223115727). My name: pid 4108 on SAPDEV (APServiceECC)

WARNING:
SAPDEV\sapmnt\trans\tmp\IRPKKT00019.ECC is already in use (24350), I'm waiting 3 sec (20100223115753). My name: pid 4108 on SAPDEV (APServiceECC)

Kindly advise

[former_member185031 · Accepted solution]

Rename this file IRPKKT00019.ECC and start the process again.

Regards,

Subhash

[Former Member · Accepted solution]

Hi Subhash,

the actual import requests are

IRPKO00019.ECC is imported successfully

IRPKT00019.ECC is still importing around 14 days is running

IRPKX00019.ECC is still not i mport .

if i kill TP.exe from taskmanager , after 10 or 15 minutes again Tp.exe started

kindly advise

[Former Member · Accepted solution]

I couldn't believe this. Sateesh, you are an incredible person for me.

Anyway,

I suggest you to cancel the entire copy process and restart from fresh. You have 140gb of database and you should have chosen system copy option for this refresh. Backup your prod, restore to sandbox and do the other post copy steps to reconfigure the sap instance.

Thanks

SV

Edited by: SV2007 on Feb 25, 2010 11:48 AM

[former_member524429]

Hi,

[Note 70547 - CC-TOPIC: Client transport|https://service.sap.com/sap/support/notes/70547]

[Note 92770 - CC-INTERN: Client import post-processing|https://service.sap.com/sap/support/notes/92770]

[Note 489690 - CC INFO: Copying large production clients|https://service.sap.com/sap/support/notes/489690]

Regards

Bhavik G. Shroff

Edited by: Bhavik G. Shroff on Jan 24, 2010 8:21 PM