Solution - Designer - CU Favorites not Available in Work Function Tool and Template Favorites

Version 7

    Behavior

     

     

    In the Work Function Tool, when selecting an Install or Remove CU in the Select Install CU or Select Remove CU dialog, the CU does not appear in the selection list even though the work functions are set correctly on the CU. This also occurs in the CU prompt dialog when using a CU Template Favorite.

    Remove.png

     

     

    Cause

     

    This is caused by bug MM52947. If a feature or object class does not have any subtypes, a SUBTYPE of -1 is set in the MM_CU_LIBRARY table for the CU when it is created. This value should be 0. When a favorite is created from this CU, it contains this -1 SUBTYPE value. The Work Function Tool and Template Favorite CU prompt dialog are searching for a SUBTYPE value of 0, so these CUs are not shown in the selection dialogs of each tool.

     

    Workaround

     

    This bug is fixed in the next ArcFM release. A patch is available for ArcFM 10.1 for this issue. Patches are not currently available for later releases. Once the patch is installed, SUBTYPE values will be saved as 0 when creating a new CU in the CU Administration tool for feature or object classes without subtypes. The patch does not fix existing CUs in MM_CU_LIBRARY or CU Favorites. They will need to be repaired manually. It will be best to handle this in a Technical Support case.

     

    To see whether the issue exists in your data, run the following SQL query to check for the incorrect SUBTYPE:

     

    For an Oracle database:

    SELECT

      CODE, TABLENAME, SUBTYPE, NAME, DESCRIPTION, OBJECTID, ID

    FROM

      SDE.MM_CU_LIBRARY

    WHERE

      SUBTYPE = -1 and TABLENAME is not NULL and length(TABLENAME) <> 0

    ORDER BY

      CODE, TABLENAME

     

    For a Microsoft SQL Server database:

    SELECT

      CODE, TABLENAME, SUBTYPE, NAME, DESCRIPTION, OBJECTID, ID

    FROM

      SDE.MM_CU_LIBRARY

    WHERE

      SUBTYPE = -1 and TABLENAME is not NULL and len(TABLENAME) <> 0

    ORDER BY

      CODE, TABLENAME

     

    If the query returns any results, these CUs will have to be updated to set the SUBTYPE to 0. Any CU Favorites that were created from these CUs will also have to be updated. Please contact Schneider Electric Technical Support to open a support case to repair this data.