Fault code 6648-4447-9000 - Error when Calculating Autumn 2020 School Census Return
When some Secondary based schools click the 'Calculate All Details' button within the School Census Autumn 2020 Return the following error occurs:
"Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in UNION ALL operator."
The issue arises because in the sims.census_pix_census_GetLearningAimsQans store procedure, the Programme Code field is fetched from two tables by using union all operator.
To resolve the issue site specific patch provided to change the programme code column of the table collation to SQL_Latin1_General_CP1_CI_AS
This issue has been escalated to development for a fix where a generic patch will be made available.
If you are experiencing this issue, please log a case with Keystone.
Patch 26031 will be made available in due course. The patch is currently undergoing a code review, followed by data testing.