error restoring OpManager DB

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?