Data Integrity – Pre-admission CTF Import Issue – updated 19/07

19/07 – We have been advised by Capita that patch 24157 has been released. The patch adds check 99 to Tools | System Diagnostics | Database Diagnostics to identify definite and likely problems with a school’s contacts and contacts addresses that are likely to have been caused by the contact/address bug.  Normally, it is only checks that fail that Database Diagnostics displays in red, but this is not the case for check 99, as this is shown in red even if the check has passed in all cases. When the system identifies data that has been affected, it will only bring it to your attention, it will not revert the data back to its original form, you will need to make the changes manually. 

Database Diagnostics will need to be initiated by a user of SIMS for each school and as it is extremely resource intensive, we ask that you avoid running Database Diagnostics during school hours.

 

Hosted Schools – Patch 24157 will be applied for you on 19/07/2018

Non Hosted Schools – Patch 24157 has been made available for you in Solus 3 so that you can apply.  FAQ: Deploying Updates/Patches via Solus 3 Manually

 

If you wish to apply outside of Solus, please contact the Scomis Service Desk to request the patch.

 

21/06 – Patch 24068 to permanently fix the import bug has been run for all schools on the hosted platform and released on Solus 3 for non-hosted schools.

13/06 -12:00 Patch 23971 has been run for all schools on the hosted platform.

Capita have identified a bug in their software when CTF files for applicants are imported into a pre-admission group.  There are two issues:

  1. The first issue is it may incorrectly link an existing contact in the Sims database to an applicant in the CTF file if an existing contact has the same name and gender as the contact attached to the new applicant in the CTF file, even if the existing contact is not the same.

In addition it may change the existing contact’s address to match the address in the CTF contact’s details .  However, this only happens if ALL of the following is true:

  • The CTF has been imported using the option to “Add data for New Pupils only” or “General” AND
  • The option has been selected to “add the new pupil/s to a pre-admission group” AND
  • There is an existing contact in the Sims database that
    • Has the same name and gender as the applicant’s contact in the CTF file, AND
    • Has a different address to the one in the CTF.

Capita have issued Patch 23971 to fix the bug which we will run for all schools on our hosted platform.  This post will be updated when the patch has been run. Non-hosted schools, the patch has been released and will be deployed if you have set Solus 3 to automatic deployment.  For manual deployment through Solus 3 please follow this faq.

2. The second issue can be if the contact for the applicant in the CTF file does not have an address it won’t update the existing pupil’s address, but it may incorrectly link an existing contact to the CTF applicant.  Capita are developing a second patch to fix this issue.  This post will be updated when it is released.

Capita are in the process of developing a routine to help schools who may have already imported CTF’s under the conditions above to identify whether they have been affected by the bug.  They are also developing a patch to correct any incorrectly changed contact addresses.  We will update this post when the routine and patch are released.

Posted in Bulletin, Upgrades.