Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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>

Tags:
Former Member
Former Member replied

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

Thanks for the reply.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question