KTA Management Console: 'DATEDIFF_BIG' is not a recognized built-in function name.
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:
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