1 Reply Latest reply: Oct 23, 2012 8:56 AM by Vivek Chetiaparath RSS

    EPM 11.1.2.1 HFM issue with Oracle Database 11g

    890303
      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.