Export datasource extraction failure

[Former Member]

Hi,

I'm loading from cube to another using std export datasource. When querying the cube and using manage /content, the data is there, but when loading the 2nd cube, it says no data found. The selection criteria on the infopackage is only on calmonth. (This same criteria is used in query and manage/contents succesfully).

RSRV shows no errors with the data.

Can export datasources get corrupt?

[Former Member]

Hi Sue

Maybe the value of calmonth you provided in seletion is not correct. You can check this in RSA3 on BW side.Enter datasource name as 8<cubename> and check it out.

Also try this- replicate the export datasource in RSA1-> Infosources.In tcode SE38 execute program RS_TRANSTRU_ACTIVATE_ALL with infosource name as 8<cubename> and source system as your BW sytem. Then try loading the data again.

Regards

Pradip

[Former Member]

Hi Sue,

Check with Tcode RSA3 if the extractor is functioning without any selection. If you have data try to insert 0CLAMONTH value in different way: 200602 - 022006 - 2006.02 - 02.2006, generally it is a problem of internal/external format of the time InfoObj selection.

The value is functioning has to be inserted in InfoPackage.

Ciao.

Riccardo.

[Former Member]

Re generate export datasource, activate agan transfer rule and try again.

Hope it helps.

Regards

[Former Member]

I've just loaded one contract successfully for 200603 (so its not the format of calmonth being the issue) but when trying to load one contract for 200604, it says no data found after very long time.

I know the data is there as I can query it and see it in manage / contents.

Message was edited by: Sue Hutton

[Former Member]

Hi Sue,

Check in SM50 during preview in RSA3 if it is looking for a view on Cube. Check also in ST22 if you have dump.

Maybe you have to apply notes: 862809 - 561961, regarding problems on the view created on E and F fact tables.

Ciao.

Riccardo.

[Former Member]

Hi Sue

I hope you are running infopackage in background mode. Check for any short dump in ST22.

Regards

Pradip

[Former Member]

This cube has successfully loaded this data before,can the view disappear?

No dumps in ST22

Will check the notes