Background job cancelled?

[Former Member]

Hi all,

One of my back gound job was cancelled due to following details:

IN SOUrce code:

-

---

> INSERT ZSTAT from table ztab.

Exception:

The ABAP/4 open sql array inserts results in duplicate records.

Please suggest me how can i resolve this...

Sachin.

[Former Member]

Hi,

It seems it is trying to insert duplicate record into the ztable. Please refer the data.

Thanks,

Sriram Ponna.

[Former Member]

Hi Sriram,

This job is executing from past so many years,we never got this type of exception.

Sachin.

[Former Member]

Hi

delete the adjacent duplicated from ztab based on primary key and compare the record with database table .

if internal table data pkey < > database table data pkey

then do INSERT

endif.

try this.

thanks

Ramya S