SAP Knowledge Base Article - Preview

3369355 - Error: [ODBC Driver 17 for SQL Server]Numeric value out of range row <row number>, col <col number> when loading data from MSS DB Connection datasource

Symptom

When execute an infopackage from the DB connection type source system, got the errors:

Unknown error while uploading data from the DB table
Message no. RSDS_ACCESS027

Errors in source system
Message no. RSM340

And from ST11, you can see the following errors:

C  ERROR: 1 in function GetNextRow (fetch) [line 18528]
C  (99) [22003] [Microsoft][ODBC Driver 17 for SQL Server]Numeric value out of range row 1, col<col number>
C  ERROR: 1 in function GetNextRow (fetch) [line 18528]
C  (99) [22003] [Microsoft][ODBC Driver 17 for SQL Server]Numeric value out of range row 2, col <col number>
C  ERROR: 1 in function GetNextRow (fetch) [line 18528]
C  (99) [22003] [Microsoft][ODBC Driver 17 for SQL Server]Numeric value out of range row 3, col <col number>
......

The same ST11  errors can also be seen from datasource data preview(T-cd=RSDS -> Preview).


Read more...

Environment

  • SAP Netweaver BW Data Warehourse All Versions

Product

SAP NetWeaver all versions

Keywords

STRING, Date, Proposal , KBA , BW-WHM-DST , Data Staging , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.