Unable to execute the query :INSERT INTO NonMODeviceType SELECT DEVICETYPEID, 'VirtualDevice', 'HostSystem' FROM DevicePackage WHERE DEVICETYPE='VMware ESX/ESXi' Message Duplicate entry '1201' for key 1
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate
entry '1201' for key 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
at com.adventnet.me.opmanager.operations.server.DatabaseConfFile.executeQuery(DatabaseConfFile.java:231)
at com.adventnet.me.opmanager.operations.server.DatabaseConfFile.executeAsperOrder(DatabaseConfFile.java:141)
at com.adventnet.me.opmanager.operations.server.DatabaseMigration.updateChanges(DatabaseMigration.java:46)
at com.adventnet.me.opmanager.operations.server.OpmPostInvocation.install(OpmPostInvocation.java:101)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1406)
at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1238)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:289)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223)
at java.lang.Thread.run(Unknown Source)
Unable to execute the query :INSERT INTO NonMODeviceType SELECT DEVICETYPEID, 'VirtualDevice', 'VirtualMachine' FROM DevicePackage WHERE DEVICETYPE='VMware Virtual Machine' Message Duplicate entry '1202' for key 1
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate
entry '1202' for key 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
at com.adventnet.me.opmanager.operations.server.DatabaseConfFile.executeQuery(DatabaseConfFile.java:231)
at com.adventnet.me.opmanager.operations.server.DatabaseConfFile.executeAsperOrder(DatabaseConfFile.java:141)
at com.adventnet.me.opmanager.operations.server.DatabaseMigration.updateChanges(DatabaseMigration.java:46)
at com.adventnet.me.opmanager.operations.server.OpmPostInvocation.install(OpmPostInvocation.java:101)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1406)
at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1238)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:289)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223)
at java.lang.Thread.run(Unknown Source)
I killed the script and restarted opmanager. When I look to the version number it looks ok: