I have a replication activity as follows, wherein I explode a whole bunch of multivalue fields based on docunid+emplid pairs:
The setup is: Source -> Order -> Activity -> CollExp - Order -> Target.
Source OrderActivityCollExpTarget OrderThe target is Notes.
1. When the target is empty the activity runs without error and the resulting target data is correct:
| docunid_unique | empID |
| 6299D8DD0A2D7FDD852574DB00573961, 6299D8DD0A2D7FDD852574DB00573961 | 47695 |
| 6299D8DD0A2D7FDD852574DB00573961, 6299D8DD0A2D7FDD852574DB00573961 | 99999 |
| Can anyone confirm that this is the correct result, when the first key value appears n times in the target document, and the second key appears once? |
2. If I run the activity a second time, having done nothing else, the activity produces the following error:
Error: Remove from Connector B affected no records (check for key precision mismatch)
Current record key values at the time of the replication error --
- Connector A record key values: DocUNID = "6299D8DD0A2D7FDD852574DB00573961, 6299D8DD0A2D7FDD852574DB00573961"; empID = "99999, 47695"
- Connector B record key values: docunid_unique = "6299D8DD0A2D7FDD852574DB00573961, 6299D8DD0A2D7FDD852574DB00573961"; empID = "47695, 99999"
3. No data is updated.
What is going on here? What is the activity unhappy about?
Return to top
Print this page
