ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Error using lisence check tool - 20160512/131750.550 - U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR ', '42000', 'Incorrect syntax near 'date'.'


Article ID: 87754


Updated On:


CA Automic Workload Automation - Automation Engine


Error Message :
U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR ', '42000', 'Incorrect syntax near 'date'.'

Error using lisence check tool - U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR ', '42000', 'Incorrect syntax near 'date'.'

This error message is related to SQL Server only.

Steps to fix & check:
  1. Download the newest version of the Usage Statistic Tool from the Automic download center.
  2. If the error still exists
  • Replace the string "date" in file¬†Automic_Agents_DB_Usage_sql.sql with date.
  • Load the script into the SQL Server Management Studio
  • Select the AE database engine
  • Open a SQl Query window
  • Copy the script¬†Automic_Agents_DB_Usage_sql.sql into the editor
  • Execute the script


Cause type:
By design
Root Cause: Refer to description


Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition


This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: Released

Fix Version(s):
Automation Engine 11.2.2 - already available

Additional Information

Workaround :