New thread type in holes database is not listed in Hole command

If you modified the holes database (eg. ...\Preferences\Holes\GOST Metric.xlsx) and newly added holes are not listed inside Solid Edge hole placement, it is possible that you inadvertently added syntactical errors, duplicated diameters, or made other such errors which are hard to find.

Solution

Solid Edge offers a tool to find such errors. It is the Hole Database Validation Tool in the Solid Edge Program folder. You execute it with a double-click on HolesDatabaseValidationTool.exe.

Here you add one or more holes databases, click debug and then view the report.

Here is an example of an output from running the tool:

Holes database debug report -
This report lists down all the errors found the holes database and the respective cell number which has the invalid value. You use the cell number to locate the cell in the Excel database.

GOST Metric.xlsx

Errors found - 1

   1.   Invalid value in thread type column. Only 1, 2, and 3 values are allowed.

        Threaded
        A625 A626 A627 A628 A629 A630 A631 A632 A633


With this information you can easily edit the identified problem cells in your holes database and ensure that you have a valid holes database with no errors.

Hardware/Software Configuration

Platform: INTL64
OS: windows
OS Version: 1064
Product: SOLID_EDGE
Application: PART/SHEETMETAL
Version: V220.0
Function: FEATURES

Ref: 002-8516559