Sorting Error after Netsuite Search

[rmedeiros]

Hi!

I’m building an integration here that gets contacts from Hubspot and update them as customers to Netsuite. I’m getting data from Netsuite by querying a saved search. After getting the data i need to sort to diff. The problem is that when i validate it takes a few minutes to the Netsuite Search to become green and, before that happens, the Sort snap will fail and become red. I tried using the Async Search and had the same issue.

Do you know why its happening?

This is the error shown at Sort snap:
Failure: class java.util.LinkedHashMap cannot be cast to class java.lang.Comparable (java.util.LinkedHashMap and java.lang.Comparable are in module java.base of loader ‘bootstrap’), Reason: Snap failed unexpectedly and did not provide any reason

[rmedeiros]

Thanks a lot for the help. The sort snap is working correctly now.

But not that the sorting path from both streams are different, how should i set the Diff snap to work with both?

[koryknick]

Can you not sort on the same values in both paths?