J1BTAX Dump SAPSQL_ARRAY_INSERT_DUPREC

[Former Member]

Hi Guru's,

When I execute a transaction "J1BTAX -> Condition Setup -> Migration -> Tax Groups in Access Sequences" a dump occurs: SAPSQL_ARRAY_INSERT_DUPREC.

I search for a SAP OSS but not found.

In Dump ocurrs in part of code:

INSERT t682z FROM TABLE it_t682z.

Could be a problem with number range?

Anyone have any suggestions?

Attached is the print!

I Need Help, please

Regards,

Mariana

[Former Member · Accepted solution]

Hi,

Please check whether the below note helps.

Note 797959 - J1BTAX: Shortdump in Tax Code Maintenance

If not, please download the  complete ABAP Dump and attach it.

Thanks and Regards,

Vimal

[thiago_cavalheiro]

Hello Mariana,

This dump is thrown when there is tentative of inserting a row to a table which has keys that already exist on the table. This is more application related than database itself, but from an Oracle expert perspective our recommendation is that you need to check whether there are any duplicated records on table t682z. The note bellow might be helpful for that purpose:

  23237 - duplicate keys, duplicate rows, duplicate records

Best regards,

Thiago

[former_member182546]

Dear Mariana ,

         Take the help of an abaper and ask him to keep a breakpoint in the portion of code where the dump occurs.

This may be due to the reason the system trying  inserting the Key field value which is already present in the check table t682z.

I hope the debugging will give a better understanding in functional perpectative.

Thanks,

With Regards,

Sudhir S