When upgrading the new 4.7 over an existing 4.x installation configured with SQL Server instead of the default DB, an error at the first login may occur. The case may be identified by the following error line in the Application logs:

Error | Database 'QueryCreateOrUpdateTable' action failed: Invalid column name 'subtype'.

Invalid column name 'specialtype'.

The problem is due to a batch of update queries not correctly compiled by SQL Server leading in a failure during the 4.7 database upgrade procedure.

The case can be fixed by simply running the attached SQL script over the application SQL Server database.