Customer Information: Access Denied when applying update

If you see an Access Denied message when applying updates please see and raise a ticket if you need further help. Thank you.

 Error: 'Subqueries are not allowed in this context..'


A small number of users are reporting an error when launching 4Matrix which reads: '4Matrix experienced a problem updating the database. Subqueries are not allowed in this context, only scalar expressions are allowed'.

This error is related to SQL 2005. 4Matrix now uses SQL code which is not supported by SQL 2005 and this was unknown to us at the time of release. We have not supported SQL 2005 for some time and so it was not tested with this version. Schools that experience this problem will need to update to a newer version of SQL and instructions can be found at this link. Please get in touch if you require help with this process.

Was this article helpful? yes / no

Powered by Help Desk Software HESK, in partnership with SysAid Technologies