2 Replies Latest reply: Apr 23, 2009 3:56 PM by 661363 RSS

    Integra upgrade from 5.1 to 5.1.3

    661363
      Hi,

      We are currently in 5.1 and upgradinig to 5.1.3. But the installer failed with theh below error message

      Merging the APSI Apps Metadata.....

      Critical step failed. Step 30 : failed with RC=1 , Error Text =
      pgmprocessor : Error returned from external program
      return code =1



      We are having the below error message in the log file of "Merging the Metadata in Integra Home .."

      ===============================================================================
      Source Table Prefix : APS1
      Destination Table Prefix : TICK
      ===============================================================================
      Merging the Table :: APS1_META_APPLICATIONS
      DELETE FROM TICK_META_APPLICATIONS A WHERE EXISTS ( SELECT 1 FROM
      APS1_META_APPLICATIONS B WHERE A.META_APPLICATION_ID = B.META_APPLICATION_ID )
      INSERT INTO TICK_META_APPLICATIONS SELECT * FROM APS1_META_APPLICATIONS
      Merging the Table :: APS1_META_APPLICATIONS_OBJECTS
      DELETE FROM TICK_META_APPLICATIONS_OBJECTS A WHERE EXISTS ( SELECT 1 FROM
      APS1_META_APPLICATIONS_OBJECTS B WHERE NVL(A.META_APPLICATION_ID,'1') =
      NVL(B.META_APPLICATION_ID,'1') AND NVL(A.META_OBJECT_ID,'1') =
      NVL(B.META_OBJECT_ID,'1') )
      INSERT INTO TICK_META_APPLICATIONS_OBJECTS SELECT * FROM
      APS1_META_APPLICATIONS_OBJECTS
      Error : APS1_META_APPLICATIONS_OBJECTS - NO INDEXES FOUND ON THE TABLE
      DECLARE
      *
      ERROR at line 1:
      ORA-20011: Failed due to lack of Indexes on this table ::
      APS1_META_APPLICATIONS_OBJECTS
      ORA-06512: at line 238


      Please advice

      Thanks & Regards,
      Rakesh