Error invalid query tree

You may receive the following error after upgrading:

Error in ………. : Invalid query tree [300-33]. The SQL error is 8180

If so, then please run the following script:

UPDATE ENPRISE_SECURITY
SET VERSION=999
WHERE APPLICATION=501

The version needs to be reset and the database needs to be updated again.

You can choose to either reset the version number for Eralis Job back to a known earlier version number or set the version to 999, then the system will rerun the database update. In order to reset the version number for Eralis Job, you will need to open the ENPRISE_SECURITY table and change the value in the VERSION columns for the row with the application ID 501.