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.
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.
- Run the following query to verify you are seeing the issue
select id, name, code
NOTE: If any results are returned, continue, if not, please contact support directly.
- The following query will resolve the issue: (the data is updated to a value of 1 which is the standard Clarity admin user)
where id=(select id
Keywords: Project List, OWB, MSP, Excel, -99, last_updated_by, properties blank.