Missing Column 'dTimeLastGenerated' in table dbo.SHIPDWGShellExpSy - 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 'dTimeLastGenerated' in table dbo.SHIPDWGShellExpSy.

Severity

Fatal.

Detailed Description

In order to support shell expansion drawings, 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 called “dTimeLastGenerated” and sets its value to "dTimeLastGenerated." 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

Shell expansion drawings in Ship Drawings will not appear correctly.

What You Should Do

  1. Run the Query Analyzer.

  2. Execute the following script: ShipDrawings\Server\Schema\SQL\VersionMigration\V6toV6.1\ODBShellExpSystem.sql.