BusinessObjects Board

Using RFC read table crashes DS 4.1

http://wiki.sdn.sap.com/wiki/display/EIM/Reading+via+RFC+Read+Table
http://wiki.sdn.sap.com/wiki/display/EIM/RFC+transport+method

5888	6000	R3C-151001	2/8/2013 3:11:55 PM	Error calling RFC function to get table data: <RFC_ABAP_RUNTIME_FAILURE-(Exception_Key: DATA_OFFSET_TOO_LARGE)- Invalid
5888	6000	R3C-151001	2/8/2013 3:11:55 PM	subfield access: Offset too large>.

What we did:

Created a user with SAP ALL rights (in ECD)

Ran the command: The one thing you should do (for execute_in_background=yes required) is going into the SAP transaction /nsm59 and create a new RFC destination of name SAPDS as Connection Typ T (TCPIP) and under Technical Settings set it to Registered Server Program and the Program ID to SAPDS as well.

Import the R/3 functions shipped with DS 4.1

According to all the stuf I found about it, the magnifier (view data) is not working on wide tables, but you should be able to get all the data even exceeding 512 bytes

http://wiki.sdn.sap.com/wiki/display/EIM/RFC+transport+method

So what to do next? What are we missing?
If we need to get all columns of for example BUT000, do we need to do it with a lookup function call towards Z_AW_RFC_READ_TABLE and what are the parameters to use this function?

Many thanks in advance!


aragornII :belgium: (BOB member since 2006-12-21)

Are trying to view data from DS Designer? Can you check if system has /BODS/RFC_STREAM_READ_TABLE?


adash (BOB member since 2009-01-11)

Yes, the view data tab in when clicking on the source table, turns out into error, but also when trying to import all records into a temporary database table.

The feedback I had from the basisteam who is responsible for the transports was that the file R63K900086 was loaded into the system.

So I suppose all the functions were loaded. How can we check if its really fine?


aragornII :belgium: (BOB member since 2006-12-21)

Problem was solved, the wrong set of functions was loaded due to confusion after upgrading from DS XI 3.2 towards DS XI 4.1
The old Data Services folder also remained after uninstall and the new one was called SAP Data Services, both had R3 functions in the admin folder
:oops:


aragornII :belgium: (BOB member since 2006-12-21)

Correct. K900086 is the 3.x transport file. I just read that this week as we also had a discussion on which transport file was used in a certain SAP system.

Thanks for reporting this back.

If you have experiences to share about the RFC streaming, there is a topic about this: BODS 4.1: RFC Streaming experiences

I am curious to know about your experiences :mrgreen:


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