How to Fix Folder ID Error Upon Performing Follow Page Connector and Update in OpenPlant PID SS10



Applies To 
Product(s):OpenPlant PID SS10
Version(s):

08.11.12.03

Environment: Windows 10 (64-bit)
Area: OpenPlant PID-ProjectWise Managed WorkSpace
Subarea: Follow Page Connector and Update
Original Author:Deepak Singh, Bentley Product Advantage Group

Background

For old drawing files coming from SS6 or lower version, even both the drawings are synced to the database, the Follow Page Connector and Update doesn’t work and prompt error message. Refer sample image as shown below.

In order to troubleshoot such issues, we need to explore the database table dbo.doc_reg and columns DCM_ID and PWV_ID. Due to NULL or blank value for these fields in database, application will prompt such message upon using Follow Page Connector and Update.

Steps to Accomplish

  1. Login to SQL database using SQLMS.
  2. Search for dbo.doc_reg table, right click on the table and pick Select Top 1000 rows as shown below.



  3. Arrange the database columns and inspect records for DCM_ID and PWV_ID. Notice that for both of the drawings, values are blank or NULL for DCM_ID and PWV_ID, refer image as shown below.



  4. In order to make Follow Page Connector and Update working, these fields must have correct value into it.
  5. To enter the correct values, load ProjectWise Client and go to Models file folder.
  6. Right mouse click on the Header and click on Manage Views. Refer image as shown below.



  7. Click on New to define a new Views as shown below.



  8. Enter desired view name, from Basic Columns include Object ID and from Folder Columns include Folder ID. Refer image as shown below.



  9. Click on OK, notice that in ProjectWise Explorer/Client these fields are populating values as shown below.



  10. If we compare it with SQL database of dbo.doc_reg table, we can conclude that

    PWV_ID is Folder ID &
    DCM_ID is Object ID.

  11. In SQL database, for dbo.doc_reg, edit the records w.r.t details in Folder ID and Object ID from ProjectWise Explorer. Refer image as shown below.



  12. Close the database and all open session of ProjectWise and OpenPlant PID.
  13. Load desired document file and perform Follow Page Connector and Update. Notice that it works properly and points to linked drawing file.

See Also

communities.bentley.com/.../how-to-work-with-follow-page-connector-and-update-for-a-projectwise-managed-env-in-openplant-pid-ss10