Blog Details Page

  • Date: May 24, 2016
  • Article by: Joe Malewicki

 

  • Have you ever wondered if your Oracle EPM/Hyperion system is patched to date?
  • Did you know that Oracle releases a collection of security fixes for their products called “Critical Patch Updates” on the Tuesday closest to the 17th day of January, April, July and October?
  • Are you aware that Oracle Technical Support has the right to refuse assisting you on an issue if that issue has been addressed in a later Patch Set?
  • When was the last time your system was patched?

 

If these are questions that scare you, then give the experts at iArch Solutions a call.  For a limited time, we are offering you a FREE, no obligation (yes we said FREE) Patch Analysis of your mission critical Oracle EPM/Hyperion Financial System of software.

Let’s jump on a quick web conference and we will perform an analysis of your system.  We will let you know which patches are missing and should be considered for application so that your Oracle EPM system is able to be the most stable, secure and best performing environment possible.

You have nothing to lose, so give us a call (203-880-4268) and schedule your free Patch Analysis today!

 

We at iArch Solutions hope you found this blog helpful. Is there a question you want answered in a blog? Send us your questions, comments and feedback.

 

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: May 16, 2016
  • Article by: Robert Barrett

When recently trying to deploy Essbase Studio, I ran into an issue where it would not create the Windows service because the password for the Windows Services install account contained one or more unacceptable characters.

Here are the steps I performed to work around this issue.

Start by re-launching the Configuration tool on the Essbase server.  This time be sure to choose “Configure Common Settings.”  Then click “Next.”

Pic1a

Deselect the “Run Windows Services as non-local system account” option. Then click “Next.”

Pic1

Now follow through the rest of the process of configuring Essbase Studio.  As you have already tried to configure Essbase Studio once, you will encounter the option to either “Drop and re-create Tables” or “Reuse existing database.”  I would choose to “Reuse the existing database.”  Click “OK” and then “Next.”

Pic2

Now continue with your configuration.  When you have completed the process, if you look at your deployed services, you will find that Essbase Studio has been deployed.  Please note, that it has configured to run as the “local system” account.

Pic3

It is important to go back to you services screen now and change the Essbase Studio settings manually.  So, right click on Essbase Studio and click on “Properties.”

Pic8

Select the “Log on” tab.  Input the correct windows account information and select “Apply.”  When you go back to your services screen, you will find that the Essbase Studio Service is no longer a local system service.  It will now be the windows service account that you previously input.

Pic6

The next step is to run the configuration tool again, this time, only select “Configure Common Settings.”

Pic4

Select to “Run Windows Services as non-local system account.”  Input the right domainusername and Password.  Then click “Next.”

Pic5

And now finish the rest of the steps in the configuration process.

We at iArch Solutions hope you found this blog helpful. Is there a question you want answered in a blog? Send us your questions, comments and feedback.

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: May 4, 2016
  • Article by: Joe Malewicki

After applying Analytics Provider Services Patch Set Update (PSU) 11.1.2.4.006 we can no longer perform an adhoc analysis to an Essbase application.  The following error is thrown inside of Microsoft Excel with the Smart View add-in:

Error:

—————————

Oracle Smart View for Office

—————————

com/essbase/services/olap/grid/EssGGridOption.setOptionSingleMbrPov(Ljava/lang/Boolean;)V

—————————

OK

—————————

Screen Shot of Error:

Pic1

 

To confirm if there is an issue with the Provider Services (APS) patch you can run a test to confirm the version details for the Provider Services JAPI:

http://:13080/aps/Test

The version of Analytic Provider Services should match the JAPI version.  Our test showed a discrepancy:

Analytic Provider Services – Release 11.1.2.4.006.003 , JAPI 11.1.2.3.4408

Pic2

This issue is being caused by the ess_japi.jar file being a “Read-Only” file. When the new patch was applied it could not update this file.

 

To correct the issue, use the following procedure:

 

Shut down ALL Oracle EPM/Hyperion services or processes.  If you don’t have a system wide stop/start script, check out our earlier post on creating this such item!  How To Create Microsoft Windows EPM/Hyperion Start and Stop Scripts

Once all services are down, locate and change the file system properties at the EssbaseJavaAPI folder level, right-click and deselect “Read-Only.”

Pic3

De-select “Read-only” and click “Apply.”

Pic4

Click “OK”

Pic5

Click “OK”

Pic6

Open an Administrator Windows command prompt (cmd.exe using right-click “Run as Administrator”).

Then you want to rollback the Analytic Provider Services (APS) Patch: 11.1.2.4.006:

For example:

opatch.bat rollback -id 22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jdk F:OracleMiddlewarejdk160_35

Type “y” when prompted and press <enter>.

Pic8

Pic9

This would be an appropriate time to go back and confirm that the ess_japi.jar is no longer set to “Read-Only.”  If it is, re-apply the same steps noted above for changing the parent folder and all sub folders/items to be “non-read only.”

Open an Administrator Windows command prompt (cmd.exe using right-click “Run as Administrator”).

Re-apply the Analytic Provider Services (APS) Patch 11.1.2.4.006:

opatch.bat apply F:OracleMiddlewareEPMSystem11R1OPatch22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jre F:OracleMiddlewarejdk160_35

Pic10

Type “y” and press <enter>.

Pic11

Pic12

Delete all of the contents of the tmp and cache directories for the APS server(s) under the WebLogic Domain.  Do NOT remove the tmp and cache folders themselves, just delete the contents.

Sample locations:

F:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0tmp

F:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0cache

Restart All Oracle EPM/Hyperion System services.

***NOTE***

The above procedures should be performed on ALL servers which are hosting Analytics Provider Services (APS) within the affected Oracle EPM /Hyperion System environment(s).

Test your Analytics Provider Services (APS) URL again:

http://:13080/aps/Test

The version of Analytic Provider Services should now match the JAPI version.

Analytic Provider Services – Release 11.1.2.4.006.003 , JAPI 11.1.2.4.006.003

Pic13

Re-test the Smart View connection and perform an adhoc connection to an Essbase application.  The error should no longer be present and the query should work.

Pic14

 

 

We at iArch Solutions hope you found this blog helpful. Is there a question you want answered in a blog? Send us your questions, comments and feedback.

 

APPLICABLE VERSIONS: 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4

 

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More