Connecting Teradata and MS SQL sources

Connectivity
Fan

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

1 REPLY
Fan

Re: Connecting Teradata and MS SQL sources

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