We recently upgraded from TS 2013 to TS 2016. While running 2013 I added a custom field for DATE CLOSED to keep track of inactive cases as we only purge after a file has been closed over 1 year. There are no attributes applied to this field. And I did not receive this error while running 2013.
Now when I run data verification I receive the errors:
Validating Case Custom
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 3751
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 3786
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 3798
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 4505
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 4628
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 4716
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 4783
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 4837
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 4862
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 4894
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 4976
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 5056
---ERROR---
The field [DATE CLOSED] contains a value that is too low.
The field [DATE CLOSED] contains a value that is too low.
Internal Record ID: 5086
Table Error Total: 13
If I run the data verification again & attempt to repair by checking for validation errors only, it will fix all of the errors. But only temporarily. The errors reappear during the next weeks data verification I run before making a weekly backup. I have also deleted this custom field & re-entered it with the same attributes. The custom field is currently blank for all open & inactive cases & I received this error today. I deleted the custom field & re-entered it & ran the data verification again & it found no errors.
Any ideas? Or will someone have to go in & look at the tables?