Equipment has DBL_UNDEFINED values persisted for CG value - Intergraph Smart 3D - Administration & Configuration

Intergraph Smart 3D Database Integrity Administration

Language
English
Product
Intergraph Smart 3D
Subproduct
Database Integrity
Search by Category
Administration & Configuration
Smart 3D Version
12.1 (2019)

Message

Equipment has DBL_UNDEFINED values persisted for CG value.

Severity

High.

Detailed Description

The equipment has Double, Undefined values persisted for the center-of-gravity (CG) values.

Possible Cause

The cause could be that the values of the CG properties (wet and dry) are persisted with the C/C++ definition for NULL instead of SQL NULL.

Possible Impacts

If the values of the CG properties (wet and dry) are persisted with DBL_UNDEFINED values instead of SQL NULL, any query that has these columns will cause an overflow error on SQL Server 2005.

What You Should Do

Run the Clean Database custom command, which updates the values of the CG properties with SQL NULL.