All Forums Connectivity
jedler 2 posts Joined 03/13
20 Mar 2013
Connecting Teradata and MS SQL sources

I am new to the forum so forgive me if this post seems remedial or incomplete.  We work with data coming from two types of data sources (MS SQL Severs, and Teradata Servers).  For a number of projects, we need to compare information across these two server types.  There are probably a number of ways to accomplish this but we are looking for an approach that is 1) scriptable and 2) can be parameterized.  My first candidate was to use a SSIS project in Visual Studio since our sql logic to join the cross-sever tables was simple (mostly just havnig a list of member ids house in a TD table and pulling those members' information from the MS SQL server table).  I have installed the annuity adapter for oracle and teradata on my system and have been trying to connect to the TD server but am having issues.  Below is detailed exporter log file.  I am forever grateful for any suggestions on how to fix my current process or offerings of a better solution to our problem.  Thanks TD folks!
****************************************************** ****************************************************** **********PC_GETOPERATTRS: *************************************************
PC_GETOPERATTRS: entering handle:   0x93e7568
PC_GETOPERATTRS: MyOperatorName:    'EXPORT_OPERATOR'
PC_GETOPERATTRS: MyOperatorType:    1 (Prod=1, Cons=2, Stand=5)
PC_GETOPERATTRS: Instance number:   1
PC_GETOPERATTRS: Max instances:     1
PC_GETOPERATTRS: RestartMode flag:  0
PC_GETOPERATTRS: Trace Level:       0x1f
PC_GETOPERATTRS: PublicLog Handle:  0x93e76d0
PC_GETOPERATTRS: PrivateLog Handle: 0x0
PC_GETOPERATTRS: bytes for glblmsg: 2097152
PC_GETOPERATTRS: size of oper_desc: 440
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SYSTEM_CharSetDefault'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 1
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: character set is default: 'F'
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SYSTEM_CharSetId'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: character set: 'UTF8'
PC_GETOPERATTRS: UTF16 mode:    0
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SYSTEM_Checkpoint'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: checkpoint value: -1736414893
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'DumpBytes'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'DumpBytes' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SYSTEM_APImode'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 3
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: API mode:          1
PC_GETOPERATTRS: *************************************************
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'LogSQL'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'LogSQL' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'AutoRestart'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'AutoRestart' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: *************************************************
PC_INITOPERATOR: output starts now (already entered)
PC_GETPLATFORMENDIAN: entering
PC_GETPLATFORMENDIAN: Platform_Endian default is LITTLE endian
PC_GETPLATFORMENDIAN: leaving
Export Operator Version 14.00.00.03
EXPORT_OPERATOR: private log not specified
PC_CREATEGLOBALS: entering
PC_CREATEGLOBALS: creating slave global memory
PC_CREATEGLOBALS: creating error global memory
PC_CREATEGLOBALS: initializing slave memory for instance: 1
PC_CREATEGLOBALS: initializing error memory for instance: 1
PC_CREATEGLOBALS: creating session global memory
PC_CREATEGLOBALS: initializing session global memory
PC_CREATEGLOBALS: leaving with result: 0
 
     ====================================================== =============
     =                                                                 =
     =                  TERADATA PARALLEL TRANSPORTER                  =
     =                                                                 =
     =             EXPORT OPERATOR     VERSION 14.00.00.03             =
     =                                                                 =
     =          OPERATOR SUPPORT LIBRARY VERSION 14.00.00.03           =
     =                                                                 =
     = COPYRIGHT 2001-2011, TERADATA CORPORATION. ALL RIGHTS RESERVED. =
     =                                                                 =
     ====================================================== =============
**** 08:39:12 Processing starting at: Wed Mar 20 08:39:12 2013
PC_SHOWVERSION: entering
PC_SHOWVERSION: operator name: Export
 
     ====================================================== =============
     =                                                                 =
     =                      Module Identification                      =
     =                                                                 =
     ====================================================== =============
PC_SHOWVERSION: node name:   'STLD050145'
     Export Operator for Windows on STLD050145
PC_SHOWVERSION: module id: 'ExportMain', module vers: '14.00.00.07'
     ExportMain : 14.00.00.07
PC_SHOWVERSION: module id: 'ExportCLI', module vers: '14.00.00.04'
     ExportCLI  : 14.00.00.04
PC_SHOWVERSION: module id: 'ExportUtil', module vers: '14.00.00.04'
     ExportUtil : 14.00.00.04
PC_SHOWVERSION: module id: 'PcomCLI', module vers: '14.00.00.16'
     PcomCLI    : 14.00.00.16
PC_SHOWVERSION: module id: 'PcomMBCS', module vers: '13.00.00.02'
     PcomMBCS   : 13.00.00.02
PC_SHOWVERSION: module id: 'PcomMsgs', module vers: '14.00.00.02'
     PcomMsgs   : 14.00.00.02
PC_SHOWVERSION: module id: 'PcomNtfy', module vers: '13.00.00.03'
     PcomNtfy   : 13.00.00.03
PC_SHOWVERSION: module id: 'PcomPx', module vers: '14.00.00.07'
     PcomPx     : 14.00.00.07
PC_SHOWVERSION: module id: 'PcomUtil', module vers: '14.00.00.06'
     PcomUtil   : 14.00.00.06
     PXICU      : 14.00.00.03
     TDICU      : 14.00.00.00
PC_SHOWVERSION: leaving
PC_GETSCHEMAHANDLE: entering
PC_GETSCHEMAHANDLE: schema handle: 0x9413e08
PC_GETSCHEMAHANDLE: leaving
PC_GETCOLUMNSCHEMA: entering
PC_GETCOLUMNSCHEMA: address of list:     0x9417f38
PC_GETCOLUMNSCHEMA: number of columns:   2
PC_GETCOLUMNSCHEMA: received column handle: 0x9417ef0
PC_GETCOLUMNSCHEMA: received column handle: 0x941ffa0
PC_GETCOLUMNSCHEMA: allocated item list at: 0x93e8f40
PC_GETCOLUMNSCHEMA: Name, Type, Size: 'PLAN_MBR_ID', 7, 84
PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0
PC_GETCOLUMNSCHEMA: attempting to malloc 12 bytes
PC_VALIDATECOLTYPE: entering with column type: 7
PC_GETCOLUMNSCHEMA: allocated item list at: 0x93e8ee0
PC_GETCOLUMNSCHEMA: Name, Type, Size: 'ST_MBR_ID', 7, 84
PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0
PC_GETCOLUMNSCHEMA: attempting to malloc 10 bytes
PC_VALIDATECOLTYPE: entering with column type: 7
PC_GETCOLUMNSCHEMA:
PC_GETCOLUMNSCHEMA: Final Column List
PC_GETCOLUMNSCHEMA: -----------------
PC_GETCOLUMNSCHEMA: Address: 0x93e8f40, next: 0x93e8ee0
PC_GETCOLUMNSCHEMA: Address: 0x93e8ee0, next: 0x0
PC_GETCOLUMNSCHEMA:
PC_GETCOLUMNSCHEMA: itemhdr address: 0x93e8f40
PC_OUTCOLLIST: ========================================
PC_OUTCOLLIST:   1. Field Name: PLAN_MBR_ID
PC_OUTCOLLIST:      Type:  VARCHAR
PC_OUTCOLLIST:      Size:  84
PC_OUTCOLLIST:      Prec:  0
PC_OUTCOLLIST:      Scale: 0
PC_OUTCOLLIST:
PC_OUTCOLLIST:   2. Field Name: ST_MBR_ID
PC_OUTCOLLIST:      Type:  VARCHAR
PC_OUTCOLLIST:      Size:  84
PC_OUTCOLLIST:      Prec:  0
PC_OUTCOLLIST:      Scale: 0
PC_OUTCOLLIST:
PC_OUTCOLLIST: There are 2 fields defined
PC_OUTCOLLIST: ========================================
PC_GETCOLUMNSCHEMA: leaving
PC_INITOPERATOR: latency flag is: 0
PC_INITOPERATOR: leaving
INITIATE: phase 1
INITMYOPERATOR: entering
INITMYOPERATOR: allocated private area at: 0x3d19a80
INITMYOPERATOR: number of bytes allocated: 176
INITMYOPERATOR: allocated event area at:   0x94b0e50
INITMYOPERATOR: leaving
PC_INITCLIOPER: entering
PC_INITCLIAREA: entering
PC_INITCLIAREA: allocating CLI area, size: 1208
PC_INITCLIAREA: allocated CLI area, addr:  0x94b1180
PC_INITCLIAREA: allocated reqstr, addr:  0x94b1640
PC_INITCLIAREA: allocated partition, addr:  0x94ade70
PC_INITCLIAREA: allocated CharSet, addr:  0x93c3cd0
PC_INITCLIAREA: allocated CharSetName, addr:  0x93c3d00
PC_INITCLIAREA: leaving
PC_GETCLIATTRS: entering
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'TdpId'
PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSExternalName'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: Tdp Id: 'EDWP'
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'UserName'
PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSUserName'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 6
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: logon user id: 'jedler'
PC_GETCLIATTRS: *************************************************
PC_GETCLIATTRS: logon password: <not displayable>
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'AccountId'
PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSAccountId'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'AccountId' not found
PC_GETATTRIBUTE: retrieving alternate: 'SYSTEM_DBMSAccountId'
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'WorkingDatabase'
PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSWorkingDatabase'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 16
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: DATABASE SQL: 'HP_QI_OWN_TABLES'
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'TenacityHours'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: Tenacity hours: 4
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'TenacitySleep'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: Sleep minutes: 2
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'MaxSessions'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: maximum sessions: 3
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'MinSessions'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: minimum sessions: 1
PC_GETCLIATTRS: *************************************************
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
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'DataEncryption'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 3
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: DataEncryption: 'OFF'
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'LogonMech'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'LogonMech' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'LogonMechData'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'LogonMechData' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'ReplicationOverride'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'ReplicationOverride' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: *************************************************
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'DiagnosticRestartMask'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'DiagnosticRestartMask' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: diag mask (hex): 0
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'DiagnosticRestartCounter'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'DiagnosticRestartCounter' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: diag counter: 0
PC_GETCLIATTRS: *************************************************
PC_GETCLIATTRS: leaving
PC_INITCLI: entering
PC_INITCLI: allocated default DBCAREA at: 0x94b1a50
PC_INITCLI: DBCHINI returns charset string: 'ASCII                         '
PC_INITCLI: DBCHINI returns charset type:   ' '
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: 'EDWP'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'EDWP'
PC_ISSUEDBCHQE: length of TDPid is:     4
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_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: 'EDWP'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'EDWP'
PC_ISSUEDBCHQE: length of TDPid is:     4
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_GETDBSLIMITS: MaxRowBytes:         64768
PC_GETDBSLIMITS: MaxLobBytes:         2097088000
PC_GETDBSLIMITS: MaxObjectNameChars:  30
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:     2544
PC_GETDBSLIMITS: MaxParamsInRequest:  2544
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: 'EDWP'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'EDWP'
PC_ISSUEDBCHQE: length of TDPid is:     4
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_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: 'EDWP'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'EDWP'
PC_ISSUEDBCHQE: length of TDPid is:     4
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_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: 'EDWP'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'EDWP'
PC_ISSUEDBCHQE: length of TDPid is:     4
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_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: 'EDWP'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: 'EDWP'
PC_ISSUEDBCHQE: length of TDPid is:     4
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_GETTASMSUPPORT: DBCHQE flag is: 'Y'
PC_GETTASMSUPPORT: setting TASM support flag to TRUE
PC_GETTASMSUPPORT: 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_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
     CLIv2      : 14.00.00.02  
PC_GETCLIVERSION: leaving with return code: 0
PC_CHECKANSIDATE: entering
PC_CHECKANSIDATE: checking if 'PLAN_MBR_ID' is an ANSI Date field
PC_CHECKANSIDATE: checking if 'ST_MBR_ID' is an ANSI Date field
PC_CHECKANSIDATE: leaving
PC_INITCLIOPER: leaving
PX_INITIATE: EOD = 0
GETMYATTRIBUTES: entering
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'BlockSize'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: Block Size: 64330
GETMYATTRIBUTES: **********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'OutLimit'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'OutLimit' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: **********************************************
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
GETMYATTRIBUTES: **********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SelectStmt'
PC_GETATTRIBUTE: mandatory: 1
PC_GETATTRIBUTE: attribute length: 71
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: SELECT request: 'SELECT PLAN_MBR_ID, ST_MBR_ID
FROM HP_QI_OWN.SICKLE_CELL_SCORECARD_CURR'
GETMYATTRIBUTES: **********************************************
CHECKORDERBY: entering
CHECKORDERBY: length of select request : 71
CHECKORDERBY: select request : SELECT PLAN_MBR_ID, ST_MBR_ID
FROM HP_QI_OWN.SICKLE_CELL_SCORECARD_CURR
CHECKORDERBY: allocated temp ptr at: 155898544
CHECKORDERBY: copy of selectptr : SELECT PLAN_MBR_ID, ST_MBR_ID
FROM HP_QI_OWN.SICKLE_CELL_SCORECARD_CURR
CHECKORDERBY: copy of selectptr after uppercase: SELECT PLAN_MBR_ID, ST_MBR_ID
FROM HP_QI_OWN.SICKLE_CELL_SCORECARD_CURR
CHECKORDERBY: token = SELECT
CHECKORDERBY: token = PLAN_MBR_ID,
CHECKORDERBY: token = ST_MBR_ID
CHECKORDERBY: token = FROM
CHECKORDERBY: token = HP_QI_OWN.SICKLE_CELL_SCORECARD_CURR
CHECKORDERBY: deallocating temp ptr at: 155898544
CHECKORDERBY: order by clause? : 0
CHECKORDERBY: exiting
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'MaxDecimalDigits'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: max decimal digits: 38
GETMYATTRIBUTES: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'IgnoreMaxDecimalDigits'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 3
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: IgnoreMaxDecimalDigits: 1
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SYSTEM_BufferMode'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 3
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: BufferMode: 'YES'
GETMYATTRIBUTES: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'BufferLengthSize'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: Row Length Size: '4'
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'BufferHeaderSize'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: Row Header Size: '4'
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'BufferTrailerSize'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: Trailer Size: '0'
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'BufferMaxSize'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: Max Buffer Size: '64260'
GETMYATTRIBUTES: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SpoolMode'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'SpoolMode' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: SpoolMode: 1
GETMYATTRIBUTES: leaving
PC_LOGJOBMETADATA: entering
PC_LOGOPERIDMETADATA: entering
PC_LOGOPERIDMETADATA: leaving
PC_LOGJOBMETADATA: leaving
PC_LOGJOBMETADATA: entering
PC_LOGJOBMETADATA: leaving
PC_LOGJOBMETADATA: entering
PC_LOGJOBMETADATA: leaving
PC_INITNOTIFY: entering
PC_INITNOTIFY: address of event table: 0x5b48140
PC_INITNOTIFY: old event, new event:  0  -->   0
PC_INITNOTIFY: old event, new event:  1  -->   1
PC_INITNOTIFY: old event, new event:  9  -->   9
PC_INITNOTIFY: old event, new event: 10  -->  10
PC_INITNOTIFY: old event, new event: 11  -->  11
PC_INITNOTIFY: old event, new event: 12  -->  12
PC_INITNOTIFY: old event, new event: 31  -->  31
PC_INITNOTIFY: old event, new event: 32  -->  32
PC_INITNOTIFY: old event, new event: 33  -->  33
PC_INITNOTIFY: old event, new event: 34  -->  34
PC_INITNOTIFY: old event, new event: 35  -->  35
PC_INITNOTIFY: old event, new event: 36  -->  36
PC_INITNOTIFY: old event, new event: 37  -->  37
PC_INITNOTIFY: old event, new event: 38  -->  38
PC_INITNOTIFY: old event, new event: 39  -->  39
PC_INITNOTIFY: old event, new event: 40  -->  40
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'NotifyMethod'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'NotifyMethod' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_INITNOTIFY: Notify method:      0
PC_INITNOTIFY: no method specified. Leaving.
PC_OUTPUTATTRS: entering
 
     ====================================================== =============
     =                                                                 =
     =                      Attribute Definitions                      =
     =                                                                 =
     ====================================================== =============
**** 08:39:13 Options in effect for this job:
              OperatorType:  Producer
              Instances:     1
              Character set: 'UTF8'
              Notify:        Not enabled
              Trace Option:  'ALL'
              Trace Output:  Enabled
PC_OUTPUTATTRS: leaving
PC_OUTPUTCLIATTRS: entering
              Encryption:    No data encryption requested
PC_OUTPUTCLIATTRS: leaving
              Tenacity:      4 hour limit to successfully connect
              Sleep:         2 minute(s) between connect retries
              Date format:   INTEGERDATE
              Blocksize:     64330 bytes
              Precision:     38 (Maximum decimal digits returned from RDBMS)
              OutLimit:      No limit in effect
PC_SHOWLAYOUT: entering
 
     ====================================================== =============
     =                                                                 =
     =                     Column/Field Definition                     =
     =                                                                 =
     ====================================================== =============
     Column Name                    Offset Length Type     
     ============================== ====== ====== ========================
     PLAN_MBR_ID                         0     84 VARCHAR
     ST_MBR_ID                          86     84 VARCHAR
     ============================== ====== ====== ========================
     INDICATOR BYTES NEEDED: 1
     EXPECTED RECORD LENGTH: 173
PC_SHOWLAYOUT: leaving
PX_INITIATE: phase 2
PC_DOLOGONMAIN: entering
 
     ====================================================== =============
     =                                                                 =
     =                   Control Session Connection                    =
     =                                                                 =
     ====================================================== =============
EXPORT_OPERATOR: connecting sessions
**** 08:39:13 Connecting to RDBMS:    'EDWP'
**** 08:39:13 Connecting with UserId: 'jedler'
PC_BUILDLOGONSTR: entering
PC_BUILDLOGONSTR: bytes allocated for Logon string: 20
PC_BUILDLOGONSTR: logon string allocated address: 0x94adf30
PC_BUILDLOGONSTR: leaving
PC_DOREQUEST: entering
PC_ISSUELOGONMAIN
PC_ISSUELOGONMAIN: entering
PC_ISSUELOGONMAIN: address of Main SQL DBCAREA: 0x94b24e0
PC_ISSUELOGONMAIN: ****************************
PC_ISSUELOGONMAIN: PREPARING MAIN SQL SESSION *
PC_ISSUELOGONMAIN: ****************************
PC_INITDBCAREA: entering
PC_INITDBCAREA: date_form init to:       D
PC_INITDBCAREA: max_parcel init to:      O
PC_INITDBCAREA: data_encryption init to: N
PC_INITDBCAREA: setting data_encryption to 'N'
PC_INITDBCAREA: this will override any SPB setting
PC_INITDBCAREA: DBCAREA max decimal digits is 0
PC_INITDBCAREA: setting max decimal digits to 38
PC_INITDBCAREA: automaticRedrive set to:N
PC_INITDBCAREA: arrayTransformsOff set to: N
PC_INITDBCAREA: date_form  set to:      T
PC_INITDBCAREA: max_parcel set to:      O
PC_INITDBCAREA: data_encryption set to: N
PC_INITDBCAREA: statemnt_status set to: O
PC_INITDBCAREA: max dec digits set to:  38
PC_INITDBCAREA: workload pointer:       'TPTEXP'
PC_INITDBCAREA: workload length:        6
PC_INITDBCAREA: leaving
PC_ISSUELOGONMAIN: Main SQL session charset:  'UTF8                          '
PC_ISSUELOGONMAIN: Main SQL session chartype: 'N'
PC_ISSUELOGONMAIN: logging on Main SQL Session
PC_CONNECTSESSION: entering
PC_CONNECTSESSION: leaving with return code:   0
PC_ISSUELOGONMAIN: Main input  session/request id: 33, 1
PC_ISSUELOGONMAIN: Main output session/request id: 33, 1
PC_FETCHRESP: entering, expecting flavor: 8
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 8
PC_ERRORSET: Success!, Activity Count: 0
PC_ERRORSET: stmnt #:     0
PC_ERRORSET: field ct:    0
PC_ERRORSET: act type:    0
PC_ERRORSET: warningcode: 0
PC_ERRORSET: warning len: 0
PC_ERRORSET: error code is:     0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 89
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 89
PC_ERRORSET: error code is:     0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 12
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 12
PC_ERRORSET: error code is:     0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_ENDREQUEST: entering
PC_ENDREQUEST: leaving
PC_ISSUELOGONMAIN: # of SQL sessions connected: 1
PC_ISSUELOGONMAIN: placing the following items in global memory
PC_ISSUELOGONMAIN: LSN number is: 1471820
PC_UPDATESESSIONINFO: **********************************************
PC_UPDATESESSIONINFO: entering
PC_UPDATESESSIONINFO: after read
PC_UPDATESESSIONINFO: LSN number is:           0
PC_UPDATESESSIONINFO: Maximum field size is:   0
PC_UPDATESESSIONINFO: Maximum buffer size is:  0
PC_UPDATESESSIONINFO: Maximum message size is: 0
PC_UPDATESESSIONINFO: Action Code is:          0
PC_UPDATESESSIONINFO: Number of DMLs is:       0
PC_UPDATESESSIONINFO: DBS Upsert Support:      0
PC_UPDATESESSIONINFO: DataEncryption Support:  0
PC_UPDATESESSIONINFO: Session charset type:    ' '
PC_UPDATESESSIONINFO: Session character set:   '                              '
PC_UPDATESESSIONINFO: updating LSN field
PC_UPDATESESSIONINFO: before write
PC_UPDATESESSIONINFO: LSN number is:           1471820
PC_UPDATESESSIONINFO: Maximum field size is:   0
PC_UPDATESESSIONINFO: Maximum buffer size is:  0
PC_UPDATESESSIONINFO: Maximum message size is: 0
PC_UPDATESESSIONINFO: Action Code is:          0
PC_UPDATESESSIONINFO: Number of DMLs is:       0
PC_UPDATESESSIONINFO: DBS Upsert support:      0
PC_UPDATESESSIONINFO: DataEncryption Support:  0
PC_UPDATESESSIONINFO: Session charset type:    ' '
PC_UPDATESESSIONINFO: Session character set:   '                              '
PC_UPDATESESSIONINFO: leaving with result: 0
PC_UPDATESESSIONINFO: **********************************************
PC_SENDTASMQUERYBAND: entering
PC_SENDTASMQUERYBAND: allocated query band request buffer at: 0x93eb0c0
PC_SENDTASMQUERYBAND: allocated 100 bytes
PC_SENDTASMQUERYBAND: issuing SET QUERY_BAND request
PC_SENDTASMQUERYBAND: 'SET QUERY_BAND = 'UTILITYNAME=TPTEXP;' UPDATE FOR SESSION;'
PC_SENDTASMQUERYBAND: length: 58
PC_SIMPLEREQ: entering
PC_SIMPLEREQ: request length: 58
PC_SIMPLEREQ: Using length: 0
PC_PROCESSREQ: entering
PC_INITIATEREQ: entering with request: 'SET QUERY_BAND = 'UTILITYNAME=TPTEXP;' UPDATE FOR SESSION;'
PC_INITIATEREQ: request length: 58
PC_INITIATEREQ: Using length: 0
PC_INITIATEREQ: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 8
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 8
PC_ERRORSET: Success!, Activity Count: 1
PC_ERRORSET: stmnt #:     1
PC_ERRORSET: field ct:    0
PC_ERRORSET: act type:    165
PC_ERRORSET: warningcode: 0
PC_ERRORSET: warning len: 0
PC_ERRORSET: error code is:     0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_PROCESSREQ: leaving with result: 0
PC_FINREQUEST: entering
PC_FETCHRESP: entering, expecting flavor: 11
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 11
PC_ERRORSET: error code is:     0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 12
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 12
PC_ERRORSET: error code is:     0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_ENDREQUEST: entering
PC_ENDREQUEST: leaving
PC_FINREQUEST: leaving with result: 0
PC_SIMPLEREQ: leaving with result: 0
PC_ISREQUESTDEADLOCKED: entering
PC_ISREQUESTDEADLOCKED: CLI/DBS result 0 is not a deadlock error
PC_ISREQUESTDEADLOCKED: leaving
PC_SENDTASMQUERYBAND: deallocating query band request buffer at: 0x93eb0c0
PC_SENDTASMQUERYBAND: leaving with return code: 0
PC_SENDQUERYBAND: entering
PC_SENDQUERYBAND: no query band information has been provided
PC_SENDQUERYBAND: leaving
PC_ISSUELOGONMAIN: leaving
PC_DOREQUEST: leaving successfully
PC_GETDEFAULTDATABASE: entering
PC_PROCESSREQ: entering
PC_INITIATEREQ: entering with request: 'HELP SESSION;'
PC_INITIATEREQ: request length: 13
PC_INITIATEREQ: Using length: 0
PC_INITIATEREQ: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 8
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 8
PC_ERRORSET: Success!, Activity Count: 1
PC_ERRORSET: stmnt #:     1
PC_ERRORSET: field ct:    47
PC_ERRORSET: act type:    50
PC_ERRORSET: warningcode: 0
PC_ERRORSET: warning len: 0
PC_ERRORSET: error code is:     0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_PROCESSREQ: leaving with result: 0
PC_ISREQUESTDEADLOCKED: entering
PC_ISREQUESTDEADLOCKED: CLI/DBS result 0 is not a deadlock error
PC_ISREQUESTDEADLOCKED: leaving
PC_FETCHRESP: entering, expecting flavor: 71
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 71
PC_ERRORSET: error code is:     0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_GETDEFAULTDATABASE: parcel flavor: 71
PC_GETDEFAULTDATABASE: number of fields(HELP SESSION): 47
PC_GETDEFAULTDATABASE: allocating array(HELP SESSION): 188 bytes
PC_GETDEFAULTDATABASE: allocated size_array at: 0x1cf75c0
PC_GETDEFAULTDATABASE: Type  1: 448, 18
PC_GETDEFAULTDATABASE: Type  2: 448, 36
PC_GETDEFAULTDATABASE: Type  3: 452, 16
PC_GETDEFAULTDATABASE: Type  4: 452, 16
PC_GETDEFAULTDATABASE: Type  5: 448, 42
PC_GETDEFAULTDATABASE: Type  6: 448, 30
PC_GETDEFAULTDATABASE: Type  7: 448, 60
PC_GETDEFAULTDATABASE: Type  8: 448, 16
PC_GETDEFAULTDATABASE: Type  9: 448, 22
PC_GETDEFAULTDATABASE: Type 10: 448, 12
PC_GETDEFAULTDATABASE: Type 11: 448, 60
PC_GETDEFAULTDATABASE: Type 12: 452, 2
PC_GETDEFAULTDATABASE: Type 13: 452, 2
PC_GETDEFAULTDATABASE: Type 14: 452, 2
PC_GETDEFAULTDATABASE: Type 15: 452, 2
PC_GETDEFAULTDATABASE: Type 16: 452, 2
PC_GETDEFAULTDATABASE: Type 17: 448, 24
PC_GETDEFAULTDATABASE: Type 18: 448, 3
PC_GETDEFAULTDATABASE: Type 19: 448, 3
PC_GETDEFAULTDATABASE: Type 20: 448, 2
PC_GETDEFAULTDATABASE: Type 21: 448, 3
PC_GETDEFAULTDATABASE: Type 22: 448, 3
PC_GETDEFAULTDATABASE: Type 23: 448, 2
PC_GETDEFAULTDATABASE: Type 24: 448, 30
PC_GETDEFAULTDATABASE: Type 25: 448, 3
PC_GETDEFAULTDATABASE: Type 26: 448, 9
PC_GETDEFAULTDATABASE: Type 27: 448, 30
PC_GETDEFAULTDATABASE: Type 28: 448, 3
PC_GETDEFAULTDATABASE: Type 29: 448, 9
PC_GETDEFAULTDATABASE: Type 30: 448, 15
PC_GETDEFAULTDATABASE: Type 31: 448, 18
PC_GETDEFAULTDATABASE: Type 32: 448, 15
PC_GETDEFAULTDATABASE: Type 33: 448, 30
PC_GETDEFAULTDATABASE: Type 34: 448, 66
PC_GETDEFAULTDATABASE: Type 35: 448, 42
PC_GETDEFAULTDATABASE: Type 36: 448, 75
PC_GETDEFAULTDATABASE: Type 37: 448, 9
PC_GETDEFAULTDATABASE: Type 38: 448, 36
PC_GETDEFAULTDATABASE: Type 39: 448, 51
PC_GETDEFAULTDATABASE: Type 40: 452, 2
PC_GETDEFAULTDATABASE: Type 41: 448, 18
PC_GETDEFAULTDATABASE: Type 42: 452, 4
PC_GETDEFAULTDATABASE: Type 43: 448, 18
PC_GETDEFAULTDATABASE: Type 44: 448, 46
PC_GETDEFAULTDATABASE: Type 45: 448, 0
PC_GETDEFAULTDATABASE: Type 46: 448, 0
PC_GETDEFAULTDATABASE: Type 47: 448, 135
PC_GETDEFAULTDATABASE: number of indicator bytes: 6
PC_FETCHRESP: entering, expecting flavor: 10
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 10
PC_ERRORSET: error code is:     0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_GETDEFAULTDATABASE: field_len: 14
PC_GETDEFAULTDATABASE: j: 14
PC_GETDEFAULTDATABASE: j: 14
PC__GETDEFAULTDATABASE: DefaultDatabase: 'ETL_ACCESS_OWN'
PC_FETCHRESP: entering, expecting flavor: 11
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 11
PC_ERRORSET: error code is:     0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 12
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 12
PC_ERRORSET: error code is:     0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_ENDREQUEST: entering
PC_ENDREQUEST: leaving
PC_GETDEFAULTDATABASE: freeing size_array at: 0x1cf75c0
PC_GETDEFAULTDATABASE: leaving
PC_DOLOGONMAIN: leaving
PC_LOGJOBMETADATA: entering
PC_LOGJOBMETADATA: leaving
PC_DOLOGONAUX: entering
PC_DOREQUEST: entering
PC_ISSUELOGONAUX
PC_ISSUELOGONAUX: entering
PC_ISSUELOGONAUX: address of Aux SQL DBCAREA: 0x94b4260
PC_ISSUELOGONAUX: ***************************
PC_ISSUELOGONAUX: PREPARING AUX SQL SESSION *
PC_ISSUELOGONAUX: ***************************
PC_INITDBCAREA: entering
PC_INITDBCAREA: date_form init to:       D
PC_INITDBCAREA: max_parcel init to:      O
PC_INITDBCAREA: data_encryption init to: N
PC_INITDBCAREA: setting data_encryption to 'N'
PC_INITDBCAREA: this will override any SPB setting
PC_INITDBCAREA: DBCAREA max decimal digits is 0
PC_INITDBCAREA: setting max decimal digits to 38
PC_INITDBCAREA: automaticRedrive set to:N
PC_INITDBCAREA: arrayTransformsOff set to: N
PC_INITDBCAREA: date_form  set to:      T
PC_INITDBCAREA: max_parcel set to:      O
PC_INITDBCAREA: data_encryption set to: N
PC_INITDBCAREA: statemnt_status set to: O
PC_INITDBCAREA: max dec digits set to:  38
PC_INITDBCAREA: workload pointer:       'TPTEXP'
PC_INITDBCAREA: workload length:        6
PC_INITDBCAREA: leaving
PC_ISSUELOGONAUX: Aux SQL session charset:  'UTF8                          '
PC_ISSUELOGONAUX: Aux SQL session chartype: 'N'
PC_ISSUELOGONAUX: logging on Auxiliary SQL Session
PC_CONNECTSESSION: entering
PC_CONNECTSESSION: leaving with return code:   0
PC_ISSUELOGONAUX: Aux input  session/request id: 34, 1
PC_ISSUELOGONAUX: Aux output session/request id: 34, 1
PC_FETCHRESP: entering, expecting flavor: 8
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 9
PC_ERRORSET: error code is:     3153
PC_ISEXCEPTION: entering with error code: 3153
PC_ISEXCEPTION: checking original exception code
PC_ISEXCEPTION: checking new exception code list
PC_ISEXCEPTION: number of codes in list: 0
PC_ISEXCEPTION: error does not match any exception code
PC_ISEXCEPTION: leaving with FALSE
PC_OUTDBSER: entering
PC_LOGJOBMETADATA: entering
PC_LOGJOBMETADATA: leaving
PC_OUTDBSER: DBS Error set to 3153
PC_OUTDBSER: placing message in global memory: TDWM Throttle violation for Concurrent Sessions: For Rule Name 'EDW_USER_SESSION_LIMIT', Limit of 4 concurrent requests
PC_UPDATEERRORINFO: entering
PC_UPDATEERRORINFO: Code: 10508
PC_UPDATEERRORINFO: Type: 8
PC_UPDATEERRORINFO: Sev : 12
PC_UPDATEERRORINFO: updating ErrorInfo, size: 812
PC_UPDATEERRORINFO: leaving
PC_LOGJOBMETADATA: entering
PC_LOGJOBMETADATA: leaving
PC_OUTDBSER: setting condition code to FATAL
PC_SETCODE: entering
PC_SETCODE: current condition code: 0
PC_SETCODE: setting condition code: 12
PC_SETCODE: leaving
PC_OUTDBSER: leaving with result: 3153
PC_ERRORSET: leaving with return code: 3153
PC_FETCHRESP: leaving with return code: 3153
PC_ISEXCEPTION: entering with error code: 3153
PC_ISEXCEPTION: checking original exception code
PC_ISEXCEPTION: checking new exception code list
PC_ISEXCEPTION: number of codes in list: 0
PC_ISEXCEPTION: error does not match any exception code
PC_ISEXCEPTION: leaving with FALSE
PC_DOREQUEST: checking for retry on error: 3153
PC_ISRETRY: entering with result, DBSError: 3153, 3153
PC_ISRETRY: leaving with return code: 0
PC_DOREQUEST: returning with FATAL Error
PC_DOLOGONAUX: returning with error: -998
PC_SETCODE: entering
PC_SETCODE: current condition code: 12
PC_SETCODE: leaving
PX_INITIATE: leaving with return code: -998
PX_Event: entering
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'EventFunction'
PC_GETATTRIBUTE: mandatory: 1
PC_GETATTRIBUTE: attribute length: 8
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PX_EVENT: event code:  10
PX_EVENT: event index: 0
PX_EVENT: querying DBSError
PX_EVENT: DBS error: 3153
PX_EVENT: DBS text:  'TDWM Throttle violation for Concurrent Sessions: For Rule Name 'EDW_USER_SESSION_LIMIT', Limit of 4 concurrent requests'
PX_Event: leaving
PX_Event: entering
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'EventFunction'
PC_GETATTRIBUTE: mandatory: 1
PC_GETATTRIBUTE: attribute length: 8
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PX_EVENT: event code:  11
PX_EVENT: event index: 0
PX_EVENT: querying CPUTime
PC_GETCPUTIME: entering
PC_GETCPUTIME: leaving
PX_EVENT: CPU time used so far: 0.015600
PX_Event: leaving
PC_CHECKOPERINIT: entering
PC_REPORTERROR: entering
PC_REPORTERROR: error message global memory, instance 1
PC_REPORTERROR: code: 10508
PC_REPORTERROR: sev:  12
PC_REPORTERROR: type: 8
PC_REPORTERROR: arg1: 3153
PC_REPORTERROR: arg2: 0
PC_REPORTERROR: arg3: 0
PC_REPORTERROR: arg4: 0
PC_REPORTERROR: arg5: 0
PC_REPORTERROR: len1:  119
PC_REPORTERROR: msg1:  TDWM Throttle violation for Concurrent Sessions: For Rule Name 'EDW_USER_SESSION_LIMIT', Limit of 4 concurrent requests
PC_REPORTERROR: len2:  0
PC_REPORTERROR: msg2: 
PC_REPORTERROR: len3:  0
PC_REPORTERROR: msg3: 
 
PC_REPORTERROR: calling errlist with type 1I1S
EXPORT_OPERATOR: TPT10508: RDBMS error 3153: TDWM Throttle violation for Concurrent Sessions: For Rule Name 'EDW_USER_SESSION_LIMIT', Limit of 4 concurrent requests
**** 08:39:13 TPT10508: RDBMS error 3153: TDWM Throttle violation for Concurrent Sessions: For Rule Name 'EDW_USER_SESSION_LIMIT', Limit of 4 concurrent requests
PC_CLEARERRORINFO: entering
PC_CLEARERRORINFO: leaving
PC_REPORTERROR: leaving with return code: 48
PC_GETCPUTIME: entering
PC_GETCPUTIME: leaving
PC_UPDATESLAVEINFO: ************************************************
PC_UPDATESLAVEINFO: entering
PC_UPDATESLAVEINFO: Instance: 1 after read
PC_UPDATESLAVEINFO: Number of Bytes:     80
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: Rows Exported:       0
PC_UPDATESLAVEINFO: Rows Sent To DBS:    0
PC_UPDATESLAVEINFO: Number of Blocks:    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:     80
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.0156001
PC_UPDATESLAVEINFO: Load Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Export Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Number Of Stmts:     0
PC_UPDATESLAVEINFO: Rows Exported:       0
PC_UPDATESLAVEINFO: Rows Sent To DBS     0
PC_UPDATESLAVEINFO: Number of Blocks     0
PC_UPDATESLAVEINFO: Bytes Sent To DBS    0
PC_UPDATESLAVEINFO: Bytes Exported:      0
PC_UPDATESLAVEINFO: leaving with result: 0
PC_UPDATESLAVEINFO: ************************************************
PC_CHECKOPERINIT: leaving
TERMINATE: phase 1
PC_DISCCLIOPER: entering
 
     ====================================================== =============
     =                                                                 =
     =                        Logoff/Disconnect                        =
     =                                                                 =
     ====================================================== =============
EXPORT_OPERATOR: disconnecting sessions
**** 08:39:13 Logging off all sessions
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_LOGOFFSQL: entering
PC_LOGOFFSQL: logging off SQL Session
PC_LOGOFFSQL: leaving with result: 0
PC_DOLOGOFFSQL: logging off Main SQL Session
PC_LOGOFFSQL: entering
PC_LOGOFFSQL: logging off SQL Session
PC_LOGOFFSQL: leaving with result: 0
PC_DOLOGOFFSQL: leaving
PC_DISCCLIOPER: leaving
PX_TERMINATE: phase 2
PC_LOGJOBMETADATA: entering
PC_LOGJOBMETADATA: leaving
PC_OUTPUTCPU: entering
PC_OUTPUTCPU: start time: 'Wed Mar 20 08:39:12 2013'
PC_OUTPUTCPU: start time: 'Wed Mar 20 08:39:12 2013'
PC_OUTPUTCPU: stop  time: 'Wed Mar 20 08:39:13 2013'
 
              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.015600
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: Bytes Sent To DBS:   0
PC_GETSLAVEINFO: Bytes Exported:      0
PC_GETSLAVEINFO: retrieving CpuTime field
PC_GETSLAVEINFO: returning value: 0.015600
PC_GETSLAVEINFO: leaving
PC_GETSLAVEINFO: *************************************************
                   1        0.02 Seconds
 
**** 08:39:13 Total processor time used = '0.0156001 Second(s)'
.        Start : Wed Mar 20 08:39:12 2013
.        End   : Wed Mar 20 08:39:13 2013
.        Highest return code encountered = '12'.
EXPORT_OPERATOR: Total processor time used = '0.0156001 Second(s)'
EXPORT_OPERATOR: Start : Wed Mar 20 08:39:12 2013
EXPORT_OPERATOR: End   : Wed Mar 20 08:39:13 2013
PC_OUTPUTCPU: leaving
PC_TERMNOTIFY: entering
PC_TERMNOTIFY: leaving
PC_TERMCLIOPER: entering
**** 08:39:13 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: deallocating main logon string at: 0x94adf30
PC_FREECLIAREA: checking special logon string buffer
PC_FREECLIAREA: checking query band session info buffer
PC_FREECLIAREA: checking request buffer
PC_FREECLIAREA: deallocating request buffer at: 0x94b1640
PC_FREECLIAREA: checking partition buffer
PC_FREECLIAREA: deallocating partition buffer at: 0x94ade70
PC_FREECLIAREA: checking character set buffer
PC_FREECLIAREA: deallocating character set buffer at: 0x93c3cd0
PC_FREECLIAREA: character set name buffer
PC_FREECLIAREA: deallocating character set name buffer at: 0x93c3d00
PC_FREECLIAREA: checking default DBCAREA buffer
PC_FREECLIAREA: deallocating default DBCAREA at: 0x94b1a50
PC_FREECLIAREA: checking main DBCAREA buffer
PC_FREECLIAREA: deallocating Main SQL DBCAREA at: 0x94b24e0
PC_FREECLIAREA: checking Aux DBCAREA buffer
PC_FREECLIAREA: deallocating Aux SQL DBCAREA at: 0x94b4260
PC_FREECLIAREA: checking Special DBCAREA buffer
PC_FREECLIAREA: checking DBC DBCAREA buffer
PC_FREECLIAREA: checking session list
PC_FREECLIAREA: checking DBCHWL session list
PC_FREECLIAREA: checking session array
PC_FREECLIAREA: deallocating DefauleDatabase at: 0x93eb0c0
PC_FREECLIAREA: calling CLI to clean up its internal buffers
PC_CLEANCLI: entering
PC_CLEANCLI: TPTAPI operators do not call DBCHCLN
PC_CLEANCLI: leaving
PC_FREECLIAREA: deallocating CLI area pointer at: 0x94b1180
PC_FREECLIAREA: leaving
PC_TERMCLIOPER: leaving
CLEANUP: entering
CLEANUP: deallocating event area at: 0x94b0e50
CLEANUP: deallocating private_oper_area at: 0x3d19a80
CLEANUP: leaving
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_FREEITEMLIST: entering
PC_FREEITEMLIST: deallocating list of columns
PC_FREEITEMLIST: deallocating itemname address: 0x94ade10
PC_FREEITEMLIST: deallocating item list address: 0x93e8f40
PC_FREEITEMLIST: deallocating itemname address: 0x94addd0
PC_FREEITEMLIST: deallocating item list address: 0x93e8ee0
PC_FREEITEMLIST: item list header is now: 0x0
PC_FREEITEMLIST: leaving
PC_FREEOPERAREA: deallocating item list header at: 0x93e8f40
PC_FREEOPERAREA: deallocating table list
PC_FREEOPERAREA: deallocating DML list
PC_FREEOPERAREA: deallocating TraceOption buffer
PC_FREEOPERAREA: deallocating TraceOption buffer at: 0x93e8d00
PC_FREEOPERAREA: deallocating PrivateLog buffer
PC_FREEOPERAREA: deallocating ConsoleInfo buffer
PC_FREEOPERAREA: deallocating ConsoleInfo buffer at: 0x93d1340
PC_FREEOPERAREA: deallocating ErrorInfo buffer
PC_FREEOPERAREA: deallocating ErrorInfo buffer at: 0x93e7ad0
PC_FREEOPERAREA: deallocating notify_area buffer
PC_FREEOPERAREA: deallocating notify_area buffer at: 0x3d483d0
PC_FREEOPERAREA: deallocating OperCmdID buffer
PC_FREEOPERAREA: deallocating glblmsg
PC_FREEOPERAREA: deallocating glblmsg at: 0xa520040
 
 
 

jedler 2 posts Joined 03/13
04 Apr 2013

The problem was solved using the ADO.NET driver for the TD source.

You must sign in to leave a comment.