Collation error in opmanager v10000
Situation :
I have a prod server which is installed opmanager v10000 (but was upgraded from version 6 to 7, 8, 9 and 10)
I have another dev server which is installed v9 then upgraded 10.
Both are with MySQL database installed, in english language, but I used to put some field with accent. To test new SP I used to backup the prod DB and restore it on the dev server. since a while,... i'm NOT able to restore my full database or configdata backup to my dev server, because I always get an error concerning field in table which are written with accent :
[05-31-2013]|[13:20:36:520]|[FINE] : Restoring table CriteriaOptions
[05-31-2013]|[13:20:36:629]|[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 'CriteriaOptions' :
Incorrect string value: '\x93leur ...' for column 'ALARMCODE' at row 935.
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 'CriteriaOptions' :
Incorrect string value: '\x93leur ...' for column 'ALARMCODE' at row 935.
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)
I dont understand why....
I dont want to install the standalone setup in french.... Would like to keep the application in english,... but I have issue to restore the DB
could it be possible to give some help ?
Franckym
I have a prod server which is installed opmanager v10000 (but was upgraded from version 6 to 7, 8, 9 and 10)
I have another dev server which is installed v9 then upgraded 10.
Both are with MySQL database installed, in english language, but I used to put some field with accent. To test new SP I used to backup the prod DB and restore it on the dev server. since a while,... i'm NOT able to restore my full database or configdata backup to my dev server, because I always get an error concerning field in table which are written with accent :
[05-31-2013]|[13:20:36:520]|[FINE] : Restoring table CriteriaOptions
[05-31-2013]|[13:20:36:629]|[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 'CriteriaOptions' :
Incorrect string value: '\x93leur ...' for column 'ALARMCODE' at row 935.
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 'CriteriaOptions' :
Incorrect string value: '\x93leur ...' for column 'ALARMCODE' at row 935.
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)
I dont understand why....
I dont want to install the standalone setup in french.... Would like to keep the application in english,... but I have issue to restore the DB
could it be possible to give some help ?
Franckym