| Product(s): | Promis.e, Bentley Substation | ||
| Version(s): | through 08.11.13.57 | ||
| Environment: | N\A | ||
| Area: | Administration Features | ||
| Subarea: | Setup |
Error or Warning Message
When creating a parts database path on [[Setup]], the following error message or similar is displayed:
Warning
The field types for the following fields do not match and cannot be mapped:
Field Part_Number do not match to field Part_Number
Field IsEquipment do not match to field IsEquipment
Field Additional_Part do not match to field Additional_Part
...
Explanation
The software checks to make sure the properties of the fields/columns in the parts database being mapped match the project database fields to avoid potential problems when the data from the parts database gets copied to the project database during design work. The fields called out in the error message have been found to be the wrong data type or the wrong length.
How to Avoid
Compare the field properties in the parts database being mapped to a table supplied with the software and make changes accordingly.
If creating a parts database path to an Access-style .MDB file, compare the properties of the fields in question to the properties of the fields in the parts_database table of the ANSI-IEEE_parts_database.mdb or iec_parts_database.mdb file using Microsoft Access. These files are typically found in the Databases subfolder of the [[Promise Data folder]] and [[Substation Data folder]]. Vanilla versions of these files can be found in the [[Default Data folder contents|.zip file containing the default Data folder contents]] if necessary.
If creating a parts database path to a table in a SQL database, compare the properties of the fields in question to the properties of the fields in the parts_database table of the project database. This can be done using SQL Server Management Studio or by examining the "CREATE TABLE parts_database" section of the SqlServerProject.sql script file that creates the project database schema. The script can be found in the [[Program folder - promis.e|Promis.e program folder]] and in the [[Program Folder - Substation|Substation program folder]] on the workstation that has promis.e/Bentley Substation installed.
See Also
[[Converting to an SQL Parts Database]]
[[Creating and Updating the Project Database]]
| Original Author: | Matt_P |