Problem / Solution: IEM import broken by an upgrade from 2017.2.1 to 2017.3.1 and now shows as type "Simple File Import"

Version 1

    Error message:

    N/A

     

    Problem:

    After upgrade from 2017.2.1 to 2017.3.1, any "IEM" data import connections will show as a "Simple File Import" and the correct options will not be available.

     

    Cause:

    A mapping in the connection table was changed to the new product name.  Instead of the product acronym IEM, it is now EPM.  This renaming also introduced a change in the expected value of a field in the database for this type of Data Import Connection such that the Data Import Connections dialog in the AdminUI no longer recognizes the type and defaults to "Simple File Import"

    Solution / Workaround:

    Run the following SQL statement on your HEATSM or IvantiSM database to update the Import Connection tables to have the new Import Type "EPM" for these import connectors.

    update Frs_def_integration_connection set Type = 'FRS.Integration.Connection.EPMConnectionDef' where Type = 'FRS.Integration.Connection.EMConnectionDef'

     

    After this is done refresh the AdminUI page and the Data import connections that were "IEM" prior to upgrade should show "EPM" and be usable once again.