Solution - Designer - Design Does Not Open due to Stored Display Errors

Version 1

    Behavior

     

    When opening a design in Workflow Manager, the design does not open, and an error dialog may or may not be shown. Errors similar to the following are written to the Miner event log:

     

    Error 11/11/2015 7:37:36 AM ArcMap 0 None "2015-11-11 07:37:36,944 [1] ERROR  [(null)] - Workflow Manager Integration:
    mmWFMIntegration.clsOpenWFM.m_pWFMEvents_DesignOpened:
    MMDesignerAPI.MMDesignerImpl.IMMListTreeAsXML2_ListTreeAsDOM:
    Invalid procedure call or argument
    Error at line: 589 - Build: 10.21.1854
    Error at line: 960 - Build: 10.21.1854
    {log4net:HostName=W7WS2, log4net:UserName=MSMITH, LoggingAssemblyFileVersion=10.21.20.1854, log4net:Identity=}
    "
    Error 11/11/2015 7:37:36 AM ArcMap 0 None "2015-11-11 07:37:36,944 [1] ERROR  [(null)] - Schneider Electric Designer XML API Extension:
    MMDesignerAPI.MMDesignerImpl.IMMListTreeAsXML2_ListTreeAsDOM:
    Invalid procedure call or argument
    Error at line: 589 - Build: 10.21.1854
    {log4net:HostName=W7WS2, log4net:UserName=MSMITH, LoggingAssemblyFileVersion=10.21.20.1854, log4net:Identity=}
    "
    Error 11/11/2015 7:37:36 AM ArcMap 0 None "2015-11-11 07:37:36,934 [1] ERROR  [(null)] - Schneider Electric Designer XML API Extension:
    MMDesignerAPI.MMDesignerImpl.LoadDesignFromDom:

    {log4net:HostName=W7WS2, log4net:UserName=MSMITH, LoggingAssemblyFileVersion=10.21.20.1854, log4net:Identity=}
    "
    Error 11/11/2015 7:37:36 AM ArcMap 0 None "2015-11-11 07:37:36,934 [1] ERROR  [(null)] - Schneider Electric Designer XML API Extension:
    MMDesignerAPI.basXMLFunc.ConvertToDesign:
    MMDesignerAPI.basXMLFunc.LoadStoredDisplay:
    Invalid procedure call or argument
    Error at line: 1344 - Build: 10.21.1854
    Error at line: 519 - Build: 10.21.1854
    {log4net:HostName=W7WS2, log4net:UserName=MSMITH, LoggingAssemblyFileVersion=10.21.20.1854, log4net:Identity=}
    "
    Error 11/11/2015 7:37:36 AM ArcMap 0 None "2015-11-11 07:37:36,934 [1] ERROR  [(null)] - Schneider Electric Designer XML API Extension:
    MMDesignerAPI.basXMLFunc.LoadStoredDisplay:
    Invalid procedure call or argument
    Error at line: 1344 - Build: 10.21.1854
    {log4net:HostName=W7WS2, log4net:UserName=MSMITH, LoggingAssemblyFileVersion=10.21.20.1854, log4net:Identity=}
    "

     

     

    Cause

     

    This is due to there being an issue with the design stored display associated with the design. The design stored display may be corrupt, or cannot be loaded for some other reason. Design stored displays are saved with a design if the WMSDisableDesignStoredDisplay parameter is configured in the Process Framework Administration Tool. To check for this parameter, start the Process Framework Administration Tool, log in and select the Configuration tab. If the WMSDisableDesignStoredDisplay parameter exists and is set to 0, design stored displays are being saved with each design. If it does not exist or is set to 1, design stored displays are not being saved.

    It is possible that this parameter was set to save design stored displays in the past, but has been changed to currently not save them. In this case design stored displays will still exist and will be loaded for designs that were saved when the parameter was set to save them.

     

    Solution

     

    Rename the stored display in the MM_STORED_DISPLAYS table. This will allow the design to be opened without errors. Follow these steps to rename it:

     

    1. Start ArcCatalog and connect to the database.

    2. Select the MM_STORED_DISPLAYS table and find the row for the design store display. This example show a design numbered 955 for work request 185.

    StoredDisplaysTable.gif

    3. Using a SQL tool appropriate for the Oracle or Microsoft SQL Server database, set the NAME field in MM_STORED_DISPLAYS to a different value using the OBJECTID.  For the example above, the SQL statement could be:

     

    update MM_STORED_DISPLAYS set NAME = 'WR_185_DN_955_X' where OBJECTID = 71443

     

    4. Start ArcMap, open Workflow Manager and open the design. It should now open without the errors occurring.

    5. Save the design. This will save a new design stored display for the design in the MM_STORED_DISPLAYS table.

     

    Note: Any graphics that were originally in the design will be lost since they were saved in the design stored display. They will have to be re-created.

     

    6. Delete the row for original design stored display in the MM_STORED_DISPLAYS table. For the example above the SQL statement would be:

     

    delete from MM_STORED_DISPLAYS where OBJECTID = 71443