Cannot Delete Client after a failed Client Copy

[Former Member]

Hello all,

I did a remote client copy from prd to dev with SAP_ALL profile. Client Copy failed - Out of storage error. I restarted and then unlocked the dev client and tried to login with my prd user id and password, login was successful but i got no authorization for any Tx Code. i tried logging with DDIC user too still no authorization for Tx Code. Pls help me as i am neither able to delete the client as i am not able to use SCC5 in the dev client nor able to repeat schedule the background clientcopy job from another dev client... Pls suggest any solution.

Regards

Shan

[former_member189546 · Accepted solution]

Hello,

Please check

552711 FAQ: Client copy

541311 CC-INFO: Parallel processes FAQ

489690 CC INFO: Copying large production clients

regards,

John nFeely

[Former Member · Accepted solution]

Hi John nFeely,

I went through the FAQ but i cannot find any useful solution for my case. My problem is inorder to reschedule the clientcopy job i am not able to use Tx Code SM37 in the client with even DDIC user. So i cannot get any action done on my dev client other than just login to the client...

Help pls.. Very urgent...

Thanx

Shan

[naveen_kumar1 · Accepted solution]

hi,

Here goes:

1. log into the client to delete

2. go into SCC5 and delete client

3. log into another client and delete entry with SCC4

4. reorg database to recover database space.

Actually, if you check "on" the little "Delete Entry from T000" checkbox, you can skip step 3.

One other way of deleting a client which could give significant performance gain and save time is at OS level using - R3trans

To delete a client 200, you have to create a command file "del200" with following entries

Clientremove

Client = 200

Select *

Place the command file in /usr/sap/trans/bin

$ cd /usr/sap/trans/bin

$ R3trans u2013w <log file name> -u 1 <command file name >

e.g $ R3trans -w del200.log -u 1 del200

To check the progress...

$ tail -f del200

Reorg the database post client delete

Regards,

Naveen.

[Former Member · Accepted solution]

Thanks Naveen for the reply. I will try it out let u know the outcome.

Regards

Shan

[Former Member · Accepted solution]

Hi shiva,

Did you try to re-launch the client copy ..it will continue from where it fails

Also have tried to login with SAP* user ?

If you want to start the client copy from scratch proceed as per the steps from Naveen.

Regards,

Srini Chapa.

[Former Member · Accepted solution]

Thanks Naveen and Srini...

I got to rescedule the job using sap* but it is running for almost 21hrs now and is still active. What could be the reason? My database size is 190GB and got 16GB ram in my development system.

Thanks

Siva

[Former Member · Accepted solution]

what does SCC3 log says?

How many parallel sessions you have used ?

Regards,

Srini Chapa.

[Former Member · Accepted solution]

Hi All,

Thanks for all u r suggestions. Atlast my remote client copy finished successfully. But had to check for TemSe data storage consistency and there where two conflicts and had to remove it and then the client copy got over in few minutes.

Now i am doing remote client copy from PRD to QAS. I am having an issue wherein it is stuck

Following is the scc3 log

Status Processing...

User SAP*

Start on 04.03.2012 / 12:51:33

Last Entry on 04.03.2012 / 20:12:37

Current Action: Copy/Delete Tables

Process Server Table Time

00001 SAP-DERP ZMSKA 14:29:45

Now the time is 05.03.2012 10:48 and the last entry is yesterday 8:12 pm....

Last i cheked for TemSe data storage consistency but there is no inconsistency.

Pls help...

Points awarded for earlier query.. Thanks...

Thanks...

Shan

[Former Member · Accepted solution]

Hi Siva,

How long the copy took place from PRD to DEV.? (may be we can comapre the timings)

Please check the system logs for any clue and make sure that network connectivity between PRD and QAS is fine.

check if thres any errors/warnings for DB related in DB14.

Regards,

Srini Chapa.