Spool has parts that are related to multiple spools - Intergraph Smart 3D - Administration & Configuration - Hexagon

Intergraph Smart 3D Database Integrity Administration

Language
English
Product
Intergraph Smart 3D
Subproduct
Database Integrity
Search by Category
Administration & Configuration
Smart 3D Version
13.1

Message

Spool has parts that are related to multiple spools.

Severity

High

Detailed Description

A part should be related to a single spool, but in this case the part is related to multiple spools.

Possible Cause

Attempting to generate spools from two different locations simultaneously.

Possible Impacts

3D model data documents cannot be published successfully.

What You Should Do

Check the database integrity report for the problematic spool OIDs, and follow the procedure below.

  1. Create a SQL filter to load the parts associated to problematic spools into the Workspace. To create a SQL filter, follow the steps below.

    1. Click Tools > Select by Filter.

    2. Select a folder in the tree view to place the SQL filter.

    3. Click New SQL Filter .

    4. On the Filter Properties dialog box, type the name to assign to the SQL filter in the Name box.

    5. Type the following SQL statement in the Text of SQL query box:

      select oidDestination from xspoolhierarchy group by oidDestination having count(*) > 1

    6. Click OK.

    7. Select the new SQL filter.

    8. Click OK.

      The software loads all the parts and associated spools.

  2. Click Delete ICON Remove to delete the redundant spools.

  3. Regenerate the spools. To generate spools, follow the steps below.

    1. Click Generate Spools .

    2. Select the Spooling tab.

    3. Select the pipelines, planning blocks, or WBS items to spool.

      SHARED Tip Use the WBS Item Type and WBS Item Purpose boxes to aid in the selection of WBS items to spool.

    4. Select the Options tab.

    5. Review the spooling options and edit, if needed.

    6. Click OK.