Computed Attributes - State / disappearing data

Fay5 years ago

Hello,
I have seen that this problem was reported a year back but no solution was posted so sorry for repeating the question:
Since yesterday, the devices are reporting on the interface and I can see their last state/attributes for few seconds and then it disappear.

With data: https://ibb.co/41XM8PF

Without data: https://ibb.co/92nYL2j

Worth, the new data are not being saved in table tc_positions since this problem started!!

I have not touched or changed anything that might explain this.

Thank you all for your help

Anton Tananaev5 years ago

Check browser console for errors.

Fay5 years ago

Thanks Anton for your answer,
I have checked the console, it doesn't have error. Additionally, as said, the data is no longer been saved in table tc_positions since this problem started.
Your guidance in this is highly appreciated.

Anton Tananaev5 years ago

Then you have to check server logs. Have you done any troubleshooting before asking for help on the forum?

Juan Sánchez5 years ago

Hello,

I post this here, because i think it could be the same (Sorry if isn't it )

I've updated from 4.6 to 4.7, on 4.6 those computed attributes were working but not on 4.7

Logs from server:

2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,5]: 'io200 == '0'? 'No sleep' : null;' undefined variable io200 - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,5]: 'io249 == '1'? 'Aviso de Interferencia' : null;' undefined variable io249 - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,5]: 'io200 == '1'? 'GPS Sleep' : null;' undefined variable io200 - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,5]: 'io200 == '2'? 'Deep Sleep' : null;' undefined variable io200 - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,5]: 'io200 == '3'? 'Online Sleep' : null;' undefined variable io200 - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,5]: 'io200 == '4'? 'Ultra Sleep' : null;' undefined variable io200 - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,5]: 'io251 == '1'? 'Ralentí Excesivo' : null;' undefined variable io251 - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,5]: 'io251 == '0'? 'Ralentí Normal' : null;' undefined variable io251 - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,5]: 'io249 == '0'? 'Sin Interferencia' : null;' undefined variable io249 - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,9]: 'gpsStatus == '0'? 'GPS OFF' : null;' undefined variable gpsStatus - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,9]: 'gpsStatus == '1'? 'GPS ON con FIX' : null;' undefined variable gpsStatus - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:18  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,9]: 'gpsStatus == '2'? 'GPS ON sin FIX' : null;' undefined variable gpsStatus - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)
2020-01-21 21:24:19  WARN: Attribute computation error - org.traccar.handler.ComputedAttributesHandler.computeAttribute@102![0,9]: 'gpsStatus == '3'? 'GPS SLEEP' : null;' undefined variable gpsStatus - Variable (... < ComputedAttributesHandler:102 < *:113 < BaseDataHandler:27 < ... < *:29 < ... < *:29 < ... < GeocoderHandler:90 < ...)

I compare TeltonikaProtocolDecoder and ComputedAttributesHandler and only a few lines on TeltonikaProtocolDecoder changes, but i don't think that are wrong.

Could you help me?

Regards!

Fay5 years ago

Thank you Anton for answering again. Very helpful.
Indeed, I've done a lot of researches on the forum and as said, I did find that the question was raised but didn't find the answer.
As for the log, yes I have reviewed it and it is confirming that the system "Failed to store position".
I have posted another error that I found but not sure if it's linked to this problem: WARN: Set property error - Unrecognized token 'NULL': was expecting 'null', 'true', 'false' or NaN at [Source: (String)"NULL "; line: 1, column: 5] - JsonParseException (... <
Looking forward to receiving your feedback and direction.
NB:Juan, I'm afraid my situation is slightly different. All the best for you as well

Juan Sánchez5 years ago

Hello,

Fay, as i can see on your red text, String is "NULL " (With a space at the end), and values expected are "null", "true", "false" or NaN. I don't know if is possible also that it has to be case sensitive.

Regards,

Fay5 years ago

Thanks Juan for your answer. The problem is that I have not done any changes in the system so not sure what exactly happened.
Do you have any recommendation?

Fay5 years ago

Hello again,
After some deeper researches, I guess the fact that I have uploaded data into the database has created this error. So probably I have imported a field with NULL instead of null.
I'm not a programmer, I try to learn by my own and all this is new to me. What I understood from the error is that I have entered the wrong value. In a column 5. I've checked all my column 5 in every table, I didn't find where I got wrong since if I say is null or is NULL, I am getting the same data. How can I determine where this entry has been entered?
I appreciate any feedback that could help me. Below is the full error.
Thanks in advance.

WARN: Set property error - Unrecognized token 'NULL': was expecting 'null', 'true', 'false' or NaN
 at [Source: (String)"NULL
"; line: 1, column: 5] - JsonParseException (... < QueryBuilder:407 < *:458 < *:308 < DataManager:447 < PositionResource:57 < ...)

Anton Tananaev5 years ago

You uploaded data into the database manually? You didn't think it's worth mentioning before?

Fay5 years ago

Yes, I uploaded manually. Hope it's not something not recommended but this was the only way to move from the old system I was using to Traccar. Your direction is highly appreciate for me to find a solution.

Anton Tananaev5 years ago

Your original comment basically reads as "I didn't do anything, but Traccar suddenly stopped working", when it should be something like "I messed everything up by manually uploading data to the database and now I need help". I don't know why decided to mislead everyone, but I don't think I'm interested in helping after this.