CLI error 207 (no message text available)

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Enthusiast

CLI error 207 (no message text available)

We have a user who is trying to move data via a TPT script.  They are exporting using the Export operator and loading using the load operator.  They are using LDAP to connect to each system, but are not entering anything in for LogonMechData as they are using a user name and password.

 

They're getting a CLI error and I'm wondering if this is LDAP related or possibly something else. Specifically, does the user need to enter LogonMechData when using LDAP? Thanks for any guidance on this connectivity issue. 

 

The private log is below...

 

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

===================================================================
= =
= TERADATA PARALLEL TRANSPORTER 64-BIT =
= =
= EXPORT OPERATOR VERSION 15.10.01.02 =
= =
= OPERATOR SUPPORT LIBRARY VERSION 15.10.01.02 =
= =
= COPYRIGHT 2001-2016, TERADATA CORPORATION. =
= ALL RIGHTS RESERVED. =
= =
= Process I.D.: 1048 =
= =
===================================================================
**** 12:47:08 Processing starting at: Thu Dec 21 12:47:08 2017

===================================================================
= =
= Module Identification =
= =
===================================================================
64-bit Export Operator for Windows on DTCL-WC2-EAE192
ExportMain : 15.10.01.01
ExportCLI : 15.10.00.05
ExportUtil : 14.10.00.01
PcomCLI : 15.10.01.02
PcomMBCS : 14.10.00.02
PcomMsgs : 15.10.01.01
PcomNtfy : 15.10.00.01
PcomPx : 15.10.01.01
PcomUtil : 15.10.01.04
PXICU : 15.10.01.02
TDICU : 15.10.01.01
MAIN_STEP APPLY_1[0001] LoadOperator DBS xxxxxxxxx.COM xxxxxxxxxxxxx.LOANS1
MAIN_STEP APPLY_1[0001] Success LoadOperator 1 1 INITIATE-Started 12:47:09 0.0000 0.0156 65000 0 0 0 0 0 N Y
LOANS1_LoadJob-21,17,5,OperatorEnter,MAIN_STEP,LoadOperator,1,2017-12-21,2017-12-21 12:47:09,1,0
LOANS1_LoadJob-21,176,5,OperatorVersion,MAIN_STEP,LoadOperator,1,2017-12-21,15.10.01.02,1,0
LOANS1_LoadJob-21,177,1,OperatorType,MAIN_STEP,LoadOperator,1,2017-12-21,2,1,0
LOANS1_LoadJob-21,178,1,OperatorInstances,MAIN_STEP,LoadOperator,1,2017-12-21,1,1,0
Teradata Parallel Transporter Load Operator Version 15.10.01.02
LoadOperator: private log not specified

===================================================================
= =
= TERADATA PARALLEL TRANSPORTER 64-BIT =
= =
= LOAD OPERATOR VERSION 15.10.01.02 =
= =
= OPERATOR SUPPORT LIBRARY VERSION 15.10.01.02 =
= =
= COPYRIGHT 2001-2016, TERADATA CORPORATION. =
= ALL RIGHTS RESERVED. =
= =
= Process I.D.: 9072 =
= =
===================================================================
**** 12:47:09 Processing starting at: Thu Dec 21 12:47:09 2017

===================================================================
= =
= Module Identification =
= =
===================================================================
64-bit Load Operator for Windows on xxxxxxxx
LoadMain : 15.10.00.06
LoadCLI : 15.10.00.07
LoadUtil : 14.10.00.01
PcomCLI : 15.10.01.02
PcomMBCS : 14.10.00.02
PcomMsgs : 15.10.01.01
PcomNtfy : 15.10.00.01
PcomPx : 15.10.01.01
PcomUtil : 15.10.01.04
PXICU : 15.10.01.02
TDICU : 15.10.01.01
CLIv2 : 15.10.01.01
LOANS1_LoadJob-21,116,5,UtilityName,MAIN_STEP,LoadOperator,1,2017-12-21,TPT Load Operator,1,0
LOANS1_LoadJob-21,0,5,LoadVersionId,MAIN_STEP,LoadOperator,1,2017-12-21,15.10.01.02,1,0
LOANS1_LoadJob-21,115,1,UtilityId,MAIN_STEP,LoadOperator,1,2017-12-21,1,1,0
LOANS1_LoadJob-21,132,5,LoadTdpId,MAIN_STEP,LoadOperator,1,2017-12-21,xxxxxxxxxxxx.COM,1,0
LOANS1_LoadJob-21,1,5,LoadUserName,MAIN_STEP,LoadOperator,1,2017-12-21,xxxxxxxxx,1,0

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

===================================================================
= =
= Column/Field Definition =
= =
===================================================================
Column Name Offset Length Type
============================== ====== ====== ========================
ACCT_NUM 0 20 VARCHAR
CLIENT_NO 22 3 CHAR
LN_NO 25 16 VARCHAR
cnt 43 8 BIGINT
============================== ====== ====== ========================
INDICATOR BYTES NEEDED: 1
EXPECTED RECORD LENGTH: 52

===================================================================
= =
= Control Session Connection =
= =
===================================================================
LoadOperator: connecting sessions
**** 12:47:17 Connecting to RDBMS: 'xxxxxxxxxx'
**** 12:47:17 Connecting with UserId: 'xxxxxx'
CLIv2 : 15.10.01.01
LOANS1_LoadJob-21,116,5,UtilityName,MAIN_STEP,ExportOperator,1,2017-12-21,TPT Export Operator,2,0
LOANS1_LoadJob-21,8,5,ExportVersionId,MAIN_STEP,ExportOperator,1,2017-12-21,15.10.01.02,2,0
LOANS1_LoadJob-21,115,1,UtilityId,MAIN_STEP,ExportOperator,1,2017-12-21,3,2,0
LOANS1_LoadJob-21,131,5,ExportTdpId,MAIN_STEP,ExportOperator,1,2017-12-21,xxxxxxxxxx.COM,2,0
LOANS1_LoadJob-21,9,5,ExportUserName,MAIN_STEP,ExportOperator,1,2017-12-21,xxxxxxx,2,0

===================================================================
= =
= Attribute Definitions =
= =
===================================================================
**** 12:47:18 Options in effect for this job:
OperatorType: Producer
Instances: 1
Character set: Not specified; will use default
Checkpoint: No checkpoint in effect
Notify: Not enabled
Tenacity: 4 hour limit to successfully connect
Sleep: 6 minute(s) between connect retries
Date format: ANSIDATE
Blocksize: Maximum allowable
OutLimit: No limit in effect

===================================================================
= =
= Column/Field Definition =
= =
===================================================================
Column Name Offset Length Type
============================== ====== ====== ========================
ACCT_NUM 0 20 VARCHAR
CLIENT_NO 22 3 CHAR
LN_NO 25 16 VARCHAR
cnt 43 8 BIGINT
============================== ====== ====== ========================
INDICATOR BYTES NEEDED: 1
EXPECTED RECORD LENGTH: 52

===================================================================
= =
= Control Session Connection =
= =
===================================================================
ExportOperator: connecting sessions
**** 12:47:18 Connecting to RDBMS: 'xxxxxxxxxxx'
**** 12:47:18 Connecting with UserId: 'xxxxxx'

**** 12:47:41 Number of Query Band data bytes sent to the RDBMS: 119

**** 12:47:41 Number of Query Band data bytes sent to the RDBMS: 120
LOANS1_LoadJob-21,127,5,ExportDbase,MAIN_STEP,ExportOperator,1,2017-12-21,xxxxxxx,2,0

===================================================================
= =
= Teradata Database Information =
= =
===================================================================
**** 12:47:43 Teradata Database Version: '15.10.06.02'
**** 12:47:43 Teradata Database Release: '15.10.06.02'
**** 12:47:43 Maximum request size supported: 1MB
**** 12:47:43 Session character set: 'ASCII'
**** 12:47:43 Total AMPs available: 1440
LOANS1_LoadJob-21,128,5,LoadDbase,MAIN_STEP,LoadOperator,1,2017-12-21,xxxxxxxxxx,1,0
**** 12:47:43 Data Encryption: supported
**** 12:47:43 Enhanced Statement Status Level: 1
**** 12:47:43 Blocksize for this job: 64330 bytes

===================================================================
= =
= Special Session Connection =
= =
===================================================================

===================================================================
= =
= Teradata Database Information =
= =
===================================================================
**** 12:47:57 Teradata Database Version: '15.10.04.05'
**** 12:47:57 Teradata Database Release: '15.10.04.04'
**** 12:47:57 Maximum request size supported: 1MB
**** 12:47:57 Session character set: 'ASCII'
**** 12:47:57 Total AMPs available: 800
**** 12:47:57 Data Encryption: supported
**** 12:47:57 Enhanced Statement Status Level: 1
**** 12:48:03 Restart log table 'xxxxxxxxxx.LOANS1_flog' has been created
**** 12:48:08 Current working DATABASE set: 'xxxxxxxxxxxxxxx'

===================================================================
= =
= Special Session Connection =
= =
===================================================================
LOANS1_LoadJob-21,102,1,LoadCLIError,MAIN_STEP,LoadOperator,1,2017-12-21,207,1,0
LOANS1_LoadJob-21,140,5,LoadCLIMsgTxt,MAIN_STEP,LoadOperator,1,2017-12-21,CLI Error 207: CLI error 207 (no message text available),1,0
LOANS1_LoadJob-21,101,0,RDBMSRestart,MAIN_STEP,LoadOperator,1,2017-12-21,,1,0
**** 12:49:55 Number of sessions adjusted due to TASM: 8

Instance Assigned Connected Result
======== ======== ========= ======================
1 8 8 Successful
LOANS1_LoadJob-21,180,1,TotalSessAssigned,MAIN_STEP,ExportOperator,1,2017-12-21,8,2,0
LOANS1_LoadJob-21,181,1,TotalSessConnected,MAIN_STEP,ExportOperator,1,2017-12-21,8,2,0
LOANS1_LoadJob-21,182,1,TASMSessionLimit,MAIN_STEP,ExportOperator,1,2017-12-21,8,2,0
======== ======== ========= ======================
Total 8 8 Successful
LOANS1_LoadJob-21,86,0,ExportBegin,MAIN_STEP,ExportOperator,1,2017-12-21,,2,0
MAIN_STEP APPLY_1[0001] Retry Error LoadOperator 1 1 INITIATE-Ended 12:50:01 172.0000 0.3594 65000 0 0 0 0 0 N Y
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
MAIN_STEP APPLY_1[0001] Success LoadOperator 1 1 TERMINATE-Started 12:50:01 0.0000 0.0000 65000 0 0 0 0 0 N Y

LoadOperator: TPT10507: CLI Error 207: CLI error 207 (no message text available)
**** 12:50:01 TPT10507: CLI Error 207: CLI error 207 (no message text available)
LOANS1_LoadJob-21,186,3,CPUTimeByInstance,MAIN_STEP,LoadOperator,1,2017-12-21,0.343750,1,0
**** 12:50:01 RDBMS CRASHED OR RETRYABLE CONDITION OCCURRED.
JOB WILL BE RESTARTED.

===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
LoadOperator: disconnecting sessions
**** 12:50:01 Logging off all sessions
LOANS1_LoadJob-21,135,0,LoadSessEnd,MAIN_STEP,LoadOperator,1,2017-12-21,,1,0

Instance Cpu Time
======== ================
1 0.34 Seconds

**** 12:50:11 Total processor time used = '0.34375 Second(s)'
. Start : Thu Dec 21 12:47:09 2017
. End : Thu Dec 21 12:50:11 2017
. Highest return code encountered = '0'.
LoadOperator: Total processor time used = '0.34375 Second(s)'
LoadOperator: Start : Thu Dec 21 12:47:09 2017
LoadOperator: End : Thu Dec 21 12:50:11 2017
**** 12:50:11 This job terminated
LOANS1_LoadJob-21,179,5,OperatorEndTS,MAIN_STEP,LoadOperator,1,2017-12-21,2017-12-21 12:50:21,1,0
LOANS1_LoadJob-21,18,1,OperatorExit,MAIN_STEP,LoadOperator,1,2017-12-21,0,1,0
MAIN_STEP APPLY_1[0001] Success LoadOperator 1 1 TERMINATE-Ended 12:50:21 20.0000 0.0000 65000 0 0 0 0 0 N Y
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
MAIN_STEP SELECT_2[0001] Success ExportOperator 1 1 TERMINATE-Started 12:50:21 0.0000 0.0000 65000 0 0 0 0 0 N Y
LOANS1_LoadJob-21,186,3,CPUTimeByInstance,MAIN_STEP,ExportOperator,1,2017-12-21,0.453125,2,0

===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
ExportOperator: disconnecting sessions
**** 12:50:21 Logging off all sessions
LOANS1_LoadJob-21,138,0,ExportSessEnd,MAIN_STEP,ExportOperator,1,2017-12-21,,2,0

Instance Cpu Time
======== ================
1 0.45 Seconds

**** 12:50:48 Total processor time used = '0.453125 Second(s)'
. Start : Thu Dec 21 12:47:08 2017
. End : Thu Dec 21 12:50:48 2017
. Highest return code encountered = '0'.
ExportOperator: Total processor time used = '0.453125 Second(s)'
ExportOperator: Start : Thu Dec 21 12:47:08 2017
ExportOperator: End : Thu Dec 21 12:50:48 2017

3 REPLIES
Teradata Employee

Re: CLI error 207 (no message text available)

CLIv2 207 is EM_NETCONN - a low-level error reported (by the TCP/IP stack) while trying to make the network connection. It's not related to LDAP.

 

You don't need LogonMechData unless your authentication rules require some parameter other than simple user name and password.

 

 

Enthusiast

Re: CLI error 207 (no message text available)

Thank you Fred for clarifying that.

 

This user is executing the script on their PC so they are using the network their PC is connected to. I'm not sure how big the table is, but could it have something to do with them pushing too much data through their network.  I'm assuming they might benefit by running this directly on the Teradata node.

 

Also, we had an error in the past where we were told to add a switch to the tbuild command. 

 

-h 50M

 

I believe this has something to do with virtual memory if I remember...

 

Could this be causing an issue?  I'm currently having the user testing this, but I'd like to know your opinion.

 

Thank you again for your help!

 

 

 

Highlighted
Teradata Employee

Re: CLI error 207 (no message text available)

You are correct, that parameter relates to memory usage on the TPT client; that would not be related.

 

The log indicates that the control sessions were connected successfully, but it failed while trying to connect the "special" (parallel data transfer) sessions to the target system. It does not appear to have tried to push any data to the target yet.

 

This error can be difficult to troubleshoot without a network trace. Assuming the problem is reproducible, I would start by checking to see if all the hostnames being used for the target database connection (with COPn suffix, if COPs are being used) resolve to the correct IPs from the client PC, and that if x is the highest valid COP then trying to access COP(x+1) reports "not found".