Local client Copy problem using sccl in ECC 6.0- Long time

[Former Member]

Hi,

My system ecc6.0 and I am started the client copy form 000 client to 100 client

Now 25 passed but still the copy process not completed .

I am create the client 100 in 000

Then logged into 100

Then start the client copy usuing sccl in background

I am not run the test run

Please check the below logs and suggest.

Regards,

Ravi

Target Client 100

Source Client (incl. Auth.) 000

source Client User Master 000

Copy Type Local Copy

Profile SAP_ALL

Status Processing...

User SAP*

Start on 13.08.2008 / 16:25:57

Last Entry on 13.08.2008 / 17:00:51

Current Action: Post Processing Component

- Last Exit Program /SAPCND/CC_GROUP_WS_NG AP-PRC-CON

Statistics for this Run

- No. of Tables 54569 of 54569

- Deleted Lines 109

- Copied Lines 5101492

Output Sm66 :-

Sort: Server

Server Name No. Type PID Status Reason Sem Start Error CPU Time User Report Action Table

myhost_RD1_00 12 BTC 11391 Running Yes 92662 SAP* SAPLSDNT Sequential Read D010TAB

Client copy from 2008-08-13 16:26:00

System ID............................ RD1

Target client........................ 100

R/3 Release.......................... 700

Basis Support Package...............SAPKB70014

Host................................. myhost

Start in background............. .....X

User................................. SAP*

Parameter

Source client........................ 000

Source client user masters............000

Copier profile:.......................SAP_ALL

Table selection

Customizing data .....................X

With application data................ X

Initialize and recreate......... X

Change documents are not copied

Target client 100

Source client 000

User Name SAP*

SAP Release 700

Profile name SAP_ALL

Total number of tables 54.569

Number of Customizing and syst. tables 34.654

Number of application tables 18.185

Number of local tables (to delete) 1.730

Total number of exit programs 14

Number of selection exits 8

Number of generation exits 1

Number of other exit programs 5

[markus_doehr2 · Accepted solution]

Did you run an update statistics before you started the copy? It seems, that the database is using a wrong access path for that table D010TAB and thus taking very long to copy...

Markus

[Former Member · Accepted solution]

hi ,

Thanks ,i not not run the update statistics .

it seems that client copy is completed we check that all the objects are copied in transection scc3 but still it showing me process in scc3 and sm66.

Please suggest what to do next ..

ravi

[markus_doehr2 · Accepted solution]

So you see a "successfully finished" in SCC3?

Markus

[Former Member · Accepted solution]

Sorry,

Actualy i am waiting for your replay.

it show 'In Processing "

and some process shows in sm66 below are the sm66 details

NNRKNDECC6_RD1_00 12 BTC 11391 Running Yes 96823 SAP* SAPLSDNT Sequential Read D010TAB

scc3 log >

13.08.2008 16:25:57 000 Processing... SAP_ALL Local

13.08.2008 12:52:27 Cancelled DELETE Deletion

13.08.2008 12:28:39 Cancelled DELETE Deletion R

13.08.2008 09:47:19 Cancelled DELETE Deletion

12.08.2008 22:07:12 Cancelled DELETE Deletion

12.08.2008 21:54:47 100 Cancelled DELETE Deletion

12.08.2008 20:49:27 000 Cancelled SAP_ALL Local

12.08.2008 18:48:16 100 Successfully Completed DELETE Deletion

Regards,

Ravi

[Former Member · Accepted solution]

Hi,

I Also had the problem in local client copy. After i run the update statistics it completed immediately. thanx.

regards

Prabhu