Client copy COMPUTE_INT_PLUS_OVERFLOW

[Former Member]

Hi Gurus,

I have problem with client copy using SCC9, it wont process 4 tables even after active restart. I got ABAP dump, enyone can help resolving issue ?

Regards

SQL2008R2

Runtime Errors COMPUTE_INT_PLUS_OVERFLOW

Exception CX_SY_ARITHMETIC_OVERFLOW

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_ARITHMETIC_OVERFLOW', was not

caught in

procedure "SCC1_WRITE_FLOW_TABLE" "(FUNCTION)", nor was it propagated by a

RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

In the current program "SAPLSCC1",

using '+' or 'ADD' to add the values 2147451769 and 73609466 resulted in a

value greater than 2147483647 or smaller than -2147483648. This

leads to a whole number overflow.

[nikolay_kumanov]

Hi, everyone! Stumbled upon this old thread while researching the same problem. Now there is a note fixing it - 1668154

[arnd_gohr]

Thanks - worked for me 😉

Note 1668154 + 2588539

[former_member204746]

Hi Lukasz (and others)

I have the exact same problem.

Have you ever found a solution to this issue?

SAP SCM 7.01 with SP11

AIX 6.1

DB2 9.7 FP7

thanks,

[former_member204746]

Cause:

total number of records being copied contains over 2 billion records and this is a limitation for field type INT4 which is limited to 2,147,483,647.

Solution:

manually exclude big tables from the client copy using report RSCCEXPT from SAP note 70290.

After that, and once the client copy is finished,  transport

those tables separately, for example, transport entries

manually by calling transaction SE09 and including the transport object

R3TR TABU <table name> with the corresponding table keys in your

transport request. And then import the request in the target system

using STMS.

you can also use R3TRANS or Oracle's IMP/EXP program or similar DB tools.

[Former Member]

Here is the right procedure - All explanations are give above .. SAP replied in response to our OSS message .  I have added a procedure for more clarity

1. Check the last entry in table CCCFLOW - for the destination client . (  For example MANDT value = 362 when CCopy is run from 100 to 362 client )

2. Make sure the TSTAMP corresponds to the time when the last Client Copy was started .

3. Make Sure NO Client copy is running - Stop / Cancel the Current client . For example if it was run in 10 parallel and 8 have already gotten this dump - the last 2 will also get this dump - so no point in wasting time to let them fail also eventually.

4. Change the value of NBRINS from 2,147,483,469 to 1 in table CCCFLOW for the last entry ( as above )

5. If SE16 is locked for change in the destination client - Do it on DB2 directly - something like this

update sapr3.cccflow set nbrins = 1 where mandt = '362' and tstamp = '20130812213848'  

6. Restart the Client Copy and it will work Fine

7. This will result in loss of statistics in the Client Copy output - But when u r copying more than 2 billion lines of data - that is really not important ..

Hope this helps everyone

[Former Member]

Hi Saurabh,

Many Thanks for posting SAP's solution. Same solution worked for me too. It saved our time and  we were able to deliver the refreshed client ontime.

Best Regards,

-Krishna Murty-

[Former Member]

you are welcome Krishna .. It took us 3 days to come to this solution - so glad - you could fix your issue quickly

[devender_goyal2]

Hi Saurabh,

We tried your solution, but it is not working.

it is failing again with the same error message.

do you think there was anything else which you change other than this table entry.

Any help would be highly appreciated.

Regards,

Devender.

[Former Member]

1. Dear Varun

SCC1_WRITE_FLOW_TABLE no errors.

export/import - i will do this later if SAP won't help.

1. Dear deepakkori

tables EKPV, EKUB. I cant figure out what are the names of two tofher tables, i just see number of tables left in scc3 (log).

How can I check what are tables are left in transport queue ?

1. Dear ashish

my SAP_APPL SP .19 thx.

I am contacting SAP, will let You know.

Best Regards

[Former Member]

We have a similiar problem here.

The function module uses a structure/table, that uses field defintions with Domain INT4: Integer number (32Bit), so restriction of values between u22122.147.483.648 and 2.147.483.647.

From my POV SAP should adjust the CCCFLOW table/structure, to avoid these shortdumps.

We have no feedback from SAP yet...

[ashish_vikas]

Hello Lukasz Wozniak,

please review and if applicable, apply :

Note 1232775 - Whole number overflow exception: COMPUTE_INT_PLUS_OVERFLOW

thanks

ashish

[former_member188883]

Hi,

If those 4 tables are not that important you can exclude them using expert settings in client copy. This will atleast help you in completing the client copy.

Regards,

Deepak Kori

[Former Member]

Hi,

You could try running a syntax check on the function module mentioned in the error dump. Since this is a standard program, there should be no errors unless there is a corruption. In that case you could consider contacting SAP.

Incase you are trying to run a RCC and can't wait, you may consider export - import method.

Hope this helps.

Regards,

Varun