Troubleshooting - Intergraph Smart Engineering Manager - 2019 (10.0) - Help - Hexagon

Metadata Import Utility Help

Language
English
Product
Intergraph Smart Engineering Manager
Search by Category
Help
Smart Engineering Manager Version
10 (2019)

This section covers common problems and their solutions when using the Metadata Import Utility.

The following log files are generated when performing actions in the utility:

Log File Type

Purpose

Location

File Naming Convention

Trace log

Lists all ribbon bar messages generated during the current session

..\Users\<User Name>\AppData\ Local\Temp\Intergraph\MDI\TraceLogs\

MetadataImportApplication.log or MetadataImportApplication.<yyyy-mm-dd>.n.log where n is an integer

Validation report log

Describes in detail the data items that failed the import process

..\Users\<User Name>\AppData\ Local\Temp\Intergraph\MDI\Reports\

<Excel file name> - ValidationReport.log

Connection to Database

Problem: Message is displayed in the ribbon: 'Cannot connect to database.'

Cause 1: You do not have the correct permissions for connecting to the database.

Solution: Contact your database administrator to request permissions.

Cause 2: Database is unavailable at time of connection.

Solution: Check the database connection using the appropriate database tools.

Problem: Message is displayed in the ribbon: 'Install 32-bit OLEDB Driver on this machine.'

Cause: Microsoft Excel is not installed on the machine where you are running the utility.

Solution: Excel must be installed on the machine where the Metadata Import Utility is installed in order for the utility to work properly.

Importing the Excel File

Problem: Message is displayed in the ribbon: 'One or more of the header names in the Excel sheet is incorrect.'

Cause: The value in one or more of the headers in the Excel sheet has been changed.

Solution: Change the headers back to their original values or copy your data into a clean Excel file specially prepared for metadata import.

Problem: Message is displayed in the ribbon: 'One or more sheets are missing in the Excel file.'

Cause: One or more of the sheets in the Excel file is missing or its name was changed.

Solution: Change the sheet names back to their original values or copy your data into a clean Excel file specially prepared for metadata import.

Problem: Message is displayed in the ribbon: 'Product selected in Excel file for importing is different from product associated with plant.'

Cause: The product selected in the Table of Contents Excel worksheet is not associated with the plant to which the Metadata Import Utility is connected.

Solution: Select the correct product in the Excel file and then re-import the file.

Import Validation

Problem: Message is displayed in the ribbon: 'File imported with errors.'

Cause: File data does not match the data model.

Solution: View the errors in the validation report log file, then after correcting data values in the Excel file, re-import the file.

Save to Database

Problem: Message is displayed in the ribbon: 'Cannot save to database.'

Causes: Multiple

Solution: Check the database connection using the appropriate database tools. If this does not resolve the problem, send the trace log file to customer support.