The PLANNGAssemblyBase table is missing the ConnectivityInfo column - Intergraph Smart 3D - Administration & Configuration

Intergraph Smart 3D Database Integrity Administration

PPMProduct
Intergraph Smart 3D
PPMCategory_custom
Administration & Configuration
Version_S3D
12.1(2019)

Message

The PLANNGAssemblyBase table is missing the ConnectivityInfo 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 ConnectivityInfo 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.