About Date fields in Transformer

BCAPP · Post by **BCAPP** » Tue Sep 20, 2005 1:55 am

Hi,

I am facing a problem while mapping two date fields in the Transformer.
The Date fields LEAD_START_DATE and LEAD_EXPIRY_DATE have been defined as DATE 10. In the Transformer I'm moving these fields into two other date fields which are defined as DATE10.
But while compiling the job i get the below error.

##E TCOS 000003 02:49:57(000) <main_program> Syntax error: Error in "transform" operator: Error in operator arg: In field "LEAD_START_DATE": The schema type "date" does not take parameters "10,0"
In field "LEAD_EXPIRY_DATE": The schema type "date" does not take parameters "10,0"

##E TCOS 000029 02:49:57(001) <main_program> Creation of a step finished with status = FAILED. (djpCLWXFMLeadsBuildProcessV3.tfbUpdateFiles)

Please let me know what can be done about the same.

Thanks,
Bhavna.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 20, 2005 2:20 am

Don't fill in the precision or scale column when the SQL data type is Date.

BCAPP · Post by **BCAPP** » Tue Sep 20, 2005 3:27 am

Hi,

I removed the precision column and defined the fields as just DATE in the SQL type.But while compiling I got the below error.

##E TCOS 000003 04:22:57(001) <main_program> Syntax error: Error in "transform" operator: Error in operator arg: In field "LEAD_START_DATE": The schema type "date" does not take parameters "0,0"
In field "LEAD_EXPIRY_DATE": The schema type "date" does not take parameters "0,0"

##E TCOS 000029 04:22:57(002) <main_program> Creation of a step finished with status = FAILED. (djpCLWXFMLeadsBuildProcessV3.tfbUpdateFiles)

Any Solutions.

Thanks,
Bhavna

cmmurari · Post by **cmmurari** » Tue Sep 20, 2005 4:09 am

Hi

In transformer stage have you mapped correctly to date type field ?? Pls check, by right it should not give error. Should compile successfully.

pls try datetime data type in source and target and let me know.

Cheers,
Krish

Nripendra Chand · Post by **Nripendra Chand** » Tue Sep 20, 2005 5:59 am

I tried it using a tranformer. it worked fine without any error.

Regards,
nripendra

ray.wurlod · Post by **ray.wurlod** » Tue Sep 20, 2005 4:32 pm

Bhavna, it sounds like your attempt at removal has been interpreted as "replace with 0". Try re-loading the metadata from your Repository.

deployDS · Post by **deployDS** » Fri Feb 09, 2007 10:58 am

I encountered the same problem today and followed Ray's advice. It worked! Thanks Ray!