TPT FastExport -Job step MAIN_STEP terminated (status 12)

Database
Enthusiast

Re: TPT FastExport -Job step MAIN_STEP terminated (status 12)

log continued......

 

PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'MaxKbSizeForSLOB'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'MaxKbSizeForSLOB' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: max SLOB size (in bytes): 1024000
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'MaxSingleLOBinKB'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'MaxSingleLOBinKB' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: max single LOB size (in bytes) using SLOB mode: 0
PC_GETCLIATTRS: *************************************************
PC_GETCLIATTRS: leaving
PC_LOADCLI: entering
PC_LOADCLI: bufsize: 45
PC_LOADCLI: allocating memory for CLI library name
PC_LOADCLI: allocated memory for CLI library name at 0x1f77670
PC_LOADCLI: CLI library: '/opt/teradata/client/15.10/lib64/libcliv2.so'
PC_LOADCLI: opening the CLI library
PC_LOADCLI: opened the CLI library
PC_LOADCLI: addr of the CLI library: 0x1f776f0
PC_LOADCLI: finding the symbols in the CLI library
PC_LOADCLI: finding the symbol: 'DBCHINI'
PC_LOADCLI: found the symbol: 'DBCHINI'
PC_LOADCLI: addr of the 'DBCHINI' symbol: 0x6f6cde1
PC_LOADCLI: finding the symbol: 'DBCHCL'
PC_LOADCLI: found the symbol: 'DBCHCL'
PC_LOADCLI: addr of the 'DBCHCL' symbol: 0x6f69ba9
PC_LOADCLI: finding the symbol: 'DBCHWL'
PC_LOADCLI: found the symbol: 'DBCHWL'
PC_LOADCLI: addr of the 'DBCHWL' symbol: 0x6f71b05
PC_LOADCLI: finding the symbol: 'DBCHQE'
PC_LOADCLI: found the symbol: 'DBCHQE'
PC_LOADCLI: addr of the 'DBCHQE' symbol: 0x6f6d5a2
PC_LOADCLI: finding the symbol: 'DBCHCLN'
PC_LOADCLI: found the symbol: 'DBCHCLN'
PC_LOADCLI: addr of the 'DBCHCLN' symbol: 0x6f6b509
PC_LOADCLI: number of CLI function names: 5
PC_LOADCLI: sizeof my_cli->CliFunctionPtrs: 40
PC_LOADCLI: sizeof void *: 8
PC_LOADCLI: number of CLI function ptrs: 5
PC_LOADCLI: leaving with return code: 0
PC_INITCLI: entering
PC_INITCLI: allocated default DBCAREA at: 0x1f77d30
PC_INITCLI: set automaticRedrive to: 'E'
PC_INITCLI: DBCHINI returns charset string: 'ASCII '
PC_INITCLI: DBCHINI returns charset type: ' '
PC_INITCLI: allocated buffer for larger CLI msg: 0x1fc3460
PC_INITCLI: dbciMsgM set to: 4096
PC_GETDBSLIMITS: entering
PC_GETDBSLIMITS: calling DBCHQE for CLI Limits
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 35
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: 'tdpid'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'tdpid'
PC_ISSUEDBCHQE: length of TDPid is: 8
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_ISRETRY: entering with result, DBSError: 0, 0
PC_ISRETRY: no error; leaving
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETDBSLIMITS: MaxRequestBytes: 1048500
PC_GETDBSLIMITS: calling DBCHQE for DBS Limits
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 36
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: 'tdpid'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'tdpid'
PC_ISSUEDBCHQE: length of TDPid is: 8
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_ISRETRY: entering with result, DBSError: 0, 0
PC_ISRETRY: no error; leaving
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETDBSLIMITS: MaxRowBytes: 64768
PC_GETDBSLIMITS: MaxLobBytes: 2097088000
PC_GETDBSLIMITS: MaxObjectNameChars: 128
PC_GETDBSLIMITS: MaxColinTbl: 2048
PC_GETDBSLIMITS: MaxTblinSel: 64
PC_GETDBSLIMITS: MaxColinSel: 65535
PC_GETDBSLIMITS: MaxColGrpBy: 191
PC_GETDBSLIMITS: MaxColOrdrBy: 16
PC_GETDBSLIMITS: MaxCharLiteralChars: 31000
PC_GETDBSLIMITS: MaxBinLiteralChars: 62000
PC_GETDBSLIMITS: MaxColBytes: 64000
PC_GETDBSLIMITS: MaxCharChars: 64000
PC_GETDBSLIMITS: MaxVarcharChars: 64000
PC_GETDBSLIMITS: MaxByteBytes: 64000
PC_GETDBSLIMITS: MaxVarbyteBytes: 64000
PC_GETDBSLIMITS: MaxDecimal: 38
PC_GETDBSLIMITS: MaxTimeScale: 6
PC_GETDBSLIMITS: MaxTimeStampScale: 6
PC_GETDBSLIMITS: MaxFldsUsingRow: 2537
PC_GETDBSLIMITS: MaxParamsInRequest: 2537
PC_GETDBSLIMITS: max single LOB size (in bytes) using SLOB mode: 2097088000
PC_GETDBSLIMITS: leaving with return code: 0
PC_GETMECHANISM: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 32
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: 'tdpid'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'tdpid'
PC_ISSUEDBCHQE: length of TDPid is: 8
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_ISRETRY: entering with result, DBSError: 0, 0
PC_ISRETRY: no error; leaving
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETMECHANISM: DBCHQE returns: 0
PC_GETMECHANISM: mechanisms not returned: 3
PC_GETMECHANISM: mechanisms returned: 1
PC_GETMECHANISM: logon mechanism is supported
PC_GETMECHANISM: leaving with result: 0
PC_GETRESULTSUMMARY: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 29
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: 'tdpid'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'tdpid'
PC_ISSUEDBCHQE: length of TDPid is: 8
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_ISRETRY: entering with result, DBSError: 0, 0
PC_ISRETRY: no error; leaving
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETRESULTSUMMARY: DBCHQE flag is: 'N'
PC_GETRESULTSUMMARY: result summary not supported by DBS
PC_GETRESULTSUMMARY: leaving with result: 0
PC_GETBIGINTSUPPORT: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 39
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: 'tdpid'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'tdpid'
PC_ISSUEDBCHQE: length of TDPid is: 8
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_ISRETRY: entering with result, DBSError: 0, 0
PC_ISRETRY: no error; leaving
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETBIGINTSUPPORT: DBCHQE flag is: 'Y'
PC_GETBIGINTSUPPORT: setting BIGINT flag to TRUE
PC_GETBIGINTSUPPORT: leaving with result: 0
PC_GETTASMSUPPORT: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 23
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: 'tdpid'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'tdpid'
PC_ISSUEDBCHQE: length of TDPid is: 8
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_ISRETRY: entering with result, DBSError: 0, 0
PC_ISRETRY: no error; leaving
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETTASMSUPPORT: DBCHQE flag is: 'Y'
PC_GETTASMSUPPORT: setting TASM support flag to TRUE
PC_GETTASMSUPPORT: leaving with result: 0
PC_GETESSSUPPORT: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 56
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: 'tdpid'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'tdpid'
PC_ISSUEDBCHQE: length of TDPid is: 8
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_ISRETRY: entering with result, DBSError: 0, 0
PC_ISRETRY: no error; leaving
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETESSSUPPORT: DBCHQE flag is: 1
PC_GETESSSUPPORT: ESS support level: 1
PC_GETESSSUPPORT: leaving with result: 0
PC_GETLOBSUPPORT: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 18
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: 'tdpid'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'tdpid'
PC_ISSUEDBCHQE: length of TDPid is: 8
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_ISRETRY: entering with result, DBSError: 0, 0
PC_ISRETRY: no error; leaving
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETLOBSUPPORT: DBCHQE flag is: 'Y'
PC_GETLOBSUPPORT: leaving with result: 0
PC_GETSLOBSUPPORT: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 57
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: 'tdpid'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'tdpid'
PC_ISSUEDBCHQE: length of TDPid is: 8
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_ISRETRY: entering with result, DBSError: 0, 0
PC_ISRETRY: no error; leaving
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETSLOBSUPPORT: SLOB client-to-server support level: 1
PC_GETSLOBSUPPORT: DBS supports SLOB client-to-server level: 1
PC_GETSLOBSUPPORT: SLOB server-to-client support level: 1
PC_GETSLOBSUPPORT: DBS supports SLOB server-to-client level: 1
PC_GETSLOBSUPPORT: leaving with result: 0
PC_GETAPHSUPPFORSPECSESS: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 23
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: 'tdpid'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'tdpid'
PC_ISSUEDBCHQE: length of TDPid is: 8
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_ISRETRY: entering with result, DBSError: 0, 0
PC_ISRETRY: no error; leaving
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETAPHSUPPFORSPECSESS: returned data length: 7
PC_GETAPHSUPPFORSPECSESS: DBCHQE flag is: 'Y'
PC_GETAPHSUPPFORSPECSESS: CLI supports APH for spec sess
PC_GETAPHSUPPFORSPECSESS: leaving with result: 0
PC_INITCLI: leaving
PC_INITCLICHARSET: entering
PC_INITCLICHARSET: charset attribute was set
PC_SETCLICHARSET: entering with charset: 'UTF8'
PC_SETCLICHARSET: character set is a name
PC_SETCLICHARSET: character set type: 'N'
PC_SETCLICHARSET: character set is : 'UTF8'
PC_SETCLICHARSET: character set type: 'N'
PC_SETCLICHARSET: character set is : 'UTF8 '
PC_SETCLICHARSET: leaving
PC_INITCLICHARSET: default charset: 'UTF8 '
PC_INITCLICHARSET: default chartype: 'N'
PC_INITCLICHARSET: leaving
PC_OPENSESSCHARSETCONV: entering
PC_OPENSESSCHARSETCONV: charset name: 'UTF8 '
PC_OPENSESSCHARSETCONV: charset name without spaces: 'UTF8'
PC_OPENSESSCHARSETCONV: found charset name
PC_OPENSESSCHARSETCONV: converter name: 'UTF8'
PC_OPENCONVERTER: entering
PC_OPENCONVERTER: opening 'UTF8' converter
PC_OPENCONVERTER: allocated charset_conv, addr: 0x1fc4470
PC_OPENCONVERTER: opening ToU callback facility
PC_OPENCONVERTER: opening FromU callback facility
PC_OPENCONVERTER: leaving with return code: 0
PC_OPENSESSCHARSETCONV: leaving with return code: 0
PC_GETCLIVERSION: entering
PC_GETCLIVERSION: calling DBCHQE for CLI version id
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 0
PC_ISSUEDBCHQE: qepItem: 9
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: not using TDP ID or SESS ID for this query
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_ISRETRY: entering with result, DBSError: 0, 0
PC_ISRETRY: no error; leaving
PC_ISSUEDBCHQE: leaving with return code: 0
CLIv2 : 15.10.00.03
PC_GETCLIVERSION: leaving with return code: 0
PC_CHECKANSIDATE: entering
PC_CHECKANSIDATE: checking if 'col1' is an ANSI Date field
PC_CHECKANSIDATE: checking if 'col2' is an ANSI Date field
PC_CHECKANSIDATE: checking if 'col3' is an ANSI Date field
.
.
.
PC_CHECKANSIDATE: checking if 'col61' is an ANSI Date field
PC_CHECKANSIDATE: leaving
PC_INITCLIOPER: leaving
GETMYSPECOPERATTRS: entering
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'DateForm'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'DateForm' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYSPECOPERATTRS: *********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'ReportModeOn'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 1
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYOPERATTRS: ReportModeOn: 0
GETMYOPERATTRS: *********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'IsolationLevel'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'IsolationLevel' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYOPERATTRS: *********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'AddBOMToFile'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'AddBOMToFile' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYOPERATTRS: *********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SelectStmt'
PC_GETATTRIBUTE: mandatory: 1
PC_GETATTRIBUTE: attribute length: 10775
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYSPECOPERATTRS: SELECT request: 'SELECT * from ( SELECT a115.col1 col1, pa12.col2 col2, MAX(a117.col3) col3, MAX(COALESCE(a19.col4,'_')) col4, , CASE WHEN a16.col5 LIKE '%A18-34%' OR a16.col5 LIKE '%P18-34%' THEN 'A18-34' WHEN a16.col5 LIKE '%A13-34%' THEN 'A13-34' ELSE 'P2+' END AS dcol, FROM table1 left join table 2 on join condition .....join table 31 on join condition WHERE col1 like '%sf%' GROUP BY col1,col2...col 55 ) A ;'
GETMYSPECOPERATTRS: ********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'MaxDecimalDigits'
PC_GETATTRIBUTE: mandatory: 0
PC_SETCODE: entering
PC_SETCODE: current condition code: 0
PC_SETCODE: setting condition code: 12
PC_SETCODE: leaving
PC_GETATTRIBUTE: invalid length rcvd; expect: 4, received: 2
PC_CHECKOPERINIT: entering
PC_REPORTERROR: entering
PC_REPORTERROR: error message global memory, instance 1
PC_REPORTERROR: code: 0
PC_REPORTERROR: sev: 0
PC_REPORTERROR: type: 0
PC_REPORTERROR: arg1: 0
PC_REPORTERROR: arg2: 0
PC_REPORTERROR: arg3: 0
PC_REPORTERROR: arg4: 0
PC_REPORTERROR: arg5: 0
PC_REPORTERROR: len1: 0
PC_REPORTERROR: msg1:
PC_REPORTERROR: len2: 0
PC_REPORTERROR: msg2:
PC_REPORTERROR: len3: 0
PC_REPORTERROR: msg3:
PC_REPORTERROR: ll_arg1: 0
PC_REPORTERROR: ll_arg2: 0
PC_REPORTERROR: ll_arg3: 0
PC_REPORTERROR: ll_arg4: 0
PC_REPORTERROR: ll_arg5: 0
PC_CLEARERRORINFO: entering
PC_CLEARERRORINFO: leaving
PC_REPORTERROR: leaving with return code: 0
PC_GETCPUTIME: entering
PC_GETCPUTIME: leaving
PC_UPDATESLAVEINFO: ************************************************
PC_UPDATESLAVEINFO: entering
PC_UPDATESLAVEINFO: Instance: 1 after read
PC_UPDATESLAVEINFO: Number of Bytes: 104
PC_UPDATESLAVEINFO: Sessions To Connect: 0
PC_UPDATESLAVEINFO: Sessions Connected: 0
PC_UPDATESLAVEINFO: Total Rows Loaded: 0
PC_UPDATESLAVEINFO: Total Error Rows: 0
PC_UPDATESLAVEINFO: Connect Result: 0
PC_UPDATESLAVEINFO: Cpu Time: 0
PC_UPDATESLAVEINFO: Load Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Export Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Number Of Stmts: 0
PC_UPDATESLAVEINFO: Use MLX: 0
PC_UPDATESLAVEINFO: Rows Exported: 0
PC_UPDATESLAVEINFO: Rows Sent To DBS: 0
PC_UPDATESLAVEINFO: Number of Blocks: 0
PC_UPDATESLAVEINFO: NoSpool Export: 0
PC_UPDATESLAVEINFO: Bytes Sent To DBS: 0
PC_UPDATESLAVEINFO: Bytes Exported: 0
PC_UPDATESLAVEINFO: updating CpuTime field
PC_UPDATESLAVEINFO: Instance: 1 before write
PC_UPDATESLAVEINFO: Number of Bytes: 104
PC_UPDATESLAVEINFO: Sessions To Connect: 0
PC_UPDATESLAVEINFO: Sessions Connected: 0
PC_UPDATESLAVEINFO: Total Rows Loaded: 0
PC_UPDATESLAVEINFO: Total Error Rows: 0
PC_UPDATESLAVEINFO: Connect Result: 0
PC_UPDATESLAVEINFO: Cpu Time: 0.03
PC_UPDATESLAVEINFO: Load Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Export Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Number Of Stmts: 0
PC_UPDATESLAVEINFO: Use MLX: 0
PC_UPDATESLAVEINFO: Rows Exported: 0
PC_UPDATESLAVEINFO: Rows Sent To DBS 0
PC_UPDATESLAVEINFO: Number of Blocks 0
PC_UPDATESLAVEINFO: NoSpool Export: 0
PC_UPDATESLAVEINFO: Bytes Sent To DBS 0
PC_UPDATESLAVEINFO: Bytes Exported: 0
PC_UPDATESLAVEINFO: leaving with result: 0
PC_UPDATESLAVEINFO: ************************************************
PC_CHECKOPERINIT: leaving
PX_TERMINATE: entering
PC_DISCCLIOPER: entering

===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================

PC_DOLOGOFFSPEC: entering
PC_DOLOGOFFSPEC: logging off Special Sessions
PC_DOLOGOFFSPEC: Special Sessions never connected
PC_DOLOGOFFSPEC: leaving
PC_DOLOGOFFSQL: entering
PC_DOLOGOFFSQL: logging off Auxiliary SQL Session
PC_DOLOGOFFSQL: Auxiliary SQL Session never connected
PC_DOLOGOFFSQL: logging off Main SQL Session
PC_DOLOGOFFSQL: Main SQL Session never connected
PC_DOLOGOFFSQL: leaving
PC_DISCCLIOPER: leaving
PC_LOGJOBMETADATA: entering
PC_LOGJOBMETADATA: leaving
PC_OUTPUTCPU: entering
PC_OUTPUTCPU: start time: 'Thu Oct 25 11:47:31 2018'
PC_OUTPUTCPU: start time: 'Thu Oct 25 11:47:31 2018'
PC_OUTPUTCPU: stop time: 'Thu Oct 25 11:47:31 2018'

Instance Cpu Time
======== ================
PC_GETSLAVEINFO: *************************************************
PC_GETSLAVEINFO: entering
PC_GETSLAVEINFO: Instance: 1
PC_GETSLAVEINFO: field: 7
PC_GETSLAVEINFO: Sessions To Connect: 0
PC_GETSLAVEINFO: Sessions Connected: 0
PC_GETSLAVEINFO: Connect Result: 0
PC_GETSLAVEINFO: Total Rows Loaded: 0
PC_GETSLAVEINFO: Total Error Rows: 0
PC_GETSLAVEINFO: Number Of Stmts: 0
PC_GETSLAVEINFO: Rows Exported: 0
PC_GETSLAVEINFO: Rows Sent To DBS: 0
PC_GETSLAVEINFO: Cpu Time: 0.030000
PC_GETSLAVEINFO: Load Phase Cpu Time: 0.000000
PC_GETSLAVEINFO: Export Phase Cpu Time: 0.000000
PC_GETSLAVEINFO: Number of Blocks: 0
PC_GETSLAVEINFO: NoSpool Export: 0
PC_GETSLAVEINFO: UseMLX: 0
PC_GETSLAVEINFO: Bytes Sent To DBS: 0
PC_GETSLAVEINFO: Bytes Exported: 0
PC_GETSLAVEINFO: retrieving CpuTime field
PC_GETSLAVEINFO: returning value: 0.030000
PC_GETSLAVEINFO: leaving
PC_GETSLAVEINFO: *************************************************
1 0.03 Seconds

**** 11:47:31 Total processor time used = '0.03 Second(s)'
. Start : Thu Oct 25 11:47:31 2018
. End : Thu Oct 25 11:47:31 2018
. Highest return code encountered = '12'.
PC_OUTPUTCPU: leaving
PC_TERMCLIOPER: entering
**** 11:47:31 This job terminated
PC_FREECLIAREA: entering
PC_FREECLIAREA: checking 64K output buffer
PC_FREECLIAREA: checking checkpoint buffer
PC_FREECLIAREA: checking main logon string buffer
PC_FREECLIAREA: checking special logon string buffer
PC_FREECLIAREA: checking query band session info buffer
PC_FREECLIAREA: closing utf8 converter
PC_FREECLIAREA: closing charset converter
PC_FREECLIAREA: checking request buffer
PC_FREECLIAREA: deallocating request buffer at: 0x1f76b70
PC_FREECLIAREA: checking partition buffer
PC_FREECLIAREA: deallocating partition buffer at: 0x1f807c0
PC_FREECLIAREA: checking character set buffer
PC_FREECLIAREA: deallocating character set buffer at: 0x1f807e0
PC_FREECLIAREA: character set name buffer
PC_FREECLIAREA: deallocating character set name buffer at: 0x1f7a870
PC_FREECLIAREA: checking default DBCAREA buffer
PC_FREECLIAREA: checking larger CLI msg buffer
PC_FREECLIAREA: deallocating larger CLI msg buffer at: 0x1fc3460
PC_FREECLIAREA: deallocating default DBCAREA at: 0x1f77d30
PC_FREECLIAREA: checking main DBCAREA buffer
PC_FREECLIAREA: checking Aux DBCAREA buffer
PC_FREECLIAREA: checking Special DBCAREA buffer
PC_FREECLIAREA: checking DBC DBCAREA buffer
PC_FREECLIAREA: checking Session Node Id buffer
PC_FREECLIAREA: checking Session Throughput buffer
PC_FREECLIAREA: checking session list
PC_FREECLIAREA: checking DBCHWL session list
PC_FREECLIAREA: checking session array
PC_FREECLIAREA: deallocating DBS retryable errors at: 0x1f77380
PC_FREESLOBAREA: entering
PC_FREESLOBAREA: have 1 SLOB_data_struct to free
PC_FREESLOBAREA: deallocating SLOB area structure at: 0x1f775b0
PC_FREESLOBAREA: leaving with return code: 0
PC_FREECLIAREA: calling CLI to clean up its internal buffers
PC_CLEANCLI: entering
PC_CLEANCLI: calling DBCHCLN
PC_CLEANCLI: leaving
PC_FREECLIAREA: deallocating CLI library name at: 0x1f77670
PC_UNLOADCLI: entering
PC_UNLOADCLI: addr of the CLI library: 0x1f776f0
PC_UNLOADCLI: closing the CLI library
PC_UNLOADCLI: closed the CLI library
PC_UNLOADCLI: leaving
PC_FREECLIAREA: deallocating CLI area pointer at: 0x1f76460
PC_FREECLIAREA: leaving
PC_TERMCLIOPER: leaving
PX_TERMINATE: free memory allocated in the operator area
PC_DELETEGLOBALS: entering
PC_DELETEGLOBALS: deleting SlaveInfo global memory
PC_DELETEGLOBALS: deleting ErrorInfo global memory
PC_DELETEGLOBALS: deleting SessionInfo global memory
PC_DELETEGLOBALS: leaving with result: 0
PC_FREEOPERAREA: deallocating column item list
PC_FREEOPERAREA: deallocating item list header at: 0x1f80760
PC_FREEITEMLIST: entering
PC_FREEITEMLIST: deallocating list of columns
PC_FREEITEMLIST: deallocating itemname address: 0x1f80830
PC_FREEITEMLIST: deallocating item list address: 0x1f80760
PC_FREEITEMLIST: deallocating itemname address: 0x1f78900
PC_FREEITEMLIST: deallocating item list address: 0x1f80850
PC_FREEITEMLIST: deallocating itemname address: 0x1f80910
PC_FREEITEMLIST: deallocating item list address: 0x1f808b0
PC_FREEITEMLIST: deallocating itemname address: 0x1f78b90
PC_FREEITEMLIST: deallocating item list address: 0x1f80930
PC_FREEITEMLIST: deallocating itemname address: 0x1f78c10
PC_FREEITEMLIST: deallocating item list address: 0x1f78bb0
PC_FREEITEMLIST: deallocating itemname address: 0x1f78c90
PC_FREEITEMLIST: deallocating item list address: 0x1f78c30
PC_FREEITEMLIST: deallocating itemname address: 0x1f78d10
PC_FREEITEMLIST: deallocating item list address: 0x1f78cb0
PC_FREEITEMLIST: deallocating itemname address: 0x1f78d90
PC_FREEITEMLIST: deallocating item list address: 0x1f78d30
PC_FREEITEMLIST: deallocating itemname address: 0x1f78e10
PC_FREEITEMLIST: deallocating item list address: 0x1f78db0
PC_FREEITEMLIST: deallocating itemname address: 0x1f78e90
PC_FREEITEMLIST: deallocating item list address: 0x1f78e30
PC_FREEITEMLIST: deallocating itemname address: 0x1f78f20
PC_FREEITEMLIST: deallocating item list address: 0x1f78ec0
PC_FREEITEMLIST: deallocating itemname address: 0x1f78fa0
PC_FREEITEMLIST: deallocating item list address: 0x1f78f40
PC_FREEITEMLIST: deallocating itemname address: 0x1f79020
PC_FREEITEMLIST: deallocating item list address: 0x1f78fc0
PC_FREEITEMLIST: deallocating itemname address: 0x1f790a0
PC_FREEITEMLIST: deallocating item list address: 0x1f79040
PC_FREEITEMLIST: deallocating itemname address: 0x1f79130
PC_FREEITEMLIST: deallocating item list address: 0x1f790d0
PC_FREEITEMLIST: deallocating itemname address: 0x1f791c0
PC_FREEITEMLIST: deallocating item list address: 0x1f79160
PC_FREEITEMLIST: deallocating itemname address: 0x1f79250
PC_FREEITEMLIST: deallocating item list address: 0x1f791f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f792d0
PC_FREEITEMLIST: deallocating item list address: 0x1f79270
PC_FREEITEMLIST: deallocating itemname address: 0x1f79350
PC_FREEITEMLIST: deallocating item list address: 0x1f792f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f793d0
PC_FREEITEMLIST: deallocating item list address: 0x1f79370
PC_FREEITEMLIST: deallocating itemname address: 0x1f79450
PC_FREEITEMLIST: deallocating item list address: 0x1f793f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f794d0
PC_FREEITEMLIST: deallocating item list address: 0x1f79470
PC_FREEITEMLIST: deallocating itemname address: 0x1f79550
PC_FREEITEMLIST: deallocating item list address: 0x1f794f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f795d0
PC_FREEITEMLIST: deallocating item list address: 0x1f79570
PC_FREEITEMLIST: deallocating itemname address: 0x1f79650
PC_FREEITEMLIST: deallocating item list address: 0x1f795f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f796d0
PC_FREEITEMLIST: deallocating item list address: 0x1f79670
PC_FREEITEMLIST: deallocating itemname address: 0x1f79750
PC_FREEITEMLIST: deallocating item list address: 0x1f796f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f797d0
PC_FREEITEMLIST: deallocating item list address: 0x1f79770
PC_FREEITEMLIST: deallocating itemname address: 0x1f79850
PC_FREEITEMLIST: deallocating item list address: 0x1f797f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f798d0
PC_FREEITEMLIST: deallocating item list address: 0x1f79870
PC_FREEITEMLIST: deallocating itemname address: 0x1f79950
PC_FREEITEMLIST: deallocating item list address: 0x1f798f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f799d0
PC_FREEITEMLIST: deallocating item list address: 0x1f79970
PC_FREEITEMLIST: deallocating itemname address: 0x1f79a50
PC_FREEITEMLIST: deallocating item list address: 0x1f799f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f79ad0
PC_FREEITEMLIST: deallocating item list address: 0x1f79a70
PC_FREEITEMLIST: deallocating itemname address: 0x1f79b50
PC_FREEITEMLIST: deallocating item list address: 0x1f79af0
PC_FREEITEMLIST: deallocating itemname address: 0x1f79bd0
PC_FREEITEMLIST: deallocating item list address: 0x1f79b70
PC_FREEITEMLIST: deallocating itemname address: 0x1f79c50
PC_FREEITEMLIST: deallocating item list address: 0x1f79bf0
PC_FREEITEMLIST: deallocating itemname address: 0x1f79cd0
PC_FREEITEMLIST: deallocating item list address: 0x1f79c70
PC_FREEITEMLIST: deallocating itemname address: 0x1f79d50
PC_FREEITEMLIST: deallocating item list address: 0x1f79cf0
PC_FREEITEMLIST: deallocating itemname address: 0x1f79dd0
PC_FREEITEMLIST: deallocating item list address: 0x1f79d70
PC_FREEITEMLIST: deallocating itemname address: 0x1f79e50
PC_FREEITEMLIST: deallocating item list address: 0x1f79df0
PC_FREEITEMLIST: deallocating itemname address: 0x1f79ed0
PC_FREEITEMLIST: deallocating item list address: 0x1f79e70
PC_FREEITEMLIST: deallocating itemname address: 0x1f79f50
PC_FREEITEMLIST: deallocating item list address: 0x1f79ef0
PC_FREEITEMLIST: deallocating itemname address: 0x1f79fd0
PC_FREEITEMLIST: deallocating item list address: 0x1f79f70
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a050
PC_FREEITEMLIST: deallocating item list address: 0x1f79ff0
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a0d0
PC_FREEITEMLIST: deallocating item list address: 0x1f7a070
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a150
PC_FREEITEMLIST: deallocating item list address: 0x1f7a0f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a1d0
PC_FREEITEMLIST: deallocating item list address: 0x1f7a170
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a250
PC_FREEITEMLIST: deallocating item list address: 0x1f7a1f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a2d0
PC_FREEITEMLIST: deallocating item list address: 0x1f7a270
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a350
PC_FREEITEMLIST: deallocating item list address: 0x1f7a2f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a3d0
PC_FREEITEMLIST: deallocating item list address: 0x1f7a370
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a450
PC_FREEITEMLIST: deallocating item list address: 0x1f7a3f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a4d0
PC_FREEITEMLIST: deallocating item list address: 0x1f7a470
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a550
PC_FREEITEMLIST: deallocating item list address: 0x1f7a4f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a5d0
PC_FREEITEMLIST: deallocating item list address: 0x1f7a570
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a650
PC_FREEITEMLIST: deallocating item list address: 0x1f7a5f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a6d0
PC_FREEITEMLIST: deallocating item list address: 0x1f7a670
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a750
PC_FREEITEMLIST: deallocating item list address: 0x1f7a6f0
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a7d0
PC_FREEITEMLIST: deallocating item list address: 0x1f7a770
PC_FREEITEMLIST: deallocating itemname address: 0x1f7a850
PC_FREEITEMLIST: deallocating item list address: 0x1f7a7f0
PC_FREEITEMLIST: item list header is now: 0x0
PC_FREEITEMLIST: leaving
PC_FREEOPERAREA: deallocating table list
PC_FREEOPERAREA: deallocating DML list
PC_FREEOPERAREA: deallocating TraceOption buffer
PC_FREEOPERAREA: deallocating TraceOption buffer at: 0x1f720e0
PC_FREEOPERAREA: deallocating PrivateLog buffer
PC_FREEOPERAREA: deallocating PrivateLog buffer at: 0x1f76180
PC_FREEOPERAREA: deallocating ConsoleInfo buffer
PC_FREEOPERAREA: deallocating ConsoleInfo buffer at: 0x1f72d60
PC_FREEOPERAREA: deallocating ErrorInfo buffer
PC_FREEOPERAREA: deallocating ErrorInfo buffer at: 0x1f72f70
PC_FREEOPERAREA: deallocating notify_area buffer
PC_FREEOPERAREA: deallocating notify_area buffer at: 0x1f72030
PC_FREEOPERAREA: deallocating LOB area buffer
PC_FREELOBAREA: entering
PC_FREELOBAREA: deallocating free lob token list
PC_FREELOBAREA: deallocating LOB header at: 0x1f72090
PC_FREELOBAREA: leaving
PC_FREEOPERAREA: deallocating OperCmdID buffer
PC_FREEOPERAREA: deallocating MyPath buffer
PC_FREEOPERAREA: deallocating MyPath buffer at: 0x1f78810
PC_FREEOPERAREA: deallocating glblmsg
PC_FREEOPERAREA: deallocating glblmsg at: 0x7c36010

Private log TWB_EVENTS:


job-578,17,5,OperatorEnter,MAIN_STEP,SQL_SELECTOR,1,2018-10-25,2018-10-25 11:47:31,2,0
job-578,176,5,OperatorVersion,MAIN_STEP,SQL_SELECTOR,1,2018-10-25,15.10.00.04,2,0
job-578,177,1,OperatorType,MAIN_STEP,SQL_SELECTOR,1,2018-10-25,1,2,0
job-578,178,1,OperatorInstances,MAIN_STEP,SQL_SELECTOR,1,2018-10-25,1,2,0
job-578,184,5,PrivateLogName,MAIN_STEP,SQL_SELECTOR,1,2018-10-25,selector_log-1,2,0
job-578,186,3,CPUTimeByInstance,MAIN_STEP,SQL_SELECTOR,1,2018-10-25,0.030000,2,0
job-578,173,0,SelectorSessEnd,MAIN_STEP,SQL_SELECTOR,1,2018-10-25,,2,0
job-578,179,5,OperatorEndTS,MAIN_STEP,SQL_SELECTOR,1,2018-10-25,2018-10-25 11:47:31,2,0
job-578,18,1,OperatorExit,MAIN_STEP,SQL_SELECTOR,1,2018-10-25,12,2,0.

Highlighted
Teradata Employee

Re: TPT FastExport -Job step MAIN_STEP terminated (status 12)

So the SQL Selector operator doesn't like the MaxDecimalDigits attribute. This is expected to be an INTEGER value; did you supply it as VARCHAR (with quotes)?

Enthusiast

Re: TPT FastExport -Job step MAIN_STEP terminated (status 12)

You caught it right. Table is defined with Decimal(19,6) so i had set maxattribute but for some reason it does not like it and i got to know when trying to load data into a table and then extract from it.

 

Now, i just have set source to Deicmal (18,6) whilei target is still Decimal (19,6) and it is working just fine.

 

Thanks for your valuable time.

 

But, was dissapointed as TPT logs couldnot capture such error precisely.