Introduction
This article explains how to resolve the Zero Date Prohibited error that can occur when running a MySQL extract in Kleene. In most cases, you can fix the issue by adding two extra parameters to the MySQL source configuration.
Issue description
A MySQL extract may fail with a Zero Date Prohibited error when the source contains date values that MySQL cannot handle in the current configuration. Updating the source connection settings usually resolves the problem.
Advanced troubleshooting steps
Step 1: Open the MySQL source configuration
In Kleene, open the MySQL source that is failing to extract.
Step 2: Add the extra parameters
Near the bottom of the source setup, find the Extra Parameters field and add the following value:
enabledTLSProtocols=TLSv1.2&zeroDateTimeBehavior=convertToNullStep 3: Save the source
Save the updated source configuration.
Step 4: Re-run the extract
Run the extract again to confirm that the error has been resolved.
Additional resources
If the extract still fails after updating the Extra Parameters field, review the source connection settings and confirm that the MySQL account has the required access and permissions. If needed, contact Kleene support for further assistance.