Duplicate Key error when updating data from ODS to data target

[Former Member]

Hi all,

When updating data from ODS to infocube, some of the data packages failed due to the following shortdump error:

Runtime Errors DBIF_DSQL2_SQL_ERROR

Exception CX_SY_NATIVE_SQL_ERROR Page 1

Occurred on 15.12.2004 at 09:22:08

-

---

SQL error "-89988" occurred when executing EXEC SQL.

-

---

What happened?

-

---

The error occurred in the current database connection "R/3*".

-

---

Error analysis

-

---

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_NATIVE_SQL_ERROR', was

neither

caught nor passed along using a RAISING clause, in the procedure "XTAB_INSERT"

"(FORM)"

.

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

-

---

How to correct the error

-

---

The exception must either be prevented, caught within the procedure

"XTAB_INSERT"

"(FORM)", or declared in the procedure's RAISING clause.

To prevent the exception, note the following:

Database error text........: "DUPLICATE KEY "

Triggering SQL statement...: "INSERT INTO "/BI0/XFUNCT_LOC" ( "SID", "OBJVERS",

"FUNCT_LOC", "CHANGED", "S__0ABCINDIC", "S__0ASSET_MAIN", "S__0COMP_CODE",

"S__0COSTCENTER", "S__0CO_AREA", "S__0MAINTPLANT", "S__0PLANPLANT",

"S__0PMPLANGRP", "S__ZPMCH056", "S__ZPMCH057" ) VALUES ( ? , "

Internal call code.........: "[DBDS/NEW DSQL]"

Please check the entries in the system log (Transaction SM21).

Any ideas?

Thanks

Rgds

[Former Member]

Hi,

I recommend two things:

a) check and repair infoobject 0funct_loc and

b) set your infopackage to psa and subsequently into data targets

regards

Siggi