Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
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
Go
New
Search
Notify
Tools
Reply
  
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, 2011Reply With QuoteReport 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.
 
Posts: 379 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.