Some schools have suffered an error importing January results this morning. The error message says unknown object ExamConvert6. It was caused by 2 queries not building properly and can be solved by either updating to version 3.9.13 released 10th March 2010 or later, or by running the following two scripts in the Divers form, Script Runner tab.

CREATE VIEW dbo.ExamConvert5 AS SELECT DISTINCT

dbo.ExamBoardNo() AS Board, ExamCand, ExamCode4, ExamCode5, ExamCode6, ExamScoreType, ExamGrade, ExamScore, ExamUCI,

ExamUnitGrade

FROM          dbo.ExamConvert1

WHERE      (RecType = N'5')

CREATE VIEW dbo.ExamConvert6 AS  SELECT      dbo.Pupil.Pu_CandNo, dbo.Pupil.Pu_Surname + N' ' + dbo.Pupil.Pu_Firstname AS Candidate, dbo.ExamBoard.ExBoardIdent,

dbo.ExamConvert5.ExamScoreType, dbo.ExamConvert5.ExamGrade, dbo.ExamConvert5.ExamScore, dbo.Pupil.PupOrigNum,

dbo.ExamOption.OptionTitle, dbo.ExamOption.OptCode, dbo.ExamType.ExamTypeIdent AS EType, dbo.ExamConvert5.ExamUnitGrade

FROM          dbo.ExamConvert5 INNER JOIN

dbo.Pupil ON dbo.ExamConvert5.ExamCand = dbo.Pupil.Pu_CandNo AND dbo.ExamConvert5.ExamUCI = dbo.Pupil.PupUCI OR

dbo.ExamConvert5.ExamCand = dbo.Pupil.Pu_CandNo AND dbo.ExamConvert5.ExamUCI = ' ' INNER JOIN

dbo.ExamOption ON dbo.ExamConvert5.ExamCode4 = dbo.ExamOption.OptCode INNER JOIN

dbo.ExamBoard ON dbo.ExamOption.Board = dbo.ExamBoard.ExamBoardNo AND

dbo.ExamConvert5.Board = dbo.ExamBoard.ExamBoardNo INNER JOIN

dbo.ExamConvert6a ON dbo.ExamOption.ExamOpIdent = dbo.ExamConvert6a.Expr1 AND

dbo.ExamOption.Board = dbo.ExamConvert6a.Board INNER JOIN

dbo.ExamType ON dbo.ExamOption.ExamTypeQual = dbo.ExamType.ExamType