rsa3 no data, but the delta is working..

[Former Member]

Hi gurus,

Need to check any reason why ..this is from PRD ,

When I did check rsa3,

2LIS_11_V_SCL

2LIS_11_VASCL   

all this datasource do not have data.. return 0 records,

but in the loading  in DSO, the delta working fine,,, everyday have new delta in the DSO,

any reason behide this situation.

Rgds

Edi.

[RamanKorrapati · Accepted solution]

Hi,

RSA3 - Always pulls data from set up tables incase of LO data sources. Before checking at RSA3, have you deleted and filled setup tables?

RSA3 you may used Full update mode.

Delta - its based on V3 update method LBWE records will be moved RSA7 and later thru delta info pack those pulled into bw.

Thanks

[Former Member]

Thanks guys for reply , all have given helping answer for my curiosity

[Former Member]

I did check from lbwe, it using direct delta..

might be coz of this reason, need to read what direct delta is mean...

[former_member220624]

Hi Edi,

Since it uses direct delta,with each posting in R3 system the record is directly sent to the delta queue in the form of a LUW (rsa7)

The data won't be available in RSA3.

If due to some reasons you decide to fill the set up table then only that data will be visible in RSA3.

Regards,

Amit

[Former Member]

Hi Edi,

You cannot able to see delta records by using RSA3 update mode is 'D', because delta you can check at RSA7. RSA3 get data from setup tables only, so delta records wont go to setup tables in case of LO.

Thanks,

Somesh.

[Former Member]

Hi Edi,

As Raman said, the LO extractors pull data from setup tables when you try from RSA3. So to get any data in RSA3 for LO extractors you will have to fill up the setup tables.

You can check the entries for app 11 in SE38 by running program RMCEX_SETUP_ENTRIES. If there are no entries in setup table for app 11 you will not see any data in RSA3 for these datasoures.

Moreover, when these datasources pull a delta data then these go for delta queues instead of setup tables to extract data. Delta queues are filled from extraction queues by running V3 programs if its a queued delta update.

If you don't want to fill the setup tables then you can check data in RSA3 for deltas too as delta test is possible for these datasources. don't forget to mention the 'Target' in RSA3 while testing for update mode = 'D'.

Thanks

Amit