After logging in to HIE get error regarding ITEMSTATUS

Version 1

    Issue:

     

    Get this error page when analyst ID and password has been entered:-

     

    The page cannot be displayed
    There is a problem with the page you are trying to reach and it cannot be displayed.

    --------------------------------------------------------------------------------

    Please try the following:

    Click the Refresh button, or try again later.

    Open the www.nottinghamschools.co.uk home page, and then look for links to the information you want.
    HTTP 500.100 - Internal Server Error - ASP error
    Internet Information Services

    --------------------------------------------------------------------------------

    Technical Information (for support personnel)

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
    [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ITEMSTATUS'.
    /touchpaper_vega/hie.asp, line 31


    Fix:

     

    In Designer, create a new element ITEMSTATUS as an ID20 field.  Add this to the Support Analyst table.  Run an IISreset.