Numeric value out of range issue in data loading

[Former Member]

Hi All,

When I run the job failing with the below error message.

Please help.

Thanks in advance.

20160 19428 DBS-070401 12/29/2014 9:39:39 AM |Data flow product_info|Loader product_info_product_info
20160 19428 DBS-070401 12/29/2014 9:39:39 AM ODBC data source <dev_server\SQLSERVER2012> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client
20160 19428 DBS-070401 12/29/2014 9:39:39 AM 11.0]Numeric value out of range>.
20160 19428 RUN-051005 12/29/2014 9:39:39 AM |Data flow product_info|Loader product_info_product_info
20160 19428 RUN-051005 12/29/2014 9:39:39 AM Execution of <Regular Load Operations> for target <product_info> failed. Possible causes: (1) Error in the SQL syntax; (2)
20160 19428 RUN-051005 12/29/2014 9:39:39 AM Database connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in the
20160 19428 RUN-051005 12/29/2014 9:39:39 AM datastore has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is for
20160 19428 RUN-051005 12/29/2014 9:39:39 AM regular load operation and load triggers are defined, check the SQL. Otherwise, for (3) and (4), contact your local DBA.
15828 
21696 DBS-070401 12/29/2014 9:39:49 AM |Data flow product_info|Loader product_info_product_info
15828 21696 DBS-070401 12/29/2014 9:39:49 AM ODBC data source <dev_server\SQLSERVER2012> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client
15828 21696 DBS-070401 12/29/2014 9:39:49 AM 11.0]Numeric value out of range>.|<Regular Load Operations>|<product_info>

[Former Member · Accepted solution]

Hi Kiwi,

You need to debug and check what values you are trying to insert.

If the data flow is full push down then try to execute the query in db and verify the column for any non integer values.

If it's not pushing down, then keep a template table in target and change respective column's data type to varchar, run the job and verify the results.

Hope this helps.

Thanks

Shesha

[Former Member · Accepted solution]

I was loaded the data for one of the column with out NULL values. Then it was worked fine.

Thanks for the reply.