topic Re: SAPSQL_ARRAY_INSERT_DUPREC in function module "ADDR_SAVE_INTERN" in Application Development and Automation Discussions

SAPSQL_ARRAY_INSERT_DUPREC in function module "ADDR_SAVE_INTERN"

Former Member — Thu, 13 Aug 2009 13:23:25 GMT

Hi ,

I am getting an SAPSQL_ARRAY_INSERT_DUPREC in function module "ADDR_SAVE_INTERN" at line WRITE_TO_DB ADRT

while posting a customer ( DEBMAS IDOC ) .

Strange thing abt this error is that the same IDOC gets processed the second time .

Any information on wat is highest address number , current address number , and how address are maintained would be helpful.

Thanks,

Lalitha Iyer

jaideepsharma — Thu, 13 Aug 2009 13:29:41 GMT

Hi,

Please go through SAP NOTE 140212 and if applicable then implement it in your system. Hope it solves your problem.

KR Jaideep,

Former Member — Thu, 13 Aug 2009 13:30:58 GMT

Hi,

SAPSQL_ARRAY_INSERT_DUPREC means that it is trying to make an entry but the entry already exists.

It is creating a duplicate entry and hence the dump.

Check if you are passing some duplicate records.

regards,

Ankur Parab

Former Member — Thu, 13 Aug 2009 13:49:41 GMT

Hi ,

I am not able to replicate this error as its a random error while posting IDOCS of a message type DEBMAS which gets resolved in the next run .

Also I cannot find the IDOC number which caused this error .

On a quick look at the note 140212 I believe this error should only occur when we create a new address .

Regards ,

Lalitha .