It started to throw this error
Could someone please point to where I can start troubleshooting?
Is disabling the Rule cache a good option?
Thanks,
Nic
Edited by EishiFUN
It started to throw this error
Could someone please point to where I can start troubleshooting?
Is disabling the Rule cache a good option?
Thanks,
Nic
You need to be logged in to reply to this post and participate in the Geotab Community discussions.
Hi @NChid-1960,
This seems to be an issue that people run into on rare occasions. It has not been possible to replicate and difficult to debug. However, there is a simple solution:
1 - Stop the API Adapter.
2 - Execute the following script to clear the Rules and Conditions tables and reseed indexes.
SQL Server Version:
truncate table [dbo].[Conditions];
truncate table [dbo].[Rules];
DBCC CHECKIDENT ('dbo.Conditions', RESEED, 0);
DBCC CHECKIDENT ('dbo.Rules', RESEED, 0);Postgres Version:
delete from public."Conditions";
delete from public."Rules";
ALTER SEQUENCE public."Conditions_id_seq" RESTART;
ALTER SEQUENCE public."Rules_id_seq" RESTART;3 - Start the API Adapter.
After restarting, the API Adapter will repopulate these tables. The "GeotabId" values of specific objects will be the same as they were before after this process.
Steve
Hi @NChid-1960 !
Thank you for asking in the Geotab Community! Let me check with our SDK experts to see if one of them can help out. 😊
Myself or another expert will jump in either later today or Monday.
In the meantime, if you solve it yourself or have other questions please update this post anytime.
Warm Regards,
Gen
Hi @NChid-1960,
This seems to be an issue that people run into on rare occasions. It has not been possible to replicate and difficult to debug. However, there is a simple solution:
1 - Stop the API Adapter.
2 - Execute the following script to clear the Rules and Conditions tables and reseed indexes.
SQL Server Version:
truncate table [dbo].[Conditions];
truncate table [dbo].[Rules];
DBCC CHECKIDENT ('dbo.Conditions', RESEED, 0);
DBCC CHECKIDENT ('dbo.Rules', RESEED, 0);Postgres Version:
delete from public."Conditions";
delete from public."Rules";
ALTER SEQUENCE public."Conditions_id_seq" RESTART;
ALTER SEQUENCE public."Rules_id_seq" RESTART;3 - Start the API Adapter.
After restarting, the API Adapter will repopulate these tables. The "GeotabId" values of specific objects will be the same as they were before after this process.
Steve
Thanks Steve.
Glad I asked, I learned something new and got an easy solution.