All Forums Tools
azeem_sy 2 posts Joined 06/09
16 Jun 2009
TPT error

Hello,I am just getting familiarized with TPT and I was trying to load a table. I am using demo version 12. Everything seems to be fine with my script and everything else, but in job state it says: completed with unexpected status from tbuild (2)Can anyone assist me with this?Thanks,Azeem Syedbelow is the script:/* 1 */ /* 2 */ /* 3 */ DEFINE JOB Movie/* 4 */ DESCRIPTION 'Loading movie table'/* 5 */ (/* 6 */ DEFINE OPERATOR W_1_o_Movie/* 7 */ TYPE LOAD/* 8 */ SCHEMA */* 9 */ ATTRIBUTES/* 10 */ (/* 11 */ VARCHAR UserName, /* 12 */ VARCHAR UserPassword, /* 13 */ VARCHAR LogTable, /* 14 */ VARCHAR TargetTable, /* 15 */ INTEGER BufferSize, /* 16 */ INTEGER ErrorLimit, /* 17 */ INTEGER MaxSessions, /* 18 */ INTEGER MinSessions, /* 19 */ INTEGER TenacityHours, /* 20 */ INTEGER TenacitySleep, /* 21 */ VARCHAR AccountID, /* 22 */ VARCHAR DateForm, /* 23 */ VARCHAR ErrorTable1, /* 24 */ VARCHAR ErrorTable2, /* 25 */ VARCHAR NotifyExit, /* 26 */ VARCHAR NotifyExitIsDLL, /* 27 */ VARCHAR NotifyLevel, /* 28 */ VARCHAR NotifyMethod, /* 29 */ VARCHAR NotifyString, /* 30 */ VARCHAR PauseAcq, /* 31 */ VARCHAR PrivateLogName, /* 32 */ VARCHAR TdpId, /* 33 */ VARCHAR TraceLevel, /* 34 */ VARCHAR WorkingDatabase/* 35 */ );/* 36 */ /* 37 */ DEFINE SCHEMA W_0_s_Movie/* 38 */ (/* 39 */ MID INTEGER,/* 40 */ NAME_2 VARCHAR(100),/* 41 */ ACTOR VARCHAR(100),/* 42 */ GENERE VARCHAR(50),/* 43 */ RATING VARCHAR(20),/* 44 */ RELEASE_YEAR SMALLINT/* 45 */ );/* 46 */ /* 47 */ DEFINE OPERATOR W_0_o_Movie/* 48 */ TYPE EXPORT/* 49 */ SCHEMA W_0_s_Movie/* 50 */ ATTRIBUTES/* 51 */ (/* 52 */ VARCHAR UserName, /* 53 */ VARCHAR UserPassword, /* 54 */ VARCHAR SelectStmt, /* 55 */ INTEGER BlockSize, /* 56 */ INTEGER MaxSessions, /* 57 */ INTEGER MinSessions, /* 58 */ INTEGER TenacityHours, /* 59 */ INTEGER TenacitySleep, /* 60 */ INTEGER MaxDecimalDigits, /* 61 */ VARCHAR AccountID, /* 62 */ VARCHAR DateForm, /* 63 */ VARCHAR NotifyExit, /* 64 */ VARCHAR NotifyExitIsDLL, /* 65 */ VARCHAR NotifyLevel, /* 66 */ VARCHAR NotifyMethod, /* 67 */ VARCHAR NotifyString, /* 68 */ VARCHAR PrivateLogName, /* 69 */ VARCHAR TdpId, /* 70 */ VARCHAR TraceLevel, /* 71 */ VARCHAR WorkingDatabase/* 72 */ );/* 73 */ /* 74 */ APPLY/* 75 */ (/* 76 */ 'INSERT INTO VIDEO_OPERATION.movie_stg (MID,NAME,ACTOR,GENERE,RATING,RELEASE_YEAR) VALUES (:MID,:NAME_2,:ACTOR,:GENERE,:RATING,:RELEASE_YEAR);'/ * 77 */ )/* 78 */ TO OPERATOR/* 79 */ (/* 80 */ W_1_o_Movie[1]/* 81 */ /* 82 */ ATTRIBUTES/* 83 */ (/* 84 */ UserName = 'tduser', /* 85 */ UserPassword = 'tduser', /* 86 */ LogTable = 'VIDEO_OPERATION.movie_stg_log', /* 87 */ TargetTable = 'VIDEO_OPERATION.movie_stg', /* 88 */ TdpId = 'localtd'/* 89 */ )/* 90 */ )/* 91 */ SELECT * FROM OPERATOR/* 92 */ (/* 93 */ W_0_o_Movie[1]/* 94 */ /* 95 */ ATTRIBUTES/* 96 */ (/* 97 */ UserName = @TeradataSourceUser, /* 98 */ UserPassword = @TeradataSourcePassword, /* 99 */ SelectStmt = 'SELECT MID,NAME,ACTOR,GENERE,RATING,RELEASE_YEAR FROM VIDEO_OPERATION.movie2;', /* 100 */ TdpId = 'localtd'/* 101 */ )/* 102 */ );/* 103 */ );

azeem_sy 2 posts Joined 06/09
18 Jun 2009

anyone? i know tpt isnt really a well known tool but any help would be much appreciated

feinholz 1234 posts Joined 05/08
01 Jul 2009

Are you using the Wizard?Can you cut and paste and the script to a text file and run from the command line?One thing I see in your script is the use of Job Variables.I do not think the Wizard can handle job variables.If you want to email me outside of this forum list, we might be able to solve this faster.

--SteveF

19 Aug 2010

Gentlemen, did you find solution for this problem?

ratchetandclank 49 posts Joined 01/08
19 Aug 2010

The message "completed with unexpected status from tbuild (2) " shows that there is something wrong, but the information provided is not enough to point to the exact error. The presented TPT script looks fine with proper syntax.

Just a wild guess.. Error 2 (in windows) means file not found. Maybe one of the files required for the TPT execution may be missing. Installing TPT will create a bunch of files in the installation directory. One of them might be missing. Or the directory where the objects are installed may not have proper permissions. Trying a reinstall of TPT might solve the problem.

Posting the console and privatelogs would be useful for analyzing. As of now, the information presented is not enough for finding out the exact problem.

Darin 13 posts Joined 09/05
31 Aug 2010

The output of this should have given a jobid if it got that far. If it did you can use TLOGVIEW to view the job log and see more of a result set.

Darin 13 posts Joined 09/05
31 Aug 2010

I see you are using @TeradataSourceUser and @TeradataSourcePassword if these are not specified in the script then you have to pass them in a variable file.

tbuildexe.exe -f -v

Also the /* XXX */ is not part of the script.

augie 1 post Joined 05/09
25 Aug 2011

Does anyone know what is the actual error behind with "completed with unexpected status from tbuild (2)"?

I'm having same problem with TPT v13.10.

Thanks.

 

feinholz 1234 posts Joined 05/08
31 Aug 2011

Please provide platform and entire console output.

Are you using the Wizard to create the job script?

If so, then please try to save that script in text form (Wizard saves it internally in XML format) and try to run it from the command line.

 

--SteveF

tt255009 4 posts Joined 11/12
30 May 2013

Hi,
 
I am trying to LOAD a table with the following TPT scripts.
1.       ErrorLIMIT1 = 5
2.       ErrorLIMIT2 = 5
3.       Maxsessions = 1
4.       Minsessions = 1
5.       Loader_Instance = 1
I have a file with 10 UV Values for a single Key value e.g., for primary key = 2 there are 10 UV records. I expected TPT to fail but it did not. Can anyone explain this behavior? What is the scenario in which Errorlimit is used by TPT and it fails.
 
Thanks

tt255009 4 posts Joined 11/12
30 May 2013

Hi,
 
I am trying to LOAD a table with the following TPT scripts.
1.       ErrorLIMIT1 = 5
2.       ErrorLIMIT2 = 5
3.       Maxsessions = 1
4.       Minsessions = 1
5.       Loader_Instance = 1
I have a file with 10 UV Values for a single Key value e.g., for primary key = 2 there are 10 UV records. I expected TPT to fail but it did not. Can anyone explain this behavior? What is the scenario in which Errorlimit is used by TPT and it fails.

TonyL 20 posts Joined 12/09
30 May 2013

The ErrorLimit attribute applies to the number of error records during the acquisition phase.
During the acquisition phase, error records include these errors:
* Data conversion errors
* Constraint violations
* AMP configuration changes
The ErrorLimit attribute does not apply to UV records. UV records occur in the application phase.

 

You must sign in to leave a comment.