DSXchange

Hi,

I designed a job and getting failed with this error message.

Fatal :
Teradata_Connector_115: [IIS-CONN-DAAPI-000034] An internal error has occurred (CC_DBSchemaRules::checkSizeDecimalSource, file CC_DBSchemaRules.cpp, line 1942)

Additional Information
------------------------
1>
Design is something like this ....

TPT conn ---> Transformer ----> TPT conn

Select statement at first TPT and then no Transformations at T and then insert statement ( I kept generate SQL as YES ) at second TPT.

2>
Fatal:
Transformer_125: Error when checking operator: Could not find input field "ETL_MDDS_ID".

3>
Warning:
Transformer_125: Error when checking operator: When binding input schema variable "APT_TRinput0Rec0": A transfer adapter is dropping the non-existent field "XXXX____ID".

Please post your views incase you came across such issues.

Thanks in advance.
friend.kak@gmail.com

Reason is Days worked --change float to decimal.

Resolution
Teradata data type ,
NUMERIC(p,s) is equal to DECIMAL NMUMRIC in WS DS SQL Data type.

Thank you! This helped me as well. Follow-up question, in the old Server edition you could view the data and it would also check to make sure the schema fit as well, but it does not appear to do that in PX. Is there any way to validate the schema in designer without running the entire job?