Remote procedure call error #1122

[akmal1999]

remote procedure call error.txt

Also, I can not see the devices in the list.

[akmal1999]

I have attached error file.

[akmal1999]

1 ---- Caused by: java.sql.SQLException: Field 'attributes' doesn't have a default value

2 --- INFO | jvm 1 | 2021/03/24 19:01:55 | SEVERE: Error during scheduled task execution
INFO | jvm 1 | 2021/03/24 19:01:55 | javax.persistence.EntityNotFoundException: Unable to find org.traccar.web.shared.model.Position with id 13227048
INFO | jvm 1 | 2021/03/24 19:01:55 | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$JpaEntityNotFoundDelegate.handleEntityNotFound(EntityManagerFactoryBuilderImpl.java:183)

[akmal1999]

Please note that I have cleand the positions table.

[vitalidze]

If you have cleaned the positions table then you have to update other tables, which have links to the positions table. For example, devices have a link to the latest position.

[akmal1999]

What you mean is if delete positions, I need to delete the devices as well that has link to the positions?

Also, I how would clean positions safely without deleting the devices or how would decouple this process?

[akmal1999]

What I am going through right now is all devices do not show up and I get a remote procedure call error. I recreated the database by dropping it from mysql and tried: I get Remote Procedure call error when I:

1. create users
2. creating devices

I attached the errors at the top of the page.

[akmal1999]

If you have cleaned the positions table then you have to update other tables, which have links to the positions table. For example, devices have a link to the latest position.

where do I need to clean the links to the positions from the devices so devices do not look in the link that calls for the positions?

[vitalidze]

You can get an idea from this #820 (comment)