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

Intergraph Smart 3D Project Management

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
Version_S3D
10.1(2014R1)

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 using ViewGenerator.exe. Make sure that the updated view is generated in catalog and model database.

  9. Regenerate the report database.