Clarity: Unable to find project in the Project List and if accessed via other means, all properties values are blanked out. Unable to Export Project List to Excel or open it in OWB/ MSP

Document ID : KB000051453
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The Project no longer displays in Project List or if accessed from another link, the project has lost its ID, Name, or other data. The project cannot be opened in either of the schedulers, MSP or OWB. Also, Export to Excel Hangs when exporting the Project List.

Solution:

The project does not display in the Project List View because the Project field INV_INVESTMENTS.LAST_UPDATED_BY holds the value -99 (minus 99). This may have been caused by unusual database activity (eg. closing the database whilst work is in progress) and where a -99 exists in the LAST_UPDATED_BY field of table INV_INVESTMENTS and the transaction may not have been completed.

  1. Run the following query to verify you are seeing the issue
    select id, name, code
    from INV_INVESTMENTS
    where last_updated_by=-99

    NOTE: If any results are returned, continue, if not, please contact support directly.

  2. The following query will resolve the issue: (the data is updated to a value of 1 which is the standard Clarity admin user)
    update INV_INVESTMENTS
    set last_updated_by=1
    where id=(select id
    from INV_INVESTMENTS
    where last_updated_by=-99)

Keywords: Project List, OWB, MSP, Excel, -99, last_updated_by, properties blank.