supcas
Posts: 1
Joined: Wed Nov 28, 2018 6:19 am

Error updating patch.v4 to Version 4.0.0.5906

Wed Nov 28, 2018 6:25 am

Hello,

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.

User avatar
johan
GpsGate
Posts: 14583
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

Re: Error updating patch.v4 to Version 4.0.0.5906

Wed Nov 28, 2018 2:49 pm

Please contact support for a solution.
Regards,
Johan

GpsGate Support

Return to “GpsGate Server - How to setup and use”