Skip to Content
avatar image
Former Member

Numeric value out of range issue in data loading

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>

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 29, 2014 at 04:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

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

      Thanks for the reply.