Remove the existing PBS structure - SmartPlant Foundation - IM Update 48 - Help - Hexagon

If you are starting from a database that already contains the PBS structure, such as SPFADW (the delivered database for integration), you must remove the PBS structure before you can create a custom hierarchy. To remove the existing PBS structure from the SPFADW database, you can use the alternative PBS sample (SP Integration Alternative PBS (SPF.SPIntegration.AlternativePBS.zip)) available from Smart Community. For more information, see Find sample data on Smart Community.

The sample files are available as part of the SPF Sample data package and are located in the AlternativePBS\AdwDatabaseWithPBS folder. Load the RemoveExistingPBS.xmlldr file using the Loader in Desktop Client, this file references all the scripts that are required to remove the existing PBS.

Make sure the Query Scope is not defined before running the load files.

• You may need to edit the paths to the scripts in the RemoveExistingPBS.xmlldr file before you run it.

• The delivered files will remove the sample plants delivered with the SmartPlant Foundation sample data. They will not remove custom plants you have created in the site. However, once the PBS has been replaced, you will no longer be able to use any plants that existed with the previous PBS structure.

• If any of the plants or projects contain data, it needs to be removed prior to starting this process. If existing data is not removed, you will receive the following error when processing the 03-DATA_Remove_ProjectsAndPlants.xml file: "Cannot terminate configuration item because it contains at least one object or rel." If you receive this error, you must terminate any objects and relationships in the plant or project and process the XML file again.

1. To remove the PBS, run RemoveExistingPBS.xmlldr in the Desktop Client loader. When you load the file, the following scripts are loaded and run in the correct order:

   • 01-ADMIN_Remove_AreaAndUnit.xml

   • 02-DATA_Remove_AreasAndUnits.xml

   • 03-DATA_Remove_ProjectsAndPlants.xml

   • 04-SCHEMA_Remove_PBSGraphDefs.xml

   • 05-SCHEMA_Remove_PBSViewDefs.xml

   • 06-SCHEMA_Remove_AreaAndUnit.xml

   • 07-SCHEMA_Remove_PlantExpansionDefaultGraphDef.xml

2. If you receive the following message that the plant you are removing cannot be found, click OK.

   

3. Process the load files again.

4. After you load the files, log out of the Desktop Client, and recycle the Application Pools. For information on recycling application pools using the Microsoft IIS Manager, refer to your Microsoft IIS documentation.

This process may take several minutes to complete.