Friday, February 4, 2011

Hyperion Planning : An Error Occurred. (Tomcat)

After reinstalling Hyperion Planning 4.0.2, I met the most funky error message ever generated.  It says : "An Error Occurred.".  That's it..  No other description or details.  At first it only happened when I opened a large form, but soon after any other form generated the same error message.  I tried restarting the planning application server (through Tomcat) and it got it working, but soon it generated the same error message.

The problem is located on the JVM.  You might want to increase the -Xms & Xmx.  

Edit : \Hyperion\HyperionPlanning\Deployment\Tomcat\4.1.30\startup.bat using your text editor.

Update the following line :

set JAVA_OPTS = -server

to

set JAVA_OPTS=-server -Xms512m -Xmx1024m

You can change the 512m / 1024m as you see fit.  A great description of Xms & Xmx and it's best size for your system could be found here.

Thursday, January 20, 2011

Oracle Database Installation Notes (Loopback Adapter)

I found out that after installing Oracle Database 10g on a VM machine and restarting the machine, the database service won't start.  A colleague of mine determine that my problem is located on me not installing a Loopback Adapter prior installing the Oracle Database.  According to an Oracle Documentation, prior to installing Oracle Database you may need to determine whether or not you will need a loopback adapter installed.  I also found out that after installing the loopback adapter and then reinstalling the Oracle Database, the installation warning regarding network configuration management is gone.
A loopback adapter is required if:
  • You are installing on a DHCP computer, or
  • You are installing on a non-networked computer and plan to connect the computer to a network after installation.
I also found a good tutorial on how to install a Loopback Adapter here