Record count in RSA3 and PSA is different

[Former Member]

Experts,

I am extracting data from 2LIS_02_SCL. Now when I extract this data in full load in RSA3, I get a total of 19200 records.

When I extract this data to PSA ONLY, the count is 19191. A total of 9 records are dropped while extraction from R3 to BI.

I do not have any infopackage selection criteria.

Any ideas why such a strange behaviour?

Thanks & BR,

Jain

[former_member215845]

Hi Raj,

You should set "Data Records / Calls" to the same as MAXLINES. You can set "Display Extr. Calls" to 3 so that all the records are extracted.

Best Regards,

Vincent

[former_member215845]

Hello Jain,

I would take a look at the authorizations as per point 5 in note 529789. Also, make sure the package size used by RSA3 is the same as that used by the infopackage as in point 2.

Best Regards,

Vincent

[Former Member]

Thanks Vincent.

The settings in table ROIDOCPRMS in BI is

SLOGSYS MAXSIZE STATFRQU MAXPROCS BTCSYSTEM MAXLINES MAXDPAKS

BWCLNT300 020000 10 03 100000

EWCLNT300 020000 10 03 100000

Can you tell me what values (Extr Calls and Display Calls) should I use in the RSA3 for extraction?

Thanks & BR,

Raj

[Former Member]

Blunder by me since the selection range no was different in BI and in RSA3

[former_member181964]

HI,

In RSA3 you give Data Records / Calls = 999999 and Display Extr. Calls = 9999 and execute and then load the data to PSA and check the total no of records in RSA3 and in PSA.

Thanks

Reddy

[former_member215845]

Hello Jain,

There are some good notes for analyzing differences between RSA3 and the PSA;

529789 BW extraction/extractor checker differences

and specifically for the logistics cockpit datasources;

992975 Analyzing data extraction for differences betw OLTP and BW

Best Regards,

Vincent

[Former Member]

Thanks Vincent.

My problem seems to be peculiar.

1. I am re-doing the setup. Have executed the necessary steps.

The issue is with the Schedule line datasource

When I run RSA3 for 2LIS_02_SCL, I get 19200 records.

When I initiate the IP from BI, I get 19191 records. I checked the job log for this request in R/3 I see that the records passed to the User Exit for this datasource is 19191 and not 19200.

Here's the exact message:

"

Call customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 14,205 records

Result of customer enhancement: 14,205 records

Call customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 14,205 records

Result of customer enhancement: 14,205 records

Asynchronous send of data package 1 in task 0002 (1 parallel tasks)

IDOC: Info IDoc 2, IDoc No. 647096, Duration 00:00:00

IDoc: Start = 02/17/2009 06:19:22, End = 02/17/2009 06:19:22

Call customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 4986 records

Result of customer enhancement: 4986 records

Call customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 4986 records

Result of customer enhancement: 4986 records

It seems that R/3 itself is not passing the rest 9 records to User Exit.

Any ideas?

Thanks & BR,

Jain