Setup Inspection Questions

On the Setup Inspection page (menu_id=setup_insp_questions_data) a user may see the following error message:

If so, it is due to a misconfiguration of the column, which can be resolved by following the steps on each of the windows below:

Navigate to the Tables window (System > Utilities > Tables) and following these steps:

1. Select the table SETUP_ASSET_SUB_CATEGORY
2. Scroll over to the System Flag column
   
   
   • If the column not visible or not editable:
     1. switch to Design Mode by clicking the gear icon in the top of the screen and switching the toggle
        
     2. Click Actions and select Change Control Properties
     3. Click (dw_tables) and then select the Data Windows tab
     4. In the Columns pane, scroll to SYSTEM_FLAG and check the Editable checkbox and uncheck the Hidden checkbox
     5. Click OK
     6. Select Reload to refresh the page
3. Change SYSTEM_FLAG from 1 to 0 for ASSET_SUB_CATEGORY_NAME column 
4. Select Save
5. In the Columns tab delete the ASSET_SUB_CATEGORY_NAME column
6. Select Save
7. If the System Flag was changed then revert the changes via change control properties
8. In Tables tab right-click on table SETUP_ASSET_SUB_CATEGORY 
9. Select Apply Changes

Navigate to the Columns window (System > Utilities > Columns) and follow these steps:

1. Find column ASSET_SUB_CATEGORY_ID
2. Right-click and select Edit
3. Set the Column Label to Asset Sub Category
4. Select Next
5. Change the Label Column name to ASSET_SUB_CATEGORY_DESC
   To see this option in the list, you may need to start typing in the Label drop-down
6. Select OK
7. Find column ASSET_SUB_CATEGORY_NAME
   If this is not marked as System (SYSTEM_FLAG was changed from 1 to 0 in previous steps) then delete column
8. Select Save

Navigate to the System Parameters window (System > Utilities > System Parameters) and select Reload All Caches.