All Forums Tools
toadrw 69 posts Joined 07/04
22 Aug 2016
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

feinholz 1234 posts Joined 05/08
22 Aug 2016

SUBSCRIBER_NO is defined as FLOAT.
It needs to be VARCHAR.
 

--SteveF

toadrw 69 posts Joined 07/04
22 Aug 2016

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

feinholz 1234 posts Joined 05/08
22 Aug 2016

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

toadrw 69 posts Joined 07/04
22 Aug 2016

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

 

feinholz 1234 posts Joined 05/08
22 Aug 2016

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

toadrw 69 posts Joined 07/04
22 Aug 2016

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.

toadrw 69 posts Joined 07/04
22 Aug 2016

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

 

feinholz 1234 posts Joined 05/08
23 Aug 2016

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

dlcook 4 posts Joined 08/16
24 Aug 2016

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!

toadrw 69 posts Joined 07/04
24 Aug 2016

I guess the issue I'm having if we are moving a flat file to Teradata why doesn't Easy Loader assume all VARCHAR?
Does this mean we need to create a job variables files with the proper schema for the flat file (it would be all VARCHAR I assume)? We're not using one in 15.00.
I also still don't understand why we're seeing FLOATS from easy loader in 15.10 when it was previously all VARCHAR in 15.00?
You've always been very helpful, Steve, when I've posted in the forum.  I appreciate all the time you have given to this question.  We'll do our best to workaround this, but something doesn't seem right here. :/  Thanks again!!!

feinholz 1234 posts Joined 05/08
24 Aug 2016

If you are loading data from a flat file to the Teradata Database, the schema will be taken from the target table.
However, it looks like we may have a bug/regression from when EasyLoader was introduced in TPT 13.0.
Please add --SourceFormat 'delimited' and that should tell EasyLoader to convert the target table schema to all-VARCHAR.
 

--SteveF

feinholz 1234 posts Joined 05/08
24 Aug 2016

Well, I could have edited the previous comment but did not in case someone read the old one.
I checked with the developer to make sure no regressions have occurred and I was assured no regressions have been introduced.
 
When EasyLoader was first released with TPT 13.0, the idea was to facilitate the loading of data from a delimited flat file to Teradata without the need for a script. And the rule was that the data in the file had to match the table layout exactly (column for column). Thus, EasyLoader would take the schema from the target table and convert the non-VARCHAR columns to VARCHAR and thus generate an all-VARCHAR schema.
 
EasyLoader should still work that way. 
 
Thus, I will investigate.
 

--SteveF

feinholz 1234 posts Joined 05/08
24 Aug 2016

Ok, another update. Yes we have a regression. We were doing an EasyLoader overhaul and introduced a bug (that is currently being fixed).
If you add --SourceFormat delimited (I do not remember whether you need quotes around it), that should get around the bug.
 
 

--SteveF

toadrw 69 posts Joined 07/04
24 Aug 2016

You're best Steve!  Once again you came through and I'm so appreciative!  Teradata is lucky to have you and thank you for sticking with this through until the end and providing us with excellent guidance as usual.
--Todd

dlcook 4 posts Joined 08/16
24 Aug 2016

 

Adding --SourceFormat delimited and --SourceFormat "delimited" both produce identical results to above.

 

Adding --SourceFormat 'delimited' produces:

 

Teradata Parallel Transporter Version 15.10.01.02 32-Bit

TPT_INFRA: TPT04187: Error: Line 9 of Local Job Variable File:

The value assignment of job variable 'DELIMITED' lacks a value specification in source file 'C:\Program Files (x86)\Teradata\client\15.10\Teradata Parallel Transporter/logs\TptScript_12160_jv'.

Job script preprocessing failed.

 

Job terminated with status 8.

 

 

Here's the contents of TptScript_12160_jv:

 

SOURCEINSTANCES = 1,

FILEINSTANCES = 1,

SOURCEMINSESSIONS = 1,

SOURCEMAXSESSIONS = 32,

TARGETINSTANCES = 1,

LOADINSTANCES = 1,

LOADMINSESSIONS = 1,

LOADMAXSESSIONS = 32,

DCPFORMAT = 'DELIMITED',

DCPOPENMODE = 'Read',

DCPTEXTDELIMITER = ',',

DCPTRACELEVEL = 'None',

TARGETFORMAT = 'DELIMITED',

TARGETOPENMODE = 'Write',

TARGETTEXTDELIMITER = ',',

LOADTRACELEVEL = 'None',

DCPFILENAME = 'C:\Users\Dave\Desktop\test.csv',

TARGETTDPID = 'tdat15',

TARGETWORKINGDATABASE = 'TestDB',

TARGETTABLE = 'TestDB.TestTable',

TARGETUSERNAME = 'dbc',

TARGETUSERPASSWORD = 'dbc' 

 

Is it perhaps a different keyword?
 
Thanks!

You must sign in to leave a comment.