Easyloader Schema Error 15.10 Only

Tools
Enthusiast

Easyloader Schema Error 15.10 Only

Hello:

We're receiving the following error on 15.10 whcih we were not receiving on 15.00.  Could you please help?  Here's our TD Load command line:

tdload -r "C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\checkpoint" -L "C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\logs" --TargetTable "SJB_TESTING"."addresses4444" --TargetTdpId tdat15 --TargetUserName <TARGET_PASSWORD> --TargetUserPassword <TARGET_PASSWORD> --TargetWorkingDatabase "SJB_TESTING" --SourceFileName "C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\sql_class.csv" --SourceTextDelimiter "|" addresses4444_LoadJob

CSV Flat File

5555555|121 Jump St.|Big City|NY|334566598|310|4531111

2222222|123 Some St.|Sometown|CA|256781212|475|5651213

4444444|12 Jump St.|Big City|NY|334566576|310|4530097

1111111|123 Any St.|Anytown|AL|456780000|435|5551213

3333333|2468 Appreciate Ave.|Mytown|MI|123561111|937|3334567

Original DDL

CREATE MULTISET TABLE SJB_TESTING.addresses244 ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      SUBSCRIBER_NO FLOAT,

      STREET VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      CITY VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      STATE VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      ZIP FLOAT,

      AREACODE FLOAT,

      PHONE FLOAT)

NO PRIMARY INDEX ;

Modified DDL (all varchar still fails)

CREATE MULTISET TABLE SJB_TESTING.addresses4444 ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      SUBSCRIBER_NO FLOAT,

      STREET VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      CITY VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      STATE VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      ZIP VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      AREACODE VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      PHONE VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC)

PRIMARY INDEX ( SUBSCRIBER_NO );

Error log

C:\Code\Nexus\Main-Branch-DaveDev\ CDW.Admin.Presentation\bin\Debug>cd "C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\"

C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT>tdload -r "C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\checkpoint" -L "C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\logs" --TargetTable "SJB_TESTING"."addresses4444" --TargetTdpId tdat15 --TargetUserName <TARGET_PASSWORD> --TargetUserPassword <TARGET_PASSWORD> --TargetWorkingDatabase "SJB_TESTING" --SourceFileName "C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\sql_class.csv" --SourceTextDelimiter "|" addresses4444_LoadJob

Teradata Parallel Transporter Version 15.10.01.02 32-Bit

Job log: C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\logs/addresses4444_LoadJob-34.out

Job id is addresses4444_LoadJob-34, running on Coffingdw

Teradata Parallel Transporter DataConnector Operator Version 15.10.01.02

Teradata Parallel Transporter Load Operator Version 15.10.01.02

$LOAD: private log specified: LoadLog

$FILE_READER[1]: DataConnector Producer operator Instances: 1

$FILE_READER[1]: TPT19108 Data Format 'DELIMITED' requires all 'VARCHAR/JSON/JSON BY NAME/CLOB BY NAME/BLOB BY NAME/XML BY NAME/XML/CLOB' schema.

$FILE_READER[1]: TPT19015 TPT Exit code set to 12.

$LOAD: connecting sessions

$LOAD: preparing target table

$LOAD: entering Acquisition Phase

$FILE_READER[1]: Total files processed: 0.

$LOAD: disconnecting sessions

$LOAD: Total processor time used = '0.28125 Second(s)'

$LOAD: Start : Mon Aug 22 10:07:07 2016

$LOAD: End   : Mon Aug 22 10:07:18 2016

Job step MAIN_STEP terminated (status 8)

Job addresses4444_LoadJob terminated (status 8)

Job start: Mon Aug 22 10:07:07 2016

Job end:   Mon Aug 22 10:07:18 2016

Teradata Load Utility Version 15.10.01.02 32-Bit

C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT>Exit

15 REPLIES
Teradata Employee

Re: Easyloader Schema Error 15.10 Only

SUBSCRIBER_NO is defined as FLOAT.

It needs to be VARCHAR.

-- SteveF
Enthusiast

Re: Easyloader Schema Error 15.10 Only

Sorry about that.  It doesn't work with the new DDL.  We don't have a problem on 15.00 even with the original DDL where there are float columns.  Here is the new test.  Thanks.

CREATE MULTISET TABLE SJB_TESTING.addressesVARCHAR ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      SUBSCRIBER_NO FLOAT,

      STREET VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      CITY VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      STATE VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      ZIP VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      AREACODE VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      PHONE VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC)

PRIMARY INDEX ( SUBSCRIBER_NO );

Script we’re running:

C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT>tdload -r "C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\checkpoint" -L "C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\logs" --TargetTable "SJB_TESTING"."addressesVARCHAR" --TargetTdpId tdat15 --TargetUserName dbc --TargetUserPassword <TARGET_PASSWORD> --TargetWorkingDatabase "SJB_TESTING" --SourceFileName "C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\sql_class.csv" --SourceTextDelimiter "|" addressesVARCHAR_LoadJob

Output of tdload:

Teradata Parallel Transporter Version 15.10.01.02 32-Bit

Job log: C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\logs/addressesVARCHAR_LoadJob-42.out

Job id is addressesVARCHAR_LoadJob-42, running on Coffingdw

Teradata Parallel Transporter DataConnector Operator Version 15.10.01.02

Teradata Parallel Transporter Load Operator Version 15.10.01.02

$LOAD: private log specified: LoadLog

$FILE_READER[1]: DataConnector Producer operator Instances: 1

$FILE_READER[1]: TPT19108 Data Format 'DELIMITED' requires all 'VARCHAR/JSON/JSON BY NAME/CLOB BY NAME/BLOB BY NAME/XML BY NAME/XML/CLOB' schema.

$FILE_READER[1]: TPT19015 TPT Exit code set to 12.

$LOAD: connecting sessions

$LOAD: preparing target table

$LOAD: entering Acquisition Phase

$FILE_READER[1]: Total files processed: 0.

$LOAD: disconnecting sessions

$LOAD: Total processor time used = '0.390625 Second(s)'

$LOAD: Start : Mon Aug 22 13:32:11 2016

$LOAD: End   : Mon Aug 22 13:32:16 2016

Job step MAIN_STEP terminated (status 8)

Job addressesVARCHAR_LoadJob terminated (status 8)

Job start: Mon Aug 22 13:32:10 2016

Job end:   Mon Aug 22 13:32:16 2016

Teradata Load Utility Version 15.10.01.02 32-Bit

Teradata Employee

Re: Easyloader Schema Error 15.10 Only

You will have to show me a job run with TPT 15.0 and a schema with FLOAT.

It should not have worked.

We have been pretty strict about this since Day 1.

-- SteveF
Enthusiast

Re: Easyloader Schema Error 15.10 Only

On 15.00 you are correct everything is varchar.  Moving the same file on 15.10 is not.

15.00 Private Log - Success

TPT_INFRA: TPT04101: Warning: TMSM failed to initialize
Teradata Parallel Transporter Coordinator Version 15.00.00.00
Teradata Parallel Transporter Executor Version 15.00.00.00
Teradata Parallel Transporter Executor Version 15.00.00.00
CheckPoint Resource Manager initialized.
Checking whether a valid CheckPoint exists for restart.
MAIN_STEP SELECT_2[0001] $FILE_READER FILE C:\Users\Todd\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 INITIATE-Started 15:24:08 0.0000 0.0000 65000 0 0 0 0 0 N Y
Teradata Parallel Transporter $FILE_READER[1]: TPT19006 Version 15.00.00.00
$FILE_READER[1]: TPT19010 Instance 1 directing private log report to 'FileReaderLog-1'.
= TraceFunction: 'NO (defaulted)' (=0) =
==========================================================================
= =
= TERADATA PARALLEL TRANSPORTER =
= =
= DATACONNECTOR OPERATOR VERSION 15.00.00.00 =
= =
= DataConnector UTILITY LIBRARY VERSION 15.00.00.17 =
= =
= COPYRIGHT 2001-2011, Teradata Corporation. ALL RIGHTS RESERVED. =
= =
==========================================================================

Operator name: '$FILE_READER' instance 1 of 1 [Producer]

**** 15:24:08 Processing starting at: Mon Aug 22 15:24:08 2016
==========================================================================
= =
= Operator module static specifics =
= =
= Compiled for platform: '32-bit WIN32' =
= Operator module name:'dtacop', version:'15.00.00.00' =
= =
= pmdcomt_HeaderVersion: 'Common 15.00.00.01' - packing 'pack (push, 1)' =
= pmddamt_HeaderVersion: 'Common 13.10.00.01' - packing 'pack (push, 1)' =
= =
==========================================================================

==========================================================================
= =
= > General attribute Definitions < =
= =
= TraceLevel: 'MILESTONES' =
= EndianFlip: 'NO (defaulted)' (=0) =
= IndicatorMode: 'NO (defaulted)' (=0) =
= NullColumns: 'YES (defaulted)' (=1) =
= SYSTEM_CharSetId: 'ASCII' =
= =
==========================================================================

LITTLE ENDIAN platform
WARNING! NotifyMethod: 'None (default)'
$FILE_READER[1]: TPT19003 NotifyMethod: 'None (default)'
Operator 'dtacop' main source version:'15.00.00.15'
DirInfo global variable name: 'DirInfo'
FileNames global variable name: 'FileNames'
DC_PREAD_SM_TOKENS global variable name: 'DC_PREAD_SM_TOKENS'

==========================================================================
= =
= > Operator attribute Definitions < =
= =
==========================================================================

$FILE_READER[1]: TPT19008 DataConnector Producer operator Instances: 1
DirectoryPath defaulting to: 'C:\Users\Todd\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT'
FileList: 'NO (defaulted)' (=0)
MultipleReaders: 'NO (defaulted)' (=0)
RecordsPerInstance: (use default calculation per schema)
EnableScan: 'Yes (defaulted)'
Initializing with CharSet = 'ASCII'.
Alphabetic CSName=ASCII
Established character set ASCII
Single-byte character set in use

==========================================================================
= =
= > Module Identification < =
= =
==========================================================================

Windows on CDW-LAPTOP
TDICU................................... 15.00.00.01
PXICU................................... 15.00.00.00
PMPROCS................................. 15.00.00.08
PMRWFMT................................. 15.00.00.02
PMTRCE.................................. 13.00.00.02
PMMM.................................... 03.00.00.01
DCUDDI.................................. 15.00.00.13
PMHEXDMP................................ 14.10.00.01
PMHDFSDSK............................... 15.00.00.00
PMUNXDSK................................ 15.00.00.02

>> Enter DC_DataConFileInfo
Job Type=0
WARNING! OpenMode attribute not specified, default 'Read' being used.
$FILE_READER[1]: TPT19203 Required attribute 'OpenMode' not found. Defaulting to 'Read'.
AppendDelimiter: 'NO (defaulted)' (=0)
TextDelimiter = ',' [1 byte(s) x'2C']
WARNING! EscapeTextDelimiter attribute not specified, there is no default
WARNING! OpenQuoteMark attribute not specified, there is no default
WARNING! CloseQuoteMark attribute not specified, there is no default
WARNING! EscapeQuoteDelimiter attribute not specified, there is no default
QuotedData: 'NO (defaulted)' (=0)
WARNING! TrimChar attribute not specified, there is no default
UseGeneralUDDIcase: 'NO (defaulted)' (=0)
UDDI_ParsingCase=1100000
WriteBOM: 'NO (defaulted)' (=0)
AcceptExcessColumns: 'NO (defaulted)' (=0)
AcceptMissingColumns: 'NO (defaulted)' (=0)
TruncateColumnData: 'NO (defaulted)' (=0)
TruncateColumns: 'NO (defaulted)' (=0)
TruncateLongCols: 'NO (defaulted)' (=0)
WARNING! RecordErrorFilePrefix attribute not specified, there is no default
RecordErrorVerbosity: OFF (default) (=0)
FileName: 'C:\Users\Todd\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\SQL_CLASS.csv'
OpenMode: 'READ' (1)
Format: 'DELIMITED' (1)
IOBufferSize: 131072 (default)

Full File Path: C:\Users\Todd\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\SQL_CLASS.csv
UTF8 File Flag: 0
Data Type Ind Length Offset M
VARCHAR ( 7) 1 20 0 N
VARCHAR ( 7) 1 255 20 N
VARCHAR ( 7) 1 255 275 N
VARCHAR ( 7) 1 255 530 N
VARCHAR ( 7) 1 20 785 N
VARCHAR ( 7) 1 20 805 N
VARCHAR ( 7) 1 20 825 N
Schema is not all character data
Schema is compatible with delimited data
Validating parsing case: 1100000.
SBCS (QUOTED DATA: No), Delimiter[1]: ','
Delimiter: x'2C'
Escape Delimiter: x''
Open Quote: x''
Close Quote: x''
Escape Quote: x''
ECI operator ID: '$FILE_READER-6172'
$FILE_READER[1]: TPT19003 ECI operator ID: '$FILE_READER-6172'
dwFileAttributes=32
Calling PX_CreateGlobalVar for DirInfo
Calling PX_CreateGlobalVar for FileNames
1 entries of 280 length each
GLOBAL files in scan for all instances: 1
Global Global Assigned Usage File File
index entry size instance status size name
1 280 1 1 283 C:\Users\Todd\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\SQL_CLASS.csv
LOCAL files for instance 1: 1
Local Global Usage File File
index index status size name
1 1 1 283 C:\Users\Todd\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\SQL_CLASS.csv
**** 15:24:08 From file 'C:\Users\Todd\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\SQL_CLASS.csv', starting to send rows.
$FILE_READER[1]: TPT19222 Operator instance 1 processing file 'C:\Users\Todd\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\SQL_CLASS.csv'.
PX_Initiate: Complete. Returning EndMethod
AllowBufferMode: 'YES (defaulted)' (=1)
MAIN_STEP APPLY_1[0001] $LOAD DBS tdat13 SQL_SANDBOX.Addresses
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 INITIATE-Started 15:24:08 0.0000 0.0000 65000 0 0 0 0 0 N Y
Addresses_LoadJob-4,17,0,OperatorEnter,MAIN_STEP,$LOAD,1,2016-08-22,,1,0
Teradata Parallel Transporter Load Operator Version 15.00.00.00
$LOAD: private log specified: LoadLog

===================================================================
= =
= TERADATA PARALLEL TRANSPORTER =
= =
= LOAD OPERATOR VERSION 15.00.00.00 =
= =
= OPERATOR SUPPORT LIBRARY VERSION 15.00.00.00 =
= =
= COPYRIGHT 2001-2014, TERADATA CORPORATION. ALL RIGHTS RESERVED. =
= =
= Process I.D.: 6612 =
= =
===================================================================
**** 15:24:08 Processing starting at: Mon Aug 22 15:24:08 2016

===================================================================
= =
= Module Identification =
= =
===================================================================
Load Operator for Windows on CDW-LAPTOP
LoadMain : 15.00.00.03
LoadCLI : 15.00.00.04
LoadUtil : 14.10.00.01
PcomCLI : 15.00.00.23
PcomMBCS : 14.10.00.02
PcomMsgs : 15.00.00.01
PcomNtfy : 14.10.00.05
PcomPx : 15.00.00.07
PcomUtil : 15.00.00.07
PXICU : 15.00.00.00
TDICU : 15.00.00.01
CLIv2 : 15.00.00.01
Addresses_LoadJob-4,116,5,UtilityName,MAIN_STEP,$LOAD,1,2016-08-22,TPT Load Operator,1,0
Addresses_LoadJob-4,0,5,LoadVersionId,MAIN_STEP,$LOAD,1,2016-08-22,15.00.00.00,1,0
Addresses_LoadJob-4,115,1,UtilityId,MAIN_STEP,$LOAD,1,2016-08-22,1,1,0
Addresses_LoadJob-4,132,5,LoadTdpId,MAIN_STEP,$LOAD,1,2016-08-22,tdat13,1,0
Addresses_LoadJob-4,1,5,LoadUserName,MAIN_STEP,$LOAD,1,2016-08-22,dbc,1,0

===================================================================
= =
= Attribute Definitions =
= =
===================================================================
**** 15:24:11 Options in effect for this job:
OperatorType: Consumer
Instances: 1
Character set: Not specified; will use default
Checkpoint: No checkpoint in effect
Notify: Not enabled
Buffer size: Maximum allowable
Error limit: No limit in effect
Tenacity: 4 hour limit to successfully connect
Sleep: 6 minute(s) between connect retries
Pause Acq: Not in effect

===================================================================
= =
= Column/Field Definition =
= =
===================================================================
Column Name Offset Length Type
============================== ====== ====== ========================
"SUBSCRIBER_NO" 0 20 VARCHAR
"STREET" 22 255 VARCHAR
"CITY" 279 255 VARCHAR
"STATE" 536 255 VARCHAR
"ZIP" 793 20 VARCHAR
"AREACODE" 815 20 VARCHAR
"PHONE" 837 20 VARCHAR
============================== ====== ====== ========================
INDICATOR BYTES NEEDED: 1
EXPECTED RECORD LENGTH: 860

===================================================================
= =
= Control Session Connection =
= =
===================================================================
$LOAD: connecting sessions
**** 15:24:11 Connecting to RDBMS: 'tdat13'
**** 15:24:11 Connecting with UserId: 'dbc'
**** 15:24:11 Retrieving the Teradata Database retryable error codes
**** 15:24:11 The RDBMS retryable error code list was not found
$LOAD: The RDBMS retryable error code list was not found
**** 15:24:11 The job will use its internal retryable error codes
$LOAD: The job will use its internal retryable error codes
Addresses_LoadJob-4,128,5,LoadDbase,MAIN_STEP,$LOAD,1,2016-08-22,SQL_SANDBOX,1,0

===================================================================
= =
= Teradata Database Information =
= =
===================================================================
**** 15:24:12 Teradata Database Version: '13.00.00.12 '
**** 15:24:12 Teradata Database Release: '13.00.00.12 '
**** 15:24:12 Maximum request size supported: 1MB
**** 15:24:12 Session character set: 'ASCII'
**** 15:24:12 Total AMPs available: 2
**** 15:24:12 Data Encryption: supported
**** 15:24:12 Enhanced Statement Status: not supported by RDBMS
**** 15:24:12 Restart log table 'SQL_SANDBOX.Addresses_RL' has been created
**** 15:24:12 Current working DATABASE set: 'SQL_SANDBOX'

===================================================================
= =
= Special Session Connection =
= =
===================================================================
**** 15:24:13 Maximum number of special sessions requested: 32
**** 15:24:13 Maximum sessions adjusted to number of AMPs: 2
**** 15:24:13 Minimum number of special sessions required: 1

Instance Assigned Connected Result
======== ======== ========= ======================
1 2 2 Successful
======== ======== ========= ======================
Total 2 2 Successful

===================================================================
= =
= Target/Error Table Information =
= =
===================================================================
$LOAD: preparing target table
**** 15:24:13 This job will use the following tables:

Target Table: 'SQL_SANDBOX.Addresses'
Error Table 1: 'SQL_SANDBOX.Addresses_ET'
Error Table 2: 'SQL_SANDBOX.Addresses_UV'

===================================================================
= =
= Acquisition Phase =
= =
===================================================================
$LOAD: entering Acquisition Phase
**** 15:24:13 DML statement for DML Group: 1

INSERT INTO SQL_SANDBOX.Addresses VALUES ( :"SUBSCRIBER_NO", :"STREET", :"CITY", :"STATE", :"ZIP", :"AREACODE", :"PHONE");

**** 15:24:13 Number of records per buffer for this job: 74
Addresses_LoadJob-4,21,1,LoadTableId,MAIN_STEP,$LOAD,1,2016-08-22,1,1,1
Addresses_LoadJob-4,22,5,LoadTableName,MAIN_STEP,$LOAD,1,2016-08-22,SQL_SANDBOX.Addresses,1,1
Addresses_LoadJob-4,19,0,LoadPhase1Begin,MAIN_STEP,$LOAD,1,2016-08-22,,1,1
Job is running in Buffer Mode
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 INITIATE-Ended 15:24:14 6.0000 0.1719 65000 0 0 0 0 0 N Y
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 INITIATE-Ended 15:24:14 6.0000 0.0000 65000 0 0 0 0 0 N Y
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 EXECUTE-Started 15:24:14 0.0000 0.0000 65000 0 0 0 0 0 N Y
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 EXECUTE-Started 15:24:14 0.0000 0.0000 65000 0 0 0 0 0 N Y
CheckPoint No. 1 started.
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 CHECKPOINT-Started 15:24:14 0.0000 0.0000 65000 0 0 0 0 0 N Y
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 CHECKPOINT-Started 15:24:14 0.0000 0.0000 65000 0 0 0 0 0 N Y
**** 15:24:14 Checkpointing instance 1, file count 0 of 1:
Non-BufferMode
dcPosSummary_t struct: Length=64
ErrRowCount=0, FileRecCount=0, DatPosLen=40, ErrPosLen=0
RecordInstanceTarget = 0
Instance position data from DC_GetPos():
Hexadecimal formatted display from address 00582DB8 for 64 bytes.
0000 00 00 00 00.00 00 00 00.28 00 00 00.00 00 00 00 *........(.......*
0010 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
0030 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
dcPosSummary_t struct: Length=64
ErrRowCount=0, FileRecCount=0, DatPosLen=40, ErrPosLen=0
RecordInstanceTarget = 0
Position data to TPT:
Hexadecimal formatted display from address 0064FEE0 for 1196 bytes.
0000 43 3A 5C 55.73 65 72 73.5C 54 6F 64.64 5C 41 70 *C:\Users\Todd\Ap*
0010 70 44 61 74.61 5C 52 6F.61 6D 69 6E.67 5C 43 6F *pData\Roaming\Co*
0020 66 66 69 6E.67 20 44 61.74 61 20 57.61 72 65 68 *ffing Data Wareh*
0030 6F 75 73 69.6E 67 5C 4E.65 78 75 73.20 50 6F 72 *ousing\Nexus Por*
0040 74 61 6C 5C.53 63 72 69.70 74 73 5C.54 50 54 5C *tal\Scripts\TPT\*
0050 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
0100 43 00 3A 00.5C 00 55 00.73 00 65 00.72 00 73 00 *C.:.\.U.s.e.r.s.*
0110 5C 00 54 00.6F 00 64 00.64 00 5C 00.41 00 70 00 *\.T.o.d.d.\.A.p.*
0120 70 00 44 00.61 00 74 00.61 00 5C 00.52 00 6F 00 *p.D.a.t.a.\.R.o.*
0130 61 00 6D 00.69 00 6E 00.67 00 5C 00.43 00 6F 00 *a.m.i.n.g.\.C.o.*
0140 66 00 66 00.69 00 6E 00.67 00 20 00.44 00 61 00 *f.f.i.n.g. .D.a.*
0150 74 00 61 00.20 00 57 00.61 00 72 00.65 00 68 00 *t.a. .W.a.r.e.h.*
0160 6F 00 75 00.73 00 69 00.6E 00 67 00.5C 00 4E 00 *o.u.s.i.n.g.\.N.*
0170 65 00 78 00.75 00 73 00.20 00 50 00.6F 00 72 00 *e.x.u.s. .P.o.r.*
0180 74 00 61 00.6C 00 5C 00.53 00 63 00.72 00 69 00 *t.a.l.\.S.c.r.i.*
0190 70 00 74 00.73 00 5C 00.54 00 50 00.54 00 5C 00 *p.t.s.\.T.P.T.\.*
01A0 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
0320 00 00 00 00.01 00 00 00.00 00 00 00.01 00 00 00 *................*
0330 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
0350 00 00 00 00.01 00 00 00.01 00 00 00.1B 01 00 00 *................*
0360 00 00 00 00.43 3A 5C 55.73 65 72 73.5C 54 6F 64 *....C:\Users\Tod*
0370 64 5C 41 70.70 44 61 74.61 5C 52 6F.61 6D 69 6E *d\AppData\Roamin*
0380 67 5C 43 6F.66 66 69 6E.67 20 44 61.74 61 20 57 *g\Coffing Data W*
0390 61 72 65 68.6F 75 73 69.6E 67 5C 4E.65 78 75 73 *arehousing\Nexus*
03A0 20 50 6F 72.74 61 6C 5C.53 63 72 69.70 74 73 5C * Portal\Scripts\*
03B0 54 50 54 5C.74 65 6D 70.5C 53 51 4C.5F 43 4C 41 *TPT\temp\SQL_CLA*
03C0 53 53 2E 63.73 76 00 00.00 00 00 00.00 00 00 00 *SS.csv..........*
03D0 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
0470 00 00 00 00.28 00 00 00.00 00 00 00.00 00 00 00 *....(...........*
0480 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
04A0 00 00 00 00.00 00 00 00.00 00 00 00 *............ *
PX_Checkpoint: Complete-Setting Execute CkptJustCompleted flag. Returning EndMethod
Task(APPLY_1[0001]): checkpoint completed, status = Success
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 CHECKPOINT-Ended 15:24:15 1.0000 0.0000 65000 0 0 0 0 0 N Y
Task(SELECT_2[0001]): checkpoint completed, status = Success
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 CHECKPOINT-Ended 15:24:15 1.0000 0.0156 65000 0 0 0 0 0 N Y
CheckPoint No. 1 finished successfully.
SYSTEM_BUFFERMODE: 'yes'
BUFFERLENGTHSIZE: 2
BUFFERHEADERSIZE: 4
BUFFERTRAILERSIZE: 6
BUFFERMAXSIZE: 64260
Buffer mode attributes defined by consumer instance:
BUFFERLENGTHSIZE set to: 4
BUFFERHEADERSIZE set to: 4
BUFFERTRAILERSIZE set to: 0
BUFFERMAXSIZE set to: 523841
Data Block size: 3470696 Buffers/Block: 54 Data Buffer size: 64272
**** 15:24:15 Finished sending rows for C:\Users\Todd\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\SQL_CLASS.csv (index 1)
Rows sent: 5, (size: 283) CPU Time: 6.73 Seconds
PX_Execute: Setting Execute EndMethod flag. Returning EndMethod
Sending stat to infrastructure: DCCheckPointNo=0
Addresses_LoadJob-4,126,1,DCCheckPointNo,MAIN_STEP,$FILE_READER,1,2016-08-22,0,2,0
Sending stat to infrastructure: DCRowsRead=5
Addresses_LoadJob-4,119,1,DCRowsRead,MAIN_STEP,$FILE_READER,1,2016-08-22,5,2,0
Sending stat to infrastructure: DCFilesRead=1
Addresses_LoadJob-4,121,1,DCFilesRead,MAIN_STEP,$FILE_READER,1,2016-08-22,1,2,0
Sending stat to infrastructure: DCRowErrorNo=0
Addresses_LoadJob-4,125,1,DCRowErrorNo,MAIN_STEP,$FILE_READER,1,2016-08-22,0,2,0
Sending stat to infrastructure: DCFileName='C:\Users\Todd\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\SQL_CLASS.csv'
Addresses_LoadJob-4,124,5,DCFileName,MAIN_STEP,$FILE_READER,1,2016-08-22,C:\Users\Todd\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT\temp\SQL_CLASS.csv,2,0
CheckPoint No. 2 started.
Task(SELECT_2[0001]) ready to checkpoint
**** 15:24:15 Starting to send data to the RDBMS
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 CHECKPOINT-Started 15:24:15 1.0000 0.0156 3470696 1 0 0 0 0 Y Y
**** 15:24:15 Checkpointing instance 1, file count 1 of 1:
BufferMode
HaveRow: 0
No files open
Position data to TPT:
Hexadecimal formatted display from address 0064FEE0 for 1132 bytes.
0000 43 3A 5C 55.73 65 72 73.5C 54 6F 64.64 5C 41 70 *C:\Users\Todd\Ap*
0010 70 44 61 74.61 5C 52 6F.61 6D 69 6E.67 5C 43 6F *pData\Roaming\Co*
0020 66 66 69 6E.67 20 44 61.74 61 20 57.61 72 65 68 *ffing Data Wareh*
0030 6F 75 73 69.6E 67 5C 4E.65 78 75 73.20 50 6F 72 *ousing\Nexus Por*
0040 74 61 6C 5C.53 63 72 69.70 74 73 5C.54 50 54 5C *tal\Scripts\TPT\*
0050 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
0100 43 00 3A 00.5C 00 55 00.73 00 65 00.72 00 73 00 *C.:.\.U.s.e.r.s.*
0110 5C 00 54 00.6F 00 64 00.64 00 5C 00.41 00 70 00 *\.T.o.d.d.\.A.p.*
0120 70 00 44 00.61 00 74 00.61 00 5C 00.52 00 6F 00 *p.D.a.t.a.\.R.o.*
0130 61 00 6D 00.69 00 6E 00.67 00 5C 00.43 00 6F 00 *a.m.i.n.g.\.C.o.*
0140 66 00 66 00.69 00 6E 00.67 00 20 00.44 00 61 00 *f.f.i.n.g. .D.a.*
0150 74 00 61 00.20 00 57 00.61 00 72 00.65 00 68 00 *t.a. .W.a.r.e.h.*
0160 6F 00 75 00.73 00 69 00.6E 00 67 00.5C 00 4E 00 *o.u.s.i.n.g.\.N.*
0170 65 00 78 00.75 00 73 00.20 00 50 00.6F 00 72 00 *e.x.u.s. .P.o.r.*
0180 74 00 61 00.6C 00 5C 00.53 00 63 00.72 00 69 00 *t.a.l.\.S.c.r.i.*
0190 70 00 74 00.73 00 5C 00.54 00 50 00.54 00 5C 00 *p.t.s.\.T.P.T.\.*
01A0 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
0310 00 00 00 00.00 00 00 00.00 00 00 00.05 00 00 00 *................*
0320 01 00 00 00.01 00 00 00.00 00 00 00.01 00 00 00 *................*
0330 05 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
0340 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
0350 01 00 00 00.02 00 00 00.01 00 00 00.1B 01 00 00 *................*
0360 00 00 00 00.43 3A 5C 55.73 65 72 73.5C 54 6F 64 *....C:\Users\Tod*
0370 64 5C 41 70.70 44 61 74.61 5C 52 6F.61 6D 69 6E *d\AppData\Roamin*
0380 67 5C 43 6F.66 66 69 6E.67 20 44 61.74 61 20 57 *g\Coffing Data W*
0390 61 72 65 68.6F 75 73 69.6E 67 5C 4E.65 78 75 73 *arehousing\Nexus*
03A0 20 50 6F 72.74 61 6C 5C.53 63 72 69.70 74 73 5C * Portal\Scripts\*
03B0 54 50 54 5C.74 65 6D 70.5C 53 51 4C.5F 43 4C 41 *TPT\temp\SQL_CLA*
03C0 53 53 2E 63.73 76 00 00.00 00 00 00.00 00 00 00 *SS.csv..........*
03D0 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
0460 00 00 00 00.00 00 00 00.00 00 00 00 *............ *
PX_Checkpoint: Complete-Setting Execute CkptJustCompleted flag. Returning EndMethod
Task(SELECT_2[0001]): checkpoint completed, status = Success
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 CHECKPOINT-Started 15:24:16 2.0000 0.0000 65000 1 0 0 0 0 N Y
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 CHECKPOINT-Ended 15:24:16 2.0000 0.0156 3470696 1 0 0 0 0 Y Y
Addresses_LoadJob-4,163,37,LoadCheckPoint,MAIN_STEP,$LOAD,1,2016-08-22,5,1,0
**** 15:24:16 Checkpoint complete. Rows sent: 5
Task(APPLY_1[0001]): checkpoint completed, status = Success
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 CHECKPOINT-Ended 15:24:17 3.0000 0.0000 65000 1 0 0 0 0 N Y
CheckPoint No. 2 finished successfully.
Task(SELECT_2[0001]) ready to take the EOD checkpoint
CheckPoint No. 3 started.
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 CHECKPOINT-Started 15:24:17 3.0000 0.0000 65000 1 0 0 0 0 Y Y
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 CHECKPOINT-Started 15:24:17 3.0000 0.0156 3470696 1 0 0 0 0 Y Y
**** 15:24:17 Checkpointing instance 1, file count 1 of 1:
BufferMode
HaveRow: 0
No files open
Position data to TPT:
Hexadecimal formatted display from address 0064FEE0 for 1132 bytes.
0000 43 3A 5C 55.73 65 72 73.5C 54 6F 64.64 5C 41 70 *C:\Users\Todd\Ap*
0010 70 44 61 74.61 5C 52 6F.61 6D 69 6E.67 5C 43 6F *pData\Roaming\Co*
0020 66 66 69 6E.67 20 44 61.74 61 20 57.61 72 65 68 *ffing Data Wareh*
0030 6F 75 73 69.6E 67 5C 4E.65 78 75 73.20 50 6F 72 *ousing\Nexus Por*
0040 74 61 6C 5C.53 63 72 69.70 74 73 5C.54 50 54 5C *tal\Scripts\TPT\*
0050 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
0100 43 00 3A 00.5C 00 55 00.73 00 65 00.72 00 73 00 *C.:.\.U.s.e.r.s.*
0110 5C 00 54 00.6F 00 64 00.64 00 5C 00.41 00 70 00 *\.T.o.d.d.\.A.p.*
0120 70 00 44 00.61 00 74 00.61 00 5C 00.52 00 6F 00 *p.D.a.t.a.\.R.o.*
0130 61 00 6D 00.69 00 6E 00.67 00 5C 00.43 00 6F 00 *a.m.i.n.g.\.C.o.*
0140 66 00 66 00.69 00 6E 00.67 00 20 00.44 00 61 00 *f.f.i.n.g. .D.a.*
0150 74 00 61 00.20 00 57 00.61 00 72 00.65 00 68 00 *t.a. .W.a.r.e.h.*
0160 6F 00 75 00.73 00 69 00.6E 00 67 00.5C 00 4E 00 *o.u.s.i.n.g.\.N.*
0170 65 00 78 00.75 00 73 00.20 00 50 00.6F 00 72 00 *e.x.u.s. .P.o.r.*
0180 74 00 61 00.6C 00 5C 00.53 00 63 00.72 00 69 00 *t.a.l.\.S.c.r.i.*
0190 70 00 74 00.73 00 5C 00.54 00 50 00.54 00 5C 00 *p.t.s.\.T.P.T.\.*
01A0 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
0310 00 00 00 00.00 00 00 00.00 00 00 00.05 00 00 00 *................*
0320 01 00 00 00.01 00 00 00.00 00 00 00.01 00 00 00 *................*
0330 05 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
0340 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
0350 01 00 00 00.02 00 00 00.01 00 00 00.1B 01 00 00 *................*
0360 00 00 00 00.43 3A 5C 55.73 65 72 73.5C 54 6F 64 *....C:\Users\Tod*
0370 64 5C 41 70.70 44 61 74.61 5C 52 6F.61 6D 69 6E *d\AppData\Roamin*
0380 67 5C 43 6F.66 66 69 6E.67 20 44 61.74 61 20 57 *g\Coffing Data W*
0390 61 72 65 68.6F 75 73 69.6E 67 5C 4E.65 78 75 73 *arehousing\Nexus*
03A0 20 50 6F 72.74 61 6C 5C.53 63 72 69.70 74 73 5C * Portal\Scripts\*
03B0 54 50 54 5C.74 65 6D 70.5C 53 51 4C.5F 43 4C 41 *TPT\temp\SQL_CLA*
03C0 53 53 2E 63.73 76 00 00.00 00 00 00.00 00 00 00 *SS.csv..........*
03D0 00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00 *................*
....
0460 00 00 00 00.00 00 00 00.00 00 00 00 *............ *
PX_Checkpoint: Complete-Setting Execute CkptJustCompleted flag. Returning EndMethod
Task(APPLY_1[0001]): checkpoint completed, status = Success
Task(SELECT_2[0001]): checkpoint completed, status = Success
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 CHECKPOINT-Ended 15:24:18 4.0000 0.0000 65000 1 0 0 0 0 Y Y
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 CHECKPOINT-Ended 15:24:18 4.0000 0.0156 3470696 1 0 0 0 0 Y Y
CheckPoint No. 3 finished successfully.
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 EXECUTE-Ended 15:24:18 4.0000 0.0156 3470696 1 0 0 0 0 Y Y
**** 15:24:18 Finished sending rows to the RDBMS
**** 15:24:18 Number of bytes sent to the RDBMS for this job: 344
Addresses_LoadJob-4,20,0,LoadPhase1End,MAIN_STEP,$LOAD,1,2016-08-22,,1,0
Addresses_LoadJob-4,26,37,LoadRowsRead,MAIN_STEP,$LOAD,1,2016-08-22,5,1,0
Addresses_LoadJob-4,27,37,LoadRowsSkipped,MAIN_STEP,$LOAD,1,2016-08-22,0,1,0
Addresses_LoadJob-4,28,37,LoadRowsRejected,MAIN_STEP,$LOAD,1,2016-08-22,0,1,0
Addresses_LoadJob-4,29,37,LoadRowsSent,MAIN_STEP,$LOAD,1,2016-08-22,5,1,0

Instance Rows Sent
======== =======================
1 5
======== =======================
Total 5

**** 15:24:18 Acquisition Phase statistics:
Elapsed time: 00:00:03 (hh:mm:ss)
CPU time: 0 Second(s)
MB/sec: 0.000
MB/cpusec: could not be determined

===================================================================
= =
= Application Phase =
= =
===================================================================
$LOAD: entering Application Phase
Addresses_LoadJob-4,23,0,LoadPhase2Begin,MAIN_STEP,$LOAD,1,2016-08-22,,1,0
**** 15:24:18 Application Phase Begin

Statistics for Target Table: 'SQL_SANDBOX.Addresses'
Total Rows Sent To RDBMS: 5
Total Rows Applied: 5
$LOAD: Statistics for Target Table: 'SQL_SANDBOX.Addresses'
$LOAD: Total Rows Sent To RDBMS: 5
$LOAD: Total Rows Applied: 5

**** 15:24:19 Application Phase End

**** 15:24:19 Application Phase statistics:
Elapsed time: 00:00:01 (hh:mm:ss)
Addresses_LoadJob-4,24,0,LoadPhase2End,MAIN_STEP,$LOAD,1,2016-08-22,,1,1
Addresses_LoadJob-4,25,37,LoadRowsInserted,MAIN_STEP,$LOAD,1,2016-08-22,5,1,1

===================================================================
= =
= Load Operator Task Cleanup =
= =
===================================================================
Addresses_LoadJob-4,30,1,LoadErrTable1,MAIN_STEP,$LOAD,1,2016-08-22,1,1,0
Addresses_LoadJob-4,32,37,LoadETRows,MAIN_STEP,$LOAD,1,2016-08-22,0,1,0
Addresses_LoadJob-4,31,1,LoadErrTable2,MAIN_STEP,$LOAD,1,2016-08-22,1,1,0
Addresses_LoadJob-4,33,37,LoadUVRows,MAIN_STEP,$LOAD,1,2016-08-22,0,1,0
Target Table 1: 'SQL_SANDBOX.Addresses'
Number of rows Error Table Name
==================== =========================================
0 'SQL_SANDBOX.Addresses_ET'
0 'SQL_SANDBOX.Addresses_UV'

$LOAD: Total Rows in Error Table 1: 0
$LOAD: Total Rows in Error Table 2: 0
$LOAD: Total Duplicate Rows: 0
**** 15:24:21 Total Duplicate Rows: 0

**** 15:24:21 Restart log table 'SQL_SANDBOX.Addresses_RL' has been dropped
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 EXECUTE-Ended 15:24:21 7.0000 0.0000 65000 1 0 0 0 0 Y Y
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 1, Total Rows Received = 0, Total Rows Sent = 0
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 TERMINATE-Started 15:24:21 0.0000 0.0000 65000 0 0 0 0 0 Y Y
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 1, Total Rows Received = 0, Total Rows Sent = 0
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 TERMINATE-Started 15:24:21 0.0000 0.0000 3470696 0 0 0 0 0 Y Y
**** 15:24:21 @@@@@ TERMINATE phase 1
Attribute 'SYSTEM_ExecutePassed' value is 'Y'

Files read by this instance: 1
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
**** 15:24:21 Total processor time used = '6.73 Seconds(s)'
$LOAD: disconnecting sessions
**** 15:24:21 Logging off all sessions
Total files processed in pass: 1
**** 15:24:21 Total files processed: 1
$FILE_READER[1]: TPT19221 Total files processed: 1.
PX_DeleteGlobalVar rc 0 for 'DirInfo'
PX_DeleteGlobalVar rc 0 for 'FileNames'
CkptCount=3
Enter DC_Term Phase 2
Sending to access module: attribute 'PRESERVE_RESTART_INFO'='NO'
Attribute 'PRESERVE_RESTART_INFO' recognized.
Shutting down API
Closing paramods
Detaching default Access Module
Exit code is 0
Closing logs
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 TERMINATE-Ended 15:24:21 0.0000 0.0000 3470696 0 0 0 0 0 Y Y
Addresses_LoadJob-4,135,0,LoadSessEnd,MAIN_STEP,$LOAD,1,2016-08-22,,1,0

Instance Cpu Time
======== ================
1 0.17 Seconds

**** 15:24:22 Total processor time used = '0.171875 Second(s)'
. Start : Mon Aug 22 15:24:08 2016
. End : Mon Aug 22 15:24:22 2016
. Highest return code encountered = '0'.
$LOAD: Total processor time used = '0.171875 Second(s)'
$LOAD: Start : Mon Aug 22 15:24:08 2016
$LOAD: End : Mon Aug 22 15:24:22 2016
**** 15:24:22 This job terminated
Addresses_LoadJob-4,18,1,OperatorExit,MAIN_STEP,$LOAD,1,2016-08-22,0,1,0
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 TERMINATE-Ended 15:24:22 1.0000 0.0000 65000 0 0 0 0 0 Y Y
Job step MAIN_STEP completed successfully
Job Addresses_LoadJob completed successfully
Job start: Mon Aug 22 15:24:02 2016
Job end: Mon Aug 22 15:24:22 2016
Total available memory: 20000000
Largest allocable area: 20000000
Memory use high water mark: 3478624
Free map size: 1024
Free map use high water mark: 23
Free list use high water mark: 0

15.10 Private Log - failed

TPT_INFRA: TPT04101: Warning: Teradata PT cannot connect to Unity EcoSystem Manager.
The job will continue without event messages being sent to Unity EcoSystem Manager.
TPT_INFRA: TPT04197: Warning: OMD API failed to initialize
Teradata Parallel Transporter Executor Version 15.10.01.02
Teradata Parallel Transporter Coordinator Version 15.10.01.02
Teradata Parallel Transporter Executor Version 15.10.01.02
CheckPoint Resource Manager initialized.
Checking whether a valid CheckPoint exists for restart.
MAIN_STEP SELECT_2[0001] ODBCOperator SQL
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 INITIATE-Started 16:23:42 0.0000 0.0000 65000 0 0 0 0 0 N Y
Addresses_LoadJob-45,17,5,OperatorEnter,MAIN_STEP,ODBCOperator,1,2016-08-22,2016-08-22 16:23:42,2,0
Addresses_LoadJob-45,176,5,OperatorVersion,MAIN_STEP,ODBCOperator,1,2016-08-22,15.10.01.02,2,0
Addresses_LoadJob-45,177,1,OperatorType,MAIN_STEP,ODBCOperator,1,2016-08-22,1,2,0
Addresses_LoadJob-45,178,1,OperatorInstances,MAIN_STEP,ODBCOperator,1,2016-08-22,1,2,0
Teradata Parallel Transporter ODBC Operator Version 15.10.01.02
ODBCOperator: private log not specified

===================================================================
= =
= TERADATA PARALLEL TRANSPORTER 32-BIT =
= =
= ODBC OPERATOR VERSION 15.10.01.02 =
= =
= OPERATOR SUPPORT LIBRARY VERSION 15.10.01.02 =
= =
= COPYRIGHT 2001-2016, TERADATA CORPORATION. =
= ALL RIGHTS RESERVED. =
= =
= Process I.D.: 26640 =
= =
===================================================================
**** 16:23:42 Processing starting at: Mon Aug 22 16:23:42 2016

===================================================================
= =
= Module Identification =
= =
===================================================================
32-bit ODBC Operator for Windows on Coffingdw
ODBCMain : 15.10.01.01
ODBCSQL : 15.10.01.03
ODBCUtil : 15.10.00.04
PcomCLI : 15.10.01.02
PcomMBCS : 14.10.00.02
PcomMsgs : 15.10.01.01
PcomNtfy : 15.10.00.01
PcomPx : 15.10.01.01
PcomUtil : 15.10.01.04
PXICU : 15.10.01.02
TDICU : 15.10.01.01
MAIN_STEP APPLY_1[0001] StreamOperator DBS tdat15
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 INITIATE-Started 16:23:42 0.0000 0.0000 65000 0 0 0 0 0 N Y
Addresses_LoadJob-45,17,5,OperatorEnter,MAIN_STEP,StreamOperator,1,2016-08-22,2016-08-22 16:23:42,1,0
Addresses_LoadJob-45,176,5,OperatorVersion,MAIN_STEP,StreamOperator,1,2016-08-22,15.10.01.02,1,0
Addresses_LoadJob-45,177,1,OperatorType,MAIN_STEP,StreamOperator,1,2016-08-22,2,1,0
Addresses_LoadJob-45,178,1,OperatorInstances,MAIN_STEP,StreamOperator,1,2016-08-22,1,1,0
Teradata Parallel Transporter Stream Operator Version 15.10.01.02
StreamOperator: private log not specified

===================================================================
= =
= TERADATA PARALLEL TRANSPORTER 32-BIT =
= =
= STREAM OPERATOR VERSION 15.10.01.02 =
= =
= OPERATOR SUPPORT LIBRARY VERSION 15.10.01.02 =
= =
= COPYRIGHT 2001-2016, TERADATA CORPORATION. =
= ALL RIGHTS RESERVED. =
= =
= Process I.D.: 19212 =
= =
===================================================================
**** 16:23:42 Processing starting at: Mon Aug 22 16:23:42 2016

===================================================================
= =
= Module Identification =
= =
===================================================================
32-bit Stream Operator for Windows on Coffingdw

StreamMain : 15.10.01.01
===================================================================
= =
= Attribute Definitions =
= =
===================================================================
StreamCLI : 15.10.01.01
**** 16:23:42 Options in effect for this job:
StreamSess : 15.10.00.02
OperatorType: Producer
StreamSort : 13.00.00.01
Instances: 1
StreamUtil : 15.10.00.03
Character set: Not specified; will use default
PcomCLI : 15.10.01.02
Checkpoint: No checkpoint in effect
PcomMBCS : 14.10.00.02
DataBlockSize: 2048K bytes
PcomMsgs : 15.10.01.01
PcomNtfy : 15.10.00.01
PcomPx : 15.10.01.01
PcomUtil : 15.10.01.04
PXICU : 15.10.01.02
TDICU : 15.10.01.01

===================================================================
= =
= SQL Session Connection =
= =
===================================================================
**** 16:23:42 Connecting to RDBMS: 'TeradataAA15'
**** 16:23:42 Connecting with UserId: 'dbc'
ODBCOperator: connecting sessions
ODBCOperator: TPT17175: Warning: Message received from ODBC driver:
STATE=HY092, CODE=0,
MSG='[Teradata][ODBC Teradata Driver] Invalid Attribute'
**** 16:23:42 TPT17175: Warning: Message received from ODBC driver:
STATE=HY092, CODE=0,
MSG='[Teradata][ODBC Teradata Driver] Invalid Attribute'

===================================================================
= =
= ODBC Driver Information =
= =
===================================================================
ODBC version = '03.80.0000'
DBMS name = 'Teradata'
DBMS version = '15.00.0208 15.00.02.08'

**** 16:23:42 Warning: The ODBC Driver used is not distributed by Teradata and
might give unexpected results

Driver name = 'TDATA32.DLL'
Driver version = '15.10.01.01'
Driver ODBC version = '03.80'

===================================================================
= =
= Source Table Column/Field Defintion =
= =
===================================================================
Column Name Offset Length Type
============================== ====== ====== ========================
Subscriber_No 0 4 INTEGER
Street 4 30 VARCHAR
City 34 20 VARCHAR
State 54 2 CHAR
Zip 56 4 INTEGER
AreaCode 60 2 SMALLINT
Phone 62 4 INTEGER
============================== ====== ====== ========================
EXPECTED RECORD LENGTH: 66

===================================================================
= =
= Column/Field Definition =
= =
===================================================================
Column Name Offset Length Type
============================== ====== ====== ========================
Subscriber_No 0 4 INTEGER
Street 4 30 VARCHAR
City 36 20 VARCHAR
"State" 58 2 CHAR
Zip 60 4 INTEGER
AreaCode 64 2 SMALLINT
Phone 66 4 INTEGER
============================== ====== ====== ========================
INDICATOR BYTES NEEDED: 1
EXPECTED RECORD LENGTH: 71
CLIv2 : 15.10.01.01
Addresses_LoadJob-45,116,5,UtilityName,MAIN_STEP,StreamOperator,1,2016-08-22,TPT Stream Operator,1,0
Addresses_LoadJob-45,4,5,StreamVersionId,MAIN_STEP,StreamOperator,1,2016-08-22,15.10.01.02,1,0
Addresses_LoadJob-45,115,1,UtilityId,MAIN_STEP,StreamOperator,1,2016-08-22,5,1,0
Addresses_LoadJob-45,134,5,StreamTdpId,MAIN_STEP,StreamOperator,1,2016-08-22,tdat15,1,0
Addresses_LoadJob-45,5,5,StreamUserName,MAIN_STEP,StreamOperator,1,2016-08-22,dbc,1,0

===================================================================
= =
= Attribute Definitions =
= =
===================================================================
**** 16:23:44 Options in effect for this job:
OperatorType: Consumer
Instances: 1
Character set: Not specified; will use default
Checkpoint: No checkpoint in effect
Notify: Not enabled
Error limit: No limit in effect
Tenacity: 4 hour limit to successfully connect
Sleep: 6 minute(s) between connect retries
Buffers: 3
Pack: 20
Robust: In effect
StreamOperator: Start-up Rate: UNLIMITED statements per Minute

===================================================================
= =
= Column/Field Definition =
= =
===================================================================
Column Name Offset Length Type
============================== ====== ====== ========================
Subscriber_No 0 4 INTEGER
Street 4 30 VARCHAR
City 36 20 VARCHAR
"State" 58 2 CHAR
Zip 60 4 INTEGER
AreaCode 64 2 SMALLINT
Phone 66 4 INTEGER
============================== ====== ====== ========================
INDICATOR BYTES NEEDED: 1
EXPECTED RECORD LENGTH: 71

===================================================================
= =
= Column/Field MacroCharSet Definition =
= =
===================================================================
Column Name MacroCharSet
============================== ====================================
Subscriber_No Not applicable
Street Not specified; will use default
City Not specified; will use default
"State" Not specified; will use default
Zip Not applicable
AreaCode Not applicable
Phone Not applicable
============================== ====================================
**** 16:23:44 Operator Command ID for External Command Interface: StreamOperator19212
StreamOperator: Operator Command ID for External Command Interface: StreamOperator19212

===================================================================
= =
= Control Session Connection =
= =
===================================================================
StreamOperator: connecting sessions
**** 16:23:44 Connecting to RDBMS: 'tdat15'
**** 16:23:44 Connecting with UserId: 'dbc'

**** 16:23:46 Number of Query Band data bytes sent to the RDBMS: 60
Addresses_LoadJob-45,130,5,StreamDbase,MAIN_STEP,StreamOperator,1,2016-08-22,SJB_TESTING,1,0

===================================================================
= =
= Teradata Database Information =
= =
===================================================================
**** 16:23:46 Teradata Database Version: '15.00.02.08'
**** 16:23:46 Teradata Database Release: '15.00.02.08'
**** 16:23:46 Maximum request size supported: 1MB
**** 16:23:46 Session character set: 'ASCII'
**** 16:23:46 RDBMS supports upsert SQL
**** 16:23:46 Data Encryption: supported
**** 16:23:46 RDBMS supports Array Support
**** 16:23:46 Enhanced Statement Status Level: 1
**** 16:23:46 RDBMS supports Statement Independence
**** 16:23:48 Restart log table 'SJB_TESTING.Addresses_tlog' has been created
**** 16:23:50 Error table 'SJB_TESTING.Addresses_ET' has been created
**** 16:23:50 Default MacroCharSet: 'LATIN'

===================================================================
= =
= Special Session Connection =
= =
===================================================================
**** 16:23:52 Maximum number of special sessions requested: All
**** 16:23:52 Minimum number of special sessions required: 1

Instance Assigned Connected Result
======== ======== ========= ======================
1 1 1 Successful
Addresses_LoadJob-45,180,1,TotalSessAssigned,MAIN_STEP,StreamOperator,1,2016-08-22,1,1,0
Addresses_LoadJob-45,181,1,TotalSessConnected,MAIN_STEP,StreamOperator,1,2016-08-22,1,1,0
Addresses_LoadJob-45,182,1,TASMSessionLimit,MAIN_STEP,StreamOperator,1,2016-08-22,0,1,0
======== ======== ========= ======================
Total 1 1 Successful
**** 16:23:52 Current working DATABASE set: 'SJB_TESTING'

===================================================================
= =
= DML Information =
= =
===================================================================
**** 16:23:52 DML statement for DML Group: 1

INSERT INTO SJB_TESTING.Addresses(:Subscriber_No, :Street, :City, :"State", :Zip, :AreaCode, :Phone);
Addresses_LoadJob-45,59,1,StreamImportBegin,MAIN_STEP,StreamOperator,1,2016-08-22,1,1,0
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 INITIATE-Ended 16:23:52 10.0000 0.2031 65000 0 0 0 0 0 N Y
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 INITIATE-Ended 16:23:52 10.0000 0.2031 65000 0 0 0 0 0 N Y
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 EXECUTE-Started 16:23:52 0.0000 0.0000 65000 0 0 0 0 0 N Y
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 EXECUTE-Started 16:23:52 0.0000 0.0000 65000 0 0 0 0 0 N Y
CheckPoint No. 1 started.
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 CHECKPOINT-Started 16:23:52 0.0000 0.0000 65000 0 0 0 0 0 N Y
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 CHECKPOINT-Started 16:23:52 0.0000 0.0000 65000 0 0 0 0 0 N Y
Task(APPLY_1[0001]): checkpoint completed, status = Success
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 CHECKPOINT-Ended 16:23:53 1.0000 0.0000 65000 0 0 0 0 0 N Y
Task(SELECT_2[0001]): checkpoint completed, status = Success
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 CHECKPOINT-Ended 16:23:53 1.0000 0.0000 65000 0 0 0 0 0 N Y
CheckPoint No. 1 finished successfully.

===================================================================
= =
= Select Request =
= =
===================================================================
**** 16:23:53 This job is submitting the following request:

SELECT Subscriber_No ,Street ,City ,"State" ,Zip ,AreaCode ,Phone FROM SJB_TESTING.Addresses;

RowSet size per fetched data block: 30393

ODBCOperator: sending SELECT request
Total number of fetches: 2
**** 16:23:53 Finished receiving rows from the data source
ODBCOperator: data retrieval complete

===================================================================
= =
= Row Export Complete =
= =
===================================================================

Instance Rows Exported
======== =======================
1 6
======== =======================
Total 6
ODBCOperator: Total Rows Exported: 6

**** 16:23:53 Export Phase statistics:
Elapsed time: 00:00:00:00 (hh:mm:ss)
CPU time: 0 Second(s)
MB/sec: could not be determined
MB/cpusec: could not be determined
CheckPoint No. 2 started.
Task(SELECT_2[0001]) ready to checkpoint

===================================================================
= =
= Load Phase =
= =
===================================================================
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 CHECKPOINT-Started 16:23:53 1.0000 0.0156 65000 1 0 6 0 0 Y Y
StreamOperator: entering Load Phase
**** 16:23:53 Starting to send data to the RDBMS
Task(SELECT_2[0001]): checkpoint completed, status = Success
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 CHECKPOINT-Started 16:23:54 2.0000 0.0000 65000 1 6 0 0 0 N Y
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 CHECKPOINT-Ended 16:23:54 2.0000 0.0156 65000 1 0 6 0 0 Y Y
Addresses_LoadJob-45,165,37,StreamCheckPoint,MAIN_STEP,StreamOperator,1,2016-08-22,6,1,0
**** 16:23:54 Checkpoint complete. Rows sent: 6
Task(APPLY_1[0001]): checkpoint completed, status = Success
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 CHECKPOINT-Ended 16:23:55 3.0000 0.0000 65000 1 6 0 0 0 N Y
CheckPoint No. 2 finished successfully.
Task(SELECT_2[0001]) ready to take the EOD checkpoint
CheckPoint No. 3 started.
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 CHECKPOINT-Started 16:23:55 3.0000 0.0000 65000 1 6 0 0 0 Y Y
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 CHECKPOINT-Started 16:23:55 3.0000 0.0156 65000 1 0 6 0 0 Y Y
Addresses_LoadJob-45,165,37,StreamCheckPoint,MAIN_STEP,StreamOperator,1,2016-08-22,6,1,0
**** 16:23:55 Checkpoint complete. Rows sent: 6
Task(SELECT_2[0001]): checkpoint completed, status = Success
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 CHECKPOINT-Ended 16:23:56 4.0000 0.0156 65000 1 0 6 0 0 Y Y
Task(APPLY_1[0001]): checkpoint completed, status = Success
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 CHECKPOINT-Ended 16:23:56 4.0000 0.0000 65000 1 6 0 0 0 Y Y
CheckPoint No. 3 finished successfully.
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 EXECUTE-Ended 16:23:56 4.0000 0.0156 65000 1 0 6 0 0 Y Y
Addresses_LoadJob-45,187,1,SessConnectedByInstance,MAIN_STEP,StreamOperator,1,2016-08-22,1,1,0
Addresses_LoadJob-45,185,37,RowsSentByInstance,MAIN_STEP,StreamOperator,1,2016-08-22,6,1,0
**** 16:23:56 Finished sending rows to the RDBMS
**** 16:23:56 Number of bytes sent to the RDBMS for this job: 251
Addresses_LoadJob-45,60,1,StreamImportEnd,MAIN_STEP,StreamOperator,1,2016-08-22,1,1,0
Addresses_LoadJob-45,68,37,StreamRowsRead,MAIN_STEP,StreamOperator,1,2016-08-22,6,1,0
Addresses_LoadJob-45,69,37,StreamRowsSkipped,MAIN_STEP,StreamOperator,1,2016-08-22,0,1,0
Addresses_LoadJob-45,70,37,StreamRowsRejected,MAIN_STEP,StreamOperator,1,2016-08-22,0,1,0
Addresses_LoadJob-45,71,37,StreamRowsSent,MAIN_STEP,StreamOperator,1,2016-08-22,6,1,0
Addresses_LoadJob-45,57,37,StreamDataErrors,MAIN_STEP,StreamOperator,1,2016-08-22,6,1,0
Addresses_LoadJob-45,82,1,StreamRunStatistics,MAIN_STEP,StreamOperator,1,2016-08-22,1,1,0
Addresses_LoadJob-45,83,37,StreamSQLStmtsSent,MAIN_STEP,StreamOperator,1,2016-08-22,12,1,0
Addresses_LoadJob-45,84,37,StreamReqsSent,MAIN_STEP,StreamOperator,1,2016-08-22,7,1,0
Addresses_LoadJob-45,68,37,StreamRowsRead,MAIN_STEP,StreamOperator,1,2016-08-22,6,1,0
Addresses_LoadJob-45,69,37,StreamRowsSkipped,MAIN_STEP,StreamOperator,1,2016-08-22,0,1,0
Addresses_LoadJob-45,70,37,StreamRowsRejected,MAIN_STEP,StreamOperator,1,2016-08-22,0,1,0
Addresses_LoadJob-45,71,37,StreamRowsSent,MAIN_STEP,StreamOperator,1,2016-08-22,6,1,0
Addresses_LoadJob-45,57,37,StreamDataErrors,MAIN_STEP,StreamOperator,1,2016-08-22,6,1,0

Instance Rows Sent
======== =======================
1 6
======== =======================
Total 6

**** 16:23:56 Load Statistics for DML Group 1 :
StreamOperator: Load Statistics for DML Group 1 :
Type: INSERT
Database: SJB_TESTING
Table or Macro Name: Addresses
Activity: 0
StreamOperator: Target Table: 'SJB_TESTING.Addresses'
StreamOperator: Rows Inserted: 0
Addresses_LoadJob-45,72,5,StreamTableStats,MAIN_STEP,StreamOperator,1,2016-08-22,Insert,1,0
Addresses_LoadJob-45,73,5,StreamDbaseName4InsTsk,MAIN_STEP,StreamOperator,1,2016-08-22,SJB_TESTING,1,0
Addresses_LoadJob-45,76,5,StreamTableName4InsTsk,MAIN_STEP,StreamOperator,1,2016-08-22,Addresses,1,0
Addresses_LoadJob-45,79,37,StreamActvtyCnt4InsTsk,MAIN_STEP,StreamOperator,1,2016-08-22,0,1,0
Addresses_LoadJob-45,139,0,StreamEndTableStats,MAIN_STEP,StreamOperator,1,2016-08-22,,1,0

**** 16:23:56 Load Phase statistics:
Elapsed time: 00:00:00:03 (dd:hh:mm:ss)
CPU time: 0 Second(s)
MB/sec: 0.000
MB/cpusec: could not be determined

===================================================================
= =
= Operator Task Cleanup =
= =
===================================================================
StreamOperator: entering Cleanup Phase
**** 16:23:57 Dropping macro 'SJB_TESTING.M16235_59031_00338_000_000'
**** 16:23:57 Macro 'SJB_TESTING.M16235_59031_00338_000_000' has been dropped
StreamOperator: Total Rows in Error Table : 6
Addresses_LoadJob-45,56,5,StreamErrorTable,MAIN_STEP,StreamOperator,1,2016-08-22,SJB_TESTING.Addresses_ET,1,0
Addresses_LoadJob-45,57,37,StreamDataErrors,MAIN_STEP,StreamOperator,1,2016-08-22,6,1,0
**** 16:23:57 Error table SJB_TESTING.Addresses_ET contains 6 rows
**** 16:23:57 Dropping restart log table 'SJB_TESTING.Addresses_tlog'
**** 16:23:58 Restart log table 'SJB_TESTING.Addresses_tlog' has been dropped
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 EXECUTE-Ended 16:23:58 6.0000 0.0000 65000 1 6 0 0 0 Y Y
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 1, Total Rows Received = 6, Total Rows Sent = 0
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 TERMINATE-Started 16:23:58 0.0000 0.0000 65000 0 0 0 0 0 Y Y
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 1, Total Rows Received = 0, Total Rows Sent = 6
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 TERMINATE-Started 16:23:58 0.0000 0.0000 65000 0 0 0 0 0 Y Y
Addresses_LoadJob-45,186,3,CPUTimeByInstance,MAIN_STEP,StreamOperator,1,2016-08-22,0.203125,1,0
Addresses_LoadJob-45,186,3,CPUTimeByInstance,MAIN_STEP,ODBCOperator,1,2016-08-22,0.203125,2,0

===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
StreamOperator: disconnecting sessions
ODBCOperator: disconnecting sessions
**** 16:23:58 Logging off all sessions
**** 16:23:58 Logging off all sessions

Instance Cpu Time
======== ================
1 0.20 Seconds

**** 16:23:58 Total processor time used = '0.203125 Second(s)'
. Start : Mon Aug 22 16:23:42 2016
. End : Mon Aug 22 16:23:58 2016
. Highest return code encountered = '4'.
ODBCOperator: Total processor time used = '0.203125 Second(s)'
ODBCOperator: Start : Mon Aug 22 16:23:42 2016
ODBCOperator: End : Mon Aug 22 16:23:58 2016
**** 16:23:58 This job terminated
Addresses_LoadJob-45,179,5,OperatorEndTS,MAIN_STEP,ODBCOperator,1,2016-08-22,2016-08-22 16:23:58,2,0
Addresses_LoadJob-45,18,1,OperatorExit,MAIN_STEP,ODBCOperator,1,2016-08-22,4,2,0
MAIN_STEP SELECT_2[0001] Success ODBCOperator 1 1 TERMINATE-Ended 16:23:58 0.0000 0.0000 65000 0 0 0 0 0 Y Y
Addresses_LoadJob-45,137,0,StreamSessEnd,MAIN_STEP,StreamOperator,1,2016-08-22,,1,0

Instance Cpu Time
======== ================
1 0.20 Seconds

**** 16:23:58 Total processor time used = '0.203125 Second(s)'
. Start : Mon Aug 22 16:23:42 2016
. End : Mon Aug 22 16:23:58 2016
. Highest return code encountered = '0'.
StreamOperator: Total processor time used = '0.203125 Second(s)'
StreamOperator: Start : Mon Aug 22 16:23:42 2016
StreamOperator: End : Mon Aug 22 16:23:58 2016
**** 16:23:58 This job terminated
Addresses_LoadJob-45,179,5,OperatorEndTS,MAIN_STEP,StreamOperator,1,2016-08-22,2016-08-22 16:23:58,1,0
Addresses_LoadJob-45,18,1,OperatorExit,MAIN_STEP,StreamOperator,1,2016-08-22,0,1,0
MAIN_STEP APPLY_1[0001] Success StreamOperator 1 1 TERMINATE-Ended 16:23:58 0.0000 0.0000 65000 0 0 0 0 0 Y Y
Job step MAIN_STEP terminated (status 4)
Job Addresses_LoadJob completed successfully, but with warning(s).
Job start: Mon Aug 22 16:23:39 2016
Job end: Mon Aug 22 16:23:58 2016
Total available memory: 52428800
Largest allocable area: 52428800
Memory use high water mark: 72856
Free map size: 1024
Free map use high water mark: 19
Free list use high water mark: 0
Teradata Employee

Re: Easyloader Schema Error 15.10 Only

Your 15.10 job is not anything like the 15.0 job.

The 15.00 job uses the DataConnector operator and the Load operator.

The 15.10 job is using the ODBC operator and the Stream operator.

-- SteveF
Enthusiast

Re: Easyloader Schema Error 15.10 Only

Thanks Steve:  I think I was sent the incorrect private log.  I'll get back to you as soon as I can with the correct one.  Sorry for the confusion.

Enthusiast

Re: Easyloader Schema Error 15.10 Only

Hello Steve:

Again, sorry about the confusion.  Below is the error and the private log when running under 15.10.  We use the same command line switches for both loads.  I would assume that Easyload would be choosing the same operators each time, but that doesn't seem to be the case.  Is there a tweak we can do to get it to use the Data Connector and Load operators?  Thanks again for the help!

$FILE_READER[1]: TPT19108 Data Format 'DELIMITED' requires all 'VARCHAR/JSON/JSON BY NAME/CLOB BY NAME/BLOB BY NAME/XML BY NAME/XML/CLOB' schema.

$FILE_READER[1]: TPT19015 TPT Exit code set to 12.

     CLIv2      : 15.10.01.01   
TPT_INFRA: TPT04101: Warning: Teradata PT cannot connect to Unity EcoSystem Manager.
The job will continue without event messages being sent to Unity EcoSystem Manager.
TPT_INFRA: TPT04197: Warning: OMD API failed to initialize
Teradata Parallel Transporter Executor Version 15.10.01.02
Teradata Parallel Transporter Executor Version 15.10.01.02
Teradata Parallel Transporter Coordinator Version 15.10.01.02
MAIN_STEP SELECT_2[0001] $FILE_READER FILE C:\Users\Leona\AppData\Roaming\Coffing Data Warehousing\Nexus Portal\Scripts\TPT
MAIN_STEP APPLY_1[0001] $LOAD DBS tdat15 SJB_TESTING.addressesNEW
CheckPoint Resource Manager initialized.
Checking whether a valid CheckPoint exists for restart.
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 INITIATE-Started 19:27:08 0.0000 0.0000 65000 0 0 0 0 0 N Y
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 INITIATE-Started 19:27:08 0.0000 0.0000 65000 0 0 0 0 0 N Y
addressesNEW_LoadJob-47,17,5,OperatorEnter,MAIN_STEP,$LOAD,1,2016-08-22,2016-08-22 19:27:08,1,0
addressesNEW_LoadJob-47,176,5,OperatorVersion,MAIN_STEP,$LOAD,1,2016-08-22,15.10.01.02,1,0
addressesNEW_LoadJob-47,177,1,OperatorType,MAIN_STEP,$LOAD,1,2016-08-22,2,1,0
addressesNEW_LoadJob-47,178,1,OperatorInstances,MAIN_STEP,$LOAD,1,2016-08-22,1,1,0
Teradata Parallel Transporter DataConnector Operator Version 15.10.01.02
addressesNEW_LoadJob-47,184,5,PrivateLogName,MAIN_STEP,$LOAD,1,2016-08-22,LoadLog,1,0
$FILE_READER[1]: Instance 1 is not generating a private log report.
Teradata Parallel Transporter Load Operator Version 15.10.01.02
$LOAD: private log specified: LoadLog
$FILE_READER[1]: DataConnector Producer operator Instances: 1

===================================================================
= =
= TERADATA PARALLEL TRANSPORTER 32-BIT =
= =
= LOAD OPERATOR VERSION 15.10.01.02 =
= =
= OPERATOR SUPPORT LIBRARY VERSION 15.10.01.02 =
= =
= COPYRIGHT 2001-2016, TERADATA CORPORATION. =
= ALL RIGHTS RESERVED. =
= =
= Process I.D.: 29228 =
= =
===================================================================
**** 19:27:08 Processing starting at: Mon Aug 22 19:27:08 2016

===================================================================
= =
= Module Identification =
= =
===================================================================
32-bit Load Operator for Windows on Coffingdw
LoadMain : 15.10.00.06
LoadCLI : 15.10.00.07
LoadUtil : 14.10.00.01
PcomCLI : 15.10.01.02
PcomMBCS : 14.10.00.02
PcomMsgs : 15.10.01.01
PcomNtfy : 15.10.00.01
PcomPx : 15.10.01.01
PcomUtil : 15.10.01.04
PXICU : 15.10.01.02
TDICU : 15.10.01.01
$FILE_READER[1]: TPT19108 Data Format 'DELIMITED' requires all 'VARCHAR/JSON/JSON BY NAME/CLOB BY NAME/BLOB BY NAME/XML BY NAME/XML/CLOB' schema.
$FILE_READER[1]: TPT19015 TPT Exit code set to 12.
CLIv2 : 15.10.01.01
addressesNEW_LoadJob-47,116,5,UtilityName,MAIN_STEP,$LOAD,1,2016-08-22,TPT Load Operator,1,0
addressesNEW_LoadJob-47,0,5,LoadVersionId,MAIN_STEP,$LOAD,1,2016-08-22,15.10.01.02,1,0
addressesNEW_LoadJob-47,115,1,UtilityId,MAIN_STEP,$LOAD,1,2016-08-22,1,1,0
addressesNEW_LoadJob-47,132,5,LoadTdpId,MAIN_STEP,$LOAD,1,2016-08-22,tdat15,1,0
addressesNEW_LoadJob-47,1,5,LoadUserName,MAIN_STEP,$LOAD,1,2016-08-22,dbc,1,0

===================================================================
= =
= Attribute Definitions =
= =
===================================================================
**** 19:27:10 Options in effect for this job:
OperatorType: Consumer
Instances: 1
Character set: Not specified; will use default
Checkpoint: No checkpoint in effect
Notify: Not enabled
Buffer size: Maximum allowable
Error limit: No limit in effect
Tenacity: 4 hour limit to successfully connect
Sleep: 6 minute(s) between connect retries
Pause Acq: Not in effect

===================================================================
= =
= Column/Field Definition =
= =
===================================================================
Column Name Offset Length Type
============================== ====== ====== ========================
"SUBSCRIBER_NO" 0 8 FLOAT
"STREET" 8 255 VARCHAR
"CITY" 265 255 VARCHAR
"STATE" 522 255 VARCHAR
"ZIP" 779 8 FLOAT
"AREACODE" 787 8 FLOAT
"PHONE" 795 8 FLOAT
============================== ====== ====== ========================
INDICATOR BYTES NEEDED: 1
EXPECTED RECORD LENGTH: 804

===================================================================
= =
= Control Session Connection =
= =
===================================================================
$LOAD: connecting sessions
**** 19:27:10 Connecting to RDBMS: 'tdat15'
**** 19:27:10 Connecting with UserId: 'dbc'

**** 19:27:11 Number of Query Band data bytes sent to the RDBMS: 120
addressesNEW_LoadJob-47,128,5,LoadDbase,MAIN_STEP,$LOAD,1,2016-08-22,SJB_TESTING,1,0

===================================================================
= =
= Teradata Database Information =
= =
===================================================================
**** 19:27:11 Teradata Database Version: '15.00.02.08'
**** 19:27:11 Teradata Database Release: '15.00.02.08'
**** 19:27:11 Maximum request size supported: 1MB
**** 19:27:11 Session character set: 'ASCII'
**** 19:27:11 Total AMPs available: 2
**** 19:27:11 Data Encryption: supported
**** 19:27:11 Enhanced Statement Status Level: 1
**** 19:27:11 Restart log table 'SJB_TESTING.addressesNEW_Log' has been created
**** 19:27:11 Current working DATABASE set: 'SJB_TESTING'

===================================================================
= =
= Special Session Connection =
= =
===================================================================
**** 19:27:12 Number of sessions adjusted due to TASM: 2

Instance Assigned Connected Result
======== ======== ========= ======================
1 2 2 Successful
addressesNEW_LoadJob-47,180,1,TotalSessAssigned,MAIN_STEP,$LOAD,1,2016-08-22,2,1,0
addressesNEW_LoadJob-47,181,1,TotalSessConnected,MAIN_STEP,$LOAD,1,2016-08-22,2,1,0
addressesNEW_LoadJob-47,182,1,TASMSessionLimit,MAIN_STEP,$LOAD,1,2016-08-22,2,1,0
======== ======== ========= ======================
Total 2 2 Successful

===================================================================
= =
= Target/Error Table Information =
= =
===================================================================
$LOAD: preparing target table
**** 19:27:12 This job will use the following tables:

Target Table: 'SJB_TESTING.addressesNEW'
Error Table 1: 'SJB_TESTING.addressesNEW_ET'
Error Table 2: 'SJB_TESTING.addressesNEW_UV'

===================================================================
= =
= Acquisition Phase =
= =
===================================================================
$LOAD: entering Acquisition Phase
**** 19:27:13 DML statement for DML Group: 1

INSERT INTO SJB_TESTING.addressesNEW VALUES ( :"SUBSCRIBER_NO", :"STREET", :"CITY", :"STATE", :"ZIP", :"AREACODE", :"PHONE");

**** 19:27:13 Number of records per buffer for this job: 79
addressesNEW_LoadJob-47,21,1,LoadTableId,MAIN_STEP,$LOAD,1,2016-08-22,1,1,1
addressesNEW_LoadJob-47,22,5,LoadTableName,MAIN_STEP,$LOAD,1,2016-08-22,SJB_TESTING.addressesNEW,1,1
addressesNEW_LoadJob-47,19,5,LoadPhase1Begin,MAIN_STEP,$LOAD,1,2016-08-22,2016-08-22 19:27:13,1,1
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 TERMINATE-Started 19:27:13 0.0000 0.0000 65000 0 0 0 0 0 N Y
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 TERMINATE-Started 19:27:13 0.0000 0.0000 65000 0 0 0 0 0 N Y
addressesNEW_LoadJob-47,186,3,CPUTimeByInstance,MAIN_STEP,$LOAD,1,2016-08-22,0.281250,1,0
$FILE_READER[1]: Total files processed: 0.
MAIN_STEP SELECT_2[0001] Success $FILE_READER 1 1 TERMINATE-Ended 19:27:13 0.0000 0.0000 65000 0 0 0 0 0 N Y

===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
$LOAD: disconnecting sessions
**** 19:27:13 Logging off all sessions
addressesNEW_LoadJob-47,135,0,LoadSessEnd,MAIN_STEP,$LOAD,1,2016-08-22,,1,0

Instance Cpu Time
======== ================
1 0.28 Seconds

**** 19:27:13 Total processor time used = '0.28125 Second(s)'
. Start : Mon Aug 22 19:27:08 2016
. End : Mon Aug 22 19:27:13 2016
. Highest return code encountered = '0'.
$LOAD: Total processor time used = '0.28125 Second(s)'
$LOAD: Start : Mon Aug 22 19:27:08 2016
$LOAD: End : Mon Aug 22 19:27:13 2016
**** 19:27:13 This job terminated
addressesNEW_LoadJob-47,179,5,OperatorEndTS,MAIN_STEP,$LOAD,1,2016-08-22,2016-08-22 19:27:13,1,0
addressesNEW_LoadJob-47,18,1,OperatorExit,MAIN_STEP,$LOAD,1,2016-08-22,0,1,0
MAIN_STEP APPLY_1[0001] Success $LOAD 1 1 TERMINATE-Ended 19:27:13 0.0000 0.0000 65000 0 0 0 0 0 N Y
Job step MAIN_STEP terminated (status 12)
Job addressesNEW_LoadJob terminated (status 12)
Job start: Mon Aug 22 19:27:07 2016
Job end: Mon Aug 22 19:27:13 2016
Total available memory: 20000000
Largest allocable area: 20000000
Memory use high water mark: 57528
Free map size: 1024
Free map use high water mark: 19
Free list use high water mark: 0
Teradata Employee

Re: Easyloader Schema Error 15.10 Only

As you can see in the column/field definition, you have a FLOAT field.

The error is to be expected.

In order to process delimited datam the schema must be all VARCHAR.

In the job output above from the 15.00 TPT, all of the fields were defined as VARCHAR.

That is why it worked.

-- SteveF
Enthusiast

Re: Easyloader Schema Error 15.10 Only

I may be running into this issue as well. How does tdload determine the source Schema?

I'm following along with the setup here: http://developer.teradata.com/database/articles/teradata-express-14-0-for-vmware-user-guide which shows a table being created with an INTEGER field, but I'm not able to successfully load data if my table has any non-VARCHAR fields. My thought was that tdload is getting the source schema from the target table schema, but if that's the case, then the example in the link above shouldn't work. Am I missing something?

Here's my table:

CREATE TABLE TestDB.TestTable

(ColInt INTEGER,

ColVarchar VARCHAR(20))

Here's the tdload command:

C:\Users\Dave\Desktop>tdload

--SourceFileName "C:\Users\Dave\Desktop\test.csv"

--TargetTdpId localtdat

--TargetWorkingDatabase TestDB

--TargetTable TestDB.TestTable  

--TargetUserName dbc

--TargetUserPassword dbc  

testJob

Here's the result:

Teradata Load Utility Version 15.10.01.02 32-Bit

TDLOAD: TPT05550: Warning: no Source File Delimiter specified, default "," will be used

Teradata Parallel Transporter Version 15.10.01.02 32-Bit

Job log: C:\Program Files (x86)\Teradata\client\15.10\Teradata Parallel Transporter/logs/testJob-1.out

Job id is testJob-1, running on DavePC

Teradata Parallel Transporter DataConnector Operator Version 15.10.01.02

$FILE_READER[1]: DataConnector Producer operator Instances: 1

$FILE_READER[1]: TPT19108 Data Format 'DELIMITED' requires all 'VARCHAR/JSON/JSON BY NAME/CLOB BY NAME/BLOB BY NAME/XML BY NAME/XML/CLOB' schema.

$FILE_READER[1]: TPT19015 TPT Exit code set to 12.

Teradata Parallel Transporter Load Operator Version 15.10.01.02

$LOAD: private log specified: LoadLog

$LOAD: connecting sessions

$LOAD: preparing target table

$LOAD: entering Acquisition Phase

$FILE_READER[1]: Total files processed: 0.

$LOAD: disconnecting sessions

$LOAD: Total processor time used = '0.28125 Second(s)'

$LOAD: Start : Wed Aug 24 10:32:48 2016

$LOAD: End   : Wed Aug 24 10:32:51 2016

Job step MAIN_STEP terminated (status 8)

Job testJob terminated (status 8)

Job start: Wed Aug 24 10:32:44 2016

Job end:   Wed Aug 24 10:32:51 2016

Thanks!