1. Perform the below steps on the Target Machine (new),before loading RPD&Catalog on BIservers (CAUTION:Please note this has to be done before loading on BIServers. Loading could corrupt the catalog and take away permissions assigned on objects)
2. Get the RPD&Catalog to target Machine. Make sure the BI Servers are down
3. Add/Update the below in instanceconfig.xml
3. Add/Update the below in instanceconfig.xml
<Catalog>
<UpgradeAndExit>false</UpgradeAndExit>
<Validate>OnStartup</Validate>
<ValidateItems>None</ValidateItems>
<ValidateLinks>None</ValidateLinks>
<ValidateAccounts>Clean</ValidateAccounts>
<ValidateHomes>None</ValidateHomes>
<UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>
</Catalog>
4. Add the below in NQSConfig
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;
5. Save both files
6. Open EM and load RPD and Catalog. Click Apply and Click Activate Changes. Don’t restart from EM
7. Go to Command line and using opmnctl restart the servers
->opmnctl startall
Wait for ~5 minutes. (This time is needed to start all the servers. Later the Presentation server will be stopped automatically)
->opmnctl stopall
8. Once the servers are down, UNDO the changes done in both config files. Start the servers again
->opmnctl startall
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;
5. Save both files
6. Open EM and load RPD and Catalog. Click Apply and Click Activate Changes. Don’t restart from EM
7. Go to Command line and using opmnctl restart the servers
->opmnctl startall
Wait for ~5 minutes. (This time is needed to start all the servers. Later the Presentation server will be stopped automatically)
->opmnctl stopall
8. Once the servers are down, UNDO the changes done in both config files. Start the servers again
->opmnctl startall
You should not face any Authentication or access denied to ‘My Dashboard’ error
