11.1.2.1 Planning RMI issues
Hey everyone. I'm having trouble with a new 11.1.2.1 Planning install; OS is Win 2008 R2 64-bit (DB is SQL 2008, standard built-in Weblogic 10). Standard set of components: Foundation / Reporting bits, Essbase, Planning, FDM; no SSL, SOA, any weirdness. Very vanilla.
The environment is fully built and running, and by and large seems to be operating as expected; I've built a test Planning application, loaded test data into Essbase, built several test reports, etc. I was making some test business rules, when I noticed that I can't seem to get a business rule to validate or launch against my test Planning application. Rules work normally against Essbase.
I bounced the various related services (EAS, RMI, Planning), and restarted them; EAS first, made sure 10080 is listening on the EAS box, then the RMI; made sure that 11333 is l... hmm. Weird, the Planning RMI service is running, but port 11333 on the Planning box isn't listening. I checked the PID of the RMI process (HyperionJavaService.exe *32), and ran a netstat -ano | findstr <PID>, and sure enough, while the RMI service appears to be running, it doesn't actually have any TCP ports open. Planning in this environment has had two patches applied (12573756 and 12432741); like an idiot, I neglected to test the Planning / Business Rules functionality before applying those patches, so I don't know if the RMI was actually working before they were applied. As the RMI appears to call only two jar files - C:\Oracle\Middleware\EPMSystem11R1\common\RMI\11.1.2.0\HyperionRMI.jar and C:\Oracle\Middleware\EPMSystem11R1\products\Planning\lib\HspJS.jar, the latter of which is replaced by patch 12573756, I rolled the two patches back, restarted the relevant services, with the same results (RMI running, no port listening). The parameters for the Windows service for the RMI registry under HKLM\SYSTEM\CurrentControlSet\services\Hyperion RMI Registry\Parameters imply that the RMI should be creating some log files (C:\Oracle\Middleware\EPMSystem11R1\diagnostics\logs\HyperionRMIRegistryStdErr/StdOut.log). These log files do not exist; I'm not sure at this point if that's because the java process that HyperionJavaService.exe is trying to invoke isn't working correctly, or if it's because I don't have a logging level option set.
My questions:
1: How can I enable logging for the RMI registry?
2: Has anyone had any similar RMI issues with Planning 11.1.2.1 / Server 08 R2 x64? If so, how did you fix them?
TL;DR: HBR doesn't seem to be talking to Planning due, apparently, to the Planning RMI registry not working. The Windows service reports that it is started, but no TCP ports are opened nor does 11333 start listening.
My apologies if I've missed somethng very silly; this is my first 11.1.2.anything install, and I'm still getting used to how the new version works. I'm very familiar with 11.1.1.3, but that doesn't mean much with 11.1.2 it seems! =(
Thank you so very much, everyone (and probably especially you, JohnGoodwin!)
Edited by: Dr. Bloodmoney on Jul 8, 2011 1:27 AM