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

Error when login issue

Tue Apr 29, 2014 4:35 am

Hi Support,

I got 2 error messages when trying to login and unable to login.

"Could not find specified column in results: license_id" and "Column 'user_count' does not belong to table QueryTable.

After rebooting server, no more error message and able to login.

Is there something I have to worry about?


This is from IIS Error Log file:
2014-04-29 06:39:38.0765 | Error | 17 | <Execute>d__0.MoveNext | SELECT pm.property_meta_id, pm.name, pm.namespace, pm.default_value, pm.type, pi.property_item_id, pi.instance_id, pi.value FROM property_meta pm LEFT OUTER JOIN (SELECT property_item_id, instance_id, value, property_meta_id FROM property_item WHERE instance_id=41) pi ON pi.property_meta_id=pm.property_meta_id WHERE pm.namespace='Application' AND pm.name='GEOCODER_LANGUAGE_KEY' |
2014-04-29 06:39:38.2171 | Error | 17 | <Execute>d__0.MoveNext | DAO ThreadID:17,start=4/29/2014 6:37:37 AM,pool=Default,method=ReverseGeocode,_ExecuteReverseGeocode=True,DB=2,user=mahfudz.sps |
2014-04-29 06:45:47.2015 | Error | 14 | DAOFactory.ResolveConnection | DAO ThreadID:6,start=4/29/2014 6:45:42 AM,pool=Default,method=GetLatestGateRecords
DAO ThreadID:13,start=4/29/2014 6:45:35 AM,pool=Default,method=GetOpenEvents,_ExecuteGetOpenEvents=True,DB=2,user=admin.gps
DAO ThreadID:14,start=4/29/2014 6:45:42 AM,pool=Default,method=GetOpenEvents
DAO ThreadID:15,start=4/29/2014 6:45:43 AM,pool=Default,method=GetEvents
DAO ThreadID:16,start=4/29/2014 6:45:27 AM,pool=Default,method=GetOpenEvents,_ExecuteGetOpenEvents=True,DB=2,user=admin.gps
DAO ThreadID:17,start=4/29/2014 6:45:42 AM,pool=Default
DAO ThreadID:18,start=4/29/2014 6:45:43 AM,pool=Default,method=GetEvents
DAO ThreadID:11,start=4/29/2014 6:45:42 AM,pool=Default,method=ReverseGeocode
DAO ThreadID:19,start=4/29/2014 6:45:44 AM,pool=Default,method=GetLocations
DAO ThreadID:20,start=4/29/2014 6:45:45 AM,pool=Default,method=GetUpdatedEvents
DAO ThreadID:13 in use 12.125 sec. ongoing query 12.125 sec.
DAO ThreadID:16 in use 20.0625 sec. ongoing query 20.0625 sec.
Connections in use 2, Default
|
2014-04-29 06:45:47.2015 | Error | 14 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Waiting for a free connection timed out for method GetOpenEvents. (Franson.DAO.ConnectionException)
at Franson.DAO.DAOFactory.m_GetFromPool()
at Franson.DAO.DAOFactory.ResolveConnection()
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at Franson.DAO.BOItem.Update()
at Franson.Directory.Session.CheckExpire(Boolean bCanUpdateExpiration)
at Franson.Directory.AuthenticationManager.Authenticate(Int32 iSessionID, String strSourceAddress, Int32 iApplicationID)
at Franson.Web.Services.ServiceFacadeBase.GetSession(Int32 iApplicationID)
at GpsGate.Directory.Service.EventFacade.GetOpenEvents(Int32 iApplicationID, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)
at GpsGate.Directory.Service.json.Event.GetOpenEvents(Int32 appId, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)

2014-04-29 06:47:12.7640 | Error | 23 | DAOFactory.ResolveConnection | DAO ThreadID:6,start=4/29/2014 6:47:11 AM,pool=Default,method=GetAllTags
DAO ThreadID:13,start=4/29/2014 6:45:35 AM,pool=Default,method=GetOpenEvents,_ExecuteGetOpenEvents=True,DB=2,user=admin.gps
DAO ThreadID:14,start=4/29/2014 6:47:12 AM,pool=Default,method=GetAllGeofences
DAO ThreadID:15,start=4/29/2014 6:47:10 AM,pool=Default
DAO ThreadID:16,start=4/29/2014 6:45:27 AM,pool=Default,method=GetOpenEvents,_ExecuteGetOpenEvents=True,DB=2,user=admin.gps
DAO ThreadID:18,start=4/29/2014 6:47:09 AM,pool=Default,method=GetArgumentInfo
DAO ThreadID:19,start=4/29/2014 6:47:07 AM,pool=Default,method=GetPhraseBook
DAO ThreadID:20,start=4/29/2014 6:47:09 AM,pool=Default,method=ReverseGeocode
DAO ThreadID:22,start=4/29/2014 6:47:08 AM,pool=Default,method=ReverseGeocode
DAO ThreadID:23,start=4/29/2014 6:47:07 AM,pool=Default,method=GetOpenEvents
DAO ThreadID:24,start=4/29/2014 6:47:08 AM,pool=Default,method=GetDeviceDefinitionByMessageFieldDictionaries
DAO ThreadID:21,start=4/29/2014 6:47:07 AM,pool=Default,method=GetPhraseBook
DAO ThreadID:13 in use 97.6875 sec. ongoing query 97.6875 sec.
DAO ThreadID:16 in use 105.625 sec. ongoing query 105.625 sec.
Connections in use 2, Default
|
2014-04-29 06:47:12.7796 | Error | 23 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Waiting for a free connection timed out for method GetOpenEvents. (Franson.DAO.ConnectionException)
at Franson.DAO.DAOFactory.m_GetFromPool()
at Franson.DAO.DAOFactory.ResolveConnection()
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at Franson.DAO.BOItem.Update()
at Franson.Directory.Session.CheckExpire(Boolean bCanUpdateExpiration)
at Franson.Directory.AuthenticationManager.Authenticate(Int32 iSessionID, String strSourceAddress, Int32 iApplicationID)
at Franson.Web.Services.ServiceFacadeBase.GetSession(Int32 iApplicationID)
at GpsGate.Directory.Service.EventFacade.GetOpenEvents(Int32 iApplicationID, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)
at GpsGate.Directory.Service.json.Event.GetOpenEvents(Int32 appId, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)

2014-04-29 06:47:27.7015 | Error | 16 | <Execute>d__0.MoveNext | SELECT e.*, ee.name AS rule_name, NULL AS closed_by_user_name FROM event e JOIN gate_event_expression_evaluator ee ON ee.gate_event_expression_evaluator_id = e.expression_evaluator_id LEFT JOIN template t ON t.object_id = ee.gate_event_expression_evaluator_id AND t.object_type = 'GpsGate.Online.Event.EventExpressionEvaluatorWriter' WHERE e.application_id = 41 AND e.closed = 0 AND e.user_id IN (177,178,179,180,181,182,183,468,469,470,471,474,475,482) AND e.server_time_stamp >= '1970-01-01 00:00:00' AND (t.template_id IS NULL OR t.hidden=0) ORDER BY e.min_time_stamp ASC, e.user_id ASC, e.expression_evaluator_id ASC |
2014-04-29 06:47:27.7015 | Error | 16 | <Execute>d__0.MoveNext | DAO ThreadID:16,start=4/29/2014 6:45:27 AM,pool=Default,method=GetOpenEvents,_ExecuteGetOpenEvents=True,DB=2,user=admin.gps |
2014-04-29 06:47:27.8265 | Error | 23 | ExtendedRpcDispatcher.OnError | Error executing JSON method | System.NullReferenceException: Object reference not set to an instance of an object.
at Franson.DAO.MarsDataReader.Close()
at Franson.DAO.ConnContainer.Dispose()
at Franson.DAO.DAOReaderBase.<Execute>d__0.<>m__Finally8()
at Franson.DAO.DAOReaderBase.<Execute>d__0.System.IDisposable.Dispose()
at Franson.DAO.DAOReaderBase.<Execute>d__0.MoveNext()
at GpsGate.Online.Event.DAO.EventReaderDAOSQL.<ExecuteEventReader>d__1c.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at GpsGate.Directory.Service.EventFacade.GetOpenEvents(Int32 iApplicationID, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)
at GpsGate.Directory.Service.json.Event.GetOpenEvents(Int32 appId, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)
2014-04-29 06:47:51.2640 | Error | 13 | <Execute>d__0.MoveNext | SELECT e.*, ee.name AS rule_name, NULL AS closed_by_user_name FROM event e JOIN gate_event_expression_evaluator ee ON ee.gate_event_expression_evaluator_id = e.expression_evaluator_id LEFT JOIN template t ON t.object_id = ee.gate_event_expression_evaluator_id AND t.object_type = 'GpsGate.Online.Event.EventExpressionEvaluatorWriter' WHERE e.application_id = 41 AND e.closed = 0 AND e.user_id IN (177,178,179,180,181,182,183,468,469,470,471,474,475,482) AND e.server_time_stamp >= '1970-01-01 00:00:00' AND (t.template_id IS NULL OR t.hidden=0) ORDER BY e.min_time_stamp ASC, e.user_id ASC, e.expression_evaluator_id ASC |
2014-04-29 06:47:51.2640 | Error | 13 | <Execute>d__0.MoveNext | DAO ThreadID:13,start=4/29/2014 6:45:35 AM,pool=Default,method=GetOpenEvents,_ExecuteGetOpenEvents=True,DB=2,user=admin.gps |
2014-04-29 06:47:52.9671 | Error | 22 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Waiting for a free connection timed out for method GetNewGateEvent. (Franson.DAO.ConnectionException)
at Franson.DAO.DAOFactory.m_GetFromPool()
at Franson.DAO.DAOFactory.ResolveConnection()
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at Franson.DAO.BOItem.Update()
at Franson.Directory.Session.CheckExpire(Boolean bCanUpdateExpiration)
at Franson.Directory.AuthenticationManager.Authenticate(Int32 iSessionID, String strSourceAddress, Int32 iApplicationID)
at Franson.Web.Services.ServiceFacadeBase.GetSession(Int32 iApplicationID)
at GpsGate.Directory.Service.DirectoryFacade.GetNewGateEvents(Int32 iApplicationID, DateTime dtServerTimeStamp, String strStateName, String[] arrChannels, Int32 iViewID, Int64 lngIndex, Int32 iCount, Boolean bAscending)
at GpsGate.Directory.Service.json.Directory.GetNewGateEvent(Int32 appId, DateTime sinceTimeStamp, String state, String[] channels, Int32 viewId, Int64 lngIndex, Int32 iCount, Boolean bAscending)

2014-04-29 06:47:58.4358 | Error | 19 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Waiting for a free connection timed out for method GetNewGateEvent. (Franson.DAO.ConnectionException)
at Franson.DAO.DAOFactory.m_GetFromPool()
at Franson.DAO.DAOFactory.ResolveConnection()
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at Franson.DAO.BOItem.Update()
at Franson.Directory.Session.CheckExpire(Boolean bCanUpdateExpiration)
at Franson.Directory.AuthenticationManager.Authenticate(Int32 iSessionID, String strSourceAddress, Int32 iApplicationID)
at Franson.Web.Services.ServiceFacadeBase.GetSession(Int32 iApplicationID)
at GpsGate.Directory.Service.DirectoryFacade.GetNewGateEvents(Int32 iApplicationID, DateTime dtServerTimeStamp, String strStateName, String[] arrChannels, Int32 iViewID, Int64 lngIndex, Int32 iCount, Boolean bAscending)
at GpsGate.Directory.Service.json.Directory.GetNewGateEvent(Int32 appId, DateTime sinceTimeStamp, String state, String[] channels, Int32 viewId, Int64 lngIndex, Int32 iCount, Boolean bAscending)

2014-04-29 06:48:55.0296 | Error | 21 | DAOFactory.ResolveConnection | DAO ThreadID:6,start=4/29/2014 6:48:50 AM,pool=Default,method=GetPhraseBook
DAO ThreadID:14,start=4/29/2014 6:47:29 AM,pool=Default,method=GetOpenEvents,_ExecuteGetOpenEvents=True,DB=3,user=pws.sps
DAO ThreadID:15,start=4/29/2014 6:48:52 AM,pool=Default,method=GetAllTags
DAO ThreadID:17,start=4/29/2014 6:48:50 AM,pool=Default,method=ReverseGeocode
DAO ThreadID:11,start=4/29/2014 6:48:50 AM,pool=Default,method=GetPhraseBook
DAO ThreadID:19,start=4/29/2014 6:48:50 AM,pool=Default,method=ReverseGeocode
DAO ThreadID:20,start=4/29/2014 6:47:51 AM,pool=Default,method=GetOpenEvents,_ExecuteGetOpenEvents=True,DB=2,user=admin.gps
DAO ThreadID:22,start=4/29/2014 6:48:51 AM,pool=Default
DAO ThreadID:24,start=4/29/2014 6:48:51 AM,pool=Default,method=GetArgumentInfo
DAO ThreadID:21,start=4/29/2014 6:48:50 AM,pool=Default,method=GetOpenEvents
DAO ThreadID:26,start=4/29/2014 6:48:53 AM,pool=Default,method=GetAllGeofences
DAO ThreadID:27,start=4/29/2014 6:48:54 AM,pool=Default,method=SetUserSetting
DAO ThreadID:14 in use 85.578125 sec. ongoing query 85.578125 sec.
DAO ThreadID:20 in use 63.671875 sec. ongoing query 63.203125 sec.
Connections in use 2, Default
|
2014-04-29 06:48:55.0296 | Error | 21 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Waiting for a free connection timed out for method GetOpenEvents. (Franson.DAO.ConnectionException)
at Franson.DAO.DAOFactory.m_GetFromPool()
at Franson.DAO.DAOFactory.ResolveConnection()
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at Franson.DAO.BOItem.Update()
at Franson.Directory.Session.CheckExpire(Boolean bCanUpdateExpiration)
at Franson.Directory.AuthenticationManager.Authenticate(Int32 iSessionID, String strSourceAddress, Int32 iApplicationID)
at Franson.Web.Services.ServiceFacadeBase.GetSession(Int32 iApplicationID)
at GpsGate.Directory.Service.EventFacade.GetOpenEvents(Int32 iApplicationID, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)
at GpsGate.Directory.Service.json.Event.GetOpenEvents(Int32 appId, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)

2014-04-29 06:49:29.9983 | Error | 17 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Waiting for a free connection timed out for method GetOpenEvents. (Franson.DAO.ConnectionException)
at Franson.DAO.DAOFactory.m_GetFromPool()
at Franson.DAO.DAOFactory.ResolveConnection()
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at Franson.DAO.BOItem.Update()
at Franson.Directory.Session.CheckExpire(Boolean bCanUpdateExpiration)
at Franson.Directory.AuthenticationManager.Authenticate(Int32 iSessionID, String strSourceAddress, Int32 iApplicationID)
at Franson.Web.Services.ServiceFacadeBase.GetSession(Int32 iApplicationID)
at GpsGate.Directory.Service.EventFacade.GetOpenEvents(Int32 iApplicationID, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)
at GpsGate.Directory.Service.json.Event.GetOpenEvents(Int32 appId, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)

2014-04-29 06:49:30.0608 | Error | 14 | <Execute>d__0.MoveNext | SELECT e.*, ee.name AS rule_name, NULL AS closed_by_user_name FROM event e JOIN gate_event_expression_evaluator ee ON ee.gate_event_expression_evaluator_id = e.expression_evaluator_id LEFT JOIN template t ON t.object_id = ee.gate_event_expression_evaluator_id AND t.object_type = 'GpsGate.Online.Event.EventExpressionEvaluatorWriter' WHERE e.application_id = 41 AND e.closed = 0 AND e.user_id IN (163,164,165,173,174,175,176,177,178,179,180,181,182,183,468,469,470,471,474,475,482) AND e.server_time_stamp >= '1970-01-01 00:00:00' AND (t.template_id IS NULL OR t.hidden=0) ORDER BY e.min_time_stamp ASC, e.user_id ASC, e.expression_evaluator_id ASC |
2014-04-29 06:49:30.0765 | Error | 14 | <Execute>d__0.MoveNext | DAO ThreadID:14,start=4/29/2014 6:47:29 AM,pool=Default,method=GetOpenEvents,_ExecuteGetOpenEvents=True,DB=3,user=pws.sps |
2014-04-29 06:49:30.2483 | Error | 17 | EventFacade.GetEvents | Franson.DAO.FillException | Database error - could not fill data SQL: SELECT * FROM sessions WHERE session_id = 5622106 (Franson.DAO.FillException)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)
at Franson.Directory.DAO.SessionDAOSQL.LoadByID(Int32 iSessionID)
at Franson.Directory.Session.Load(Int32 iID)
at Franson.Directory.AuthenticationManager.Authenticate(Int32 iSessionID, String strSourceAddress, Int32 iApplicationID)
at Franson.Web.Services.ServiceFacadeBase.GetSession(Int32 iApplicationID)
at GpsGate.Directory.Service.EventFacade.GetEvents(Int32 iApplicationID, Int32 iHandleID, Int32[] users, Int32[] rules, DateTime date, Int32 iIndex, Int32 iCount)
Value cannot be null.
Parameter name: dataReader (System.ArgumentNullException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)

2014-04-29 06:49:30.4827 | Error | 25 | ReportingFacade.GetReports | System.IndexOutOfRangeException | System.IndexOutOfRangeException: Could not find specified column in results: report_id
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.DAO.DAOReaderBase.GetInteger(IDataReader reader, String strFieldName)
at GpsGate.Reporting.v3.DAO.ReportReaderDAO.m_createReport(IDataReader reader, QueryReaderDAOSQL queryDao, ReportRendererReader rendererReader)
at GpsGate.Reporting.v3.DAO.ReportReaderDAO.<ExecuteReportReader>d__0.MoveNext()
at Franson.Directory.Security.AuthorizedReader`1.<Read>d__0.MoveNext()
at GpsGate.Reporting.Web.v3.Service.ReportingFacade.GetReports(Int32 iApplicationID)
2014-04-29 06:49:30.4983 | Error | 25 | ReportingFacade.GetReports | Could not get reports for application 41 |
2014-04-29 06:49:30.4983 | Error | 25 | ExtendedRpcDispatcher.OnError | Error executing JSON method | System.IndexOutOfRangeException: Could not find specified column in results: report_id
at GpsGate.Reporting.Web.v3.Service.ReportingFacade.GetReports(Int32 iApplicationID)
at GpsGate.Reporting.Web.v3.Service.json.Reporting.GetReports(Int32 appId)
2014-04-29 06:49:31.5608 | Error | 31 | ExtendedRpcDispatcher.OnError | Error executing JSON method | System.IndexOutOfRangeException: Could not find specified column in results: namespace
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.Directory.DAO.PropertyItemReaderDAO.ExecuteToPropertyItem()
at Franson.Directory.DAO.PropertyItemReaderDAO.GetPropertyItem(String strName, String strNamespace, Int32 iInstanceID)
at Franson.Geo.Geocoding.GeocoderFactory.GetApplicationGeocoderLanguageKey(Int32 iApplicationID)
at Franson.Geo.Geocoding.GeocoderFactory.GetGeocoderByApplicationId(Int32 iAppId)
at GpsGate.Directory.Service.GeocoderFacade.ReverseGeocode(Int32 iApplicationID, List`1 lstPositions)
at GpsGate.Directory.Service.json.Geocoder.ReverseGeocode(Int32 appId, JsonObject[] arrPositions)
2014-04-29 06:49:33.0296 | Error | 28 | ExtendedRpcDispatcher.OnError | Error executing JSON method | System.IndexOutOfRangeException: Could not find specified column in results: event_id
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.DAO.DAOReaderBase.GetLong(String strFieldName)
at GpsGate.Online.Event.DAO.EventReaderDAOSQL.<ExecuteEventReader>d__24.MoveNext()
at Franson.Directory.Session.<FilterUserLevelDataAccess>d__0`1.MoveNext()
at GpsGate.Directory.Service.EventFacade.<GetUpdatedEvents>d__6.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at GpsGate.Directory.Service.json.Event.GetUpdatedEvents(Int32 appId, Int32[] users, DateTime since)
2014-04-29 06:49:34.3108 | Error | 6 | ExtendedRpcDispatcher.OnError | Error executing JSON method | System.IndexOutOfRangeException: Could not find specified column in results: track_data_id
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.DAO.DAOReaderBase.GetLong(IDataReader reader, String strFieldName)
at GpsGate.Online.Message.DAO.GateMessageReaderDAOSQL.<Execute>d__2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at GpsGate.Online.Message.DAO.GateMessageReaderDAOSQL.LoadLatestUniqueRecordsByUser(Int32 iUserID, Boolean bFilterNotMapped)
at GpsGate.Online.Message.GateMessageReader.LoadLatestUniqueRecordsByUser(Int32 iUserID, Boolean bFilterNotMapped)
at GpsGate.Directory.Service.DirectoryFacade.GetLatestGateRecords(Int32 iApplicationID, Int32 iUserId, Boolean bFilterNotUsed)
at GpsGate.Directory.Service.json.Directory.GetLatestGateRecords(Int32 appId, Int32 userId, Boolean bFilterNotUsed)
2014-04-29 06:49:34.8577 | Error | 6 | ExtendedRpcDispatcher.OnError | Error executing JSON method | System.IndexOutOfRangeException: Could not find specified column in results: namespace
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.Directory.DAO.PropertyItemReaderDAO.ExecuteToPropertyItem()
at Franson.Directory.DAO.PropertyItemReaderDAO.GetPropertyItem(String strName, String strNamespace, Int32 iInstanceID)
at Franson.Geo.Geocoding.GeocoderFactory.GetApplicationGeocoderLanguageKey(Int32 iApplicationID)
at Franson.Geo.Geocoding.GeocoderFactory.GetGeocoderByApplicationId(Int32 iAppId)
at GpsGate.Directory.Service.GeocoderFacade.ReverseGeocode(Int32 iApplicationID, List`1 lstPositions)
at GpsGate.Directory.Service.json.Geocoder.ReverseGeocode(Int32 appId, JsonObject[] arrPositions)
2014-04-29 06:49:34.8733 | Error | 29 | ExtendedRpcDispatcher.OnError | Error executing JSON method | System.IndexOutOfRangeException: Could not find specified column in results: track_data_id
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.DAO.DAOReaderBase.GetLong(IDataReader reader, String strFieldName)
at GpsGate.Online.Message.DAO.GateMessageReaderDAOSQL.<Execute>d__2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at GpsGate.Online.Message.DAO.GateMessageReaderDAOSQL.LoadLatestUniqueRecordsByUser(Int32 iUserID, Boolean bFilterNotMapped)
at GpsGate.Online.Message.GateMessageReader.LoadLatestUniqueRecordsByUser(Int32 iUserID, Boolean bFilterNotMapped)
at GpsGate.Directory.Service.DirectoryFacade.GetLatestGateRecords(Int32 iApplicationID, Int32 iUserId, Boolean bFilterNotUsed)
at GpsGate.Directory.Service.json.Directory.GetLatestGateRecords(Int32 appId, Int32 userId, Boolean bFilterNotUsed)
2014-04-29 06:49:37.2640 | Error | 30 | ExtendedRpcDispatcher.OnError | Error executing JSON method | System.IndexOutOfRangeException: Could not find specified column in results: username
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.DAO.DAOReaderBase.GetString(IDataReader reader, String strFieldName)
at GpsGate.Online.Directory.DAO.GateUserReaderDAOSQL.<ExecuteGateUserReader>d__7.MoveNext()
at GpsGate.Online.Directory.View.<Filter>d__0.MoveNext()
at Franson.Directory.Session.<FilterUserLevelDataAccess>d__0`1.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at GpsGate.Directory.Service.DirectoryFacade.GetUpdatesForUsersInGroup(Int32 iApplicationID, Int32 iStartIndex, Int32 iStopIndex, Int32 iViewID, DateTime dtSince)
at GpsGate.Directory.Service.json.Directory.GetUpdatesForUsersInGroup(Int32 appId, Int32 start, Int32 stop, Int32 viewId, DateTime since)
2014-04-29 06:49:37.5452 | Error | 25 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Database error - could not fill data SQL: SELECT * FROM applications WHERE application_id = 41; (Franson.DAO.FillException)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)
at Franson.Directory.DAO.ApplicationDAOSQL.LoadByID(Int32 iID)
at GpsGate.VehicleTracker.VehicleTrackerApplication.LoadByID(Int32 iID)
at GpsGate.Admin.Service.UserFacade.GetDeviceMappers(Int32 iApplicationID)
at GpsGate.Admin.Service.json.User.GetDeviceMappers(Int32 appId)
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. (System.Data.ConstraintException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)

2014-04-29 06:49:40.5765 | Error | 28 | ExtendedRpcDispatcher.OnError | Error executing JSON method | System.IndexOutOfRangeException: Could not find specified column in results: event_id
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.DAO.DAOReaderBase.GetLong(String strFieldName)
at GpsGate.Online.Event.DAO.EventReaderDAOSQL.<ExecuteEventReader>d__24.MoveNext()
at Franson.Directory.Session.<FilterUserLevelDataAccess>d__0`1.MoveNext()
at GpsGate.Directory.Service.EventFacade.<GetUpdatedEvents>d__6.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at GpsGate.Directory.Service.json.Event.GetUpdatedEvents(Int32 appId, Int32[] users, DateTime since)
2014-04-29 06:49:43.1702 | Error | 25 | ExtendedRpcDispatcher.OnError | Error executing JSON method | System.IndexOutOfRangeException: Could not find specified column in results: event_id
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.DAO.DAOReaderBase.GetLong(String strFieldName)
at GpsGate.Online.Event.DAO.EventReaderDAOSQL.<ExecuteEventReader>d__24.MoveNext()
at Franson.Directory.Session.<FilterUserLevelDataAccess>d__0`1.MoveNext()
at GpsGate.Directory.Service.EventFacade.<GetUpdatedEvents>d__6.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at GpsGate.Directory.Service.json.Event.GetUpdatedEvents(Int32 appId, Int32[] users, DateTime since)
2014-04-29 06:49:47.4515 | Error | 31 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Database error - could not fill data SQL: SELECT * FROM sessions WHERE session_id = 0 (Franson.DAO.FillException)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)
at Franson.Directory.DAO.SessionDAOSQL.LoadByID(Int32 iSessionID)
at Franson.Directory.Session.Load(Int32 iID)
at Franson.Directory.AuthenticationManager.Authenticate(Int32 iSessionID, String strSourceAddress, Int32 iApplicationID)
at Franson.Web.Services.ServiceFacadeBase.GetSession(Int32 iApplicationID)
at GpsGate.Directory.Service.DirectoryFacade.GetUpdatesForUsersInGroup(Int32 iApplicationID, Int32 iStartIndex, Int32 iStopIndex, Int32 iViewID, DateTime dtSince)
at GpsGate.Directory.Service.json.Directory.GetUpdatesForUsersInGroup(Int32 appId, Int32 start, Int32 stop, Int32 viewId, DateTime since)
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. (System.Data.ConstraintException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)

2014-04-29 06:49:49.5921 | Error | 30 | LoginControl.Login | Exception during login | System.ArgumentException: Column 'user_count' does not belong to table QueryTable.
at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at Franson.License.DAO.UserSearchDAOSQL.GetLicenseUsers()
at Franson.License.LicenseManager.Reload()
at Franson.License.LicenseManager..ctor()
at GpsGate.WebControls.LoginControl.Login(String strUsername, String strPassword)
2014-04-29 06:49:50.6077 | Error | 31 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Database error - could not fill data SQL: SELECT * FROM sessions WHERE session_id = 0 (Franson.DAO.FillException)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)
at Franson.Directory.DAO.SessionDAOSQL.LoadByID(Int32 iSessionID)
at Franson.Directory.Session.Load(Int32 iID)
at Franson.Directory.AuthenticationManager.Authenticate(Int32 iSessionID, String strSourceAddress, Int32 iApplicationID)
at Franson.Web.Services.ServiceFacadeBase.GetSession(Int32 iApplicationID)
at GpsGate.Directory.Service.EventFacade.<GetUpdatedEvents>d__6.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at GpsGate.Directory.Service.json.Event.GetUpdatedEvents(Int32 appId, Int32[] users, DateTime since)
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. (System.Data.ConstraintException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)

2014-04-29 06:49:52.3890 | Error | 20 | <Execute>d__0.MoveNext | SELECT e.*, ee.name AS rule_name, NULL AS closed_by_user_name FROM event e JOIN gate_event_expression_evaluator ee ON ee.gate_event_expression_evaluator_id = e.expression_evaluator_id LEFT JOIN template t ON t.object_id = ee.gate_event_expression_evaluator_id AND t.object_type = 'GpsGate.Online.Event.EventExpressionEvaluatorWriter' WHERE e.application_id = 41 AND e.closed = 0 AND e.user_id IN (177,178,179,180,181,182,183,468,469,470,471,474,475,482) AND e.server_time_stamp >= '1970-01-01 00:00:00' AND (t.template_id IS NULL OR t.hidden=0) ORDER BY e.min_time_stamp ASC, e.user_id ASC, e.expression_evaluator_id ASC |
2014-04-29 06:49:52.3890 | Error | 20 | <Execute>d__0.MoveNext | DAO ThreadID:20,start=4/29/2014 6:47:51 AM,pool=Default,method=GetOpenEvents,_ExecuteGetOpenEvents=True,DB=2,user=admin.gps |
2014-04-29 06:49:53.0921 | Error | 20 | Index.get_WebContext | Franson.DAO.FillException | Database error - could not fill data SQL: SELECT * FROM applications WHERE application_id = 41; (Franson.DAO.FillException)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)
at Franson.Directory.DAO.ApplicationDAOSQL.LoadByID(Int32 iID)
at GpsGate.VehicleTracker.VehicleTrackerApplication.LoadByID(Int32 iID)
at GpsGate.VehicleTracker.WebUI.Index.get_WebContext()
Value cannot be null.
Parameter name: dataReader (System.ArgumentNullException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)

2014-04-29 06:49:53.0921 | Error | 20 | Index.get_WebContext | Error creating web context. Database error - could not fill data SQL: SELECT * FROM applications WHERE application_id = 41; |
2014-04-29 06:49:53.0921 | Error | 20 | Index.Page_Load | System.Threading.ThreadAbortException | System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at GpsGate.VehicleTracker.WebUI.Index.get_WebContext()
at GpsGate.VehicleTracker.WebUI.Index.get_Lang()
at GpsGate.VehicleTracker.WebUI.Index.Page_Load(Object sender, EventArgs e)
2014-04-29 06:49:53.1077 | Error | 20 | Index.Page_Load | Error Loading VehicleTracker Index = Thread was being aborted. |
2014-04-29 06:50:03.2483 | Error | 31 | LoginControl.Login | Exception during login | System.IndexOutOfRangeException: Could not find specified column in results: license_id
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.License.GpsGateLicense.FromDataReader(IDataReader dr)
at Franson.License.ServerLicense.FromDataReader(IDataReader dr)
at Franson.License.DAO.LicenseReaderDAOSQL.<LoadAll>d__8`1.MoveNext()
at Franson.License.LicenseManager.Reload()
at Franson.License.LicenseManager..ctor()
at GpsGate.WebControls.LoginControl.Login(String strUsername, String strPassword)
2014-04-29 06:50:20.2483 | Error | 31 | LoginControl.Login | Exception during login | System.ArgumentException: Column 'user_count' does not belong to table QueryTable.
at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at Franson.License.DAO.UserSearchDAOSQL.GetLicenseUsers()
at Franson.License.LicenseManager.Reload()
at Franson.License.LicenseManager..ctor()
at GpsGate.WebControls.LoginControl.Login(String strUsername, String strPassword)
2014-04-29 06:50:37.5296 | Error | 31 | LoginControl.Login | Exception during login | System.IndexOutOfRangeException: Could not find specified column in results: license_id
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.License.GpsGateLicense.FromDataReader(IDataReader dr)
at Franson.License.ServerLicense.FromDataReader(IDataReader dr)
at Franson.License.DAO.LicenseReaderDAOSQL.<LoadAll>d__8`1.MoveNext()
at Franson.License.LicenseManager.Reload()
at Franson.License.LicenseManager..ctor()
at GpsGate.WebControls.LoginControl.Login(String strUsername, String strPassword)
2014-04-29 06:50:51.5140 | Error | 20 | LoginControl.Login | Exception during login | System.ArgumentException: Column 'user_count' does not belong to table QueryTable.
at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at Franson.License.DAO.UserSearchDAOSQL.GetLicenseUsers()
at Franson.License.LicenseManager.Reload()
at Franson.License.LicenseManager..ctor()
at GpsGate.WebControls.LoginControl.Login(String strUsername, String strPassword)
2014-04-29 06:51:10.6233 | Error | 31 | LoginControl.Page_Load | Database error in login control | System.IndexOutOfRangeException: Could not find specified column in results: install_status
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.DAO.DAOReaderBase.GetInteger(IDataReader reader, String strFieldName)
at GpsGate.Deploy.DAO.DeployPackageReaderDAO.GetDeployPackageStatus(String strName, String strNamespace)
at GpsGate.Deploy.DeployPackageManager.GetDeployPackageStatus(String strName, String strNamespace)
at GpsGate.WebControls.LoginControl.m_IsMobileEnabled()
at GpsGate.WebControls.LoginControl.Page_Load(Object sender, EventArgs e)
2014-04-29 06:51:20.0765 | Error | 31 | LoginControl.Login | Exception during login | System.IndexOutOfRangeException: Could not find specified column in results: license_id
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.License.GpsGateLicense.FromDataReader(IDataReader dr)
at Franson.License.ServerLicense.FromDataReader(IDataReader dr)
at Franson.License.DAO.LicenseReaderDAOSQL.<LoadAll>d__8`1.MoveNext()
at Franson.License.LicenseManager.Reload()
at Franson.License.LicenseManager..ctor()
at GpsGate.WebControls.LoginControl.Login(String strUsername, String strPassword)
2014-04-29 06:51:43.6233 | Error | 31 | LoginControl.Login | Exception during login | System.ArgumentException: Column 'user_count' does not belong to table QueryTable.
at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at Franson.License.DAO.UserSearchDAOSQL.GetLicenseUsers()
at Franson.License.LicenseManager.Reload()
at Franson.License.LicenseManager..ctor()
at GpsGate.WebControls.LoginControl.Login(String strUsername, String strPassword)
2014-04-29 06:51:59.3890 | Error | 31 | LoginControl.Login | Exception during login | System.IndexOutOfRangeException: Could not find specified column in results: license_id
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at Franson.DAO.MarsDataReader.get_Item(String name)
at Franson.License.GpsGateLicense.FromDataReader(IDataReader dr)
at Franson.License.ServerLicense.FromDataReader(IDataReader dr)
at Franson.License.DAO.LicenseReaderDAOSQL.<LoadAll>d__8`1.MoveNext()
at Franson.License.LicenseManager.Reload()
at Franson.License.LicenseManager..ctor()
at GpsGate.WebControls.LoginControl.Login(String strUsername, String strPassword)
2014-04-29 07:01:56.0770 | Error | 3 | PagePluginManager.LoadPlugin | System.IO.FileNotFoundException | System.IO.FileNotFoundException: Could not find file 'E:\GpsServer\IIS\Resources\ScriptPlugins\com.GpsGate\Branding\BrandingPagePlugin.xml'.
File name: 'E:\GpsServer\IIS\Resources\ScriptPlugins\com.GpsGate\Branding\BrandingPagePlugin.xml'
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)
at Franson.Web.UI.Plugin.PagePluginManager.LoadPlugin(String strPhysicalPath)
2014-04-29 07:01:56.2801 | Error | 3 | PagePluginManager.LoadPlugin | Could not load PagePlugin. Message: Could not find file 'E:\GpsServer\IIS\Resources\ScriptPlugins\com.GpsGate\Branding\BrandingPagePlugin.xml'. |
2014-04-29 07:06:51.7020 | Error | 9 | <Execute>d__0.MoveNext | SELECT e.*, ee.name AS rule_name, NULL AS closed_by_user_name FROM event e JOIN gate_event_expression_evaluator ee ON ee.gate_event_expression_evaluator_id = e.expression_evaluator_id LEFT JOIN template t ON t.object_id = ee.gate_event_expression_evaluator_id AND t.object_type = 'GpsGate.Online.Event.EventExpressionEvaluatorWriter' WHERE e.application_id = 41 AND e.closed = 0 AND e.user_id IN (163,164,165,173,174,175,176,177,178,179,180,181,182,183,468,469,470,471,474,475,482) AND e.server_time_stamp >= '1970-01-01 00:00:00' AND (t.template_id IS NULL OR t.hidden=0) ORDER BY e.min_time_stamp ASC, e.user_id ASC, e.expression_evaluator_id ASC |
2014-04-29 07:06:51.8738 | Error | 9 | <Execute>d__0.MoveNext | DAO ThreadID:9,start=4/29/2014 7:02:50 AM,pool=Default,method=GetOpenEvents,_ExecuteGetOpenEvents=True,DB=2,user=pws.sps |
2014-04-29 07:06:52.4520 | Error | 9 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Database error - could not fill data SQL: SELECT * FROM sessions WHERE session_id = 5622234 (Franson.DAO.FillException)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)
at Franson.Directory.DAO.SessionDAOSQL.LoadByID(Int32 iSessionID)
at Franson.Directory.Session.Load(Int32 iID)
at Franson.Directory.AuthenticationManager.Authenticate(Int32 iSessionID, String strSourceAddress, Int32 iApplicationID)
at Franson.Web.Services.ServiceFacadeBase.GetSession(Int32 iApplicationID)
at GpsGate.Directory.Service.EventFacade.GetOpenEvents(Int32 iApplicationID, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)
at GpsGate.Directory.Service.json.Event.GetOpenEvents(Int32 appId, Int32[] users, DateTime since, Int32 iIndex, Int32 iCount)
Value cannot be null.
Parameter name: dataReader (System.ArgumentNullException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Fill(String strSelect, String strTableName)







Best Regards,
piter197

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

RE: Error when login issue

Tue Apr 29, 2014 9:59 am

This has to so with that IIS did not properly install the updated assemblies. A iisreset or application pool recycle would solve the problem. There is no known case when a server reboot is needed for GpsGate Server. Avoid that.

Regards,
Johan

GpsGate Support

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

RE: Error when login issue

Tue Apr 29, 2014 10:01 am

Thank you. I'll remember that if the same case occur

Best Regards,
piter197

ragesh1962
Posts: 4
Joined: Fri Apr 25, 2014 1:37 pm
Location: India

RE: Error when login issue

Fri May 02, 2014 11:25 am

I am admin of my server.
I am giving authority to user to change password.

User Chane the password But after some time user forget their password.
So, How can i see new password of that user?

m1Gps
Posts: 67
Joined: Sat Dec 28, 2013 7:25 pm

RE: Error when login issue

Fri May 02, 2014 1:08 pm

Hi Support,

In case, piter 197 posted here, may I know is the GGS watchdog would notify us if such error occur in our Server.

Regards

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