piter197
Posts: 830
Joined: Sun Jan 09, 2011 3:32 am

Error updating beta Patch.v4 4.0.0.3814

Thu Feb 25, 2016 1:39 am

Hi Support,

I got error message when trying to update beta Patch.v4 4.0.0.3814 Could not install database packages: Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql'

Progress of the plugin deployment action stop at step 11/16.

From NMEA error log file message:

2016-02-25 04:10:19.9191 | Error | 37 | Module.Install | Error executing query. Error 1406: Failed to execute 'INSERT INTO script_app SELECT (click_id + 1) * (click_id + 2) / 2 + 1, application_id, CONCAT('App for click script ', name), CONCAT('App for click script ', name), NULL, NULL FROM click_script;' |
2016-02-25 04:10:19.9660 | Error | 37 | InstallDbPackagesOperation.Execute | Franson.Install.DB.ModuleExecutionException | Franson.Install.DB.ModuleExecutionException: Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql' ---> Franson.DAO.ExecuteDBException: Failed to execute 'INSERT INTO script_app SELECT (click_id + 1) * (click_id + 2) / 2 + 1, application_id, CONCAT('App for click script ', name), CONCAT('App for click script ', name), NULL, NULL FROM click_script;' ---> System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.43]Data too long for column 'name' at row 4
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.PackageManager.InstallPackages(String strPath)
at GpsGate.Deploy.Operation.InstallDbPackagesOperation.Execute(List`1 lstParameters)
2016-02-25 04:10:19.9660 | Error | 37 | InstallDbPackagesOperation.Execute | Could not install database packages on path D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages. Message:Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql' |
2016-02-25 04:10:19.9660 | Error | 37 | DeployOperationExecuter.m_LogSetErrorAndState | Error when executing async deploy package ID 30 deploy operation InstallDbPackages. Exception message: EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql'. |
2016-02-25 04:10:19.9816 | Error | 37 | ExecuteDeployOperationsCmdBase.PendingCommit | Deploy package installer device operation InstallDbPackages state for deploy package ID 30 was not Finished. Step: 11. State: Executing InstallDbPackages. |
2016-02-25 04:10:19.9816 | Error | 37 | ExecuteDeployOperationsCmdBase.PendingCommit | There was a deploy package installer device error EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql' for deploy package ID:30 step: 11 |
2016-02-25 04:10:19.9816 | Error | 37 | Queue.m_SendPending | Error executing command GpsGate._UpgradeDeployPackage OUT: Device:2 | GpsGate.Deploy.InstallerDeviceException: EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.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.m_SendPending(IQueueSender sender, Object oArgument, QueueItem item)

Please help, thank you.



Best Regards,
piter197

User avatar
Josip
Posts: 20
Joined: Tue Mar 11, 2014 2:30 pm
Location: Sweden

RE: Error updating beta Patch.v4 4.0.0.3814

Thu Feb 25, 2016 3:21 pm

New beta version of Patch.v4 plugin is available from beta.gpsgate.com repository. Updating to it should work ok now.


Regards,
Josip

GpsGate Support

piter197
Posts: 830
Joined: Sun Jan 09, 2011 3:32 am

RE: Error updating beta Patch.v4 4.0.0.3814

Thu Feb 25, 2016 5:53 pm

Hi Josip,

Thank you for quick response. Unfortunately it still not working. from SiteAdmin-Plugins page after succesful download I get error when installing: Could not install database packages: Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql'

From NMEA log file:
2016-02-25 21:35:21.1237 | Error | 22 | InstallDbPackagesOperation.Execute | Franson.Install.DB.ModuleExecutionException | Franson.Install.DB.ModuleExecutionException: Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql' ---> Franson.DAO.ExecuteDBException: Failed to execute 'CREATE TABLE script_app ( script_app_id INT NOT NULL AUTO_INCREMENT, application_id INT NOT NULL, name VARCHAR(300) NOT NULL, description TEXT NULL, run_as_user_id INT NULL, state LONGTEXT NULL, PRIMARY KEY (script_app_id), UNIQUE KEY IX_unique_script_app_appid_name (application_id, name) ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;' ---> System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.43]Specified key was too long; max key length is 767 bytes
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.PackageManager.InstallPackages(String strPath)
at GpsGate.Deploy.Operation.InstallDbPackagesOperation.Execute(List`1 lstParameters)
2016-02-25 21:35:21.1237 | Error | 22 | InstallDbPackagesOperation.Execute | Could not install database packages on path D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages. Message:Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql' |
2016-02-25 21:35:21.1237 | Error | 22 | DeployOperationExecuter.m_LogSetErrorAndState | Error when executing async deploy package ID 30 deploy operation InstallDbPackages. Exception message: EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql'. |
2016-02-25 21:35:21.1393 | Error | 22 | ExecuteDeployOperationsCmdBase.PendingCommit | Deploy package installer device operation InstallDbPackages state for deploy package ID 30 was not Finished. Step: 11. State: Executing InstallDbPackages. |
2016-02-25 21:35:21.1393 | Error | 22 | ExecuteDeployOperationsCmdBase.PendingCommit | There was a deploy package installer device error EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql' for deploy package ID:30 step: 11 |
2016-02-25 21:35:21.1550 | Error | 22 | Queue.m_SendPending | Error executing command GpsGate._UpgradeDeployPackage OUT: Device:2 | GpsGate.Deploy.InstallerDeviceException: EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.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.m_SendPending(IQueueSender sender, Object oArgument, QueueItem item)



Best Regards,
piter197

User avatar
Josip
Posts: 20
Joined: Tue Mar 11, 2014 2:30 pm
Location: Sweden

RE: Error updating beta Patch.v4 4.0.0.3814

Thu Feb 25, 2016 6:56 pm

Another beta version of Patch.v4 is available now. Please try again.


Regards,
Josip

GpsGate Support

piter197
Posts: 830
Joined: Sun Jan 09, 2011 3:32 am

RE: Error updating beta Patch.v4 4.0.0.3814

Sat Feb 27, 2016 5:42 am

I have try to update to Patch.v4 beta 4.0.0.3824 but still unsuccessful with error from NMEA error log file:

2016-02-27 09:33:25.9878 | Error | 18 | DAOFactory.StartRoundTrip | Thread already have a RoundTrip assigned. |
2016-02-27 09:33:26.4722 | Error | 3 | Module.Install | Error executing query. Error 1406: Failed to execute 'INSERT INTO script_app SELECT (click_id + 1) * (click_id + 2) / 2 + 1, application_id, CONCAT('App for click script ', name), CONCAT('App for click script ', name), NULL, NULL FROM click_script;' |
2016-02-27 09:33:26.4878 | Error | 3 | InstallDbPackagesOperation.Execute | Franson.Install.DB.ModuleExecutionException | Franson.Install.DB.ModuleExecutionException: Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql' ---> Franson.DAO.ExecuteDBException: Failed to execute 'INSERT INTO script_app SELECT (click_id + 1) * (click_id + 2) / 2 + 1, application_id, CONCAT('App for click script ', name), CONCAT('App for click script ', name), NULL, NULL FROM click_script;' ---> System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.43]Data too long for column 'name' at row 4
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.PackageManager.InstallPackages(String strPath)
at GpsGate.Deploy.Operation.InstallDbPackagesOperation.Execute(List`1 lstParameters)
2016-02-27 09:33:26.4878 | Error | 3 | InstallDbPackagesOperation.Execute | Could not install database packages on path D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages. Message:Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql' |
2016-02-27 09:33:26.4878 | Error | 3 | DeployOperationExecuter.m_LogSetErrorAndState | Error when executing async deploy package ID 30 deploy operation InstallDbPackages. Exception message: EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql'. |
2016-02-27 09:33:26.4878 | Error | 3 | ExecuteDeployOperationsCmdBase.PendingCommit | Deploy package installer device operation InstallDbPackages state for deploy package ID 30 was not Finished. Step: 11. State: Executing InstallDbPackages. |
2016-02-27 09:33:26.5035 | Error | 3 | ExecuteDeployOperationsCmdBase.PendingCommit | There was a deploy package installer device error EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.MySQL.sql' for deploy package ID:30 step: 11 |
2016-02-27 09:33:26.5035 | Error | 3 | Queue.m_SendPending | Error executing command GpsGate._UpgradeDeployPackage OUT: Device:2 | GpsGate.Deploy.InstallerDeviceException: EX_DEPLOY_OPERATION_INSTALL_DBPACKAGES#Error executing 'D:\GpsServer\Deploy\DeployPackages\com.GpsGate\Patch.v4\DbPackages\GpsGateServerModule_4.0.0.ZZR.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.m_SendPending(IQueueSender sender, Object oArgument, QueueItem item)


Best Regards,
piter197

piter197
Posts: 830
Joined: Sun Jan 09, 2011 3:32 am

RE: Error updating beta Patch.v4 4.0.0.3814

Sun Mar 20, 2016 2:07 am

Hello itmasgroup,

Checking your profile, you use our GPS link page (vt1.bumitrack.com) as your homepage, We do not like this! please remove it from your profile.



Best Regards,
piter197

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

RE: Error updating beta Patch.v4 4.0.0.3814

Sun Mar 20, 2016 9:49 am

We have now deleted the "itmasgroup" user.

Regards,
Johan

GpsGate Support

piter197
Posts: 830
Joined: Sun Jan 09, 2011 3:32 am

RE: Error updating beta Patch.v4 4.0.0.3814

Tue Mar 22, 2016 1:55 am

Thank you Johan, although this could not prevent them to create new user in this forum.

Best Regards,
piter197

rmgrac
Posts: 2
Joined: Thu Feb 09, 2017 2:47 am

Re: Error updating beta Patch.v4 4.0.0.3814

Thu Feb 09, 2017 2:49 am

Hi,

I just installed GPSGATE for enterprise trial however was not able to update Plugin name
Patch.v4.

Status
Server error There was an error during plugin deployment. Please click Continue.
Plugin name
Patch.v4
Status
Could not read block - no data! (position 0x006D4840)

I hope to seek for your help. Thank you.

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