I do have a following the below schema:
Code: Select all
ODBC ----> Transformer------>Join------>Destination
|
|
|
|
SeqFile
I am having two problems here:
First one, error when writing in destination (seq file):
The field is coming from the SeqFile, that is created in a previous job. Its a query coming from a ODBC Enterprise, then a Transformer do all transformation (no nulls, and timestamps and dates are converted to strings). I had to modify this job, so in its first execution, was not doing these transformations (so the fields were passed to the seqfile as dates)SIEACM24: Error when checking operator: When binding input interface field "FECHA_INI_ACM_CIF" to field "FECHA_INI_ACM_CIF": No default type conversion from type "date" to type "string[max=23]".
Error when checking operator: When binding input interface field "FECHA_FIN_ACM_CIF" to field "FECHA_FIN_ACM_CIF": No default type conversion from type "date" to type "string[max=23]".
PROBLEM2 (and I think this is the cause for everything)
This column is read from the ODBC, but left behind in the following transformer. Then, in Join, a column with same name is coming from SeqFile.Join: When checking operator: Dropping component "FECHA_INI_ACM_CIF" because of a prior component with the same name.
Before you shout on me to search the forum: RCP is disabled in my project.
Knowing this, how is it possible the column from the ODBC is reaching the Join stage?
Thanks very much!!!!