Local client copy fails

[former_member199632]

Hi,

I have performed a homogeneous system copy from Production (PRD)  to Quality Server.(QAS)

(Restored from a PRD backup)

In Production Server, there were 4 clients - 000,001,050,300 with SID as PRD

After system copy;

Quality System, also got the same clients 000,001,050,300 with SID as QAS

So now, its having same client numbers in both PRD and QAS. Will this be an issue?

(SID is different. But Client numbers are same. 300-PRD   &   300-QAS)

After that , i tried to change the client number 300 of QAS through Local Client copy

(creating another new client called 612. and planned to remove 300 from QAS)

But when i execute the SCCL , after few seconds it got failed. (After 200+ seconds)

RFC connections are working fine.

I have checked the logs in SCC3 as well. But it not giving any clues. Any idea how to rectify this?

What would be the best way of changing this client number?

log files are attached.

regards,

zerandib

logfile-1.TXT.zip

[Former Member]

Hi,

 So now, its having same client numbers in both PRD and QAS. Will this be an issue? 
(SID is different. But Client numbers are same. 300-PRD   &   300-QAS)

Why do you think that is an issue as these both are different system.

After system copy did you do all the post processing steps.

Do you see any issue in Sm21 log . is there space in the system.

Can you please past the if any dump is in created in st22 related to this. I think there would be dump as per the job failure.

Thanks

Rishi abrol

[former_member199632]

Yes Rishi, i have posted the ST22 dump as well

uncaught exception CX_SDB_ORA_PROGRAM_ERROR.

Post installation steps are done and enough space is there too

[Former Member]

Error is

   ORA-20003: Specified bug number (5099019) does not exist

ORA-06512: at                        |

|    "SYS.DBMS_STATS", line 14531

ORA-06512: at "SYS.DBMS_STATS", line                             |

|    14552

ORA-06512: at line 1                 

Please check the below note if it helps.

1667086 - ORA-20003 - Specified bug number (<number>) does not exist.

Thanks

Rishi Abrol

[karthikeyan_natarajan4]

Hi Zerandib,

Please check the below two notes

838725  - Oracle dictionary statistics and system statistics

1667086  - ORA-20003 - Specified bug number (<number>) does not exist.

regards

kartik

[ashish_vikas]

So now, its having same client numbers in both PRD and QAS. Will this be an issue?

No, there should not be any issue. you should use different logical system name for QA system clients, run BDLS.

for client copy cancellation, please check if you have ABAP dump (ST22) and provide logs.

best regards

ashish

[former_member199632]

hi vikas,

There is uncaught exception CX_SDB_ORA_PROGRAM_ERROR in ST22 dump...

But no idea how to rectify that.

regards,

zeandib

[ashish_vikas]

please check if this note is valid for you system and if yes, apply it.

1417124  - Error ORA-20001 in statistics class CL_SDB_ORA_UPDATE_STATS

Also run : brconnect -u / -c -f stats -t all and see if this works fine.

best regards

ashish

[sunny_pahuja2]

Hello,

There is no issue in having same client number in quality as in production system.

As far as this error is concerned, could you please check any error message in SM21/ST22?

Thanks,

Sunny

[former_member199632]

Hi Sunny,

I have checked ST22 & SM21

Found this uncaught exception CX_SDB_ORA_PROGRAM_ERROR in ST22 dump.

It is attached.

Client.............. 612

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

Language key........ "E"

Transaction......... " "

Transactions ID..... "527B0215007F7D79E10000000A0A0A79"

Program............. "CL_SDB_ORA_UPDATE_STATS=======CP"

Screen.............. "SAPMSSY0 1000"

Screen line......... 6

I have tried by generating mentioned program CL_SDB_ORA_UPDATE_STATS=======CP as well.

But no success yet.any idea!

regards,

Zerandib

CX_SDB_ORA_PROGRAM_ERROR.TXT.zip

[sunny_pahuja2]

Could you please run update stat and once it is finished, then please run client copy again?

Thanks,

Sunny