Failed Live Schema Update

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting >

Failed Live Schema Update

Affected Software Version/Build: Updates to/databases using 7.20.2+


Symptoms: An EQuIS Live Schema Update fails with the following message:


The column "logger_datum_id" cannot be modified because it is either a computed column or is the result of a UNION operator.




Cause/Details: ST_VERSION entries for Live where VER_DATE = "25 Mar 2020" are missing, which can occur if the updates were applied outside of EQuIS (in SQL Server Management Studio). SQL logic processes that there are changes to a computed column (LOGGER_DATUM_ID) . although the update does not actually affect that column.


Resolution/Workaround: Perform the following steps, with assistance from EarthSoft Support:

1.Ensure that the database contains all five updates to the Live schema from March 25, 2020.

2.Enter the VER_DATE = "25 Mar 2020" entries into ST_VERSION manually.

3.Verify these steps.