Coordinate System contains some Planes/Cylinders at same position - 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

Message

Coordinate System contains some Planes/Cylinders at same position.

Severity

High.

Detailed Description

Some Planes/Cylinders on the axis of the Coordinate System are at the same position.

Possible Cause

Unknown.

Possible Impacts

Unable to copy/paste the Coordinate System. Unable to edit those Planes/Cylinders.

What You Should Do

Change the Plane/Cylinder positions so they are unique on the axis.

To see all positions on a given axis, execute the following scripts for each reported Coordinate System. Replace '{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}' with the oid of the Coordinate System. The script will display Plane/Cylinder oid, name, and position.

  • For the X-axis:

    select entity.oid, namedItem.strName, entity.position from GRDSYSSPGGridPlane as entity
    join XXAxisCS as cs on entity.oid = cs.oidDestination
    join CORENamedItem as namedItem on namedItem.oid = entity.oid
    where cs.oidOrigin = '{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}';

  • For the Y-axis:

    select entity.oid, namedItem.strName, entity.position from GRDSYSSPGGridPlane as entity
    join XYAxisCS as cs on entity.oid = cs.oidDestination
    join CORENamedItem as namedItem on namedItem.oid = entity.oid
    where cs.oidOrigin = '{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}';

  • For the Z-axis:

    select entity.oid, namedItem.strName, entity.position
    from GRDSYSSPGElevationPlane as entity
    join XZAxisCS as cs on entity.oid = cs.oidDestination
    join CORENamedItem as namedItem on namedItem.oid = entity.oid
    where cs.oidOrigin = '{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}';

  • For the R-axis:

    select entity.oid, namedItem.strName, entity.position
    from GRDSYSSPGRadialPlane as entity
    join XRAxisCS as cs on entity.oid = cs.oidDestination
    join CORENamedItem as namedItem on namedItem.oid = entity.oid
    where cs.oidOrigin = '{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}';

  • For the C-axis:

    select entity.oid, namedItem.strName, entity.position
    from GRDSYSSPGRadialCylinder as entity
    join XCAxisCS as cs on entity.oid = cs.oidDestination
    join CORENamedItem as namedItem on namedItem.oid = entity.oid
    where cs.oidOrigin = '{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}';