Project (or subproject) no longer displays in Project List or if accessed from another link, the project has lost its ID, Name, or other data. The project will appear to be 'empty'. You will also be unable to open the Project using any scheduler (Microsoft Project or Open Workbench).
On Premise Customers: Test these statements in a non-production copy of the database before implementing in production.
These query statements will execute in Oracle or MSSQL.
Be sure to 'commit' the update statements for the changes to take effect.
Project field SRM_PROJECTS.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 SRM_PROJECTS a transaction may not have been completed.
- Run the following query to verify you are seeing the issue this resolves:
select id, name, unique_name
where last_updated_by = -99
If any results are returned, continue, if not, please contact support directly
- The following query will update the field to user record 1 which is the stock 'admin' user record ID:
where id= ' nnnnnn '
Where nnnnnn is the project id obtained from the first query. You can also verify that the id by also looking at the URL when you try and access the project, the URL will contain the id.
- Also, run the following additional query to check the INV_INVESTMENTS table data to see if any records are affected by the -99 value:
select id, name, code
- The following query will update the field to user record ID = 1 which is the stock 'admin' user record ID :
where id=(select id
Be sure to 'commit' the changes, go back into the application and look for the investment again.