Error when trying to export table from SAP to MSSQL with RFC

system · February 20, 2013, 3:00pm

Below the error message I receive when trying to use a SAP table as source in a dataflow to export data to MSSQL 2008. (with RFC method)

When limiting the columns to only the decimals and numerics, no errors
When limiting the columns to only the varchar and char fields, no errors
When taking all columns, it fails…

Any idea’s?

(14.1) 02-20-13 15:32:19 (E) (5288:4540) RUN-050803: |Data flow New_DataFlow3|Reader /WATP/TARBNOTES
                                                     Cannot convert data <-Inz           W.RS.S-00002-Gl> into type <DECIMAL> in file <SapDB::srcDB_table_batch_stream>, row number
                                                     <1>, column number <133>.
 (14.1) 02-20-13 15:32:21 (E) (5288:5648) R3C-150605: |Data flow New_DataFlow3|Reader /WATP/TARBNOTES|Transform /WATP/TARBNOTES__Driver
                                                     The SAP job was canceled for host < >, job name <b950f0217b6911e28cdd14a8137416b5>, job count <15273900>, job log from SAP
                                                     <20130220, 152739, Job started
                                                     20130220, 152739, Step 001 started (program /BODS/RPT_STREAM_READ_TABLE, variant &amp;0000000000012, user ID SAPDS____USR)
                                                     20130220, 153158, Data Services read error.Check Data Services error
                                                     20130220, 153158, Job cancelled after system exception ERROR_MESSAGE
                                                     >.
 (14.1) 02-20-13 15:32:21 (E) (5288:4540) R3C-150412: |Data flow New_DataFlow3|Reader /WATP/TARBNOTES
                                                     RFC CallReceive error <RFC_ABAP_EXCEPTION-(Exception_Key: READ_ERROR>.
 (14.1) 02-20-13 15:32:31 (E) (5972:5252) R3C-150605: |Data flow New_DataFlow3|Reader /WATP/TARBNOTES|Transform /WATP/TARBNOTES__Driver
                                                     The SAP job was canceled for host < >, job name <b950f0217b6911e28cdd14a8137416b5>, job count <15273900>, job log from SAP
                                                     <20130220, 152739, Job started
                                                     20130220, 152739, Step 001 started (program /BODS/RPT_STREAM_READ_TABLE, variant &amp;0000000000012, user ID SAPDS____USR)
                                                     20130220, 153158, Data Services read error.Check Data Services error
                                                     20130220, 153158, Job cancelled after system exception ERROR_MESSAGE

aragornII (BOB member since 2006-12-21)

system · February 21, 2013, 6:37am

Is this RFC streaming or RFC read table? I can only see that you have a DF and not a R/3 DF?

Could you please check tx SM21 in SAP? And possibly also tx ST22?

And does writing to a flat file work?

Johannes Vink (BOB member since 2012-03-20)

system · February 21, 2013, 7:28pm

Very likely one of your columns has a column delimiter character in its value?

Werner Daehn (BOB member since 2004-12-17)

system · February 22, 2013, 11:19am

Correct indeed Werner, thanx for the hint!

aragornII (BOB member since 2006-12-21)

system · November 7, 2013, 2:42am

Hello,
I am getting the same error when loading an SAP table via RFC in data services 4.1 into a MSSQL database. Did you come up with a workaround for this or did you revert back to an ABAP flow?
I get an error message when attempting to view the data in data services of the ECC table in question.

Thanks,

Ozzloz (BOB member since 2013-11-07)

system · November 27, 2014, 9:50am

I faced a similar issue where its giving error as:

RUN-050803: |Data flow |Reader Query
Cannot convert data into type in file SapDB::srcDB_table_query_stream, row number <0>, column number <14>.

I just checked my data and found special characters in Column 13 which had length more than the defined length of the column 13. Hence the data from column 13 was getting pushed to column 14 and in turn the data from column 14 (which was of type Char) was getting pushed further to get loaded into next column i.e. Column 15 which was of type Decimal.

Solution:
while extracting the data I set the value for each column as VARCHAR(255).

Not Specified (BOB member since 2014-11-27)