This error occurs when the HandiSoft (HandiTax) data source fails to process because the installed version of HandiTax is out of date. Updating HandiTax to the current year version will usually resolve the issue.
Why Error 42000 occurs
Error [42000] Syntax error: Invalid keyword specification indicates that the HandiTax version installed on your system is not compatible with the version expected by Zap Data Hub.
This often happens when the HandiTax software has not been updated to the current year release (e.g., 2024, 2025, etc.).
How to resolve Error 42000
1. Check your HandiTax version
Confirm which version of HandiTax 20nn (nn = current year) is installed on your machine.
2. Install the latest HandiTax update
Download the most recent HandiTax release for your licensed year and install it on the server or workstation used by Zap Data Hub.
3. Reprocess the HandiSoft data source
After updating, reprocess the HandiSoft connector in Zap Data Hub to confirm the error is resolved.
Need assistance?
If the error persists:
Raise a support case
Reference the error code in this article in your ticket
Include details about the version of HandiTax installed
This will help support confirm compatibility and investigate further.