0
Answered

UNIFYBroker/Plus attempting to join source to incorrect target

Adrian Corston 2 years ago in UNIFYBroker/Plus updated by Matthew Davis (Technical Product Manager) 2 years ago 5

Log says:

20221129,21:30:25,UNIFYBroker,Link,Error,"Request to sync changes on link failed.  Request to sync changes on link Employee > AD User (ad53013b-b271-4ed6-a959-dc11aeaa5eca) in direction outgoing failed with message Source entity '0b5d5a72-fd60-4777-b1ef-f1d4a035c87d' cannot be joined to ambiguous join targets: [391e6395-a3c2-424c-9799-30a98508ac1f, 5a6e4486-75f8-4487-ab8f-4eeccf06a524]. Cannot proceed with join. [Count:4321]. Duration: 00:00:04.5645340

Link join criteria is:

Image 6392

Source entity is:

Image 6393

Target entities are:

Image 6394

Image 6395

Why would an attempt to join to 5a6e4486-75f8-4487-ab8f-4eeccf06a524 be happening, given it doesn't match the join criteria?

Answer

Answer

The root cause of this was staff from the customer's outsourced IT department updating employeeID values wrongly, in contravention of documented processes.

Please close this ticket and mark 'not a bug'.

There is a possibly-related but less critical issue with a duplicate ambiguous join target getting reported twice on the incoming direction.  In this case the error is legitimate, because there are two entities with the same join criteria field value, but the error itself is showing the same target entity (7a252472-3043-4018-b122-f16033b18a65) twice for some reason:

20221129,21:30:21,UNIFYBroker,Link,Error,"Request to sync changes on link failed. Request to sync changes on link Employee > AD User (ad53013b-b271-4ed6-a959-dc11aeaa5eca) in direction incoming failed with message Source entity '391e6395-a3c2-424c-9799-30a98508ac1f' cannot be joined to ambiguous join targets: [0b5d5a72-fd60-4777-b1ef-f1d4a035c87d, 7a252472-3043-4018-b122-f16033b18a65, 7a252472-3043-4018-b122-f16033b18a65]. Cannot proceed with join. [Count:2309]. Duration: 00:00:07.1606939

Under review

Hi Adrian,

Are there any joins that exist against the source entity currently? ( 0b5d5a72-fd60-4777-b1ef-f1d4a035c87d ) Or is it a newly provisioned entity? 

Under Remove Joins for the link I can see that entity already showing, which I believe means it is already joined.  I don't know how to see which locker it's joined to.

Answer

The root cause of this was staff from the customer's outsourced IT department updating employeeID values wrongly, in contravention of documented processes.

Please close this ticket and mark 'not a bug'.