fastinsert returns "Numeric value out of range" error, but insert works
7 views (last 30 days)
Hi! I have a situation where, on precisely the same data set, fastinsert is returning
"Java exception occurred: sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][ODBC SQL Server Driver]Numeric value out of range"
but insert works. Looking at the help for fastinsert I see:
"...fastinsert ... supports more (emphasis added) object types than insert"
and the only exception to that I see documented is
"The fastinsert function only supports dates in U.S. format; that is, dates in mm/dd/yyyy format."
I did have this problem, but I corrected it (at least, the error I was getting before is different than the one cited above).
Is anyone aware of any other (undocumented) fastinsert limitations? Any other ideas?