2024-02 - SIF Relationship object is not created due to order of relevant events

Issue

When creating a new student in Synergetic via Future Student Maintenance and transferring to current students, sometimes the Student Contacts in SIF are not created because the objects are not created in the correct order of dependency. e.g. StudentContactRelationship depends on StudentContact existing which in turn depends on StudentPersonal.

This has created problems at some schools as their SIF data does not reflect all the data in Synergetic correctly which in turn impacts their integrations with other systems.

Fix

1. Download the fix from the link below

2. Save to a location of your choosing, that you can access from your SQL Server

3. Open and run the patcher

   • Open the zip file and extract the included exe file to your SQL server (or to a location that can communicate with the SQL Server)

   • Run the exe - this will run a database patcher wizard which will take you through the steps to apply the fix to the database 

   • The patcher can be applied with users remaining logged in to the system, and will only take seconds to run