2023-03 - NZQA - Assessments Opportunities Fix

Owned by Graham Kidd
Last updated: Mar 27, 2023

Fix updated to V70_20_1_8611_HotFixv70DSY23836NZQAStandardsLoad_DBPatcher.zip 13:00 27/03/2023.

Table of Contents

Overview of changes included in this hotfix package

NZQA have recently included Assessment Opportunities in their Standards Import file

An update to the Synergetic NZQA Standards Import functionality to handle this change was released recently (Version 70.20.4 and later) and this has been found to have an issue.

NZQA require that where a Standard does not have an Assessment Opportunity, that this is indicated by the value being a Null.  Currently these are being set to 0 and this is causing S15 errors to appear for standards that do not have/use Assessment Opportunities.

This issue is fixed by running the below script against NZ instances of Synergetic.


Obtaining and applying the hotfix

We have created a SQL fix for v70 release of Synergetic. 

1) Download the fix from the link below :

2) Open and run the patcher

  • Open the zip file and extract the included exe file to your SQL server (or to a location that is able to 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 database logic changes for this report.
  • The patcher can be applied with Users remaining logged in and will only take seconds to run

3) Once the patcher has completed successfully, your system should be updated and ready to correctly upload NZQA Standards

4) Re-import the latest NZQA Standards file via the NZQA tab of Students > Student Data Import/Export...

    This must be done to fix the Assessment Opportunities data in your system.

5) You are now ready to run the "Export Entries and Results File".  This time there should be no errors about Assessment Opportunity exceeding the maximum of zero


Requesting Assistance


As always, if you have any further questions or concerns, our Support team is available to assist:

Please make sure to mention that your query is in relation to the ‘NZQA Standards Assessment Opportunity not Null' fix as appropriate’ to help our support team action your request as efficiently as possible.