...
V70_21_1_8609_HotFixv70DSY23836NZQAStandardsLoad_DBPatcher.zip
- Save to a location of your choosing, that you can access from your SQL Server
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) The issue You should now be resolved.6) You can run this SQL to confirm the issue is repaired:
| Code Block | ||||
|---|---|---|---|---|
| ||||
select AssessmentOpportunities, count(*)
from SubjectAssessmentNCEAStandards
where fileyear = 2023
group by AssessmentOpportunities |
There should be no AssessmentOpportunities counted for 0.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:
...