Dear all,I met a error when connecting Teradata server form a Solaris Teradata Client. This only happen on Solaris, so I think the Teradata Server is working well.I don't know what cause the problem and how to resolve it.Waiting for advice. ========Error message on Solaris===========> bteq Teradata BTEQ 08.02.02.00 for UNIX5. Copyright 1984-2004, NCR Corporation. ALL RIGHTS RESERVED. Enter your logon or BTEQ command:logon dsserver/user1;logon dsserver/user1Password: *** Warning: DBS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS>=========Success log on other platform=========> bteq Teradata BTEQ 08.02.03.00 for UNIX5. Copyright 1984-2005, NCR Corporation. ALL RIGHTS RESERVED. Enter your logon or BTEQ command:logon dsserver/user1;logon dsserver/user1Password: *** Logon successfully completed. *** Transaction Semantics are BTET. *** Character Set Name is 'ASCII'. *** Total elapsed time was 3 seconds. BTEQ -- Enter your DBC/SQL request or BTEQ command:=========Sytem information:=======SunOS 5.10 Generic_125100-10 sun4u sparc SUNW,Sun-Fire-V440=========package information after install===========-bash-3.00# pkginfo |grep Terasystem TeraGSS Teradata GSS client packagesystem TeraGSS32 Teradata GSS client packageapplication bteq Teradata BTEQ Applicationapplication cliv2 Teradata CLIV2 Packageapplication cliv2so Teradata CLIV2so Packagelibrary piom Teradata Data Connector Access Module APIlibrary tdicu Shared common components for Internationalization for Teradataapplication tdodbc Teradata ODBC Driver==========Install log============-bash-3.00# cat /var/ncr/logs/pkgadd.logTue Oct 14 16:47:37 CST 2008Installation of was successful.Installation of was successful. Copyright (C) NCR Corporation, 2004 All Rights Reserved.Adding TD_ICU_DATA environment variable to /etc/profile file.Adding TD_ICU_DATA environment variable to /etc/.login file.Installation of was successful. Copyright (C) 2000-2003. NCR Corporation All Rights Reserved.Installation of was successful. Copyright (C) NCR Corporation, 2003-2004 All Rights ReservedAdding CLI COPLIB environment variable to /etc/profile file.Adding CLI COPERR environment variable to /etc/profile file.Installation of was successful.WARNING: setting mode of to default mode (755) Copyright (C) NCR Corporation, 2003-2004 All Rights ReservedKeeping existing /usr/lib/clispb.dat fileInstallation of was successful. Copyright (C) NCR Corporation, 1984-2004 All Rights ReservedInstallation of was successful.Copyright 1994-2004 by NCR CorporationAll Rights Reserved.NCR CONFIDENTIAL and TRADE SECRETPortions of this software are copyrightedby DataDirect Technologies 1991-2004Installation of was successful.
Based on DNS/hosts "dsserver" might resolve to a different (invalid) ip-address.Try to "ping dsservercop1" to check if it's the correct ip-address.Dieter
Thanks.I have add a record in /etc/hosts and can ping dsservercop1, but problem still exist.*.*.*.*(ip address) dsserver dsserverCOP1 #Teradata Server=> ping dsservercop1dsservercop1 is alive
can you try login using ip address from bteq ?.logon v.x.y.z/id;Also compare the ip address you get via ping / nslookup to the actual IP address ( are they same)
Hi, thanks for reply. I tried your advice.==================> ping -s dsserverCOP1PING dsserverCOP1: 56 data bytes64 bytes from **.**.**.com(18.104.22.168): icmp_seq=0. time=269. ms64 bytes from **.**.**.com(22.214.171.124): icmp_seq=1. time=264. msthe IP address(126.96.36.199 for example) is correct but I got this error when try to conncet using the ip address=============> bteq Teradata BTEQ 08.02.02.00 for UNIX5. Copyright 1984-2004, NCR Corporation. ALL RIGHTS RESERVED. Enter your logon or BTEQ command:.logon 188.8.131.52/user1.logon 184.108.40.206/user1Password: *** CLI error: CLI2: BADLOGON(303): Invalid logon string. *** Return code from CLI is: 303 *** Error: Logon failed! *** Total elapsed time was 4 seconds. Teradata BTEQ 08.02.02.00 for UNIX5. Enter your logon or BTEQ command:
if there's teradata odbc installed in your system, try making use of the adhoc program in the examples folder to connect.The other issue I could think of is a firewall problem between the two systems. which you will have to enlist the help of SA/Networking folks.
Thank you very much, this issue occured after Solaris IP address changed, I think it caused by network problem.
I have installed teradata dem0 12 vesrion on Windows XP. I am getting the below error when I try to logon to BTEQ.
*** Warning: DBS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS>
my hosts file has the below entry :
127.0.0.1 localhost localtdcop1
Please let me know how can I resolve this?