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): 

Windows:

• 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\11.1.2.0
• 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.

Reference:
(Ref: Web Analysis - Reporting And Analysis Configuration with New Database Fails (Doc ID 1482499.1))