The PLANNGAssemblyBase table is missing the BlobSize column - 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

The PLANNGAssemblyBase table is missing the BlobSize column.

Severity

Crucial.

Detailed Description

The implementation of Copy Similar functionality in V6 required the addition of several new tables in the Model and Catalog databases. The new tables are created in a V5 database during migration. The PLANNGAssemblyBase table does not have the new BlobSize field.

Possible Cause

Migration to V6 of a database created on an earlier version was not performed or was not successful.

Possible Impacts

The Copy Similar functionality will not work.

What You Should Do

  1. Run the Query Analyzer.

  2. Select the script that adds new columns to the PLANNGAssemblyBase table. The script location is: [Product Folder]\Planning\Server\Schema\Sql\VersionMigration\V5toV6\ UpdateAsmBaseTable.sql.

  3. Execute the script against the Model database.