DB Migration from MySQL to MSSQL
Hi All,
I migrated my opmanager (11200) from MySQL to MSSQL.
During the last step, when restoring the DB, it does not complete the tables (stops on lets say last 20 tables) and I had the following error: (now opmanager is on MSSQL and working fine, but I am afraid that some important data was not restored because of the below)
[04-25-2016]|[14:45:35:728]|[SEVERE] :
jdbc.RestoreException: Error occurred while Restoring Data.
at jdbc.RestoreDB.readFileAndRestoreData(RestoreDB.java:151)
at jdbc.AbstractRestoreDB.restoreDB(AbstractRestoreDB.java:99)
at jdbc.AbstractRestoreDB.doRestore(AbstractRestoreDB.java:423)
at jdbc.RestoreBackup.restoreDB(RestoreBackup.java:81)
at jdbc.RestoreBackup.main(RestoreBackup.java:203)
Caused by: java.util.concurrent.ExecutionException: java.lang.Exception: Restore failed for table 'ElementAvailabilityDaily2016_04_02_24' :
Starting copy...
10000 rows sent to SQL Server. Total sent: 10000
SQLState = 37000, NativeError = 9002
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]The transaction log for database 'OpManagerDB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
BCP copy in failed.
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at jdbc.RestoreDB.readFileAndRestoreData(RestoreDB.java:142)
... 4 more
Caused by: java.lang.Exception: Restore failed for table 'ElementAvailabilityDaily2016_04_02_24' :
Starting copy...
10000 rows sent to SQL Server. Total sent: 10000
SQLState = 37000, NativeError = 9002
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]The transaction log for database 'OpManagerDB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
BCP copy in failed.
at jdbc.RestoreDB$RestoreData.restoreUsingBcpCmd(RestoreDB.java:318)
at jdbc.RestoreDB$RestoreDataThread.call(RestoreDB.java:193)
at jdbc.RestoreDB$RestoreDataThread.call(RestoreDB.java:161)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
[04-25-2016]|[14:45:35:728]|[FINE] : Deleting temporary files if exists ...
[04-25-2016]|[14:45:42:135]|[FINE] : temp files deleted successfully.
[04-25-2016]|[14:45:42:135]|[FINE] : Restore finished at : 04-25-2016 at 14:45:42:135
[04-25-2016]|[14:45:42:135]|[FINE] : ******************* Restore DB Completed ***********************
Please advice ???