IBM Support

Error Message: 22003 [Microsoft][SQL Server Native Client 10.0]Numeric value out of range

Troubleshooting


Problem

I'm running a stream which uses a SQL Source node. The datasource uses the SQL Server Native Client 10.0 ODBC driver. The table in the SQL Server 2008 database has a decimal 15,5 field. Running the stream gives below error. Error Message: 22003 [Microsoft][SQL Server Native Client 10.0]Numeric value out of range

Resolving The Problem

This problem has been reported to SPSS Development - Workaround Available
This is working as designed.
As a workaround, use float instead of decimal.
More information about he use of float and decimal can be found in the Help of SQL Server 2008

[{"Product":{"code":"SS3RA7","label":"SPSS Modeler"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Modeler","Platform":[{"code":"PF033","label":"Windows"}],"Version":"13.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

84112

Document Information

Modified date:
16 June 2018

UID

swg21483818