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.
This article is specific to Projects; but the concept can be used for NPIOS, Incidents, Cost Plans or any other table affected by the -99 symptom.
One root cause of this issue was fixed, however, if this symptom occurs again, please report to CA Support for root-cause determination.
The project does not display in the Project List View because the 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 and the transaction may not have been completed.
NOTE: These steps are provided with the understanding that the actions should be fully tested in a non-production system first for verification of proposed solution.
- Run the following query to verify you are seeing the issue
select id, name, unique_name
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 application 'admin' user)
where id=(select id