Highest Return Code Encountered = '8'
Start : Wed Sep 24 14:00:04 2008 . Are you aComputer / IT professional?Join Tek-Tips Forums! Highest return code encountered = '12'. **** 11:51:06 FDL4818 FastLoad Terminated ----------------------------------- 0 Kudos Reply All forum topics Previous Topic Next Topic 6 REPLIES feinholz Teradata Employee Mark as New Bookmark Register now while it's still free! this contact form
BTEQ will return an 8. If it still does not work, you need to check following points:- Is the table DDL exactly same in both systems/environments- Is the data file being used same for both systems/environmentsHTH.Regards,Adeel Does anyone know what it can be, and more importantly how to fix it? Statement# 1, Info =0 *** Total elapsed time was 1 second.
Highest Return Code Encountered = '8'
RE: Help Fast Load Problem dnoeth (Instructor) 5 Jun 03 03:29 You have to remove all but the first (the data starts with a '|') delimX fields:set record vartext "|";definedummy(varchar(1)),EmpNo(varchar(9)),Name(varchar(12)),DeptNo(varchar(3)),PhoneNo(varchar(4)),JobTitle(varchar(12)),Salary(varchar(9)),YrsExp(varchar(2)),DOB(varchar(11)),Sex(varchar(1)),Race(varchar(1)),MStat(varchar(1)),EdLev(varchar(2)),HCap(varchar(2))That's it Also there is a way to specify a different return code to it.. August 22, 2013 at 4:28 PM Anonymous said... The exit code at the end of the job is the highest level of error that occurred during execution of the job, and may not represent the level of errors or
Thanks for sharing usefull information.. Highest Return Code Encountered = '12' which is pretty standard SQL for a script to drop the table before it creates it. Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. http://community.teradata.com/t5/Tools/Fastload-Logtable-error/td-p/59512 CheckTable PendingOpinspects the table header to find these persistent utility locks. 0 Kudos Reply Teradata Links Teradata.com Teradata Partners Support & Forums Support Portal / TaYS Teradata Aster Community Communities
here is the script ------------------------------------------------ SESSIONS 4; ERRLIMIT 25; LOGON VIVALDI/username,password; DATABASE MY_DB; /* START IMPORTING FROM LINE 2 */ RECORD 2; /* DATA IS DELIMITED BY A | */ SET Make shure that there's no linebreak after the last record.If that doesn't help:drop the table, drop the error tables, submit a DELETE FROM sysadmin.fastlogIf it's still not working, then i can't RE: Help Fast Load Problem cici (MIS) 3 Jun 03 19:19 Try to use SET RECORD VARTEXT;instead of UNFORMATTED RE: Help Fast Load Problem mpramods (TechnicalUser) (OP) 4 Jun 03 10:39 Community Teradata Community Browse Register · Sign In · Help Fastload Logtable error Tools All communityThis categoryThis boardKnowledge baseUsers turn on suggestions
Highest Return Code Encountered = '12'
Showing results for Search instead for Did you mean: Teradata : Product Forums : Tools : Fastload Logtable error Options Subscribe to RSS Feed Mark Topic as New Mark Topic as This job cannot be continued or restarted. =================================================================== = Highest Return Code Encountered = '8' I have a tried searching, but I can't see any reference to this error anywhere. Enter your logon or BTEQ command: .quit; .quit; *** Exiting BTEQ... *** RC (return code) = 8 If you run the above script without the failure you will get a '0'
Teradata keeps track if a table had already begun to be loaded by a FastLoad process. 0 Kudos Reply td4007 N/A Mark as New Bookmark Subscribe Subscribe to RSS Feed Get weblink Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. I can see a field 'status' - with values 'loading init' in SYSADMIN.FASTLOG . Start : Wed Jun 20 11:50:23 2012 .
Highest return code encountered = '12'.**** 14:27:33 FastLoad Pausedcheers,Young chap 0 Kudos Reply All forum topics Previous Topic Next Topic 5 REPLIES Adeel_Chaudhry Teradata Employee Mark as New Bookmark Subscribe Subscribe Just out of curiosity.--Samir 0 Kudos Reply Fred Teradata Employee Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 03-20-2015 Different Teradata database error codes are assigned a specific return code value.The below table will give what different return codes are returned by BTEQ for different Error codes it receives from
Already a member?
End : Wed Jun 20 11:51:06 2012 . One row found. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. One column returned. *** Total elapsed time was 1 second.
I am trying using the Demo Version of Teradata and the fastscript is straight from the teradata demo documentation.Can anybody help me with what is the prolem here.When I run this Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page balasven Enthusiast Mark as New Bookmark Subscribe offcourse)?Lastly, can you provide the table DDL in Database, FastLoad script and sample data row causing problem?Regards,Adeel 0 Kudos Reply idontknow Enthusiast Mark as New Bookmark Subscribe Subscribe to RSS Feed his comment is here All Rights Reserved.
BTEQ -- Enter your DBC/SQL request or BTEQ command: sel count(*) from dbc.errormsgs; sel count(*) from dbc.errormsgs; *** Query completed. create table blort ..... Possible BTEQ return codes are as given below Return Code Description 00 Job completed with no errors. 02 User alert to log on to the Teradata Database. 04 Warning error. 08 Resubmit request.2837 Table being fast loaded; no data dumped.2838 Table is unhashed; no data dumped.2840 Data rows discarded due to inconsistent hash codes.2843 No more room in data base.2866 Table was
It could be as simple as a drop table blort; *** Failure 3807 Object 'blort' does not exist. Community Teradata Community Browse Register · Sign In · Help FAST LOAD ERROR Tools All communityThis categoryThis boardKnowledge baseUsers turn on suggestions Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Very useful information.
So, do i need to check for a specific status that would tell this fload is still active on a source table or just an entry in SYSADMIN.FASTLOG for a source Archives of the TeradataForum Message Posted: Fri, 08 Jan 2005 @ 04:12:19 GMT
Community Teradata Community Browse Register · Sign In · Help Fastload Script is Erroring out with the Highest error code='8' while Running a shell script Tools Count(*) ----------- 2473 BTEQ -- Enter your DBC/SQL request or BTEQ command: .logoff .logoff *** You are now logged off from the DBC. Be sure to check the job logs and error tables of completed jobs to identify any errors or warnings that may have occurred, so that you can determine whether or not Close this window and log in.