JDBC Merging fails with Sort Error when results are already sorted

[gmilunich (Geoff Milunich)]

Thanks Colin!

This looks like a similar topic for reference:

JDBC Merge rows error for multivalued records

Hi all, I would like to merge columns from a specific database table so we can aggregate in multivalued attributes. When we follow the steps listed in the guide doc we get a “data should be sorted in ascending order. Last identifier NOCLOGS\testuser current noclogs\testuser” error message which we’ve attempted to resolve using this by querying accounts using order by “SELECT * FROM dbo.mytable ORDER BY ADUsername ASC” but still the same error. We updated the JDBC Source to enable merge by sett…