AnsweredAssumed Answered

How to deal with NetSuite connector converting large numbers to scientific notation?

Question asked by 53587767 on Mar 3, 2016
Latest reply on Mar 7, 2016 by 53587767


One of my processes starting throwing an error after we made a deal with a big client which resulted in a large invoice (over $10M). The invoice data is coming from NetSuite and is being read fine with the exception that the large invoice is being converted into scientific notation. I'm pushing this into our analytics database (MS SQL) which is where the error arises because it is reading the notation as text and cannot convert it to a number.

 

The error reads as such:

Child Synchronous Process Call: NS Invoices>STATS [execution-e066a52c-168a-4ad9-9a5e-64a0c1a6119f-2016.03.02(shape20)] call ended in error: com.boomi.process.ProcessException: [Microsoft][ODBC SQL Server Driver]Numeric value out of range; Caused by: [Microsoft][ODBC SQL Server Driver]Numeric value out of range

 

Has anyone had to deal with this?

Outcomes