on 05-19-2009 8:33 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There were problem with masterdata. Thanks guys for your kind help.
Regards,
Rishit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.