Missing Column 'dVolumeThicknessNeg' in table dbo.SHIPDWGScantlingByVolumeAE - 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 (2018)

Message

Missing Column 'dVolumeThicknessNeg' in table dbo.SHIPDWGScantlingByVolumeAE.

Severity

Fatal.

Detailed Description

For Scantlings by Volume to support different thickness values, a new persistent property is added.

A migration script is necessary to handle this change for existing Model databases. The migration script adds a new column named "dVolumeThicknessNeg" and sets its value the same as "dVolumeThickness". Also, this script modifies the GET and SET stored procedures.

Possible Cause

Database changes have occurred, and the migration to a higher version was not done or else failed.

Possible Impacts

New functionality will be unavailable. Attempts to use the Scantlings by Volume functionality will fail.

What You Should Do

The migration procedure should be performed. However, the script that was to be executed during the migration may be executed directly as follows:

  1. Run Query Analyzer.

  2. Execute the script (ShipDrawings\Server\Schema\SQL\VersionMigration\V6toV6.1\ODBScantlingByVolume.sql).