Changes were made in January 2017 to the COM_CAx_Composition, COM_CAx_Structure and Alliance_Structure tables to limit the values in min_percent_cover and max_percent_cover tables. The attached queries will help network staff identify records which contain invalid characters which will prevent users from opening records. There are two queries in each attachment. If you run the first query and there are no errors and no results, you are done. If you get an error (invalid number) running the statement, run the second query to determine where the non-numeric data are. If the query returns records which need to be fixed, those records must be fixed using an update statement in SQL, as the records will not open due to the invalid character.
BX-3112
BX-3229