Why is only the place local PRP an option in Bentley Substation?

I cannot seem to place a "Master" Project Reference Point in Bentley Substation because the radio button is un-selectable.

Why is only the place local PRP an option? I am in the master 3D file... I've tried deleting any existing PRPs and starting over. I've tried hitting clear......
And while on the subject of PRP's... Why is placing an "X" in a file such a arduous & confusing process? IDK.... But any help would be greatly appreciated, Thanks.

Parents
  • Hi Jeff. The software sure seems to think the master PRP is already placed. That's the only reason I've seen for why the Master radio button is not selectable. To find the page it thinks the master PRP is on, you could query the database. One way to do this is to create a new report template using Report Template Designer and choose Customized By SQL Statement on the New Report Template dialog. Then paste the following into the window below Customized By SQL Statement:

    SELECT dbo.Description.name, dbo.Description.ownerId, dbo.Description.project_id, dbo.Page.name AS page, dbo.Page.fileName, dbo.Description.type
    FROM     dbo.Description INNER JOIN dbo.Page ON dbo.Description.ownerId = dbo.Page.id
    WHERE  (dbo.Description.name = 'MPRP') AND dbo.Description.type ='Page' AND (dbo.Description.project_id = @projectid) 

    Or you can use this query in SQL Server Management Studio. In that case you would need to replace "@projectid" with the actual Project.id value of the project, as seen in the first line of the ect.fid file.

    Hopefully this will direct you to the page from which you need to delete the existing master PRP.



  • Thanks for the reply Matt.
    Since we are running Bentley Substation from the client's server side, I think we are locked out of a lot of the back end stuff. Because when I tried to access the Report Template Designer from project manager a command protection message stated: "You do not have permission to use this function". And I don't have SQL Server Management Studio. So is there possibly another option to find out where this PRP is living? Doesn't placing the PRP create a locked level to place the reference point on?

    Jeff Getch

    Using Bentley Substation V8i SS7 v.- 08.11.12.137

  • Can you make a backup of the project? If so, you could restore it into your own system for investigation or upload it to us.

    Otherwise it seems that you would have to check every 3D Layout page for a PRP or ask your client to run the SQL query I provided.

    Or maybe the master PRP or page containing the master PRP was deleted yet due to some issue the data for the PRP remains in the database. In that case, direct access to the database data may be required to remove the record.



Reply
  • Can you make a backup of the project? If so, you could restore it into your own system for investigation or upload it to us.

    Otherwise it seems that you would have to check every 3D Layout page for a PRP or ask your client to run the SQL query I provided.

    Or maybe the master PRP or page containing the master PRP was deleted yet due to some issue the data for the PRP remains in the database. In that case, direct access to the database data may be required to remove the record.



Children
No Data