Database and data migration issues
The following topics apply to troubleshooting issues with database and data migration:
Database cleanup command does not workThe first attempt to delete some BMC Server Automation objects using
Delete cleanupDatabasemight fail. However, subsequent runs of
Delete cleanupDatabasedelete the objects.
Online database cleanup process hangs on SQL Server
When performing an online database cleanup on a SQL Server database, certain cleanup options cause the database cleanup process to go into an unresponsive state. For example, after running the BLCLI command
Delete cleanupHistoricalData, the BLCLI hangs. This issue occurs when the Compatibility Level setting of the SQL Server database is set to too low a version, that is, SQL Server 2005 or earlier — database versions that are no longer supported by BMC Server Automation.
Perform the following steps to reset the Compatibility Level setting of your SQL Server database:
- Through the Microsoft SQL Server Management Studio, find the name of your database in the list of databases.
- Right-click the database name and select Properties.
- In the Properties dialog box, select the Options page from the list of pages on the left.
- At the top of the Options page, check what value appears in the Compatibility level field. If the value in this field is too low (SQL Server 2005 or earlier), set it to SQL Server 2008 or later.
After adjusting the compatibility level, run the online database cleanup process once again.
Offline database cleanup fails to launch after an upgrade
After a BMC Server Automation upgrade, the dbm.exe or dbm.nsh file fails to launch the Database Maintenance Wizard for offline database cleanup.
- Navigate to the <InstallDir>\NSH\br\dbm-rcp\configuration directory.
For example, C:\Program Files\BMC Software\BladeLogic\NSH\br\dbm-rcp\configuration (on Windows) or /opt/bmc/bladelogic/NSH/br/dbm-rcp/configuration (on Linux or UNIX).
- From this directory, delete all files and subdirectories, except for the config.ini file.
- Run the dbm.exe or dbm.nsh file (in the <InstallDir>\NSH\br\dbm-rcp directory) again.
Offline database schema fails with a BLFILE error
Offline database clean up fails with the below error, if either the Snapshot module or the Audit module is selected individually for an offline database clean up.
alter table snapshot_blfile WITH CHECK add constraint FKX5_snapshot_blfile foreign key (blfile_id) references BLFILE(blfile_id)
Error Message - The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FKX5_snapshot_blfile".
Workaround: To avoid this issue, BMC recommends you to run clean up on the Snapshot and Audit modules together while executing the offline clean up.
BMC does not recommend, nor does it support database schema changes.
DB migration fails with error message ORA-39212
The following behaviors are observed: