|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/30/2009 1:01:20 PM
Posts: 2,
Visits: 10
|
|
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 */ );
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/30/2009 1:01:20 PM
Posts: 2,
Visits: 10
|
|
|
anyone? i know tpt isnt really a well known tool but any help would be much appreciated
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/9/2009 3:27:04 PM
Posts: 38,
Visits: 46
|
|
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.
|
|
|
|