TPT doesn't show any error and log are empty.

Tools & Utilities

TPT doesn't show any error and log are empty.

Hi All,

We are using tpt script to load all our data to warehouse. our files are .txt extension.

This script was successfully executed in last week month, but from last week it doesn't display anything and just empty.

When we checked with our dba's they informed, session has modified to 6 before it was 8.(maximum session = 6) and we modified to 6 in tpt also it not working.

Same script working when its executed separately in unix box( script not worked when its execute through loop having more file and its worked without anyissue before)

This will give some idea about the issue. Sample script provided below.

Thanks in Advance!!!

tpt executed using

tbuild -f /abad/tptscripts/tpt_generic_delim.tpt -j xd-1277  -u "td_id ='xxxx' td_username='xxxx'

        userpassword='xxxx' logtable='f1' targetable='f1'

        errortable_et='f1_ET' errortable_uv='f1_UV'

        filename='/abc/f1.txt' format='DELIMITED' openmode='READ' worktable_wt='f1_WT'

        indicatoremode='N' CLIENT_KY='XX', CLIENT_ID='XXXX'

        inputschema='f1.schema',insertzstatement='f1.ins'

        schemaname=clm_def_f1,delimiter=',' error_limit=10000"

tpt:

DEFINE JOB FILE_UPDATE

DESCRIPTION 'Load TD tables from a file'

(

 DEFINE SCHEMA @schemaname

 (

  INCLUDE @inputschema;

 );

DEFINE OPERATOR FILE_READER

TYPE DATACONNECTOR PRODUCER

SCHEMA @schemaname

ATTRIBUTES

(

                VARCHAR PrivateLogName,

                VARCHAR DirectoryPath,

                VARCHAR FileName = @filename,

                VARCHAR Format = @format,

                VARCHAR OpenMode = @openmode,

                VARCHAR IndicatorMode = @indicatoremode,

                VARCHAR TextDelimiter   = @delimiter,

                VARCHAR QuotedData = 'Optional',

                VARCHAR OpenQuoteMark = '"',

                VARCHAR AcceptExcessColumns = 'YesWithoutLog'

 );

DEFINE OPERATOR DDL_OPERATOR

TYPE DDL

ATTRIBUTES

(               VARCHAR PrivateLogName ,

                VARCHAR TdpId        = @td_id,

                VARCHAR UserName     = @td_username,

                VARCHAR UserPassword = @userpassword

);

DEFINE OPERATOR UPDATE_OPERATOR

TYPE UPDATE

SCHEMA *

ATTRIBUTES

(

                VARCHAR PrivateLogName ,

                VARCHAR TdpId        = @td_id,

                VARCHAR UserName     = @td_username,

                VARCHAR UserPassword = @userpassword,

                VARCHAR LogTable     = @logtable,

                VARCHAR TargetTable  = @targetable,

                VARCHAR ErrorTable1  = @errortable_et,

                VARCHAR ErrorTable2  = @errortable_uv,

                VARCHAR WorkTable     = @worktable_wt,

                INTEGER ErrorLimit    = @error_limit,

                INTEGER TenacityHours = 1,

                INTEGER TenacitySleep = 1,

                INTEGER MaxSessions   = 2,

                INTEGER MinSessions   = 1

);

STEP Truncate_Table

(

APPLY('DELETE FROM '||@targetable||';')

TO OPERATOR(DDL_OPERATOR[1]);

);

STEP Insert_Table

(

APPLY

(

 INCLUDE @insertstatement;

)

TO OPERATOR (UPDATE_OPERATOR[1])

SELECT * FROM OPERATOR (FILE_READER[1]);

);

);

Regards,

Senthil