KB90866423: WebCenter - How to restore a deleted Project (SQL database)

Description

This article describes how to restore a WebCenter project that was accidentally deleted.

Procedure

We do allow executing certain queries in the Database so that you can read some of the values of the deleted project. You can then continue to create a new project and manually fill out the values from the original project. The steps below describe how to get information regarding Project Documents and Project Attributes.

Steps to find deleted documents in the FileStore

Access the WebCenter Database and perform the following steps: 

1.  Look up the project ID by executing the following SQL query:

   SELECT * FROM  [WebCenter4_0].[webcenter].projects where projectname like '%<project name of the project you try to restore>%'

2. You should see your deleted project in the list or returned records. Most likely, only one record will be returned, being the one of the deleted project. You find the project ID in the column ID.

3. Use the project ID in the following query:

   SELECT * FROM [WebCenter4_0].[webcenter].[project_documentsQ] where PFDV_Project_Id = '<project ID>'

    

4. You can now see a list of documents that were in the deleted project. For each of the documents that you want to restore, do the following: 

   1. Look at the V_encoded_name value. This is the encoded name of the document in the FileStore subdirectory.

   2. Look at the V_ID value. This is the document version ID of the document. Take the first 6 digits after the underscore.
      For example, if the document version ID is 0002_0000001040, you use 000000. This indicates the subdirectory in the FileStore\documents folder where the document resides.

   3. Locate the FileStore directory and use the encoded name to find the physical file for the document in the project. This document is the latest version of the document in the project.
      

   4. You can now re-upload this document to a new WebCenter project.

      Do not delete this document from the FileStore and do not rename it either. Copy the document to another directory, rename it to the original name and re-upload it to the WebCenter project.
      

Steps to find the Attribute values of the deleted project

If you want to know the Attribute values of the project, access the WebCenter Database and perform the following steps: 

1. Look up the project ID by executing the following SQL query:

   SELECT * FROM  [WebCenter4_0].[webcenter].projects where projectname like '%<project name of the project you try to restore>%'

2. Now execute the following query:

   SELECT * FROM [WebCenter4_0].[webcenter].[project_AttributeQ] where P_ID = '<project ID>'

3. In the Attr_Attributename column you will find the Attribute name and in the PATTR_Attr_Value column you will find the value of the Attribute.  
4. You can now fill the values of the Attributes in your newly created project.