cancel
Showing results for 
Search instead for 
Did you mean: 

Error executing CJ88 - INSERT DUPREC

Former Member
0 Kudos

Hello all,

while trying to execute settlement (CJ88/CJ8G) we are facing the following problem for some projects (investment measures).

=> Express Document "Updated was terminated" received of author

This message is followed by "SAPSQL_ARRAY_INSERT_DUPREC" message hold in the inbox and occurs after press the DETAILS LIST button.

I have visited notes 702794, 624729 and even though it seems relevant, it's applied as my sap version is 6.0.

does anyone know how to get around this ?

Thanks in advance.

Gilson D'Elrei

Accepted Solutions (0)

Answers (3)

Answers (3)

nitin_patoliya
Active Contributor
0 Kudos

Take help of technical team vai debug etc.But I suggest you to create OSS for the same, as there could be no of reason for think kind of Program error.

With Regards

Nitin P.

former_member478182
Active Participant
0 Kudos

Hello Gilson

The system dumps at the line:

INSERT entry XXXX to table XXX

Please let me know which table system tries to insert here, or you can upload the first 10 pages short dump for checking.

Regards,

Jane

Former Member
0 Kudos

Thanks Jane.

The problem occurs in table ANEP as below.

>>>>> INSERT ANEP FROM TABLE XANEP_INS.

I have analized notes 85957 and 439823 as suggested by Ivanna but as our version (6.x) it seems does not apply.

I have checked number ranges inconsistencies as described in Note 85957 using RKOABRNR program report - it doesn't report any error.

Thanks for your collaboration.

Gilson D'Elrei

Edited by: Gilson DElrei on May 14, 2010 9:31 PM

former_member478182
Active Participant
0 Kudos

Hi Gilson,

when creating new depreciation areas on the AUC of the investment measure, the necessary settlement information have to be inserted for the tables AUAI and COEPBR either.Normally such short dump is because of incosistancy of the above tables. The suggestions and reports from note 317806 could help in this case.

Regards,

Jane

Former Member
0 Kudos

Hi Gilson!

Have you tryed to implement the notes below?

Note 439823 - Short dump SAPSQL_ARRAY_INSERT_DUPREC; LNRAN overflow

Note 85957 - SAPSQL_ARRAY_INSERT_DUPREC for INSERT AUAA

Regards,

Ivanna