Modify the interface names of the target database - Intergraph Smart 3D - Administration & Configuration - Hexagon

Intergraph Smart 3D Project Management

Language
English
Product
Intergraph Smart 3D
Subproduct
Project Management
Search by Category
Administration & Configuration
Smart 3D Version
13.1

If any table name or column name exceeds 30 characters or starts with a numeric character, the software displays a warning message similar to the following example:

WARNING:

Invalid View Name: JCURTEPipingSpecialtyStockPartDataO

Identifier has too many (35) characters for Oracle

View for interface: JCURTEPipingSpecialtyStockPartDataO

Belonging to package: UDP

Cannot be generated

In this example, the interface name is more than 30 characters.

You can use the following procedure to change the interface names of the target database and resolve such errors:

  1. Preserve the interface IID or the OID of interface with the invalid name for conversion. You can get the IID using MetaDataBrowser.exe to connect to the catalog schema.

  2. Delete the interface using Bulkload.exe. Make sure that you have enabled the update object type hierarchy and catalog views in Bulkload.exe.

  3. Modify the InterfaceName to comply with the Oracle limitations. You can also modify the AttributeName, if required, as shown below.

    AttributeUserName and SymbolParameter must be the same as the source database interface properties.

  4. Modify the part class definition and part definition that implements the new interface to reflect the updated attribute names in the occurrence properties, as shown below.

  5. Update the GUIDs sheets for the updated interface and properties.

    • The GUID of the updated interface must be identical to that of the source database interface, as shown below.

    • The DispID of properties must not be changed.

  6. Bulkload the sheet in Add/Modify/Delete mode using Bulkload.exe. Make sure that you have enabled the update object type hierarchy and catalog views in Bulkload.exe. For more information about using the Bulkload.exe utility, see Loading Reference Data into the Catalog in the Smart 3D Reference Data Guide.

  7. When the bulkload process is complete, review the bulkload output log file, and verify that there are no failures related to the above changes.

  8. Regenerate the views for catalog and model. Make sure that the updated view is generated in catalog and model database. For more information, see View Generator.

  9. Regenerate the reports database.