ETLPro 5774 Error Writer: Rejected: Field: Mandatory field is missing

After ETL-Pro 5733 I have installed latest version 5774 today.

Now a simple data update job from Reader Excel to Writer MySQL throws ERRORS:
"Error Writer: Rejected: Field: Mandatory field ... is missing".

It looks like empty cells from Excel are causing this problem.
I remember we had such issues with earlier ETL releases already solved and it comes up again now.

Please advise.

Hello

If field is empty it must be treated as null.
There are several ways of addressing this problem.

You can replace null with some value using "Is Null" fuction
For example for number fields you can replace null with zero.

You can also use defauls as alternative.

If it is not clear I can post some screenshots later.

Peter

The Situation is:

Excel provides empty fields, meaning zero length strings.
DB requires not Null.

If "Database Default => Default" is set or not set does not solve the entire Problem.
The Default for number fields is aleady 0 and that's no Problem.
But a global solution is needed for empty text fields.

Since the table has over 80 colums, a manual operation for each would not be a good idea.

As it worked well with older ETLPro, I wonder what was changed and how to get back to former solution.

UDATE: Further tests:
ETLPro's setting "Database Default => Default" does not provide the real DB default value that is NOT NULL.
Must be an ETLPro bug.

Have you tried setting to default to two single quotes?

Like in the picture below

Yes, a blank space does it as well.

But as mentioned before: Since the table has over 80 colums, a manual operation for each would not be a good idea.

Anyhow the "Database Default => Default" bug should be fixed, to make it work like before again.

This one works



Mike