cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
542
Views
0
Helpful
1
Replies

TMS 14.5 ETL Job failed

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

1 Accepted Solution

Accepted Solutions

Kjetil Ree
Cisco Employee
Cisco Employee

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

View solution in original post

1 Reply 1

Kjetil Ree
Cisco Employee
Cisco Employee

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