Sets options for reporting all of the user classes (PartClasses), user interfaces (CustomInterfaces), and user attribute (Attributes) names that violate the Oracle length constraint in an MSSQL database. You can also correct these violations by taking inputs from a file that you specify. This dialog box identifies names that are prone to fail due to the Oracle 30-character limitation in the site, catalog, and model databases. It then writes that data into a Microsoft Excel workbook with each type of data on a work sheet.
Report
Indicates that the utility writes all of the user classes, user interfaces, and user attributes that violate the Oracle naming constraints for a database to an Excel workbook.
Update
Indicates that the utility updates the selected database with the truncated names.
Database Type
Displays the source database type. By default this is MSSQL. You cannot edit this value.
Server
Displays the name of the database server. All servers registered on the computer are available on the list.
Site database
Displays the site database name. All site databases on the Server are available on the list.
Site schema database
Displays the schema name for the Site Database.
Catalog database
Displays the catalog database name. All catalog databases on the Server are available on the list.
Catalog schema database
Displays the schema name for the Catalog database.
Report location
If Report is selected, this box displays the folder to which the utility writes the report. You can type the path, or click the browse button to navigate to the folder.
The software automatically generates a report file name based on the Catalog database value and the system time. For example, SM3D_v1200240000_CDB_08_08_2018_17_58_39.xlsx.
If Update is selected, this box displays the path and file name of the Excel workbook that contains the truncated names for the update. You can type the path and file name, or click the browse button to navigate to the file.
-
If you do not supply a value for this box, Smart 3D uses the system Temp location as the default.
-
Schema Name Validator uses the same system time for both the log file and the report file names.
Map file location
Displays the path and file name of an Excel workbook that has the Truncated Names column defined. This is an optional step. If you provide this file, the utility uses your inputs to add the truncated names to the output report.
You can type the path and file name, or click the browse button to navigate to the file.
Log file
Displays the path and file name of the log file. You can type the path, or click the browse button to navigate to the folder.
The software automatically generates a log file name based on the Catalog database value and the system time. For example, Chamfer_CDB_26_08_2018_18_23_45.log.
-
If you do not supply a value for this box, Smart 3D uses the system Temp location as the default.
-
Schema Name Validator uses the same system time for both the log file and the report file names.
Report/Update
-
Report
Starts the reporting process. When the process completes, the software writes a Report Generated.xlsx file to the folder specified in the Report location box.
-
Update
Starts the updating process. The software updates all of the model databases under the specified catalog. At the end of the process, the software regenerates views for the catalog database only. You must regenerate the views for the model databases.
Schema Name Validator makes the following verifications:
-
The database name in the Data Base Info row of each worksheet in the workbook must match the value in Site database or Catalog database. If there is a discrepancy, the software displays an error message.
-
Each value in the Truncated Names column must be unique on each work sheet. If there is a duplication, the software displays an error message.
-
The values in the Truncated Names column must meet the Oracle length constraints. Custom interfaces and attributes must be 30 characters or fewer. Part class names must be 23 characters or fewer. If there is a length violation, the software displays an error message.
-
The characters _, $, and # are not allowed at the start of a truncated name value, but they can exist elsewhere in the string. The characters ! and @ are not allowed in any part of the truncated name string. If these characters are present, the software displays an error message.
-
If the Truncated Names box is blank, the software skips that row and displays a warning message. You have the option to continue to the next value.
When the reporting or updating finishes, the software generates a log file. For more information, see Log File.
Cancel
Cancels the operation and closes the dialog box. The utility does not save any of the changes that you made to the dialog box.