Technicians report not working "PERCENTILE_CONT is not a recognized built-in function name"

Question

Whenever I open technician reports, I get the error page. In the error log there's an error "'PERCENTILE_CONT is not a recognized built-in function name"

Answer

Jitbit Helpdesk (the self-hosted version) requires MS SQL Server 2012 or later.

If you have SQL Server 2012 but still get this error, it can be caused by your database migrated from an older version of SQL Server. Make sure the "database compatibility level" is set to "110" at least.

To set the database compatibility level using SQL Server Management Studio (SSMS):

  1. Connect to the appropriate server or instance hosting your database.
  2. Select the server name in Object Explorer.
  3. Expand Databases
  4. Right-click the database, and then select Properties.
  5. In the "Select a page" pane, select Options.
  6. The current compatibility level is displayed in the Compatibility level list box
  7. Change the level
Creation date: 10/4/2022 9:50 AM      Updated: 10/4/2022 9:50 AM
Solving problems with on-premise version of Jitbit Helpdesk ticketing system