on 05-26-2013 7:20 PM
Dear All,
I am trying to load the kna1 table from ecc to hana through BODS. I am getting error message like "28386 115107584 JOB 5/26/2013 10:51:24 PM Job <STUDENT_KNA1> is terminated due to error <151001>".
what could be the possible issue.
NOTE : I successfully loaded TCURR table to hana from ecc though same connection and data store.
Thanks,
Hello,
based on the error in the log you will see if this is SAP HANA related error or BOBJ Data Services related error...
In second case (non-HANA related error) I would suggest to move (if you can do it) the question to forum because there you will find more experts for BusinessObjects Data Services problems...
Tomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tomas, Thanks for your reply.
here is the job log -
27020 | 4226303744 | R3C-151001 | 5/26/2013 10:50:39 PM | |Data flow DF_KNA1 |
27020 | 4226303744 | R3C-151001 | 5/26/2013 10:50:39 PM | Error calling RFC function to get table data: <RFC_ABAP_EXCEPTION-(Exception_Key: DATA_BUFFER_EXCEEDED, SY-MSGTY: E, SY-MSGID: |
27020 | 4226303744 | R3C-151001 | 5/26/2013 10:50:39 PM | FL, SY-MSGNO: 046, SY-MSGV1: /BODS/RFC_READ_TABLE)>. |
27000 | 1703876352 | R3C-151001 | 5/26/2013 10:50:47 PM | |Data flow DF_KNA1 |
27000 | 1703876352 | R3C-151001 | 5/26/2013 10:50:47 PM | Error calling RFC function to get table data: <RFC_ABAP_EXCEPTION-(Exception_Key: DATA_BUFFER_EXCEEDED, SY-MSGTY: E, SY-MSGID: |
27000 | 1703876352 | R3C-151001 | 5/26/2013 10:50:47 PM | FL, SY-MSGNO: 046, SY-MSGV1: /BODS/RFC_READ_TABLE)>. |
Hi Raghavendra,
There is problem in data buffer which does no have enough space to accommodate data.
The cause is due to:
"When you use an SAP application table as a data flow source, Data Services extracts data using the Data Services-provided RFC (remote function call) Z_AW_RFC_READ_TABLE. The function call extracts up to 2048 bytes per row. If this function is not loaded to the SAP application server, Data Services extracts data using the SAP-supplied function, RFC_READ_TABLE. This function call limits extracted data to 512 bytes per row."
Resolution: Install the Z_AW_RFC_READ_TABLE function on the SAP application server.
For more details please refer to SAP note: 1752954 regarding how to do this.
Regards
Raj
Hi there Raj & Co,
I have found an error in the SAP Note 1752954 - DATA_BUFFER_EXCEEDED error - Data Services.
It refers to a function called 'Z_AW_RFC_READ_TABLE'. However this function is actually called
RFC_STREAM_READ_TABLE
The SAP Supplement for Data Services refers to the RFC_STREAM_READ_TABLE function and not what is specified in the SAP note 1752954.
Regards,
Ainsley
Hello Raj and Tomas,
Thanks for your reply.
I am able to fix this issue by splitting the select query.
Thanks,
Raghu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Place the abap file "Z_AW_RFC_READ_TABLE" in the Trans folder of SAP Application Server side
i.e
Where the SAP Application Server is Installed. for ex:\\Server Name\sapmnts\trans
run it in Run mode.
Place the Abap file in SAP Application Server side using /nSE37 Transaction Code
OR
Go to SAP BODS Designer in that Tools->Options->SAP(Expand)Environment
in that popup window.Set the Maximum number of rows as 100.If the data record are big
The value default is 5000.
IT IS GOING TO WORK OUT.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
can you look into job log?
Tomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.