Licensed: After upgrading to Connect 9.1, Exception occurs when clicking on Meeting Tab

Problem Description:

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.

Resolution:

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.