3 Replies Latest reply: Dec 10, 2012 10:56 AM by 880996 RSS

    Reporting and Ananlysis framework config fail: configure with database fail

    781502
      Hi,

      I am configuring EPM 11.1.2.1 on Windows 2008 R2 64 bit on single machine with Oracle 11g as the RDBMS source.
      - Foundation - Configured successfully
      - Reporting and Analysis - "configure with Database" failing.
      - Rest of the components(Essbase ) was configured successfully( including configure with database)
      -Error in configtool.log is:

      [2012-11-28T16:44:56.754+05:30] [EPMCFG] [TRACE] [EPMCFG-01102] [oracle.EPMCFG] [tid: 48] [ecid: 0000Jh6iSJx1baIqyobe6G1GhV2F00000F,0] [SRC_CLASS: com.hyperion.cis.DBConfigurator] Execute SQL: ALTER TABLE OJB_DLIST_ENTRIES ADD CONSTRAINT OJB_DLIST_ENTRIES_PK PRIMARY KEY (ID)
      [2012-11-28T16:44:56.760+05:30] [EPMCFG] [ERROR] [EPMCFG-01102] [oracle.EPMCFG] [tid: 48] [ecid: 0000Jh6iSJx1baIqyobe6G1GhV2F00000F,0] [SRC_CLASS: com.hyperion.cis.DBConfigurator] Execute SQL: SQLException: java.sql.sqlsyntaxerrorexception: ora-02260: table can have only one primary key[[

      There are multiple such errors.

      Has anybody seen such error before?
      Please suggest

      thanks,
      Ankit