Inbox Reva
Posts: 28
Joined: Mon May 20, 2019 8:56 pm

Error updating database table tag_privileges_ob

Sun Aug 18, 2019 10:04 am

Hi
I get an error while synchronizing a custom application template

// An error occurred: Could not merge applications. Error updating database table tag_privileges_obj
See the error log for more details. (This error message will disappear within 2 minutes)

Error log displays

Code: Select all

2019-08-18 10:56:44.2971 | Error | 33 | TemplateImporter.Import | Error updating database table tag_privileges_obj | Error updating database table tag_privileges_obj (Franson.DAO.UpdateDBException)
   at Franson.DAO.DAOBase.Update()
   at Franson.DAO.DAOItem.Update()
   at Franson.Directory.DAO.TagWriterDAOSQL.Update()
   at Franson.Directory.Security.DAO.RoleTagWriterDAOSQL.Update()
   at Franson.DAO.BOItem.Update()
   at Franson.Directory.TagWriter.Update()
   at Franson.Directory.UserTagWriter.Update()
   at Franson.Directory.Security.RoleTagWriter.Update()
   at Franson.Templating.TemplateImporter.ImportObject(Guid templateGuid, Int32 iTemplateVersion, String strObjectType, XmlNode objectData, Guid parentGuid, Boolean bUpdate, Boolean bPartial, Boolean bHidden, Boolean bReadOnly, Boolean bIsClone)
   at Franson.Templating.TemplateImporter.Import(Stream stream, Guid parentGuid, Guid referenceGuid, Boolean bIsClone)
ERROR [23000] [MySQL][ODBC 5.3(w) Driver][mysqld-5.5.43]Duplicate entry '66-152-42' for key 'PRIMARY' (System.Data.Odbc.OdbcException)
   at Franson.DAO.DAOBase._Adapter_RowUpdated(Object sender, RowUpdatedEventArgs e)
   at System.Data.Odbc.OdbcDataAdapter.OnRowUpdated(RowUpdatedEventArgs value)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
   at Franson.DAO.DAOBase.Update()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
   at Franson.DAO.DAOBase.Update()

2019-08-18 10:56:44.3127 | Error | 33 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1062 | 
2019-08-18 10:56:44.3283 | Error | 33 | MergeApplicationCmdExe.Commit | Could not merge applications. Error updating database table tag_privileges_obj | Error updating database table tag_privileges_obj (Franson.DAO.UpdateDBException)
   at Franson.DAO.DAOBase.Update()
   at Franson.DAO.DAOItem.Update()
   at Franson.Directory.DAO.TagWriterDAOSQL.Update()
   at Franson.Directory.Security.DAO.RoleTagWriterDAOSQL.Update()
   at Franson.DAO.BOItem.Update()
   at Franson.Directory.TagWriter.Update()
   at Franson.Directory.UserTagWriter.Update()
   at Franson.Directory.Security.RoleTagWriter.Update()
   at Franson.Templating.TemplateImporter.ImportObject(Guid templateGuid, Int32 iTemplateVersion, String strObjectType, XmlNode objectData, Guid parentGuid, Boolean bUpdate, Boolean bPartial, Boolean bHidden, Boolean bReadOnly, Boolean bIsClone)
   at Franson.Templating.TemplateImporter.Import(Stream stream, Guid parentGuid, Guid referenceGuid, Boolean bIsClone)
   at Franson.Templating.TemplateManager.Merge(BOItem templateItem, BOItem targetItem, Guid referenceGuid, Boolean bLogging)
   at GpsGate.Online.Directory.Command.MergeApplicationCmdExe.Commit()
ERROR [23000] [MySQL][ODBC 5.3(w) Driver][mysqld-5.5.43]Duplicate entry '66-152-42' for key 'PRIMARY' (System.Data.Odbc.OdbcException)
   at Franson.DAO.DAOBase._Adapter_RowUpdated(Object sender, RowUpdatedEventArgs e)
   at System.Data.Odbc.OdbcDataAdapter.OnRowUpdated(RowUpdatedEventArgs value)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
   at Franson.DAO.DAOBase.Update()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
   at Franson.DAO.DAOBase.Update()

How to solve this error
thank
respectfully

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