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

Document ID : KB000087754
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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:
Cause type:
By design
Root Cause: Refer to description
Resolution:
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 :
N/A