ArcFM Desktop Configuration Guide
Configure Schematics Script Attributes

Resource Center Home

Migration to version 10 can fail when your schematic dataset contains column names (field names) longer than 31 characters. Such messages include "Invalid column definition" and "exceeds the maximum column name length":

You must complete two steps to fix this problem. First, download and install the Schematics Migration Patch from Esri. This patch allows migration to complete successfully with warning messages—instead of failing outright:

Second, create script attributes to address the offending column names (which are attributes of a feature class) described in the green warning messages. The script attributes you create allow you to base the symbology and labeling of a feature class upon particular fields, which were previously too long for the migration tool to successfully process. In other words, schematic script attributes allow your field names to appear and function within the Symbology and Labels tabs of a feature's Layer Properties menu:

Follow this procedure to create schematic script attributes for every field for which a warning message was generated during migration:

  1. In ArcCatalog, right-click the new schematics dataset you migrated to version 10.x. and select Edit. The Schematic Dataset Editor opens.
  2. In the tree on the left, right-click the Node Schematic Feature Class related to the error and select New Attribute: 

    In the example above, the migration tool generated three instances of the same warning: 

    greeley.DBO.FiberOpticCable_CABLENAME : name too long for field storage.

    In this case, you must create a new script attribute for each warning. The new attributes must be placed in each of the three nodes containing the existing attributes about which the migration tool warned. Nodes in the following example are indicated in red, while the existing, offending attributes are indicated in green:

     
  3. Name the attribute with 31 or fewer characters (e.g., FiberCableName).
  4. Set the Type menu to Script.
  5. Set the Storage Mode to Field.
  6. Set the Evaluation Mode to On Generate/Update.
  7. In the Script box, type the parameter name (e.g., greeley.DBO.FiberOpticCable_CABLENAME) to assign that parameter value to the script attribute. This is the same as the field name referenced in the warning message.
  8. Click the green plus (+) sign button.
  9. Under Parameters, select the field to which the script attribute refers (e.g., greeley.DBO.FiberOpticCable_CABLENAME). This is also the same as the field name referenced in the warning message
  10. Click OK.
  11. Click Save . In ArcFM, you can now symbolize and label based on this field:
  12. Repeat this process for all attributes for which a warning message was generated.
  13. Return to the upgrade process.

 

 

Send Comment to ArcFMdocumentation@schneider-electric.com