All Forums Teradata Studio
akshaykhobare 6 posts Joined 09/13
23 Sep 2013
Unable to launch Teradata Studio Express
fgrimmer 553 posts Joined 04/09
23 Sep 2013

Can you provide more information? What version did you install? 32-bit or 64-bit? What version of JRE? What is the problem when you launch?

akshaykhobare 6 posts Joined 09/13
24 Sep 2013

Sorry , my post got submitted before I could add details.
I have installed  - TDExpress14.10_Sles11_40GB - on VMware ( Host OS - Windows7 ) &  was able to connect to Teradata bteq through Linux Terminal ( i.e .logon 127.0.0.1/dbc -->> dbc ). Then I downloaded TeradataStudioExpress__linux_x86_64.14.10.00.00-1.tar.gz & followed instructions for 'Linux install' mentioned on - http://downloads.teradata.com/download/tools/teradata-studio-express exactly.
When I run 'rpm -qa TeradataStudioExpress' ; I get   'TeradataStudioExpress 14.10.00.00 -1' , so I am guessing Teradata Studio  has been installed rightly.
Its installed at /opt/teradata/TeradataStudioExpress/TeradataStudioExpress where I can see workspace dir as well.
Now , when I click on TeradataStudioExpress icon (.exe) , a pop-up yellowish window appears ( as if TeradataStudioExpress opening is in progress) ,but after 30 seconds it goes off the screen & nothing more.
Can you please help me to know ,if I missed some setting which is preventing TeradataStudioExpress client  OR if I am going wrong while accessing TeradataStudioExpress ?     ( I tried re-installing same TeradataStudioExpress setup again as well)
 I basically wanted SQL Assistant type client through which I can play with Teradata.
Really thanks for your prompt reply & for Teradata Express.

fgrimmer 553 posts Joined 04/09
24 Sep 2013

Can you look to see if a configuration.log file is created in the configuration directory of the install or any error message in the .log file in your workspace /.metadata directory.   Just to clarify, you are running 64-bit JRE in your VM?  Can you run Studio Express outside your VM and connection to TD Express system?

akshaykhobare 6 posts Joined 09/13
24 Sep 2013

java  runtime env is - 1.6.0_43

akshaykhobare 6 posts Joined 09/13
24 Sep 2013
#
# A fatal error has been detected by the Java Runtime Environment:
#
#  SIGSEGV (0xb) at pc=0x00007fffe95dbdf1, pid=6742, tid=140737328940816
#
# JRE version: 6.0_43-b01
# Java VM: Java HotSpot(TM) 64-Bit Server VM (20.14-b01 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C  [libpangoft2-1.0.so.0+0x18df1]  pango_ot_tag_from_script+0x83f1
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#

This is code snippet from .log file created. So it seems I am  running 64-bit JRE in your VM. So this error is related to JRE?  Although Icouldnt find any meningful error message.
 Should I try to install TeradataStudio on host OS & try to connect to VMware-Teradata express? I will try that ...

fgrimmer 553 posts Joined 04/09
24 Sep 2013

This error was reported in this forum. It appears to be related to the JRE inside the VM and something has gotten corrupt. Yes, I would try running Studio Express outside the Vm and connect to Teradata Express. Sorry for the inconvenience.

akshaykhobare 6 posts Joined 09/13
25 Sep 2013

Hi,
Thanks for the suggestion.
In 2nd attemp I was able to install Teradata Studio on Host OS.  I followed instructions as mentioned  at http://developer.teradata.com/database/articles/teradata-express-network-configuration & changed hosts & resolv.conf at /etc/.
   Now  I am trying to establish a connection from Studio to VM-TD Express image. I am creating 'New Teradata Connection Profile'.But I am not sure what 'database server name'  should I try out. I attempted with few alias names from hosts/host.conf/resolv.conf .
     I searched several posts here but I couldnt figure it out exactly.  Can you please guide me here OR point meto the post which can explain connection testing process. Sorry for the newbie question but I am naive to networking/administration.

fgrimmer 553 posts Joined 04/09
25 Sep 2013

Find out the IP address of your VM and use that for the Database Server Host.

akshaykhobare 6 posts Joined 09/13
28 Sep 2013

Thanks. I was able to test connection after adding cop entry in,
1.  /etc/hosts in VMWare
2. C:\Windows\System32\drivers\etc\hosts on Host OS
 

shettykiran58 2 posts Joined 07/13
02 Dec 2013

Unable to launch Teradata 14 on Rhel 6.
I am new to teradata 
I installed below packages of Teradata 14:
Teradata Studio 14,
cliv2
Tdodbc
Tdicu
TeraGss
It seems that there are some more packages to be installed 
Can anyone help me to get the full packages of Teradata 14 for Linux(rhel x86_64)
 
Thanks,
Kiran
 

fgrimmer 553 posts Joined 04/09
03 Dec 2013

@Kiran, Please post your question on the Cloud Computing forum. thanks

nathanvig23 1 post Joined 03/14
29 Mar 2014

Hi,
 
I have downloaded and installd teradata studio express 14.10 but i was not able to create a new connection profile. Because i dont know what to give for database server name.
Please help me to rectify this problem.
 
Regards,
Vigneshnathan.

fgrimmer 553 posts Joined 04/09
02 Apr 2014

Vigneshnathan, You need to have the name or IP address of the Teradata Database that you are connecting to and enter that value for the Database Server Name. Then enter the username and password for the user you are logging in as.

KAlesh 1 post Joined 03/14
03 Apr 2014

I downloaded and installed Teradata studio express 14.10.1.201310271204 a few weeks ago. I have tried on and off to connect to the database I need but I have not been able to make it work. I have tried to set up a Teradata database connection.  For the database server name I have used a name and the IP address (at different times). With both I get "ping succeeded" when I test the connection.  However when the set up is complete I see a whole lot of entries, which are not at all what I expect to see/need. A colleague works with teradata sql assistant and this works fine. I got forwarded to Teradata Studio express when I tried to find teradata sql assistant myself.  Any ideas what I could be doing wrong with the installation? Any chance of getting teradata sql assistant instead?  Thanks for your help.

fgrimmer 553 posts Joined 04/09
03 Apr 2014

Kristina, Once you connect, the Data Source Explorer displays the databases and users for the Teradata system. You can change the Data Source Explorer Load Preference to load just databases, just databases but include DBC, just databases but include DBC and yourself, or databases and users with permspace. You can also use the Filter option on the Databases folder to filter out or just include certain databases to display in the DSE. It's possible that the database you are looking for is a child to another database. You can change the preference to not Show Databasea and Users in Hierarchical Display to show all databases and users in flat display. To get to the preference, go to top toolbar Window>Preferences>Teradata Datatools Preferences>Data Source Explorer Load Preferences.

ankit.kaushik 1 post Joined 06/14
31 Aug 2014

Hello,
I am having a similar problem as OP: "Now , when I click on TeradataStudioExpress icon (.exe) , a pop-up yellowish window appears ( as if TeradataStudioExpress opening is in progress) ,but after 30 seconds it goes off the screen & nothing more."
 
The only difference is TD Studio Express is installed on host OS (no VM). Are there any ways to solve this issue. I have already reinstalled TD Studio Express but to no avail.

fgrimmer 553 posts Joined 04/09
31 Aug 2014

Ankit, Just to recap what is the environment, are you running Teradata Studio Express inside a Teradata Express VM or outside, on your desktop? Is there an error message displayed? Is there a .log file located in the install directory /configuration?

15 Jan 2015

I have installed teradata studio express for practice. while creating connection profile, in database server name what has to be given.Do i need to install any other terdata components.Please help in this.

fgrimmer 553 posts Joined 04/09
15 Jan 2015

sahithi, Enter the IP address or hostname of your database server.

integration 5 posts Joined 05/15
28 May 2015

hi i am unable to create new  connection profile am getting ping failed.
i installed TeradataStudioExpress__win32_x86.15.10.00.01 version on windows 7 32 bit system.
i have jdk1.8.0_25 and jre7 but am unable to create teradata database 

fgrimmer 553 posts Joined 04/09
29 May 2015

@integration, What is the exception you are getting when you try to ping or connect?

integration 5 posts Joined 05/15
10 Jun 2015

Hi all,
i have installed teradata database express 13.0 version in my windows 7 32bit system. installation has been done successfully. and i defined some sample datasources but i am unable to connect them using teradata administrator while connect to data source getting below error
10054: 10054 WSA E ConnReset:Connection reset by peer.
please suggest me how to resolve it and how to enter into database.
 
thanks,
jaipal.

fgrimmer 553 posts Joined 04/09
10 Jun 2015

Jaipal, Please post your question to the Tools Forum so someone can assist you regarding the Teradata Administrator product. thanks.

Jcarlo145 1 post Joined 04/16
04 May 2016

Hi everyone, can someone please help me. I am new to Teradata and I have just installed

Teradata Studio Express

Version: 15.10.01.01.201601251512

on a Windows 7 64 bit system. 

I am trying to connect to a Teradata Database but I am unsuccessful so far...

I select TeraData Database from the connection Profile types. 

The default driver selected is Teradata Embeded JDBC Driver

I define the Database Servername, Username and password

but when I test the connection, it fails and returs the error "ping failed" 

java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.09] [Error 1000] [SQLState 08S01] Login failure for Connection to testServer Wed May 04 21:21:42 SGT 2016 socket orig=testServer cid=61c7c0c8 sess=0 java.net.UnknownHostException: testServer   at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)   at java.net.InetAddress$2.lookupAllHostAddr(Unknown Source)   at java.net.InetAddress.getAddressesFromNameService(Unknown Source)   at java.net.InetAddress.getAllByName0(Unknown Source)   at java.net.InetAddress.getAllByName(Unknown Source)   at java.net.InetAddress.getAllByName(Unknown Source)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:200)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:300)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:148)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:134)   at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO(GenericTeradataConnection.java:116)   at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:98)   at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:208)   at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)   at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)   at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:233)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:159)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:277)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:122)   at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)   at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)   at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataPingFactory.createConnection(TeradataPingFactory.java:36)   at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)   at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)   at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)   at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)   at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)  

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:94)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:69)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:207)

at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:59)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:155)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:134)

at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO(GenericTeradataConnection.java:116)

at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:98)

at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:208)

at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)

at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)

at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:233)

at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:159)

at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:277)

at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:122)

at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)

at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataPingFactory.createConnection(TeradataPingFactory.java:36)

at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)

at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Caused by: java.net.UnknownHostException: testServer

at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)

at java.net.InetAddress$2.lookupAllHostAddr(Unknown Source)

at java.net.InetAddress.getAddressesFromNameService(Unknown Source)

at java.net.InetAddress.getAllByName0(Unknown Source)

at java.net.InetAddress.getAllByName(Unknown Source)

at java.net.InetAddress.getAllByName(Unknown Source)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:200)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:300)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:148)

... 21 more

 

I hope you can help me on this as I really want to learn using Teradata. Thank you.

 

fgrimmer 553 posts Joined 04/09
04 May 2016

John Carlo, Do you have a Teradata Database server called testServer? The error exception says unknown host: "java.net.UnknownHostException: testServer". If you don't have a Teradata Database server to test with, you can download Teradata Express or look into Teradata Database offerings on AWS as an option.

narasimhan_ns 1 post Joined 04/15
13 May 2016

Hi,
I have recently installed Teradata Studio express for Mac 15.10.01. However, after installation, the software is not launching. Instead it shows a small window of Teradata Studio express in yellow as though its launching but doesn't go beyond that.
Request your help.

fgrimmer 553 posts Joined 04/09
16 May 2016

Narasimhan, We have seen problems with JVM 7 on Mac. Please upgrade your JVM to 8. thanks.

ArpitaC@30 1 post Joined 05/16
19 May 2016

Hi Francine,
I am facing a similar kind of issue as mentioned by John Carlo after installing Teradata Studio express 15  for Windows 7. I am trying to create a connection to create my own databases and tables in my local desktop for query practicing but each time I am trying to create a connection it is saying "error trying to create connection java net unknownhostexception" . I did not completely get what you said - "If you don't have a Teradata Database server to test with, you can download Teradata Express or look into Teradata Database offerings on AWS as an option."
Could you please elaborate a little more. I am new to teradata and want to do more hands-on so am trying to install it in my local desktop.
Looking forward to you.
-Arpita

Ashi

dnoeth 4628 posts Joined 11/04
19 May 2016

Hi Arpita,
Teradata Studio is only a database client used to connect to a database server.
The server might be Teradata Express VM
http://downloads.teradata.com/download/database/teradata-express-for-vmware-player
or the new AWS vesion:
http://downloads.teradata.com/download/database/teradata-express/amazon-ec2

Dieter

newb1 22 posts Joined 09/13
21 May 2016

WHERE DO YOU FIND OUT THE HOST NAME? I HAVE TDE 14.00.03.02 for VMware (4GB) AND ​I HAVE THE SAME PROBLEM WITH THE CONNECTION TO THE DATABASE. I THINK THE INSTRUCTIONS SHOULD BE REWRITTEN IN A MORE DETAIL AROUND THIS.

newb1 22 posts Joined 09/13
21 May 2016

Ok I've worked out how to do this in Studio Express  for TDE 14.00.03.02 for VMware (4GB) if you running on a PC with Windows. Database Server Name: 127.0.0.1 , User Name (Domain): DBC, Password: DBC
 
This will give you the same as the bteq example here :
​http://developer.teradata.com/database/articles/teradata-express-14-0-for-vmware-user-guide

You must sign in to leave a comment.