Forum Discussion

rmedeiros's avatar
rmedeiros
New Contributor III
3 years ago

Sorting Error after Netsuite Search

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

6 Replies

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor

    Your target system i.e. snowflake doesn’t have all the columns defined; meaning for instance, your upstream has 5 columns, snowflake has been defined with less than 5 columns thus data couldn’t be ingested.

    Try to have a mapper before snowflake snap and if you have defined 3 cols, specify those 3 in the mapper prior and you will not see any error on execution.