teradata CLI2: BADLOGMECH(507): Requested logon mechanism is not available.错误解决。
系统的fexp脚本这两天偶尔报以下错误，这应该由于cliv2在客户端选择了td1或其他验证机制，而teradata服务器端并未配置其支持td1验证的原因。
通过手工在登录字符串前显示增加.logmech TD2;（服务器端支持TD2认证机制）之后，该错误就不再发生。
日志如下：
perl itf_kddq_e.pl ITF_ITF_KDDQ_E_20090317.dir Starting ...
TX_Date=20090317
Today= 2009-03-17
2009/03/18 09:46:59
Prepare daily data ...
----------------------
sqlStmt1 = SELECT CAST(TRIM(CAST(Telecom_Area_Name AS CHAR(40)))||CAST(';' AS CHAR(1))||
TRIM(CAST(Username AS CHAR(40)))||CAST(';' AS CHAR(1))||
CAST(';' AS CHAR(1))||
TRIM(CAST(std_Prd_Lvl4_name AS CHAR(40)))||CAST(';' AS CHAR(1))||
TRIM(CAST(Brand_Type_name AS CHAR(40)))||CAST(';' AS CHAR(1))||
TRIM(CAST(Std_User_Type_Cd AS CHAR(40)))||CAST(';' AS CHAR(1))||
TRIM(CAST(CDsc_Eff_Dt AS CHAR(40)))||CAST(';' AS CHAR(1))||
TRIM(CAST(CDsc_Exp_Dt AS CHAR(40)))
AS CHAR(1000))
FROM BSSWORK.YD_KDDQ_HIST_E
----------------------
DATA_DATE = 20090317
myCtl = kddq_5
tmpfile = kddq_5.20090317
outfile = dq-zj-sx-20090317.txt
========================================================================
= =
= FastExport Utility Release FEXP.07.09.00.000 =
= Platform WIN32 =
= =
========================================================================
= =
= Copyright 1990-2006, NCR Corporation. ALL RIGHTS RESERVED. =
= =
========================================================================
**** 09:46:59 UTY2411 Processing start date: WED MAR 18, 2009
========================================================================
= =
= Logon/Connection =
= =
========================================================================
0001 /* Add your fexp options here */
.LOGTABLE ITFTEMP.LOG_kddq_5_shaoxing;
0002 .LOGON DWJYFX,;
**** 09:47:02 UTY8400 Teradata Database Release: V2R.06.02.02.18
**** 09:47:02 UTY8400 Teradata Database Version: 06.02.02.21b
**** 09:47:02 UTY8400 Default character set: ASCII
**** 09:47:02 UTY8400 Current RDBMS has UDT support
**** 09:47:02 UTY8400 Current RDBMS has Large Decimal support
**** 09:47:02 UTY8400 Maximum supported buffer size: 1M
**** 09:47:02 UTY8400 Data Encryption supported by RDBMS server
**** 09:47:31 UTY6211 A successful connect was made to the RDBMS.
**** 09:47:31 UTY6217 Logtable 'ITFTEMP.LOG_kddq_5_shaoxing' has been created.
========================================================================
= =
= Processing Control Statements =
= =
========================================================================
0003 .BEGIN EXPORT;
0004 .EXPORT OUTFILE kddq_5.20090317 MODE RECORD format text;
0005 SELECT CAST(TRIM(CAST(Telecom_Area_Name AS CHAR(40)))||CAST(';' AS
CHAR(1))||
TRIM(CAST(Username AS CHAR(40)))||CAST(';' AS
CHAR(1))||
CAST(';' AS CHAR(1))||
TRIM(CAST(std_Prd_Lvl4_name AS CHAR(40)))||CAST(';'
AS CHAR(1))||
TRIM(CAST(Brand_Type_name AS CHAR(40)))||CAST(';'
AS CHAR(1))||
TRIM(CAST(Std_User_Type_Cd AS CHAR(40)))||CAST(';' AS
CHAR(1))||
TRIM(CAST(CDsc_Eff_Dt AS CHAR(40)))||CAST(';' AS CHAR(1))||
TRIM(CAST(CDsc_Exp_Dt AS CHAR(40)))
AS CHAR(1000))
FROM BSSWORK.YD_KDDQ_HIST_E
;
0006 .END EXPORT;
========================================================================
= =
= FastExport Initial Phase =
= =
========================================================================
**** 09:47:31 UTY8700 Options in effect for this FastExport task:
. Sessions: 4 session(s).
. Minimum of 1 export session(s) requested.
. Mode: RECORD
. Blocksize: 64260 bytes.
. Outlimit: No limit in effect.
**** 09:47:31 UTY8715 FastExport is submitting the following request:
Select NULL from ITFTEMP.LOG_kddq_5_shaoxing where (LogType = 220) and (Seq
= 1) and (FExptSeq = 0);
**** 09:47:33 UTY8707 CLI error: DBCHCL returned 507.
text: CLI2: BADLOGMECH(507): Requested logon mechanism is not available.
========================================================================
= =
= Logoff/Disconnect =
= =
========================================================================
**** 09:47:45 UTY6215 The restart log table has NOT been dropped.
**** 09:47:45 UTY6212 A successful disconnect was made from the RDBMS.
**** 09:47:45 UTY2410 Total processor time used = '0.140625 Seconds'
. Start : 09:46:59 - WED MAR 18, 2009
. End : 09:47:45 - WED MAR 18, 2009
. Highest return code encountered = '12'.
Failed to call fastexport!
Failed to Call fexp utility
perl itf_kddq_e.pl ITF_ITF_KDDQ_E_20090317.dir Finished.
阅读(2062) | 评论(0) | 转发(0) |
