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.
BMC does not recommend, nor does it support database schema changes.
DB migration fails with error message ORA-39212
The following behaviors are observed: