UTY2813 Error limit exceeded while processing record number
When i try loading data(Arabic-Unicode) using informatica from teradata to teradata with (Teradata_Tpump_Upsert) and staging 'ON' i get the below error. In the intermediate file i can see the arabic data but finally the workflow fails with the below error. I did contact the informatica support team and they say it could be the problem with the loader....and they could not say what could be the error. Have any one of you come across such an error?If so can you please guide me on solving the same.
0016 /* End Import Section */ .END LOAD; **** 14:27:04 UTY6609 Starting to log on sessions... **** 14:27:04 UTY6610 Logged on 1 sessions. ======================================================================== = = = TPump Import(s) Beginning = = = ======================================================================== **** 14:27:04 UTY6630 Options in effect for following TPump Import(s): . Tenacity: 4 hour limit to successfully connect load sessions. . Max Sessions: 1 session(s). . Min Sessions: 1 session(s). . Checkpoint: 0 minute(s). . Errlimit: 1 rejected record(s). . Restart Mode: SIMPLE. . Serialization: OFF. . Packing: 5 Statements per Request. . StartUp Rate: UNLIMITED Statements per Minute. **** 14:27:04 UTY6608 Import 1 begins. **** 14:27:04 UTY2813 Error limit exceeded while processing record number 2, ending load. ======================================================================== = = = Logoff/Disconnect = = = ======================================================================== **** 14:27:04 UTY6215 The restart log table has NOT been dropped. **** 14:27:04 UTY6212 A successful disconnect was made from the RDBMS. **** 14:27:04 UTY2410 Total processor time used = '0.15625 Seconds' . Start : 14:27:01 - FRI AUG 17, 2007 . End : 14:27:04 - FRI AUG 17, 2007 . Highest return code encountered = '12'.
Re: UTY2813 Error limit exceeded while processing record number
Hi, The informatica tool in the background is executing Teradata TPUMP script. If the specified no. of errors exceeds the limit specified in TPUMP, the mload will throw the errors. The uniqueness violation errors are not counted in errorlimit. So try by making the errorlimit 0. Then u can track the step by step actual errors.