SAPSQL_ARRAY_INSERT_DUPREC while loading 0MAT_PLANT into BW

[Former Member]

Hi,

I am getting the below error as a short dump while loading master data object 0MAT_PLANT in BW.This is a source system dump.

"SAPSQL_ARRAY_INSERT_DUPREC"

I was now asked to identify the duplicate records so that the R/3 team could delete the same and we could re-run.I dont really see any way to through which i could get this done. Could anyone help me in this regard.I need to supply the erroneous record details so that R/3 could fox. Could there be an queries that i could run using site article combinations to find out this?

I use version 2.0 B of Business Warehouse.

Regards,

Jitu K

[former_member188975 · Accepted solution]

Hi Jitu,

In the InfoPackage that loads 0MAT_PLANT you can try to set Processing as PSA and Subsequently Update into Data Target, and also check the Ignore Double Data records. I think this setting should be there in version 2.0 B too and will prevent the dump caused due to dupplicate data records.

Hope this helps...