All Forums

Covers all topics related to Teradata database connectivity, including the use of client technologies such JDBC, ODBC, .NET Provider etc. For articles, blogs and more, see the Connectivity section of this site.

You must login to post to the forums.
First attempt fails. 20 min. later connection results. Topic by hagedorn 04 Dec 2012 teradata, restart, connect informatica, catalog string

Hi,
I have a problem with Informatica connection to Teradata. Every night we kick off a job which gets an error connecting to Teradata. It gives the error message Unable to get catalog string. We restart the job and it connects after 20 min. and runs successfully. Any ideas regarding what the issue could be? Could it be a Data Source Resolution error?
Regards,
Richard

3134 views
5 replies, 2 years ago
Teradata XML services - help needed Topic by rs131112 07 Aug 2008

I have installed Teradata XML services into our test environment. During the installation I needed to modify the scripts to increase the spoolspace max for the SYSXML logon to 2GB to get the libraries to load properly - that was a bit painful. Now, I am trying to work through the first example in the document - generate a canonical schema from an existing table/view. Here's the command that I am using:call sysxml.gen_query_canonical_schema('select * from ttmp.rs_xml_test','logon','pass', outv);I am running this through TSA. It just sits there and runs with the hourglass - over 20+, 30+ minutes before I kill it. Seems like something is not right. Any comments or advise on this problem?

21476 views
8 replies, 2 years ago
Remote Access Issue Topic by TDW 14 Dec 2012

Hi All,
I am not sure of the exact perameters, so please bear with  me.

2092 views
0 replies
Excel Connector for Teradata Topic by Bajju 08 Feb 2012

Hi,

Is there any Excel connector availble to execute the query from Excel for teradata?

It should support to user to runs the query from excel & the result should populate in the same excel / other excel workbook from predefined column & row

 

Thanks in advance

Bajju

14679 views
9 replies, 2 years ago
how to configure fastload connection to informatica Topic by sanjeeviravi 12 Dec 2012

 
Hi Friends,
 
Can someone share me how to configure loader connection to informatica
we are using Informatica 9.1 hf4 on unix IBM AIX 64bit server
 
Regards,
Sanjeevi 

2427 views
0 replies
Event number 33-13810-00 (severity 10, category 12) Vconfig GDO is missing or corrupt. Topic by manish27 04 Dec 2012

HI forum,
I am new to teradata, installed demo version 12 in my pc having windows xp sp2. After installing, the "start teradata" button is showing disabled in the teradata service control. Also I have loggin issues though the host entry in etc is :
127.0.0.1       localhost localtdcop1
127.0.0.1       localhost tdadmincop1
127.0.0.1       localhost tdusercop1

2433 views
0 replies
Connection Pool issue(Connection reset by peer: socket write error) with server in DMZ Topic by PheobeChang 30 Nov 2012

I am using connection pool with Tomcat 7.  The web server sits in the DMZ, while Teradata is in the internal network.  Port 1025 opened in the web server.  When the application first starts up, everything works fine.  But it seems after a short time, the pooled connection fails, with the following error:

3138 views
1 reply, 2 years ago
64 Bit OLE DB Provider for Windows Server 2008 or alternative to MSDASQL? Topic by cliffk 13 Nov 2012

We have software that does not have an ODBC option for connection to database, only OLE DB.
The software is on 64 Bit Windows Server 2008.
MSDASQL - microsofts OLE DB to ODBC Provider will not work as it is not compatible with .NET.
MSDATASHAPE does not appear to work as an alternative to MSDASQL.
1) When will the Teradata 64 Bit OLE DB Provider be released?

1454 views
0 replies
Using Named Parameters from SQL Server Reporting Services Topic by mr_tim 22 Apr 2011 odbc, .net data provider, parameter, named parameters, ?, @, reporting services, bids, report builder

Named Parameters are a great feature when using Teradata SQL Assistant. All one has to do is put "?my_parm" in the SQL. This can be very helpful in testing a query and can be a great time saver.

Microsoft's report development tools also provide the same feature... using "@my_parm" syntax within the query of a report. This works great with other databases. However, it does't work when using the Teradata .NET Data Provider nor ODBC to Teradata. One has to use an unamed parameter markert, simply "?", in their SQL.

8454 views
2 replies, 2 years ago
JDBC DatabaseMetadata.getColumns Seems Slow Topic by vlewis 22 Mar 2012 jdbc, performance, slow, databasemetadata, getcolumns

When I call

ResultSet rs = dbmd.getColumns(null, "CUSTDATA", "TRANS", null);

it takes 16 seconds to get an answer back on a fairly unloaded system.  This table has 27 columns.

 

This seems to be excesvily slow.  Is there anything that can be done to speed this up?

 

8290 views
10 replies, 2 years ago
Could not initialize class javax.crypto.SunJCE_b Topic by sreevaddi 06 Nov 2012 jdbc, r, teradatar

 

Hi,

 

I am trying to connect to TeraData from R.

 

RStudio v0.96 (R v2.15.1)

JDBC v14.00.00.21

JDK v1.7.0_07

Mac v10.7.4

 

...

library(DBI)

library(RJDBC)

library(rJava)

6715 views
5 replies, 2 years ago
JDBC works fine but RJDBC fails Topic by sreevaddi 07 Nov 2012 rjdbc jdbc single sign-on teradriver connectivity

Hi,
I have successfully connected to teradata from standalone java application using jdbc.
But fails to establish connection using RJDBC.

RStudio v0.96 (R v2.15.1)

JDBC v14.00.00.21

JDK v1.7.0_09

2984 views
2 replies, 2 years ago
Problem Authenticating through JDBC running on Linux. Topic by gbrenneman 24 Sep 2012

Hi all,
I am trying to connect to Teradata Database 14 using the Teradata JDBC 14 driver.  The Java code is running on a Linux server using Ubuntu 12 and JVM 6 (64-bit).  I keep getting the following error....
com.teradata.jdbc.jdbc_4_util.JDBCException: [Teredata Database] [TeraJDBC 14.00.00.14] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.

5551 views
4 replies, 2 years ago
DAO Error When Exporting To MS Access Topic by myokitis 11 Oct 2012

Whenever I try to export my dataset from SQLA 13.10.0.04 into an MS Access 2007 table I get the following error:
SQLA Version: 13.10.0.4
System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Access.Dao.Recordset'.

Any ideas how this can be rectified?
Thanks.

2412 views
2 replies, 2 years ago
How to Call Teradata Stored Procedure Topic by mahesh21.r 01 Mar 2010 error in stored procedure call

Hi,
When i try to call the stored procedure "ACEREWARDS_CUSTOMERPREF(?)", it throws error "something missing between "(" and "?" ", i dont know what it exactly looking for. If i removed the "(?)", it throws "stored procedure does not exists.
I am using Terdata.Client.Provider 13.0 in C#.NET3.5.
Any suggestions.

16801 views
5 replies, 2 years ago
OBIEE sourcing from Teradata nQSError: 43113] Message returned from OBIS Topic by L809rd 26 Oct 2012

Experts,
We are sourcing from Teradata 13 on our OBIEE 11g running on Windows server 2008 64Bit but we are getting errors in the dashboards as follows:

4719 views
2 replies, 2 years ago
Install Teradata SQL Assistant Topic by ddesore 10 Oct 2008

I am trying to install SQL Assistant7.1 but am getting the error - "Teradata SQL Assistant not supported on 64 bit Windows".Can anyone please provide information/link to resolve this issue ? Or if some kind of a patch exists ?Thanks,

31829 views
12 replies, 2 years ago
Java exception | locked <0x00000007c53633f0> (a com.teradata.jdbc.jdk6.JDK6_SQL_PreparedStatement) Topic by pallila 15 Oct 2012

We are getting this error when we are the doing inserts/updates from multiple threads. Has anyone seen this error before and what could be the problem. Below is the stack trace. Any pointers appreciated.
 
 
java.lang.Thread.State: RUNNABLE
        at java.net.SocketInputStream.socketRead0(Native Method)

2311 views
1 reply, 2 years ago
org.hibernate.exception.GenericJDBCException: could not execute query Topic by XenBeven 11 Oct 2012

I am getting a weird exception which I have no clue how to fix it. My scenario is:
When I execute following parameterized query using java hibernate(via jdbc driver) everything works great:
StringBuffer hqlStringBuffer = new StringBuffer("from student where name like :Name and class=:Class and section:Section");
 

5801 views
3 replies, 2 years ago
"Invalid date supplied for" error Topic by stani75 04 Oct 2012 odbc, date format, ms query

My database is a Teradata version 13.00.01.19
I retrieve data with a MS Excel v2003 file (using MS Query)
Before to do that, I installed "the tdodbc__windows_i386.13.10.00.05" products on my desktop : Teradata Client 13.10, Teradata 13.10.00.05 ODBC driver. I created a System DSN etc.

11643 views
8 replies, 2 years ago
ExecuteUpdate -- -row count return type is int Topic by emilwu 14 Feb 2011 jdbc, executeupdate, 32-bit range, row count

I noticed that the statement.executeUpdate() method returns int data type , which conforms to JDBC standard. However, here is the question: it is Teradata!!! the affected row count can easily blow away the integer range. How to deal with such issue?

8986 views
6 replies, 2 years ago
Error - Only an ET or null statement is legal after a DDL Statement. Topic by bedum 01 Oct 2012 ddl statement

I runtime combined 4 create table commands into a string. However, when i run this string as below in C#, 
 

5446 views
3 replies, 2 years ago
Perl DBI and show procedure Topic by dmtoropov.sbt 03 Oct 2012

Hi Guys. I am trying to execute 'show procedure ' using Perl DBI, but always getting wrong result. The same code with 'show view' works correctly. Does anybody help me?
 

1934 views
0 replies
ODBC--call failed error Topic by Min 08 Oct 2007

Hi,I have created views in a teradata database and i am trying to link these in access using the link function. However a pop-up box with the following error message appears when trying to link the tables:"ODBC-call failed[NCR][ODBC Teradata Driver][Teradata Database]The user does not have any access to database DB1.

23462 views
3 replies, 2 years ago
10065 WSE E HostUnreach from XP to remote Teradata DB Topic by Harry Droogendyk 28 Sep 2012 odbc, 10065

There's lots of posts relating to the 10065 error, but I don't see any solutions that apply to this case.
Teradata is up and running and usable for 100s of others in my organization - not a problem on the TD side.

2421 views
0 replies

Pages