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.
-
Create a SQL filter to load the parts associated to problematic spools into the Workspace. To create a SQL filter, follow the steps below.
-
Click Tools > Select by Filter.
-
Select a folder in the tree view to place the SQL filter.
-
Click New SQL Filter .
-
On the Filter Properties dialog box, type the name to assign to the SQL filter in the Name box.
-
Type the following SQL statement in the Text of SQL query box:
select oidDestination from xspoolhierarchy group by oidDestination having count(*) > 1
-
Click OK.
-
Select the new SQL filter.
-
Click OK.
The software loads all the parts and associated spools.
-
-
Click Delete to delete the redundant spools.
-
Regenerate the spools. To generate spools, follow the steps below.
-
Click Generate Spools .
-
Select the Spooling tab.
-
Select the pipelines, planning blocks, or WBS items to spool.
Use the WBS Item Type and WBS Item Purpose boxes to aid in the selection of WBS items to spool.
-
Select the Options tab.
-
Review the spooling options and edit, if needed.
-
Click OK.
-