topic Re: SAPSQL_ARRAY_INSERT_DUPREC Release 700 ECC 6.0 in Application Development and Automation Discussions

SAPSQL_ARRAY_INSERT_DUPREC Release 700 ECC 6.0

Former Member — Tue, 15 Sep 2009 08:36:23 GMT

Hi expert.

When i run Financial Statements with T.Code F.01 then I see a error SAPSQL_ARRAY_INSERT_DUPREC and i try with SAP Report standard Cash Fow then i met error SAPSQL_ARRAY_INSERT_DUPREC too.

Please help me resolve this error.

SAP System intalled on OS LINUX

Version: ECC 6.0.

Release: 700.

Thanks & Best Regards,

Dungnv.

Re: SAPSQL_ARRAY_INSERT_DUPREC Release 700 ECC 6.0

Former Member — Tue, 15 Sep 2009 08:53:55 GMT

Hi,

This dump arises when the program is trying to insert some entries but the entries already exists.

Check in SM13 the update terminations.

Keep a breakpoint at the statement where the dump is coming and re-run the process.

Turn on update debugging incase it is not stopping at the breakpoint and then re-run the process.

In debug check which entries the program is trying to insert and that those already exists in the table.

The issue might be due to some wrong updates of internal tables in some userexits.

Regards,

Ankur Parab

Re: SAPSQL_ARRAY_INSERT_DUPREC Release 700 ECC 6.0

Former Member — Tue, 15 Sep 2009 09:30:27 GMT

Thanks Ankur Parab support for me.

i checked T.Code SM13 but update request show 0 update recode found.

i know entries the program is trying to insert and that those already exists in the table too but i don't have solution to resolve

this problem.

please guide me details to resolve that issue.

Dungnv.

Thanks & best regards,

Re: SAPSQL_ARRAY_INSERT_DUPREC Release 700 ECC 6.0

Former Member — Tue, 15 Sep 2009 09:53:35 GMT

Hi,

As i suggested earlier put a breakpoint at the statement where the dump is coming.

You can see the dump details in ST22.

In debug just check which are the duplicate entries and what is causing them to come.

The problem may be some wrong period is selected.

You can also discuss with your functional consultant.

Regards,

Ankur Parab