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
|Kofax Total Agility||7.10|
Add any references to other internal or external articles