3 Replies Latest reply on Aug 15, 2013 1:49 PM by Adam Khan

    Migration Halted from 7.6 to 8.3

    Adam Khan

      I am migrating from Bladelogic 7.6 to 8.3 and across this error. Please help!!!!

       

      Database info:

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      PL/SQL Release 11.2.0.3.0 - Production

      CORE    11.2.0.3.0    Production

      TNS for Linux: Version 11.2.0.3.0 - Production

      NLSRTL Version 11.2.0.3.0 - Production

       

      Error:

      DB_DIAGNOSIS_8310    SQLScript    END    08/14/2013 16:11:13    Failed    Migration halted. SQL Script had error in section begining: SQL(CREATE OR REPLACE PROCEDURE dbd_log_xcutn_start
      (
        p_dx_id                IN dbd_diagnosis_xcutn.dx_id%TYPE,
        p_spd_diagnosis_name   IN dbd_specific_diagnosis_sp.spd_diagnosis_name%TY

       

      blmigration log:

      14 Aug 2013 15:43:17,826] [Thread-15] [INFO] [::] [] EXCEPTION WHILE RUNNING SINGLE STEP MIGRATION FROM 7.6.0,7.7.0 TO 8.0.0
      ============================================================================================
      [1] ERROR: TSK NM=SQLScript  ; TSK SCR NM=    ; TO=8.0.0  ; TSK MSG=Migration halted. SQL Script had error in section begining: SQL(CREATE OR REPLACE PROCEDURE dbd_log_xcutn_start
      (
        p_dx_id                IN dbd_diagnosis_xcutn.dx_id%TYPE,
        p_spd_diagnosis_name   IN dbd_specific_diagnosis_sp.spd_diagnosis_name%TY 
      .
      .
      ****** FINISHED ****** SINGLE STEP MIGRATION FROM 7.6.0,7.7.0 TO 8.0.0
      FROM CONFIG FILE C:\BladeLogic\83-external-files\bl_8.3.00\db_scripts\oracle\upgrade\7.6.0_to_8.0.0\OM\Migration_actions\
      WITH **1** ERRORS
      .
      .
      [14 Aug 2013 15:43:17,902] [Thread-15] [INFO] [::] []
      ============================================================================================
      DISPLAYING ALL THE ERRORS
      ============================================================================================

       

      [14 Aug 2013 15:43:17,904] [Thread-15] [INFO] [::] [] [1] SingleStepMigrationResult: TSK NM=SQLScript  ; TSK SCR NM=    ; TO=8.0.0  ; TSK MSG=Migration halted. SQL Script had error in section begining: SQL(CREATE OR REPLACE PROCEDURE dbd_log_xcutn_start
      (
        p_dx_id                IN dbd_diagnosis_xcutn.dx_id%TYPE,
        p_spd_diagnosis_name   IN dbd_specific_diagnosis_sp.spd_diagnosis_name%TY

       

      [14 Aug 2013 15:43:17,905] [Thread-15] [INFO] [::] [] Any error=true;; Framework error=false;; Data error=true

       

      [14 Aug 2013 15:43:17,907] [Thread-15] [INFO] [::] []
      ============================================================================================

       

      [14 Aug 2013 15:43:17,908] [Thread-15] [INFO] [::] [] MIGRATION FRAMEWORK WAS SUCCESSFUL
      [14 Aug 2013 15:43:17,909] [Thread-15] [INFO] [::] [] DATA MIGRATION WAS NOT SUCCESSFUL AND DID NOT FINISH BECAUSE THERE WAS AN ERROR
      [14 Aug 2013 15:43:17,909] [Thread-15] [INFO] [::] [] Total time: 0 minutes 18 second(s)
      [14 Aug 2013 15:43:17,909] [Thread-15] [INFO] [::] []
      ============================================================================================

       

      [14 Aug 2013 15:43:18,227] [Thread-15] [INFO] [::] [] Seconds waited for client/UI to return=1(1350 ms)
      [14 Aug 2013 15:43:18,399] [MigDataChangedThread1376509379] [INFO] [::] [] Exiting data notification thread, anyListenersLeft=false; anyExceptions=false; wasDataChanged=false