Background Job Error Message

[Former Member]

Hi Experts,

I am getting an error message to background job. Can anyone tell me what is this "ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC". Actually couple of jobs cancelled because of this reason.

Job started

Step 001 started (program /SAPAPO/TS_LCM_PLOB_DELTA_SYNC,

ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Job cancelled

Thanks in Advance..

Regrads

Sujay

[Former Member · Accepted solution]

Please try to do the consistency check for the master planning objects.

There is inconsistency in the planning objects

Are you running this program first time in the background?

[Former Member]

Hi

The error message is due to the program trying to insert duplicate records in the table. Please see ST22 in the APO side which will clearly tell the program and line where this exception occurs. This will solve the problem.

Also SAP recommeds to run the following report to check consistency in the standard table

o ZZMATLOC_ADJUST: this report eliminates inconsistencies between

tables /SAPAPO/MATKEY and /SAPAPO/MATLOC. its codes are attached

in note 668792.

o ZZMATMAP_ADJUST: by running this report, inconsistencies between

tables /SAPAPO/MATKEY and /SAPAPO/MATMAP are eliminated. This

reports can be found in the note 365838.

o Z_MATMOD_ADJUST: This reports helps to get rid of

inconsistencies between tables /SAPAPO/MATKEY and /SAPAPO/MATMOD.

Its codes are contained in the note 364044

o ZZMAT_PROFILES_ADUST: This reports helps to delete obsolete

profiles in the system. Related code are contained in the note

485981

Prasanna

[Former Member]

Hi Sujay,

Try taking time series consistency check /OM 17

This error occurs when a job tries to create a

new record to the system wherein already the

old record with similar details exists which it

cannot overwrite and those entries will be

considered as duplicate entries.

Is the cancelled jobs are related to PPM?

Please confirm

Regards

R. Senthil Mareeswaran.

[Former Member]

Hi Sujay,

Please ensure you don't have 2 jobs running a "plob_delta_sync" on the same planning area.

For example if you create CVC with option "adjust automatically time series" you should not run a "plob_delta_sync" after.

Actually the best is to NOT use the the "adjust automatically times series" for background (and process chain) runs since it trigger an extra job you don't "control".

See note 573127, which described something similar.

I hope it helps...

Regards

Julien

[Former Member]

Please try to do the consistency check for the master planning objects.

There is inconsistency in the planning objects

Are you running this program first time in the background?