Solution  - Designer - "CU Lib ID was not found" Error When Saving a Design

Version 5

    Behavior

     

    When saving a design in Designer, this error occurs;
    "CU Lib ID was not found in the Workflow Manager CU Library. CU code='PW35-1', name='PW35-1'"

     

    CULibID.png

     

    Cause

     

    This error occurs because the CU in the error is not present in the MM_WMS_COMPATIBLE_UNIT_LIBRARY table in the Process Framework database. For every unique CODE in the MM_CU_LIBRARY table in the geodatabase, there must be a corresponding row with the same CODE in MM_WMS_COMPATIBLE_UNIT_LIBRARY.

     

    When this error occurs, the design will still save successfully, but when it is closed and re-opened, the description for the CU will show as (UNKNOWN CU LIBRARY ENTRY) in the design tab:

    designtree.png

      Once the CU is added to MM_WMS_COMPATIBLE_UNIT_LIBRARY the description will be correct.

     

    Solution

     

    Check for the CU in the CODE column in the MM_WMS_COMPATIBLE_UNIT_LIBRARY table. If it doesn't exist, a row will need to be added to MM_WMS_COMPATIBLE_UNIT_LIBRARY using SQL statements. Labor cost data for the CU will also need to be added to MM_WMS_LABOR_COST.

     

    Note: By default, managing compatible units and CU favorites is a manual process. Many clients have tools to automate this process. Please check with your administrator to see if your site has custom tools for CU management. If such a tool exists, use it to correct this missing CU issue.

     

    To add the CU data using SQL statements:

     

    1. Add a row in MM_WMS_COMPATIBLE_UNIT_LIBRARY. Use the columns in this table to create the INSERT statement.

     

    This table contains all of the CUs available in Designer.  Add a row in this table with the same information used when the CU was created in the CU Administration Tool.  Note: Make sure the CODE field matches the CODE that was used in the new CU that was created.

    ID

    A primary key for the CU. This field also acts as a foreign key for the MM_WMS_COMPATIBLE_UNIT table and MM_WMS_LABOR_COST tables.

    CODE

    The code used to identify the CU and its work function (e.g., PW40-1 = POLE WOOD 40ft CLASS 1). This value must exactly match the CODE for the CU as it appears in the CU Administration Tool.

    DESCRIPTION

    A description of the CU (e.g., POLE WOOD CLASS 1 40ft).

    MATERIAL_COST

    The dollar amount associated with purchasing this CU.

    SCRAP_VALUE

    The dollar amount associated with scrapping the CU when it is no longer in use.

    UNITS_OF_MEASURE_ID

    Refers to the ID field of the MM_WMS_UNITS_OF_MEASURE table.

    GIS_SYMBOLIZED

    Indicates whether the CU is symbolized or non-symbolized. 0 = not symbolized; any other value = symbolized.

     

    2. Add rows in MM_WMS_LABOR_COST for each work function. Use the columns in this table to create the INSERT statement.

     

    This table is used to calculate the costs associated with a design. Cost is assigned based on the CU and the work function.  A separate row is required for each work function for the same CU_ID that you want to have labor costs.  Example: If the CU can be Installed as well as Removed, then two rows must exist with the same CU_ID but with different WORK_FUNCTION_IDs (one for Install and one for Remove) and different COSTs to reflect the labor costs of Install vs. Remove.

    CU_ID

    This field refers to the ID field in the MM_WMS_COMPATIBLE_UNIT_LIBRARY table.

    WORK_FUNCTION_ID

    This field refers to the ID field in the MM_WMS_WORK_FUNCTION table.

    COST

    The dollar amount associated with performing the chosen work function for the CU.

     

     

    MM_WMS_WORK_FUNCTION is referenced to get IDs to use as the WORK_FUNCTION_ID value in MM_WMS_LABOR_COST.

    This table defines the available work functions for CUs. The following work functions are required and may not be removed without causing problems: Install (1), None (0), and Replace (-10). This table will not be updated. It will only be referenced for values to add rows to the labor cost table.

    ID

    The primary key for the work function.

    CODE

    A numeric identifier that represents the work function.

    NAME

    The name of the work function as it appears in the Workflow Manager user interface.

    APPLY_SCRAP

    Indicates whether scrap material will result from the work function. This value is used in determining design cost. 0 = no; any other value = yes.

    APPLY_MATERIAL

    Indicates whether material will be needed for the work function. This value is used in determining design cost. 0 = no; any other value = yes.

    ABBREVIATION

    Contains an abbreviation for the work function (e.g., Install = I, Remove = R). The abbreviations in this field should match those in the MM Work Function Abbr domain (visible in ArcCatalog Properties dialog).