compilation error

dsx_venkat · Post by **dsx_venkat** » Mon Sep 12, 2005 3:52 am

Hi all,

I am getting this error,

XFM050: Error when checking operator: When binding input interface field "EFF_DT" to field "EFF_DT": No default type conversion from type "string" to type "date".

But i checked through out the job, EFF_DT is of type DATE.

any idea why i am getting this error.

Thanks
venkat

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Sep 12, 2005 4:12 am

You have mapped a col defined as string (char or varchar) to a col defined as date. Check it in the transformer stage. You may need any conversion function.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 12, 2005 4:40 am

Check the schema associated with EVERY link. Somewhere there's a string data type. Otherwise you wouldn't have seen that particular error.

venkat n · Post by **venkat n** » Mon Sep 12, 2005 5:22 am

Sainathan Is correct, thats the mistake in transform
You have mapped a col defined as string (char or varchar) to a col defined as date. Check it in the transformer stage.

dsx_venkat · Post by **dsx_venkat** » Mon Sep 12, 2005 5:28 am

Hi all,

I have solved the problem, I just renamed the EFF_DT as EFF_DT_1, it got compiled,

But i have check through out the job, EFF_DT is a Date type, no way it can map to the string datatype, I dont know why it shouted like that.

any have thanks for your reply pals.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 12, 2005 3:34 pm

Do you have RCP enabled, and there's a string EFF_DT in a source schema?