error restoring OpManager DB
Hi team !
I tried many time to restore a Production DB to a dev server and everytime i have an error :
[05-30-2013]|[14:11:12:085]|[SEVERE] :
jdbc.RestoreException: Error occurred while Restoring Data.
at jdbc.RestoreDB.readFileAndRestoreData(RestoreDB.java:146)
at jdbc.AbstractRestoreDB.restoreDB(AbstractRestoreDB.java:97)
at jdbc.AbstractRestoreDB.doRestore(AbstractRestoreDB.java:416)
at jdbc.RestoreBackup.restoreDB(RestoreBackup.java:81)
at com.adventnet.me.opmanager.dbmanager.DataMaintenance$BackupRestoreWindow$RestoreRunThread.run(DataMaintenance.java:704)
Caused by: java.util.concurrent.ExecutionException: java.lang.Exception: Restore failed for table 'CustomFieldsForDevices' :
Incorrect string value: '\xE9e' for column 'UDF2' at row 9.
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at jdbc.RestoreDB.readFileAndRestoreData(RestoreDB.java:137)
... 4 more
Caused by: java.lang.Exception: Restore failed for table 'CustomFieldsForDevices' :
Incorrect string value: '\xE9e' for column 'UDF2' at row 9.
at jdbc.RestoreDB$RestoreData.restoreUsingLoadDataQuery(RestoreDB.java:229)
at jdbc.RestoreDB$RestoreDataThread.call(RestoreDB.java:192)
at jdbc.RestoreDB$RestoreDataThread.call(RestoreDB.java:156)
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)
The 2 servers are on the same level regarding OpManager (v10000) and i just would like to restore the Prod DB on the DEV server to test the new version v10100....
Thanks in advance for your help
New to ADSelfService Plus?