Skip to main content
Kofax

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

Article # 3038316 - Page views: 22

Issue

 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.

 

Cause

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;

https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-big-transact-sql?view=sql-server-ver15

 

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:

https://docshield.kofax.com/KTA/en_US/7.10.0-vmhad0mru4/print/KofaxTotalAgilityTechnicalSpecifications_EN.pdf

 

Solution

This issue will be addressed in KTA v7.11.

 

Level of Complexity 

Easy

 

Applies to  

Product Version Build Environment Hardware
Kofax Total Agility 7.10      

References

Add any references to other internal or external articles

 

Article # 3038316
  • Was this article helpful?