Error 42000 Encountered When Exporting the Articles Report to Excel

about 14 years ago | Article no. 2314

0 ratings

THIS ARTICLE APPLIES TO:

Knowledgebase version 8.3.2 Hot Fix 1

ISSUE DESCRIPTION:

When exporting the "Articles" report to Excel, the following error is generated:
ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '1'.

ROOT CAUSE:

This is caused by an error in Knowledgebase version 8.3.2 Hot Fix 1.

SOLUTION OR WORK AROUND:

This error is fixed in Knowledgebase 8.3.2 Hot Fix 2. Updating to the latest version of Knowledgebase will resolve this issue.

AFFECTED SYSTEMS & USERS:

Administrators

ADDITIONAL INFORMATION:

ESCALATION PROCEDURE:

If you have trouble performing these steps, or have additional questions, please contact our Support group at 877-373-7848 (option 2) or via email at cimsupport@moxiesoft.com.