Skip to main content

KTA Management Console: 'DATEDIFF_BIG' is not a recognized built-in function name.

Article # 3038316 - Page views: 296


 After upgrading to KTA 7.10, and trying to access the new KTA Management Console in the Workspace, the following error is shown:


'DATEDIFF_BIG' is not a recognized built-in function name. 

Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

If you need technical assistance, reference action: GetArchivingWorkerTaskStats.


This error is reported for the majority of forms within the Management Console.



DATEDIFF_BIG' is a function which was added with SQL 2016 and the Management Console is accessible where KTA is installed against SQL 2016 and above;


The error only occurs where KTA is installed against SQL 2012 and therefore this is a known issue which will be addressed in KTA v7.11.


Based on the KTA 7.10 technical specifications, SQL 2012 is still supported:



This issue will be addressed in KTA v7.11.


Level of Complexity 



Applies to  

Product Version Build Environment Hardware
Kofax Total Agility 7.10      


Add any references to other internal or external articles


Article # 3038316
  • Was this article helpful?