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?