cancel
Showing results for 
Search instead for 
Did you mean: 

Issue in loading kna1 table from ecc to hana through BODS

Former Member
0 Kudos

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,

Accepted Solutions (1)

Accepted Solutions (1)

tomas-krojzl
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Tomas, Thanks for your reply.

here is the job log -

270204226303744R3C-1510015/26/2013 10:50:39 PM|Data flow DF_KNA1
270204226303744R3C-1510015/26/2013 10:50:39 PMError calling RFC function to get table data: <RFC_ABAP_EXCEPTION-(Exception_Key: DATA_BUFFER_EXCEEDED, SY-MSGTY: E, SY-MSGID:
270204226303744R3C-1510015/26/2013 10:50:39 PMFL, SY-MSGNO: 046, SY-MSGV1: /BODS/RFC_READ_TABLE)>.
270001703876352R3C-1510015/26/2013 10:50:47 PM|Data flow DF_KNA1
270001703876352R3C-1510015/26/2013 10:50:47 PMError calling RFC function to get table data: <RFC_ABAP_EXCEPTION-(Exception_Key: DATA_BUFFER_EXCEEDED, SY-MSGTY: E, SY-MSGID:
270001703876352R3C-1510015/26/2013 10:50:47 PMFL, SY-MSGNO: 046, SY-MSGV1: /BODS/RFC_READ_TABLE)>.
rindia
Active Contributor
0 Kudos

Hi Raghavendra,

There is problem in data buffer which does no have enough space to accommodate data.

The cause is due to:

  1. The data extracted for a row in an SAP application table source is larger than 512 bytes.
  2. The Data Services Remote Function Call (RFC) Z_AW_RFC_READ_TABLE is not installed on the SAP application server.

"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

Former Member
0 Kudos

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

rindia
Active Contributor
0 Kudos

Hi Ainsley,

In SAP note 1752954, SAP suggested to install  the function 'Z_AW_RFC_READ_TABLE' in the resolution.

Also I went to the source code of 'Z_AW_RFC_READ_TABLE' which has APPEND statements to CODETAB. But I could not figure it out about RFC_STREAM_READ_TABLE?

Regards

Raj

former_member223578
Active Participant
0 Kudos

Hi Raj,

We are also facing same issue... can you please let us know how to install  Z_AW_RFC_READ_TABLE in SAP ECC system


Regards,

Krishna.M

lucas_oliveira
Advisor
Advisor
0 Kudos

Please don't resurrect/highjack dead-old-answered threads. Create a new thread and refer to this one if necessary.

Special attention to

BRs,

Lucas de Oliveira (moderator)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello Raj and Tomas,

Thanks for your reply.

I am able to fix this issue by splitting the select query.

Thanks,

Raghu

Former Member
0 Kudos

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.

rindia
Active Contributor
0 Kudos

Hi Raghavendra,

Could you please send the complete message of the job log like this:

Regards

Raj

tomas-krojzl
Active Contributor
0 Kudos

Hello,

can you look into job log?

Tomas