Licensed: After upgrading to Connect 9.1, Exception occurs when clicking on Meeting Tab
This occurs with licensed installations only. It does not apply to Hosted or ACMS customers.
After upgrading to Connect 9.1, some customers are experiencing a problem where they receive an exception message when they try to click on the Meeting tab in the menu.
A search in the error logs reveals messages like the following:
[11-04 16:27:05,613] http-80-25 (ERROR) Exception caught in DBRows.populate(), e=java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'b'.
In particular, note the “Incorrect syntax near ‘b'” part of the message. This is caused by differences in syntax compatibility in Microsoft SQL Server.
The problem can be fixed by setting the database compatibility level of the Connect database. Establish a connection to the Connect database on SQL Server (usually by using the SQL Server Management Studio), and run the following query:
sp_dbcmptlevel 'breeze', 90
If your Connect database is named something other than “breeze”, then put the correct name of the database in the query.