5 Replies Latest reply: Feb 1, 2013 2:30 AM by 988323 RSS

    Object ID not created when adding new member

    988323
      Hi,
      I have 11 Dimension on my application, while i tried to add new member on user define dimension (Location) and on entity dimension. the object id is not created in repository.
      i'm using Hyperion Planning 11.1.1.1 what might be the cause and how to fix this?
      please help.

      Regards,
      Ika
        • 1. Re: Object ID not created when adding new member
          JohnGoodwin
          What is the exact error that is being generated in the logs?

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: Object ID not created when adding new member
            988323
            Hi John,

            this is the error that i've got.

            java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
            ORA-06512: at "APPS.XJM_UPLOAD_SD_PKG", line 494

                 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
                 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
                 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
                 at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)
                 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
                 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)
                 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3057)
                 at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(SnpSessTaskSql.java)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.treatTaskTrt(SnpSessTaskSqlS.java)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
                 at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
                 at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
                 at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java)
                 at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
                 at com.sunopsis.dwg.cmd.e.i(e.java)
                 at com.sunopsis.dwg.cmd.e.y(e.java)
                 at com.sunopsis.dwg.DwgJv.treatCmd(DwgJv.java)
                 at com.sunopsis.dwg.DwgJv.main(DwgJv.java)
                 at oracle.odi.Agent.main(Agent.java)
            /u01/oracle/TEST/apps/apps_st/appl/xxcust/12.0.0/bin/XXJM_UPLOAD_SDF
            Program exited with status 110

            after checking the object id for location and entity is not found.
            • 3. Re: Object ID not created when adding new member
              988323
              this is the query that I used

              SELECT object_id
              -- INTO hasil
              FROM hsp_object
              WHERE UPPER (object_name) = UPPER ('20-401-31700');

              Regards,
              Ika
              • 4. Re: Object ID not created when adding new member
                JohnGoodwin
                985320 wrote:
                java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
                ORA-06512: at "APPS.XJM_UPLOAD_SD_PKG", line 494
                This does not look a planning error to me, maybe you should log it with Oracle.

                Cheers

                John
                http://john-goodwin.blogspot.com/
                • 5. Re: Object ID not created when adding new member
                  988323
                  Thank u John,
                  I've got my issue resolved.