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'
Want content like this delivered to your inbox? Sign up for our newsletter!
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 *