Skip to main content
OutSystems

CONCAT is not a recognized built-in function name

Problem

After upgrading to OutSystems 10, when creating/upgrading the database in the Configuration Tool, sometimes the following error shows up:

"Database Error: Database error - 'CONCAT' is not a recognized built-in function name"

This happens when using SQL Server 2008 or SQL Server 2008 R2 as database management system, because one of the Configuration Tool database creation scripts (runtimemodel_sqlserver.sql) has a CONCAT function, but the CONCAT function only exists since SQL Server 2012.

Resolution

As a workaround, the database creation script can be edited to adapt to SQL Server 2008 by following these instructions:

  1. Access directory OUTSYSTEMS_HOME/Platform Server/db/ .
  2. Open the file runtimemodel_sqlserver.sql with a text editor (eg.: notepad, notepad++).
  3. Search for "CONCAT" in the file. You should find a code line that looks like this : SET [KEY] = NEWID(), NAME = CONCAT(NAME, 'X') 
  4. Replace the previously found line with this one: SET [KEY] = NEWID(), NAME = NAME + 'X'
  5. Save the changes and re-run the Configuration Tool

Please confirm that by following these steps you were able to overcome the issue.