I had a data type problem in my MSSQL database table. I went into the MSSQL database table design and changed the datatype of a tag. At the same time i deleted a test tag (column) in the table. I did not delete the tag from the FactorySQL database.
After saving the MSSQL table, FactorySQL stopped collecting data and gave me an error message saying it could not find the tag in the MSSQL database that i had deleted. It looks like FactorySQL data collection for the entire group stopped.
To solve the problem i deleted the test tag from the FactorySQL database and restarted the group. Everything is running happily now.
Obviously i should have deleted the FactorySQL tag at the same time i deleted the MSSQL column. My mistake. But should the entire group have stopped scanning because of this error? If it did not stop scanning was the data cached someplace? I can’t seem to find it.
Thanks for the help.