cjrigo
Posts: 1
Joined: Sat Jun 16, 2018 2:54 pm

Datetime Problems (Pending, but not position jet)

Sat Jun 16, 2018 3:29 pm

Hi guys,
We are using GpsServer, and about 2 months we having troubles with the application since the GPS devices are reporting information with a pretty bad date and time. For example: today is 2018-06-16 (yyyy-MM-dd) and the most od devices reporting about 2018-06-05 and 2018-06-09. Consequently all devices show the status: Pending, but no position jet.

My devices are: Nautiz X1.
Media Transport: TCP (not gprs)

Example NMEA sentence:
[6/16/2018 9:03:37 AM]
(172.16.4.119:53102/CasGPSGate/tcp) Client: $FRCMD,842614120209,_SendMessage,,2248.29952,S,6914.54277,W,0.0,0.21,209.8,[b]060618,151026[/b].400,1,HDOP=0.83,TEMP=378.0,IGN=1,RVS=0,EVTTYP=0.0,HDG=209,SPD=0.21,VIV=TRO12| CEX11,EVTID=20218617,GPSANT=1,SATS=12,VDOP=1.15,BARPRES=82121,GRAD=0*77[0x0D][0x0A]
(Blue: Server Datetime, Red: GPS Received Datetime)

Example Server reading this sentence.
[6/16/2018 9:03:37 AM] (172.16.4.119:53102/CasGPSGate/tcp) Report: (-69.2423795, -22.804992, 0) (0.11, 209) (6/6/2018 3:10:26 PM)(MagneticVariation=1 x)(SubCommand=_SendMessage x)(HDOP=0.83)(VDOP=1.15)(BarPressure=82121)(Gradient=0 x)(SatelliteCount=12 x)(Acceleration=0 x)(VehiclesInViewList=TRO12, CEX11 x)(EventCode=20218617)(EventRecordID=0 x)(TimeInAlarm=0 x)(OtherVehicleDistance=0 x)(OtherVehicleHeading=0 x)(OtherVehicleID=0 x)(OtherVehicleName= x)(OtherVehicleTimeInRange=0 x)(OtherVehicleSpeed=0 x)(Ignition=True x)(Idle=True x)(Gear=4)(Input1=False x)(Input2=False x)(Input3=False x)(Input4=False x)(Output1=False x)(Output2=False x)(Output3=False x)(Output4=False x)(GPS Antenna Cut=False x)(AlarmActive=False x)(CriticalAlarmActive=False x)(WarningAlarmActive=False x)(Temperature=378 x)(MagHeading=209)(GForceX=0 x)(GForceY=0 x)(GForceZ=0 x)(GeoFenceList=)(GeoFenceNames= x)(RFRemoteSerialNumber= x)(RFAssetName= x)(RFRemoteAssetName= x)(RFMachineType=0 x)(RFGear=0 x)(RFRemoteGear=0 x)(RFRF=0 x)(RFRemoteSensorPos=0 x)(RFRemoteRange=0 x)(RFTimestamp=0 x)(RFTimestampString= x)(RFSpeed=0 x)(RFSpeedZone=0 x)(RFTimer=0 x)(RFMinRange=0 x)(RFEventID=0 x)(RFEventGroupID=0 x)(RFRemoteMachineType=0 x)(EventType=Position Report)(AlarmType=3004 x)(RFRemoteSN=973460 x)(TravellingBackwards=False x)(TravellingForwards=True x)(Speed=0.11 x)(_MaintenanceDue=False x)

We did a few test and check:
- The Nautiz X1 hava a good UTC datetime.
- We are using UTC 0 in server and devices.
- We rebooted the server, several times.
- The server firewall is off.

Does anyone have any other idea on how to resolve this issue?

Some logs:

Code: Select all

2018-06-14 16:04:52.4703 | Error | 11 | DatabaseInterface.ReportProcessingThread | Running command | 
2018-06-14 16:04:52.4703 | Error | 11 | DatabaseInterface.ReportProcessingThread | Going to insert into position delta | 
2018-06-14 16:04:52.4703 | Error | 11 | DatabaseInterface.ReportProcessingThread |  | 
2018-06-14 16:04:52.4703 | Error | 11 | DatabaseInterface.ReportProcessingThread | Inside exception block | 
2018-06-14 16:04:52.4703 | Error | 11 | DatabaseInterface.ReportProcessingThread | ExecuteScalar: CommandText property has not been initialized   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at CasGPSGate.DatabaseInterface.ReportProcessingThread() | 
2018-06-14 16:04:52.4703 | Error | 11 | DatabaseInterface.ReportProcessingThread | PositionDelta ID0 | 
2018-06-14 16:04:52.5770 | Error | 11 | DatabaseInterface.ReportProcessingThread | Generating SQL | 
2018-06-14 16:04:52.6918 | Error | 11 | DatabaseInterface.ReportProcessingThread | Running command | 
2018-06-14 16:04:52.6918 | Error | 11 | DatabaseInterface.ReportProcessingThread | Going to insert into position delta | 
2018-06-14 16:04:52.6918 | Error | 11 | DatabaseInterface.ReportProcessingThread |  | 
2018-06-14 16:04:52.6918 | Error | 11 | DatabaseInterface.ReportProcessingThread | Inside exception block | 
2018-06-14 16:04:52.6918 | Error | 11 | DatabaseInterface.ReportProcessingThread | ExecuteScalar: CommandText property has not been initialized   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at CasGPSGate.DatabaseInterface.ReportProcessingThread() | 
2018-06-14 16:04:52.6918 | Error | 11 | DatabaseInterface.ReportProcessingThread | PositionDelta ID0 | 
2018-06-14 16:04:52.8063 | Error | 11 | DatabaseInterface.ReportProcessingThread | Generating SQL | 
2018-06-14 16:04:52.9156 | Error | 11 | DatabaseInterface.ReportProcessingThread | Running command | 
2018-06-14 16:04:52.9156 | Error | 11 | DatabaseInterface.ReportProcessingThread | Going to insert into position delta | 
2018-06-14 16:04:52.9156 | Error | 11 | DatabaseInterface.ReportProcessingThread |  | 
2018-06-14 16:04:52.9156 | Error | 11 | DatabaseInterface.ReportProcessingThread | Inside exception block | 
2018-06-14 16:04:52.9156 | Error | 11 | DatabaseInterface.ReportProcessingThread | ExecuteScalar: CommandText property has not been initialized   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at CasGPSGate.DatabaseInterface.ReportProcessingThread() | 
2018-06-14 16:04:52.9156 | Error | 11 | DatabaseInterface.ReportProcessingThread | PositionDelta ID0 | 
2018-06-14 16:04:53.0181 | Error | 11 | DatabaseInterface.ReportProcessingThread | Generating SQL | 
2018-06-14 16:04:53.0337 | Error | 19 | CLParser.WriteData | Going to enter in Queue | 
2018-06-14 16:04:53.0337 | Error | 19 | CLParser.WriteData | Data entered in Queue | 
2018-06-14 16:04:53.0493 | Error | 19 | MsmqBase.InsertMessageToQueue | Printing Message | 
2018-06-14 16:04:53.0493 | Error | 19 | MsmqBase.InsertMessageToQueue | CasGPSGate.CLPacket | 
2018-06-14 16:04:53.0493 | Error | 19 | MsmqBase.InsertMessageToQueue | Generating message object | 
2018-06-14 16:04:53.0493 | Error | 19 | MsmqBase.InsertMessageToQueue | Message object generated | 
2018-06-14 16:04:53.0493 | Error | 19 | MsmqBase.InsertMessageToQueue | Preparing to send message | 
2018-06-14 16:04:53.0493 | Error | 19 | MsmqBase.InsertMessageToQueue | Message sent | 
2018-06-14 16:04:53.0493 | Error | 11 | DatabaseInterface.ReportProcessingThread | Command typePing | 
2018-06-14 16:04:53.0493 | Error | 11 | DatabaseInterface.ReportProcessingThread | Running command | 
2018-06-14 16:04:53.0493 | Error | 11 | DatabaseInterface.ReportProcessingThread | Going to insert into position delta | 
2018-06-14 16:04:53.0493 | Error | 11 | DatabaseInterface.ReportProcessingThread | usp_UpdateEvents '842616080074', 0, 0, 0, null, '06/14/2018 20:04:53.049', 0.00000, 0.00000, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, 0, null, null, 0, 0, null, 0, null, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0; | 
2018-06-14 16:04:53.0806 | Error | 11 | DatabaseInterface.ReportProcessingThread | Position Delta after DB call is8507119 | 
2018-06-14 16:04:53.0806 | Error | 11 | DatabaseInterface.ReportProcessingThread | PositionDelta ID8507119 | 
2018-06-14 16:04:53.0806 | Error | 11 | DatabaseInterface.ReportProcessingThread | Generating SQL | 
2018-06-14 16:04:53.1951 | Error | 11 | DatabaseInterface.ReportProcessingThread | Running command | 
2018-06-14 16:04:53.1951 | Error | 11 | DatabaseInterface.ReportProcessingThread | Going to insert into position delta | 
2018-06-14 16:04:53.1951 | Error | 11 | DatabaseInterface.ReportProcessingThread |  | 
2018-06-14 16:04:53.1951 | Error | 11 | DatabaseInterface.ReportProcessingThread | Inside exception block | 
2018-06-14 16:04:53.1951 | Error | 11 | DatabaseInterface.ReportProcessingThread | ExecuteScalar: CommandText property has not been initialized   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at CasGPSGate.DatabaseInterface.ReportProcessingThread() | 
2018-06-14 16:04:53.1951 | Error | 11 | DatabaseInterface.ReportProcessingThread | PositionDelta ID0 | 
2018-06-14 16:04:53.3044 | Error | 11 | DatabaseInterface.ReportProcessingThread | Generating SQL | 
2018-06-14 16:04:53.4188 | Error | 11 | DatabaseInterface.ReportProcessingThread | Running command | 
2018-06-14 16:04:53.4188 | Error | 11 | DatabaseInterface.ReportProcessingThread | Going to insert into position delta | 
2018-06-14 16:04:53.4188 | Error | 11 | DatabaseInterface.ReportProcessingThread |  | 
2018-06-14 16:04:53.4188 | Error | 11 | DatabaseInterface.ReportProcessingThread | Inside exception block | 
2018-06-14 16:04:53.4188 | Error | 11 | DatabaseInterface.ReportProcessingThread | ExecuteScalar: CommandText property has not been initialized   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

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