This discussion is archived
1 Reply Latest reply: Oct 23, 2012 6:56 AM by Vivek Chetiaparath RSS

EPM 11.1.2.1 HFM issue with Oracle Database 11g

890303 Newbie
Currently Being Moderated
Hi,
My environment : windows 2008 R2, Oracle database 11.1.0.7 and Oracle Client 11.2.0.x, EPM 11.1.2.1
I am trying to install HSS, Planning , Essbase, HFM, EPM, Calc Manager on one m/c with oracle Http.

Initially I have configured HSS & changed the services to start manually and post system machine reboot - I am able to connect to HSS. In the similar I have configured EPMA without interface tables, Essbase, Planning, Calc Manager. For each component after system reboot I am able to connect to their respective components.

When I configured HFM and when I restart my machine & start the HSS services, I received the below errors from HSS logs.

<Oct 20, 2012 2:17:55 PM PDT> <Error> <JDBC> <BEA-001112> <Test
"select count(*) from HSS_COMPONENT_TYPES" set up for pool
"EPMSystemRegistry" failed with exception:
"java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not
exist
".>
<Oct 20, 2012 2:19:55 PM PDT> <Error> <JDBC> <BEA-001112> <Test
"select count(*) from HSS_COMPONENT_TYPES" set up for pool
"EPMSystemRegistry" failed with exception:
"java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not
exist
".>
<Oct 20, 2012 2:21:55 PM PDT> <Error> <JDBC> <BEA-001112> <Test
"select count(*) from HSS_COMPONENT_TYPES" set up for pool
"EPMSystemRegistry" failed with exception:
"java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not
exist
".>
<Oct 20, 2012 2:23:55 PM PDT> <Error> <JDBC> <BEA-001112> <Test
"select count(*) from HSS_COMPONENT_TYPES" set up for pool
"EPMSystemRegistry" failed with exception:
"java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not
exist

I have configured HSS, essbase, planning, calc ma, epma to single oracle db schema. Whereas HFM to another schema.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points