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

Version 5



    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'"






    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:


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




    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.


    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.


    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.


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


    The dollar amount associated with purchasing this CU.


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


    Refers to the ID field of the MM_WMS_UNITS_OF_MEASURE table.


    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.


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


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


    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.


    The primary key for the work function.


    A numeric identifier that represents the work function.


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


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


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


    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).