TPT error

Tools

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 Syed

below 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 */ );
11 REPLIES

Re: TPT error

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

Re: TPT error

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
Teradata Employee

Re: TPT error

Gentlemen, did you find solution for this problem?
Enthusiast

Re: TPT error



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.
Enthusiast

Re: TPT error

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.
Enthusiast

Re: TPT error

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.
N/A

Re: TPT error

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.

Teradata Employee

Re: TPT error

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
Enthusiast

Re: TPT error

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