TMS 14.5 ETL Job failed

[Hans-Werner Prinz]

Hello,

TMS 14.5 says: Data awrehouse ETL failed: The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.

Does anyone have an idea how to solve this?

according to the 14.5 Rel.Notes this belongs to the new bridge utilization part, and is not supported by TAC.

/hans

[Kjetil Ree · Accepted solution]

Hi,

ETL job failures are by definition bugs, but no one has reported this particular failure before.

To troubleshoot, I would need a database copy and your log-etl.txt file. I'll send you a private message.

Regards,
Kjetil