Sunday, 29 December 2013

Database Configuration For Reporting & Analysis Gets Fail

Step: 1
  • Stop all the services of EPM system.
Step: 2
  • Download and apply a service fix numbered: 13807599
  • The downloaded file extracted in the following location,
      • C:\Oracle\Middleware\EPMSystem11R1\OPatch
  • Extracted file name: 13807599
Step: 3

To apply the patch, enter the following command on (Start-->Run-->Cmd): 

      • opatch.bat apply C:\Oracle\Middleware\EPMSystem11R1\OPatch\13807599 -oh C:\Oracle\Middleware\EPMSystem11R1 –jre C:\Oracle\Middleware \jdk160_21

Step: 4
Download cleanup-ra-components-rule.xml and located in the following location,
      • C:\Oracle\Middleware\EPMSystem11R1\OPatch

Step: 5
  • Delete Existing R&A components using registry-cleanup.bat file located in following location,
      • C:\Oracle\Middleware\EPMSystem11R1\OPatch\13807599\files\common\config\
  • Navigate to the above location in cmd prompt and then execute the following command,
      • Registry-cleanup.bat -eoi C:\ORACLE\MIDDLEWARE\user_projects\epmsystem1 -rules     C:\Oracle\Middleware\EPMSystem11R1\OPatch\cleanup-ra-components-rule.xml
  • Restart the machine.
Step: 6
  • Run configtool, select all the R&A tasks and perform new configuration.
(Ref: Web Analysis - Reporting And Analysis Configuration with New Database Fails (Doc ID 1482499.1))    

No comments:

Post a Comment