When I try to update patch.v4 to version 4.0.0.5906 I get the following error:
There was an error during plugin deployment. Please click Continue.
Could not install database packages: Error executing 'C:\GpsGateServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZZI.MySQL.sql'
NMEA error:
Code: Select all
2018-11-28 03:10:05.4218 | Error | 25 | ActivityCache.FlushCache | Franson.DAO.BlockException | RoundTrip is denied database access. (Franson.DAO.BlockException) at Franson.DAO.DAOFactory.ResolveConnection() at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName) at Franson.DAO.DAOBase.Fill(String strSelect) at Franson.Directory.Activity.DAO.ActivityWriterDAOSQL.TryLoad(Int32 iSessionID, Int32 iApplicationID, InterfaceType interfaceType, Boolean bLive) at Franson.Directory.Activity.ActivityWriter.TryLoad(Key key, Boolean bLive) at Franson.Directory.Activity.ActivityWriter.LockLoadAndUpdate(Key key, Boolean bLive, DateTime dtTimestamp, ActivityOptions options) at Franson.Directory.Activity.ActivityCache.FlushCache(Object oSender) 2018-11-28 03:10:22.4558 | Error | 22 | Module.Install | Error executing query. Error 1062: Failed to execute 'ALTER TABLE msg_field_dictionary_entry ADD CONSTRAINT UC_dict_id_out_id UNIQUE (msg_field_dict_id, out_msg_field_id);' | 2018-11-28 03:10:22.4558 | Error | 22 | InstallDbPackagesOperation.Execute | Franson.Install.DB.ModuleExecutionException | Franson.Install.DB.ModuleExecutionException: Error executing 'C:\GpsGateServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZZI.MySQL.sql' ---> Franson.DAO.ExecuteDBException: Failed to execute 'ALTER TABLE msg_field_dictionary_entry ADD CONSTRAINT UC_dict_id_out_id UNIQUE (msg_field_dict_id, out_msg_field_id);' ---> System.Data.Odbc.OdbcException: ERROR [23000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.49]Duplicate entry '64-127' for key 'UC_dict_id_out_id' at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow) at Franson.DAO.DAOBase.ExecuteNonQuery(String strCommand) --- End of inner exception stack trace --- at Franson.DAO.DAOBase.ExecuteNonQuery(String strCommand) at Franson.Install.DB.Module.Install(Boolean bDoNotCreate) --- End of inner exception stack trace --- at Franson.Install.DB.Module.Install(Boolean bDoNotCreate) at Franson.Install.DB.Package.Install(Boolean bDoNotCreate) at Franson.Install.DB.Package.Install() at Franson.Install.DB.PackageManager.InstallPackages(String strPath) at GpsGate.Deploy.Operation.InstallDbPackagesOperation.Execute(List`1 lstParameters) 2018-11-28 03:10:22.4558 | Error | 22 | InstallDbPackagesOperation.Execute | Could not install database packages on path C:\GpsGateServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages. Message:Error executing 'C:\GpsGateServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZZI.MySQL.sql' | 2018-11-28 03:10:22.4558 | Error | 22 | DeployOperationExecuter.m_LogSetErrorAndState | Error when executing async deploy package ID 94 deploy operation InstallDbPackages. Exception message: EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'C:\GpsGateServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZZI.MySQL.sql'. | 2018-11-28 03:10:22.4558 | Error | 22 | ExecuteDeployOperationsCmdBase.PendingCommit | Deploy package installer device operation InstallDbPackages state for deploy package ID 94 was not Finished. Step: 11. State: Executing InstallDbPackages. | 2018-11-28 03:10:22.4558 | Error | 22 | ExecuteDeployOperationsCmdBase.PendingCommit | There was a deploy package installer device error EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'C:\GpsGateServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZZI.MySQL.sql' for deploy package ID:94 step: 11 | 2018-11-28 03:10:22.4558 | Error | 22 | Queue._SendPending | Error executing command GpsGate._UpgradeDeployPackage OUT: Device:1 | GpsGate.Deploy.InstallerDeviceException: EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'C:\GpsGateServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZZI.MySQL.sql' at GpsGate.Deploy.Command.ExecuteDeployOperationsCmdBase.PendingCommit(Object oDeviceData, String strCustomState) at GpsGate.Online.Net.Protocol.ProcessPending(Queue queue, QueueItem item, Object oDeviceData) at Franson.Message.Queue._SendPending(IQueueSender sender, Object oArgument, QueueItem item)
Any help appreciated.