BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

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


 
Search this topic... | Search DI: SAP-specific ERP/BW... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Author Message
aragornII
Senior Member
Senior Member



Joined: 21 Dec 2006

Posts: 55
Location: Belgium


flag
PostPosted: Wed Feb 20, 2013 10:00 am 
Post subject: Error when trying to export table from SAP to MSSQL with RFC

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?

Code:
(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 &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 &0000000000012, user ID SAPDS____USR)
                                                     20130220, 153158, Data Services read error.Check Data Services error
                                                     20130220, 153158, Job cancelled after system exception ERROR_MESSAGE
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Thu Feb 21, 2013 1:37 am 
Post subject: Re: Error when trying to export table from SAP to MSSQL with

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?
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10591
Location: Germany


flag
PostPosted: Thu Feb 21, 2013 2:28 pm 
Post subject: Re: Error when trying to export table from SAP to MSSQL with

Very likely one of your columns has a column delimiter character in its value?
_________________
Werner Daehn
ex Product Manager Data Services at SAP SE

www.rtdi.io
Back to top
aragornII
Senior Member
Senior Member



Joined: 21 Dec 2006

Posts: 55
Location: Belgium


flag
PostPosted: Fri Feb 22, 2013 6:19 am 
Post subject: Re: Error when trying to export table from SAP to MSSQL with

Correct indeed Werner, thanx for the hint!
Back to top
Ozzloz
Forum Member
Forum Member



Joined: 06 Nov 2013

Posts: 4



PostPosted: Wed Nov 06, 2013 9:42 pm 
Post subject: Re: Error when trying to export table from SAP to MSSQL with

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,
Back to top
Not Specified
Forum Member
Forum Member



Joined: 27 Nov 2014

Posts: 1



PostPosted: Thu Nov 27, 2014 4:50 am 
Post subject: Re: Error when trying to export table from SAP to MSSQL with

I faced a similar issue where its giving error as:

RUN-050803: |Data flow |Reader Query
Cannot convert data <XX> into type <DECIMAL> 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).
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0281 seconds using 17 queries. (SQL 0.0024 Parse 0.0009 Other 0.0249)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo