3ecommunications.net

Home > Return Code > Highest Return Code Encountered = '8'

Highest Return Code Encountered = '8'

Contents

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'

Any idea which tables contain this info. The Privacy Policy and Terms of Use for this Teradata website changed effective September 8, 2016. End : Wed Sep 24 14:27:33 2008 .

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 .

Expected: 84, Received: 45FastLoad - Enter your command:end loading;===========================================================End Loading Phase============================================================0011 end loading;**** 17:53:53 RDBMS error 2719: FASTLOAD END LOADING cannot be inside the Data Loading phase.The script is as follows:sessions Your use of this Teradata website is governed by the Privacy Policy and the Terms of Use, including your rights to materials on this website, the rights you grant to your Defined: 15, Received: 1280 =================================================================== = = = Logoff/Disconnect = = = ===================================================================**** 14:27:29 Logging off all sessions**** 14:27:33 Total processor time used = '1.15625 Seconds' . navigate here RE: Help Fast Load Problem mpramods (TechnicalUser) (OP) 4 Jun 03 16:26 Thanks cici and BillDHSfor answering my query.

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.

That should solve the fastload issue.To drop the error table just use drop table statement. 0 Kudos Reply balasven Enthusiast Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct All the required information regarding ERROR HANDLING using BTEQ is present in this blog, its really more useful.Nayak you did a great jobThank you very much August 5, 2011 at 10:51 The Privacy Policy and Terms of Use for this Teradata website changed effective September 8, 2016. Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free!

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 < Last>> Subj: Re: Return Code 8 See, if the directory where the files are, can be accessed from the directory from where you are invoking the fastload. I have the script and input flat file listed above.Thank you very much,mpramods.

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.

The target table is still empty.**** 10:32:14 DEFINE Syntax Error**** 10:32:14 Invalid column type for column: DELIM0Only VARBYTE, VARCHAR or LONG VARCHAR column typessupported for Variable-Length Text record type===========================================================*** 10:32:15 Total Resources Join | Advertise Copyright © 1998-2017 ENGINEERING.com, Inc. Registration on or use of this site constitutes acceptance of our Privacy Policy.