have a job to find the new and update records using the MAP_OPERATION, but I got the error message as following. I can’t find the cause why do the delete action for those records with update type
DS_LIBRARY"."DI_OPERATION_TYPE"='U'.
|Sub data flow DF_WS_Library_1_1|Loader Map_Operation_4_DS_LIBRARY
SQL submitted to database <> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;462failed on update or delete
by foreign key constraint violation: "WHITESOURCE_DB_DEV"."_SYS_TRIGGER_RUL_DEL_23963514_#0_#": line 2 col 277 (at pos 440):
[10000] (range 3) user-defined error exception: referential constraint violated>. The SQL submitted is <DELETE FROM
"WHITESOURCE_DB_DEV"."DS_LIBRARY" WHERE EXISTS ( SELECT 1 FROM "WHITESOURCE_DB_DEV"."DT__539816_187_1_2_26436" WHERE
"DT__539816_187_1_2_26436"."ID"="DS_LIBRARY"."ID" AND "DT__539816_187_1_2_26436"."DI_OPERATION_TYPE"='U' AND
"DI_SEQUENCE_NUMBER" IN ( SELECT MAX("DI_SEQUENCE_NUMBER") FROM "WHITESOURCE_DB_DEV"."DT__539816_187_1_2_26436" GROUP BY
"ID"))>.
(14.2) 04-01-20 09:46:5 (E) (26436:32084) RUN-051005: |Sub data flow DF_WS_Library_1_1|Loader Map_Operation_4_DS_LIBRARY
Execution of <DELETE FROM "WHITESOURCE_DB_DEV"."DS_LIBRARY" WHERE EXISTS ( SELECT 1 FROM
"WHITESOURCE_DB_DEV"."DT__539816_187_1_2_26436" WHERE "DT__539816_187_1_2_26436"."ID"="DS_LIBRARY"."ID" AND
"DT__539816_187_1_2_26436"."DI_OPERATION_TYPE"='U' AND "DI_SEQUENCE_NUMBER" IN ( SELECT MAX("DI_SEQUENCE_NUMBER") FROM
"WHITESOURCE_DB_DEV"."DT__539816_187_1_2_26436" GROUP BY "ID"))> for target <DS_LIBRARY> failed. Possible causes: (1) Error in
the SQL syntax; (2) Database connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The
user defined in the datastore has insufficient privileges to execute the SQL. If the error is for preload or postload
operation, or if it is for regular load operation and load triggers are defined, check the SQL. Otherwise, for (3) and (4),
contact your local DBA.
(14.2) 04-01-20 09:47:00 (E) (41200:42552) DFC-250038: |Dataflow DF_WS_Library
Sub data flow <DF_WS_Library_1_1> terminated due to error <70407>.
(14.2) 04-01-20 09:47:00 (E) (41200:30384) FIL-080134: |Dataflow DF_WS_Library|Pipe Listener for DF_WS_Library_1_1
Named pipe error occurred: <The pipe has been ended.
>
(14.2) 04-01-20 09:47:00 (E) (41200:42312) FIL-080134: |Dataflow DF_WS_Library|Pipe Listener for DF_WS_Library_1_2
Named pipe error occurred: <The pipe has been ended.
>
(14.2) 04-01-20 09:47:00 (E) (41200:28272) FIL-080134: |Dataflow DF_WS_Library|Pipe Listener for DF_WS_Library_1_3
Named pipe error occurred: <The pipe has been ended.
>
(14.2) 04-01-20 09:47:00 (E) (41200:43556) FIL-080134: |Dataflow DF_WS_Library|Pipe Listener for DF_WS_Library_1_4
Named pipe error occurred: <The pipe has been ended.
>
(14.2) 04-01-20 09:47:00 (E) (41200:41896) FIL-080134: |Dataflow DF_WS_Library|Pipe Listener for DF_WS_Library_1_5
Named pipe error occurred: <The pipe has been ended.
>
(14.2) 04-01-20 09:47:00 (E) (36512:42224) DFC-250038: |Dataflow DF_WS_Library
Sub data flow <DF_WS_Library_1_1> terminated due to error <70407>.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.