Resolving issues after updating old installations to 23.0.3 or newer

Introduction

If you have an older installation (~4 years old or more) and have updated to 23.0.3 or 24.0.0, you may experience various problems and performance issues caused by some old malformed information still present in the DB. For example, scheduled AD synchronization may not start anymore.

Disclaimer: The instructions in the solution below assume you are using Microsoft SQL Server.

Solution

You can check if you are affected by running this SQL query on the EgoSecure database:

SELECT OSVERSION
  FROM AGENTS
  WHERE OSVERSION LIKE '%<PType>%';

If it returns any entries, you are affected by this issue. In this case, perform a backup of the DB, then run this script to correct the malformed data in the DB: SQL script .