Number Ranges after client copy

[#1]

Dear Basis Gurus,

i am planning a client copy from our production system to our quality assurance system to refresh a old existing client.

In past i have done some similar copies. After the copies i am always facing the problem with the number ranges (short dump SAPSQL_ARRAY_INSERT_DUPREC). Then I need to adjust the number ranges I need manually. This is a lot of work.

How is the standard procedure in this case? Is there any option to do this in a more efficient way?

Best regards,

Klaus

[Former Member · Accepted solution]

Dump is: SQL_ARRAY_INSERT_DUPRC

I am using Transaction SCC9 with copy Profile SAP_ALL

[Former Member · Accepted solution]

hm!, how much time it take to complete the client copy?

[Former Member · Accepted solution]

It is a huge Client, round about 12 hours.

[Former Member · Accepted solution]

why can't you use system copy process? which will be easy and reliable.

refer  489690 - CC INFO: Copying large production clients

[Former Member · Accepted solution]

I only want to refresh one Client on the test System. The other clients should not be affected. 

[ACE-SAP · Accepted solution]

Hi

Did you delete the target client content (SCC5) before the copy  ?

This can strongly improve copy runtime.

How many parallel process did you use?

Regards