cancel
Showing results for 
Search instead for 
Did you mean: 

Data Loading Error in ODS(0FIAR_O03) from DTP

Former Member
0 Kudos

Hi All,

I have executed DTP to load data in ODS(0FIAR_O03). I got data in PSA.

While I am activating data in ODS, I am getting following errors:

1)Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER Message no. RSDRO302

2)Fiscal year variant HH not expected Message no. FGV001

3)Process 000046 returned with errors Message no. RSODSO_PROCESSING006

4)No SID found for value 'HH' of characteristic 0FISCVARNT Message no. BRAIN070

5)Process 000047 returned with errors Message no. RSODSO_PROCESSING006

6)Activation of M records from DataStore object 0FIAR_O03 terminated Message no. RSM1102

I don't know how to solve this errors. Please help me to solve this errors. I am new to BI.

Regards,

Rishit kamdar

Accepted Solutions (1)

Accepted Solutions (1)

mansi_dandavate
Active Contributor
0 Kudos

Hi,

Go to source system tab, right click onthe ECC Source system and click on transfer global settings. Select fiscal year variants and simulate.

Then try to load again.

Regards,

Mansi

Former Member
0 Kudos

Hi Mansi,

Thanks for your early reply.

I have done that but it show same erros.

Regards,

Rishit Kamdar

Former Member
0 Kudos

Hi,

well, simulate will not work, you need to update or reconstruct the tables.

Siggi

Former Member
0 Kudos

Hi Siggi,

Thanks for your reply.

How can i reconstruct the table? I am new to BI.

Regards,

Rishit kamdar

Former Member
0 Kudos

Hi Siggi,

Thanks for your reply.

How can i reconstruct the table? I am new to BI.

Regards,

Rishit kamdar

Former Member
0 Kudos

Hi All,

Is there any other help.

Please help me.

Regards,

Rishit kamdar

Answers (3)

Answers (3)

Former Member
0 Kudos

There were problem with masterdata. Thanks guys for your kind help.

Regards,

Rishit

Former Member
0 Kudos

HI,

SID error comes during activation of ODS because the related MD is not available for assigning SIDs.

Whenever Master Data is loaded SID's are generated for those Master Data records.

Now when you load Transaction Data these SID's will used (for the records which use above master data values). This results in performance gain.

If Transaction Data is loaded first than the system checks for SID's. If they are not available system generate SID's. This results in a loss of performance.

Now in the case if you don't have the setting selected (Further Processing Without Master Data/Always update data, even if no master data exists for the data) system will throw error No Sid?s found and load will terminate.

So as a first step ensure that the related master data is loaded and Attribute change run has been triggered.

OR

Load the MD and Activate the MD (Modeling > InfoObject > Search the Infoobject > Right click > Activate Master Data)

Once you perform this you can retrigger the activation. It should work fine.

OR

In the infopackage goto Update Tab and make the setting Update the records even if no master data exist and reload

--

rgds,

Edited by: Krishna Rao on May 19, 2009 4:01 PM

former_member208595
Active Participant
0 Kudos

Hi,

1. Check in your ECC(R/3)system whether fiscal year variant has been mantained or not by using tcode- OB29.You need to mantain in ECC system first.

2. After that do the settings in BW system-> RSA1> source system-> select your source system-> right click on that & select Transfer Global settings-> select fiscal year variant & execute

3. After that load your data & activate the DSO

Former Member
0 Kudos

Hi

To Ashish,

Thanks for your reply.

I have done. I have put marked in Fiscal Year Variant and Save it. But i am getting same errror.

To Siggi,

Thanks for your reply.

How can i reconstruct the table?

Regards,

Rishit kamdar

Regards,

Rishit Kamdar

former_member208595
Active Participant
0 Kudos

Hi,

. You loaded master data first or not? If not then load master data first, then transaction data