Skip to Content
Information
Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Database and data migration issues

The following topics apply to troubleshooting issues with database and data migration:

 Database cleanup command does not work

The first attempt to delete some BMC Server Automation objects using Delete cleanupDatabase might fail. However, subsequent runs of Delete cleanupDatabase delete the objects.

 Data Migration Manager upgrades fail

When you launch upgrades from the Data Migration Manager console, the console must remain open and connected to the upgrade process until the process completes. The upgrade process fails if:

  • You close the console — Do not close the console.
  • The session times out — If you are running the upgrade using a remote console, disable session timeouts before launching the Data Migration Manager.
  • The session loses connection to the upgrade process for any reason — Check network connections.

Schema changes

BMC does not recommend, nor does it support database schema changes.

DB migration fails with error message ORA-39212

Observed behavior

 The following behaviors are observed:

  • Database migration fails.
  • The ORA-39212 exception is thrown.
  • The following code is observed in the blmigration.log: 

 

2015-01-28 23:35:17,534 [Thread-62 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO com.bladelogic.mig.framework.singlestepmigration.SingleStepMigrationResult  - [1] SingleStepMigrationResult: TSK NM=mig_chng_contnts_tbl_98005  ; TSK SCR NM=    ; TO=8.6.00  ; TSK MSG=ORA-39212: installation error: XSL stylesheets not loaded correctly

ORA-06512: at "SYS.DBMS_METADATA", line 5088

ORA-06512: at "SYS.DBMS_METADATA", line 7589

ORA-06512: at line 1

ORA-06512: at "BLADELOGIC.LIB_DATA_DICT", line 237

[2] SingleStepMigrationResult: TSK NM=mig_chng_contnts_tbl_98005  ; TSK SCR NM=    ; TO=8.6.00  ; TSK MSG=Upgrade halted. mig_chng_contnts_tbl_98005 did not complete step change contents of table at point 0. Contact BladeLogic Support before resuming.

 

Cause

Oracle is not able to execute the Oracle-supplied package DBMS_METADATA, which loads the XSL stylesheet data in the Oracle data dictionary when it runs.

Workaround

Use the following procedure to resolve this issue: 

  1. Connect to the Oracle database with the following credentials:
    • User: SYS
    • Role: SYSDBA
  2. To reload the stylesheets, execute the following SQL command: SQL> exec dbms_metadata_util.load_stylesheets;
  3. Rerun the migration.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Server Automation 8.3