No data in reports/replay or anything except alerts

RDET2 years ago

Hi clever people.
My system has been running well for weeks. Suddenly today, when you try replay or go to reports, chrome just pops up with a red box "No Data"
Safari just leaves the screen blank.
Database checked and there is current telemtry data, up to the minute.
No errors in logs, just shows the info that report was drawn.
Can see vehicle on map, can see vehicle info when you click on more info, but no other reporting works.
Have restarted just in case.
Any ideas where to check

Anton Tananaev2 years ago

Maybe start by checking the API response payload and see how long it takes.

RDET2 years ago

Thank you Anton. I will start figuring out what you mean by that.

Anton Tananaev2 years ago

You should be able to find it in the browser developer tools (network tab).

RDET2 years ago

Get 366ms from combined initiator, also no errors in console other than Geolocation not being available.

Anton Tananaev2 years ago

And the payload?

RDET2 years ago

I need to still puzzle this out.
The only request with a payload is the combined request, and the payload tabs lists nothing other than: from: 2023-06-08T22:00:00.000Z
to: 2023-06-09T21:59:59.999Z
deviceId: 2

RDET2 years ago

Strangely, I can do a report on last week. Just not this week.

RDET2 years ago

The issue is strange. There was nothing to monitor under network before, when you click on report it would just immediately state "no data"
Even when testing now. Then suddenly, with no changes made to anything, it started trying to run the report.
It eventually stopped with a failed to fetch and a log entry of

2023-06-10 10:45:01  INFO: user: 1, report: route, from: 2023-06-04 00:00, to: 2023-06-10 23:59, devices: [2], groups: []
2023-06-10 10:45:31  WARN: Failed callback - Close SendCallback@4408baa4[PENDING][i=null,cb=null] in state PENDING - IOException (...)
2023-06-10 10:45:31 ERROR: An I/O error has occurred while writing a response message entity to the container output stream. - ClosedChannelException (...)
2023-06-10 10:45:31  WARN: Unable to release Session Session@2ec65f63{id=node01tmtbdd67gdqi19il5hsunvalh0,x=node01tmtbdd67gdqi19il5hsunvalh0.node0,req=0,res=true} - InterruptedException (...)

Ill start investigating Postgres SQL logs, although server is running on idle, not general issues detected yet.
Anyone who may have seen this before, help would be appreciated

RDET2 years ago

I also tried export instead of viewing, it export an excel sheet instantly, but data is empty.
Verified once again, data exists in the DB.

Anton Tananaev2 years ago

Seems like a timeout. Happened right after 30 seconds.

RDET2 years ago

I saw that, even migrated to MySQL DB just to check if it's that. Still no change. My Sql with a brand new DB and no data setup from scratch, instantly resulted in "no data" but data does exist.
ill keep scratching.

Anton Tananaev2 years ago

I think you're probably missing something. Are you sure you're looking at the same time interval and the same device? Make sure you consider the timezone.

RDET2 years ago

You were correct. what I missed is that the device is reporting, under status, data from 4 days ago.
I have sent an sms to the unit of getgps, it responds via sms with the correct data/time and gps fix.
So in case anyone else ever runs into this, the data on the unit ran out but it still reported as online, but once the data issue was resolved, the date time is now slowly crawling closer to the real date time, unit is replaying all the old location data. Strangely the device still sent sms's and some status with a data issue, hence to oversight.
Thanks for the help Anton.