Solution - Designer - Design Does Not Open Due to "End element was missing the character '>'." Error

Version 14

    Behavior

     

    When attempting to open a design, the design does not open, and all of the buttons on the Designer Workflow Manager toolbar in ArcMap are disabled. ArcMap must be closed and restarted. The following error messages are written to the Miner event log:

     

    2015-07-30 12:42:39,900 [1] ERROR [(null)] - Designer Workflow Manager:

    mmWorkflowManager.clsWFMExtension::IMMWorkflowManager_OpenDesign

    mmWorkflowXml.clsDesignerXmlDN::IMMPxXml2_Export

    mmWorkflowXml.clsDesignerXmlDN::GetDNElement

    End element was missing the character '>'.

    Error at line: 140 - Build: 10.21.1102

    Error at line: 990 - Build: 10.21.1102

    Error at line: 887 - Build: 10.21.1102

    {log4net:HostName=COR-PDSN10AP-03, LoggingAssemblyFileVersion=10.21.10.1102}

     

    2015-07-30 12:42:39,900 [1] ERROR [(null)] - Designer Workflow Manager:

    mmWorkflowXml.clsDesignerXmlDN::IMMPxXml2_Export

    mmWorkflowXml.clsDesignerXmlDN::GetDNElement

    End element was missing the character '>'.

    Error at line: 140 - Build: 10.21.1102

    Error at line: 990 - Build: 10.21.1102

    {log4net:HostName=PT-830360, LoggingAssemblyFileVersion=10.21.10.1102}

     

    2015-07-30 12:42:39,900 [1] ERROR [(null)] - Designer Workflow Manager:

    mmWorkflowXml.clsDesignerXmlDN::GetDNElement

    End element was missing the character '>'.

    Error at line: 140 - Build: 10.21.1102

    {log4net:HostName=PT-830360, LoggingAssemblyFileVersion=10.21.10.1102}

     

    Cause

     

    This is caused by an incomplete XML string being written to the DB_WORKSPACE_PROPERTIES column in the MM_WMS_DESIGN table for the design. This is due to the DB_WORKSPACE_PROPERTIES column not having sufficient length to contain the entire XML string.


    Solution

     

    Increase the length of the DB_WORKSPACE_PROPERTIES column and repair the data using the following steps:

     

    1. Increase the length of the DB_WORKSPACE_PROPERTIES column in the MM_WMS_DESIGN table using SQL statements appropriate for the Microsoft SQL Server or Oracle database. Note: Be sure to back up the MM_WMS_DESIGN table before increasing the column length. Increase it enough to provide for the length shortfall found in the results of the query in step 2, plus some extra length for safety. The column can be lengthened with direct SQL statements since the table is not registered as versioned and the column is not a key or indexed.

     

       2.  Run this query to find any designs with incomplete XML in the DB_WORKSPACE_PROPERTIES field:

     

    select

      ID,

      NAME,

      WORKSPACE_DB_PROPERTIES

    from

      PROCESS.MM_WMS_DESIGN

    where

      WORKSPACE_DB_PROPERTIES not like '%BASE>'

     

       3.  Run a SQL update statement to add the missing portion of the XML for each of the designs found in step 2.

            For example, if the current incomplete contents of DB_WORKSPACE_PROPERTIES contains a string with ">" missing from the closing </DATABASE> tag

    as shown here:

     

    <DATABASE LOCATION="Remote"><SERVER>GIS_SVR</SERVER>

    <INSTANCE>sde:sqlserver:GIS_SVR</INSTANCE>

    <USER>Adams</USER><DBVERSION>ADAMS.WR38552_DN36457</DBVERSION>

    <DBNAME>ACD_GIS</DBNAME><AUTHENTICATION>DBMS</AUTHENTICATION></DATABASE

     

    Correct the XML with a SQL update statement:

     

    update PROCESS.MM_WMS_DESIGN set DB_WORKSPACE_PROPERTIES = '

    <DATABASE LOCATION="Remote"><SERVER>GIS_SVR</SERVER>

    <INSTANCE>sde:sqlserver:GIS_SVR</INSTANCE>

    <USER>Adams</USER><DBVERSION>ADAMS.WR38552_DN36457</DBVERSION>

    <DBNAME>ACD_GIS</DBNAME><AUTHENTICATION>DBMS</AUTHENTICATION></DATABASE>' where ID = <ID of design>