Infor CRM 8.3.08 Introduces Duplicate Data to the APPIDMAPPING Table

During the upgrade to Infor CRM 8.3.08 the upgrade process introduces a duplicate APPID row into the APPIDMAPPING table. This is because the APPIDMAPPING table does not contain a unique constraint on the ID (shame, shame):

This results in the inability to manage the SData Sync Configuration.

You will also see similar errors popping up randomly throughout the web client.

In order to fix this you can run the following SQL scripts:

  update sysdba.appidmapping set appid='BADINFORBAD1' where name = 'Infor CRM' and ISSYSTEMENDPOINT is null 
  
  update sysdba.appidmapping set name='Infor CRM' where name = 'Saleslogix' and ISSYSTEMENDPOINT='T'
ABOUT THE AUTHOR

Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!