Login problem after installing Teradata Studio (express) 16.20.09 on Teradata database

Teradata Studio
Fan

Login problem after installing Teradata Studio (express) 16.20.09 on Teradata database

Dear fellow Studio (Express) user,

After installing Teradata Studio or Teradata Studio Express, I can't logging on Teradata database. See the screendump from connection properties en logfile at the bottom of this topic.

In the following order I installed with default settings:

  1. jre-10.0.2_windows-x64_bin.exe
  2. TeradataODBC__windows_indep.16.20.14.00
  3. TeradataStudioExpress__win64_x86.16.20.09.00

When I configure a new connectionprofile (with an IP-adres as database server name; username and password; LDAP authentication mechanism), I can't select the ODBC-driver in the window 'Specify a Driver and Connection Details'. I successfully  tested the ODBC-connection via the ODBC-connectiondmanager from Windows. The JDBC-driver generate the error in the log-file.

Please help me further,

Ton Kuipers

Connectionproperties Teradata JDBC.PNG

Logfile


!ENTRY org.eclipse.datatools.connectivity 2 -1 2019-01-23 16:16:48.101
!MESSAGE Error creating SQL Model Connection connection to KPN10. (Error: [Teradata JDBC Driver] [TeraJDBC 16.20.00.10] [Error 1000] [SQLState 08S01] Login failure for Connection to 10.68.162.100 Wed Jan 23 16:16:48 CET 201... See log for futher details)
!STACK 0
java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 16.20.00.10] [Error 1000] [SQLState 08S01] Login failure for Connection to 10.68.162.100 Wed Jan 23 16:16:48 CET 201... See log for futher details
 at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnectionFactory.createPooledConnection(TeradataJDBCConnectionFactory.java:116)
 at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataConnectionFactory.createConnection(TeradataConnectionFactory.java:51)
 at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)
 at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:861)
 at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435)
 at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363)
 at com.teradata.datatools.connection.pool.ConnectionPoolControl.checkProfile(ConnectionPoolControl.java:313)
 at com.teradata.datatools.connection.pool.ConnectionPoolControl.getConnection(ConnectionPoolControl.java:417)
 at com.teradata.datatools.connection.pool.ConnectionHelper.getConnection(ConnectionHelper.java:40)
 at com.teradata.datatools.connection.services.impl.ConnectionService.getConnection(ConnectionService.java:70)
 at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnectionFactory.createConnection(TeradataJDBCConnectionFactory.java:56)
 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.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:705)
 at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:690)
 at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
 at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
 at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
 at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
 at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:179)
 at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:61)
 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:56)
Caused by: java.net.SocketException: Permission denied: connect
 at java.base/java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
 at java.base/java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
 at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
 at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
 at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
 at java.base/java.net.PlainSocketImpl.connect(Unknown Source)
 at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
 at java.base/java.net.Socket.connect(Unknown Source)
 at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:1242)

!ENTRY org.eclipse.ui 4 0 2019-01-23 16:16:48.101
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.NullPointerException
 at com.teradata.datatools.dtp.sqltools.db.teradata.services.TeradataDBSQLService.isDBFeatureUpdate(TeradataDBSQLService.java:758)
 at com.teradata.datatools.dtp.sqltools.db.teradata.services.TeradataDBSQLService.updateDBDefinition(TeradataDBSQLService.java:741)
 at com.teradata.datatools.dtp.sqltools.db.teradata.services.TeradataDBSQLService.getSQLParser(TeradataDBSQLService.java:140)
 at org.eclipse.datatools.sqltools.sqleditor.internal.editor.SQLUpdater.enableSyntaxValidation(SQLUpdater.java:539)
 at org.eclipse.datatools.sqltools.sqleditor.internal.editor.SQLUpdater.run(SQLUpdater.java:136)
 at org.eclipse.datatools.sqltools.sqleditor.SQLEditor$4.run(SQLEditor.java:1467)
 at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:37)
 at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:182)
 at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4213)
 at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3820)
 at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1150)
 at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)
 at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1039)
 at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:153)
 at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:680)
 at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)
 at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:594)
 at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148)
 at com.teradata.studioexpress.Application.start(Application.java:58)
 at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
 at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
 at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
 at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
 at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.base/java.lang.reflect.Method.invoke(Unknown Source)
 at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
 at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
 at org.eclipse.equinox.launcher.Main.run(Main.java:1499)
 at org.eclipse.equinox.launcher.Main.main(Main.java:1472)

!ENTRY org.eclipse.datatools.connectivity 4 -1 2019-01-23 16:16:48.179
!MESSAGE Could not connect to KPN10.
!SUBENTRY 1 org.eclipse.datatools.connectivity 2 -1 2019-01-23 16:16:48.179
!MESSAGE Error creating SQL Model Connection connection to KPN10. (Error: [Teradata JDBC Driver] [TeraJDBC 16.20.00.10] [Error 1000] [SQLState 08S01] Login failure for Connection to 10.68.162.100 Wed Jan 23 16:16:48 CET 201... See log for futher details)
!STACK 0
java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 16.20.00.10] [Error 1000] [SQLState 08S01] Login failure for Connection to 10.68.162.100 Wed Jan 23 16:16:48 CET 201... See log for futher details
 at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnectionFactory.createPooledConnection(TeradataJDBCConnectionFactory.java:116)
 at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataConnectionFactory.createConnection(TeradataConnectionFactory.java:51)
 at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)
 at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:861)
 at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435)
 at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363)
 at com.teradata.datatools.connection.pool.ConnectionPoolControl.checkProfile(ConnectionPoolControl.java:313)
 at com.teradata.datatools.connection.pool.ConnectionPoolControl.getConnection(ConnectionPoolControl.java:417)
 at com.teradata.datatools.connection.pool.ConnectionHelper.getConnection(ConnectionHelper.java:40)
 at com.teradata.datatools.connection.services.impl.ConnectionService.getConnection(ConnectionService.java:70)
 at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnectionFactory.createConnection(TeradataJDBCConnectionFactory.java:56)
 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.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:705)
 at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:690)
 at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
 at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
 at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
 at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
 at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:179)
 at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:61)
 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:56)
Caused by: java.net.SocketException: Permission denied: connect
 at java.base/java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
 at java.base/java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
 at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
 at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
 at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
 at java.base/java.net.PlainSocketImpl.connect(Unknown Source)
 at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
 at java.base/java.net.Socket.connect(Unknown Source)
 at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:1242)


Accepted Solutions
Fan

Re: Login problem after installing Teradata Studio (express) 16.20.09 on KPN10

Yesterday 28-01-2019 realized a working installation Teradata Studio Express. The installation is carried out as follows and in the following order:
1. Installing JAVA 8 update 201 (jre-8u181-windows-i586.exe)
2. Installing Teradata Studio Express Version 16.20.08.00 (TeradataStudioExpress__win32_x86.16.20.08.00.zip)

 

Both programs can be downloaded from:
1. https: //www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html
2. http: //downloads.teradata.com/download/tools/teradata-studio-express

 

Although I use Windows 10 64bit, I have installed the 32bit version for both JAVA and Teradata.
 
Login problems when using Java (JRE) 10
The installation manual on the Teradata download site prescribes the use of Oracle's Java Runtime Environment (JRE) 10 for the latest version of Studio Express. However, in my situation, I get a problem with logging in. Studio Express cannot connect to the database and generates the error message: "java.net.SocketException: Permission denied: connect". This problem does not occur when using Java 8 with the latest version of Studio Express 32 bit version)

 

Remark 
Other installation of Teradata concerning ODBC and JDBC have not been necessary. You can use the Windows ODBC driver to test whether you can loggin into the Teradata database with your log-in-credentials. To do this, you must create the data source for Teradata using the ODBC-data-sources-management application after installing this driver.

1 ACCEPTED SOLUTION
4 REPLIES 4
Highlighted
Teradata Employee

Re: Login problem after installing Teradata Studio (express) 16.20.09 on KPN10

Hi,

 

Teradata Studio uses JDBC not ODBC and so ODBC-driver will not be visible.

When LDAP is  selected as "Authentication Mechanism " we need to provide LDAP credentials instead DB username & Password.

Please try connect again by giving LDAP credentials ( OR)

change Auth mehcnism to "Password_Protected" with the same credentials you have entered before and verify.

 

 

 

Fan

Re: Login problem after installing Teradata Studio (express) 16.20.09 on KPN10

Dear Srilatha,

I follow the instructions of our database administrator by using the LDAP as "Authentication Mechanism" and the crendentials that I use are the LDAP-version. Is it possible that their is an other explanation for this problem?

When I change the "Authentication Mechanism" to PASSWORD_PROTECTED I get the same result in the logfile.

Many thanks for your reply,

Ton Kuipers

Teradata Employee

Re: Login problem after installing Teradata Studio (express) 16.20.09 on KPN10

It's certainly possible to use LDAP authentication with only simple username and password as credentials.

As far as differences between ODBC and JDBC, you could try removing the ENCRYPTDATA=ON property (or setting it to OFF).

 

But the traceback seems to indicate a problem with Java run-time opening the socket connection, which is often a firewall or network settings issue. I haven't used this particular version, but with some earlier Java releases, explicitly requesting IPv4 sometimes helped in situations like this. Edit the TeradataStudio.ini file (in the Program Files folder where Studio is installed) and add a line at the end with this option: -Djava.net.preferIPv4Stack=true

Fan

Re: Login problem after installing Teradata Studio (express) 16.20.09 on KPN10

Yesterday 28-01-2019 realized a working installation Teradata Studio Express. The installation is carried out as follows and in the following order:
1. Installing JAVA 8 update 201 (jre-8u181-windows-i586.exe)
2. Installing Teradata Studio Express Version 16.20.08.00 (TeradataStudioExpress__win32_x86.16.20.08.00.zip)

 

Both programs can be downloaded from:
1. https: //www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html
2. http: //downloads.teradata.com/download/tools/teradata-studio-express

 

Although I use Windows 10 64bit, I have installed the 32bit version for both JAVA and Teradata.
 
Login problems when using Java (JRE) 10
The installation manual on the Teradata download site prescribes the use of Oracle's Java Runtime Environment (JRE) 10 for the latest version of Studio Express. However, in my situation, I get a problem with logging in. Studio Express cannot connect to the database and generates the error message: "java.net.SocketException: Permission denied: connect". This problem does not occur when using Java 8 with the latest version of Studio Express 32 bit version)

 

Remark 
Other installation of Teradata concerning ODBC and JDBC have not been necessary. You can use the Windows ODBC driver to test whether you can loggin into the Teradata database with your log-in-credentials. To do this, you must create the data source for Teradata using the ODBC-data-sources-management application after installing this driver.