Upgrade bundled MSSQL driver to 11.2

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Unresolved
    • None
    • Component/s: Environment - Database
    • None
    • 2

      There is an intermittent issue, still to be diagnosed by Microsoft, where the bundled SQL Server driver can fail to properly communicate with the database.  

        This error affects multiple database versions, and is documented with SQL Server 2016 and SQL Server 2019.

      This error is seen in the logs, and the UI gives a 500 Internal Server Error:

      Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      Database:
      
      name:Microsoft SQL Server
      version:15.00.4395
      minor version:0
      major version:15
      Driver:
      name:Microsoft JDBC Driver 9.2 for SQL Server
      version:9.2.1.0
      
      com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid. Unexpected token unknown token (0xA3).  

      The solution is to update the driver to 11.2.  Here is the fix release for JDBC regarding the token error https://learn.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver16#fixes-in-112 .

            Assignee:
            Unassigned
            Reporter:
            Sarah A
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: