Can't import data or publish to Analytics because of the following error message:-
Orchestrate data flow import has failed. The detailed information is as follows:
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. Warning: Null value is eliminated by an aggregate or other SET operation.
Import command:
EXEC [wf].[pr_Merge_orc_RateTable]
If the error generates after saving the plan and publishing to Analytics, the functionality has been enhanced in Orchestrate version 7.77 hotfix 50. Please upgrade to this version or above.
If the error generates during a data import, there are some duplicate entries in the database. Please start a conversation on the Access Community Portal. How to contact Support via the MyAccess Portal | Orchestrate Help Centre