Error with Tag history

HI,
I recently moved Ignition from one server to another, I also moved the SQL DB attached to Ignition.
I am on Version 7.9.14.

I have attached the logs with a few errors I am getting.

One that is common is “Cannot insert the value NULL into column ‘id’, table ‘F1-FD-DB.dbo.sqlth_te’; column does not allow nulls”

Why is it trying to write NULL to the sqlth_te table?
There are other issues But ill try keep one thread per issue.
Thanks

Edit. Seems like each time I make a new Tag in the PLC it’s doing this. Also all of my Ignition screen go red for a few seconds.

I helped a client today that had the same issue. We had to erase the tables that Ignition creates by default and let Ignition create them again, then imported the data to those tables.
I’m not exactly clear why we had to do this but here is my theory, in the tables that Ignition creates automatically there is a configuration that makes the id column an indexed column, that means that whenever a row is added, the new id value of that row is equal to the previous row value plus one. Because this configuration was not imported, when Ignition tried to add a row the system didn’t automatically assign an id number equal to the previous row plus one, instead, it added Null to the id column of the new row, which is not accepted by the database because the id column is configured to not allow Null values.