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
Fatal error while using TPT connector at source levels
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 28
- Joined: Sat May 03, 2008 3:57 am
- Location: chennai
Re: Fatal error while using TPT connector at source levels
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.
Resolution
Teradata data type ,
NUMERIC(p,s) is equal to DECIMAL NMUMRIC in WS DS SQL Data type.
Re: Fatal error while using TPT connector at source levels
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?
Grant Dever
Programmer Analyst Sr
Programmer Analyst Sr