Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Extracting high volume of data from SAP R/3

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Extracting high volume of data from SAP R/3
 Login/Join
 
Member
posted
when more than certain amount of data is present in a SAP R/3 table, data migrator is not able extract the data,

after some point of time (15 - 45 mins),we are getting this error,

SAP/R3 REQUEST ERROR: RFC_ERROR_PROGRAM
SAP/R3 ERROR EXECUTING ABAP4 PROGRAM : <objectName>

- The SAP synonym doesn't contain any RAW data types
- Adapter is a SAP R/3 4.6C - ECC 5.0, 6.x Non Unicode
- DM Version: 7.6.11

SQL is some thing similar to this,

SELECT
T1.BSIS_MANDT , --Client
T1.BSIS_BUKRS , --Company Code
T1.BSIS_BELNR , --Accounting document number
T1.BSIS_GJAHR , --Fiscal year
T1.BSIS_BUZEI , --Number of Line Item Within Accounting Document
T1.BSIS_HKONT --General ledger account
FROM
v04_bsis T1
WHERE
T1.BSIS_MANDT = '026' AND
T1.BSIS_BUKRS NOT IN ( '3218' , '3284' ) AND
T1.BSIS_HKONT IN ( '2240000000' , '2210300000' )

RFC trace is as shown below:

15.06.55 CC -SAPPAS : Function Name : ZIBI
15.06.55 CD -SAPPAS : Calling Rfc Function - RfcCallReceive
15.09.22 CD -SAPPAS : Returning from Rfc Function - RfcCallReceive
15.09.22 CD -SAPPAS : RC = 3
15.09.22 CB -SAPPAS : exited. Errcode= -1; ibiSapExFunction
15.09.22 CB -SAPPAS : entered. ibiSapLastError
15.09.22 CD -SAPPAS : Calling Rfc Function - RfcLastErrorEx

What are the possbile reasons for getting this kind of error, and what is/are the solution(s)?

Appreciate your help.


7.6, AIX, all output
 
Posts: 13 | Registered: February 03, 2011Report This Post
Guru
posted Hide Post
The product manager for SAP suggests that you look at the dev_rfc and rfc traces for cause of the error. If it's not apparent then please open a hottrack case and post the traces and he'll take a look at them and suggest further.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Extracting high volume of data from SAP R/3

Copyright © 1996-2020 Information Builders