Check Database View Structure

Use this diagnostic test to validate the fieldlst table for mismatched column IDs, values and other issues that can affect the display of fields in Millennium. You must be a Millennium system administrator in a system that uses Microsoft SQL Server to run this test.

Use the following steps to run this diagnostic test:

1. Sign into the system as a Millennium system administrator.
2. Select Tools>System Upkeep>Diagnostics from the menu. The Diagnostics page opens.
3. In the Database Groups and Views section click the Check the structure of all Millennium Database Views link.
4. Click Run to run the report. The report produces a file with the name ValidateGetColumnsResultDate.txt, where Date is the current date. If no problems are encountered, the system shows a message that indicates no issues were found.
5. You can save the file locally or open it to view the results. Use a browser (such as Internet Explorer or Chrome) to open the report file for optimum formatting.

The report has a format similar to the following: