Empower project is missing from Empower 3 Configuration window - WKB207937

SYMPTOMS

• Project missing from Empower 3 Configuration 
• Project info table does not show the missing project
• The project was not deleted by the Empower user
• The data is present on the Empower file server

ENVIRONMENT

• Empower 

CAUSE

Project updates are done by a delete statement followed by an insert statement, instead of with a single update statement. 

If the connection to the database was lost while Empower was updating project information, the information about the project was lost, causing the project to be inaccessible.

FIX or WORKAROUND

CRI-3787 was raised for this issue, A fix is implemented in Empower 3.8.0.

ADDITIONAL INFORMATION

A projectinfo is deleted and then inserted when:

1. Project properties are updated.
2. Child project properties are updated when parent project properties are updated.
3. NuGenesis project archive properties are updated.
4. The last archived data in a backed-up project is updated.
5. A restored project is updated.