When we performed the migration to 11.1.2.3 since it was a new install some of the reports failed with the error "Error executing query:-1" .In addition to this a lot of the missing values were also being generated as a result. To resolve this issue, We had applied a fix in the previous environment as this issue seemed to exist there as well. We found out that this was due to the MDX query setting on FR Server and it was set to the default 'True' value. To carry out the same, follow the steps below.
1. Navigate to C:\Oracle\Middleware\EPMSystem11R1\products\financialreporting\bin and launch FRConfig.cmd
In some instances, this utility doesn't open and throws a java error. To fix that, follow step 2 below.
2. Edit setInstance.cmd and add the
set EPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1
3. Now, it opens the FRConfig.cmd. In the MBeans tab, expand the Financial Reporting tab and scroll to the EssbaseUseMDX setting.
4. Restart FR services. This should fix the issue.
I had found that on a parallel environment since it had loopback adapters present for the VIP, It did not work out for me. In that case, launch the enterprise manager module and correct it from there.Click on System MBean Browser.
Navigate to the Application MBeans
Also a side note, PreviewUserPOV can be set to True, so that end users don't have to set their FR Preferences to On. We can make the change on FRStudio.cmd
No comments:
Post a Comment