Teradata Forums / Drivers and UDFs / Teradata

SQLException error codes

channegan — Mon, 05 May 2008 10:27:42 GMT

What SQLException error codes should I expect when exceeding query timeouts?Here's what I'm seeing when using JDBC...For MACRO calls, I’m using the java.sql.PreparedStatement. For STORED PROCEDURE calls, I’m using the java.sql.CallableStatement.For both MACRO and STORED PROCEDURE calls, I’m setting the timeout via the setQueryTimeout(int) method.When a MACRO exceeds the timeout threshold, I receive the following SQLException information…[NCR] [Teradata JDBC Driver] : HY000 802 : Timeout Packet stream read error: local="my server"/"my ip":"my port" remote="my server"/"my ip":"my port" cid=40e569 sess=1053567 Wed Apr 30 14:54:04 EDT 2008 java.net.SocketTimeoutExceptionThe vendorCode/errorCode is 802.When a STORED PROCEDURE exceeds the timeout threshold, I receive two different messages in the SQLException…[NCR] [Teradata JDBC Driver] : executeQuery error: The statement has been canceled by another thread at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:126) at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:101) at com.ncr.teradata.jdbc_4.util.ErrorAnalyzer.analyzeError(ErrorAnalyzer.java:35) at com.ncr.teradata.jdbc_4.Statement.executeStatement(Statement.java:298) at com.ncr.teradata.jdbc_4.PreparedStatement.execute(PreparedStatement.java:60) at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalCallableStatement.execute(TeraLocalCallableStatement.java:160)The vendorCode/errorCode is 751I've also seen the same information as the MACRO timeout:[NCR] [Teradata JDBC Driver] : HY000 802 : Timeout Packet stream read error: local="my server"/"my ip":"my port" remote="my server"/"my ip":"my port" cid=1ee926 sess=1411733 Tue Apr 29 21:30:13 EDT 2008 java.net.SocketTimeoutException: However, I cannot recreate the last exception when debugging.Does anyone know why I'm seeing mixed results between MACRO vs STORED PROCEDURE timeouts?Does anyone know why I'm seeing mixed results between STORED PROCEDURE timeouts?What other vendorCodes/errorCodes can I expect when a query via JDBC is canceled due to a timeout?I need to be able to separate the differences between a sql timeout versus a "real" database problem. Since JDBC driver only throws SQLExceptions, I know of no other way than by inspecting SQLException attributes. I'm doing this by the following code snippet: private void processSQLExceptionForTimeOut(SQLException e) throws SQLException { if(e.getErrorCode() == 802 || e.getErrorCode() == 751 || e.getMessage().contains("Timeout Packet stream read error") || e.getMessage().contains("executeQuery error: The statement has been canceled by another thread")) { //process timeout } else { //a "real" database problem may exist? } throw e; }Let me know if you need more information in terms of Driver Version and/or MACRO/PROCEDURE definitions, or information on the Teradata software/hardware version.Thanks in advance,Chris

ODBC connection

T Anderson — Fri, 25 Apr 2008 15:05:39 GMT

Has anyone come across a Queryman SQL Assistant error when trying to connect to Oracle via ODBC? I am able to connect to Oracle through MicroSoft Access. Queryman SQL Assistant is timing out when connecting to Oracle (driver version 8.01.07.00).

VS 2008 Integration

atwoodjw — Mon, 14 Apr 2008 14:59:18 GMT

Hi,Is Visual Studio 2008 Integration coming for the .NET Data Provider for Teradata? I just upgraded and am no longer able to use the integration features -- i.e. Sever Explorer, Data Connections, etc.Thanks,J

jdbc - Invalid date supplied

Radek — Tue, 15 Apr 2008 05:07:59 GMT

Hi,I have some problem inserting date into db field which is type of Date.From java code side i can see prepareStatement debug information and there is Date object which is formated as yyyy-mm-dd hh:mm:ss - Ibatis framework prepare this itself and i have no influence on this. The community of this framework informed me, that it is jdbc driver task to automatically translated into correct type, and it should not bother me. But whatever i do, there is always a message : .JDBCException: [NCR] [Teradata DBMS] : Invalid date supplied for TABLE_NAME.DATE_FIELD_NAME.Where is the problem?Thanks for answer

ODBC Driver Install

swapnadeep.ganguly — Fri, 11 Apr 2008 05:55:37 GMT

Hi all,I was trying to install ODBC driver that was provided with the Teradata 8.1 Demo cd. I was unable to install the same to the windows. Can any one please guide me out regarding the steps that I should follow to install the same. This would be of great help.

Equivalent to Oracle's New_Time()

bbhusan — Fri, 21 Mar 2008 02:03:03 GMT

Hi Friends,Can we get your kind co-operation sharing knowledge on Equivalent to Oracle's New_Time() function which we require to implement in our migration project in TD.Oracle Function: New_Time('Timestamp',In_Zone,Out_Zone);I appreciate your effort and time finding such valuable solutions & looking forward to get an early response in this regard soon.Thanks... in advance,bbhusan... a TD lover

Problem downloading OLE DB drivers from Teradata website

orion — Thu, 10 Apr 2008 02:57:16 GMT

Hi,The downloads (OLE DB Drivers) does not seem to work. I have tried from 3 different computers (with different internet connections) to download using both IE and Firefox. The download seems to start but stops immediately with no file or a very small file (below 65K) being downloaded.Here is the webpage that I have tried: http://www.teradata.com/DownloadCenter/Download.aspx?ForumID=101&TopicID=9143For the driverTTU 8.2 Windows i386 tdoledb.01.05.00.02With the same result I have also tried to download the driver:TTU 7.1 OLE DB Provider for Teradata The Teradata website in general seems sluggish with slow response.I even tried to contact Teradata through the website where there is a form for feedback on the site itself. However, even that I could not get to work. I got an error message after completing and submitting the form, saying that the requested page was not available, and that the problem might be caused by a mandatory field not being filled out. I double checked and all required fields was filled. Strange ....Could someone check the download to see if it works for them.Best regardsFrank

Bad characters when querying on UNIX enviornment

shai — Sun, 27 Jan 2008 03:52:19 GMT

Hello,I'm trying to use OracleBI (OBI) with teradata under AIX 5.2 . I defined everything needed in OBI and also in AIX but when I enter the application and try to query, I get result but where I have Hebrew characters I see meaningless chars (ex: íù àìì).If I execute the same query the application does in windows TD client the characters are displayed as it should.So my question, how do I set the characterset to the ODBC under AIX UNIX system?

Does JDBC driver v3.3.0.0 silently ignore batch mode?

dkarr — Mon, 07 Apr 2008 17:39:04 GMT

While searching various sites yesterday, I thought I read that the TeraData JDBC driver (at some version) has a bug that causes it to ignore "batch mode", such that multiple statements submitted in the same transaction would be sent to the database separately, instead of in a batch (batching would make it more efficient). Can anyone confirm whether that is the case, and whether a newer version than what I have (3.3.0.0) has a fix for that problem?

JDBC not doing cop discovery - unknown host

rs131112 — Fri, 28 Mar 2008 13:59:06 GMT

I'm accessing 2 different Linux servers, same JDBC (3.02). I am not the server administrator. Using server1, I can successfully connect to the database using the "hostname", and JDBC does the "cop discovery" just like it is supposed to. On the server2, if I just use the hostname, I get an "unknown host" error message. If I specify a specific "cop" name, then I can get connected. Seems like it should be a simple configuration change to something on server2 to make JDBC work with the cop discovery, but I don't know what to do. Any advise?

ODBC IM002: Dataset name not Found and no default driver speicfied

swapnadeep.ganguly — Mon, 07 Apr 2008 08:01:39 GMT

Hi All,I tried to install Teradata from Teradata 8.1 Demo cd. After that when I tried to run the SQL Assisstant 7.1, I was not able to connect to any System DSN's. However Tdata32.dll file is available in WINDOWS/Win32 folder. This signifies that the ODBC driver is installed properly.Can any one please help me out by providing your important suggesstions in this regard.

JDBC v3.03.00.00 not passing props, including DSName

dkarr — Sat, 05 Apr 2008 15:09:58 GMT

I'm helping to diagnose some issues with using the Teradata JDBC driver v3.03.00.00 from WebLogic 9.2. I believe I discovered that this version of the driver ignores the Properties object passed into the getConnection() method. Can anyone confirm that?Assuming that's true, since our WebLogic ConnectionPool setting was attempting to set the DSName property, what would be the possible impacts if that property was not set? It seems redundant to me, as our connection string is using an IP address, and the value we were attempting to set for DSName was the same IP address.I now know that the workaround for it not using the Properties is simply to append each property setting at the end of the URL (comma-separate), I'm just trying to understand what the impact would have been if the property wasn't set.

JDBC and calling a macro

Rainer Kopp — Mon, 16 Jul 2007 13:01:36 GMT

Hello,

It's easy to call a teradata procedure with the teradata JDBC driver.

But is it possible to call a macro in JDBC too?

I found no documentation of this nice feature...

Greetings
Rainer Kopp

MTDP: EM_TIMEEXCEEDED(245): Timeout from DBCHWL.

Rahul Pawar — Mon, 24 Mar 2008 08:54:43 GMT

Hi Folks, I'm using a .NET Data provider version [01.02.00.00] for Teradata. I'm using connection pooling feature which is being provided by the data provider. Once i start using my web based application, as the number of users start using system concurrently at some point of time application throws the below given exception.As a developer i'm not able to come to a conclusion, what the problem would be ?Any help will be appreciated.Regards,Rahul Pawar.

How to convert a number into hexadecimal value in TD

US — Mon, 24 Mar 2008 10:17:49 GMT

Please help if anybody can.Thanks in advanceUmesh

Incorrect characters returned in UTF8 session

yulian — Mon, 17 Mar 2008 11:49:06 GMT

When using JDBC to retrieve characters from a char column in UTF8 charset session, we get a character string of double the size of the column length. Does anyone know why and how to workaound it?For example: 1. connect to the database in UTF8 sessionjdbc:teradata://td/CHARSET=UTF82. create table and insert dataCREATE TABLE employee (empName CHAR(10));INSERT INTO empolyee values('a');3. SELECT empName from employeeThe length of empName is 20. (Wrong!)4. connect to the database in default charset sessionjdbc:teradata://td5. SELECT empName from employeeThe length of empName is 10. (Correct!)I'm using JDBC Driver 12.0.0.1 and the database is V2R6.

username and password

arun_gr108 — Sat, 15 Mar 2008 10:53:00 GMT

i have just installed teradata... sql query analysis 6.1 its asking for odbc connectivity....when i try to create it its asking for user name, password,ip address and default database.can any one suggest me the study username and password where i can find table to work.eg :(in oracle)Scott/tiger

.net provider setup in SSIS

zetetikos — Thu, 13 Mar 2008 17:04:39 GMT

I'm trying to get the .net provider for teradata working. Following sumerized the situation:1) If I put the ip address in the connection manager then I it test OK within the connection manager but gets "Failed to acquire connection... Connection may not be configured correctly" when I execute the SQL task.2) If I put the name for the server in I get the "MTDP:EM_NOHOST(224) error from teradata. The host name is 5 characters and is in the hosts file and is pingable via the name.3) When I try to connect with nquery I get the CLI error 510 when I try to connect. Can't find what this means anywhere.4) Other ado.net providers are workingI've been searching and searching and have found lots of info by nothing that solves my problem Thanks.

How to write UDF to handle operating System I/O operations

upendra.mishra — Fri, 18 Jan 2008 04:59:14 GMT

[b]Hi Can anyone please guide me writing fopen(),put_line() and fclose() UDFs in Teradata.These functions are in ORACLE UTL_FILE package.As database is migrating from oracle to teradata,I need to replace those functionality with teradata functions.OR Is there any similar UDF available with anyone who can share the code .Any type help what you can give in this respect is welcome.[/b]Thanks In Advance

UDF for calling Email sending program

devopam — Mon, 10 Mar 2008 11:29:47 GMT

Hello there,I am looking for a custom UDF which would have the following signature:Input:1. From Email addr. 2.To Email addr(s) 3. Subject line 4. Body TextOutput: Status codeThis is to use the UDF to send emails.Do we have something readily available for this ?Thanks in advance

Sample C program to query and load Teradata

radshri — Wed, 05 Mar 2008 14:31:45 GMT

I have heard of 2 ways to query and load data into Teradata -'Teradata Preprocessor2 for Embedded SQL' Using ODBC driverI have a requirement to provide a way for C and Fortran applications to query and to load data into Teradata. This should work on Windows, Unix and Linux.Does any one have sample programs that show both these approaches?Does any one know the pros and cons of both these approaches?Thank You.

Java class libraries for MDS

oravecz — Mon, 03 Mar 2008 09:58:42 GMT

The Teradata Meta Data Services Programmer Guide references a Java class library called MetaJava.jar located at %METAHOME%/jdk. I have the Teradata Tools and Utilities Release 8.1 Meta Data Services Version 6.1.0 CD, but no such libraries are included.Where may I find this library?

Teradata ODBC driver with Apache/PHP

bobomagic — Fri, 10 Aug 2007 13:11:21 GMT

Has anyone successfully setup and run an Apache/PHP environment with the Teradata ODBC driver?

I can get everything running, but odbc_connect() PHP calls result in segfaults in Apache. It's strange, because running php from the command line with the same php script works fine. Looking at the trace files, it looks like the authentication step is happening, and then poof.

Any ideas of things to try?

CONVERT MERGE STATMENT INTO UPSERT STATMENT

raj1983 — Wed, 13 Feb 2008 00:42:42 GMT

Hi,CAn any body help me out to convert the below MERGE statement into UPSERT Statment(in teradata)...MERGE INTO cop_best_email plUSING(SELECTb.prs_cd_id, b.apple_id, b.effective_update_date,b.date_create, b.date_update, b.email_address,a.prs_idFROM sl_acd_best_email b , acd_person aWHERE b.prs_cd_id = a.prs_cd_id(+)AND b.upd_ts >= ld_last_insertAND b.upd_ts <= ld_max_dt) slON (pl.prs_cd_id = sl.prs_cd_id)WHEN MATCHED THENUPDATE SETpl.prs_id = sl.prs_id,pl.apple_id = sl.apple_id,pl.prs_eff_upd_ts = sl.effective_update_date,pl.prs_email_addr = sl.email_address,pl.acd_cre_ts = sl.date_create,pl.acd_upd_ts = sl.date_update,pl.upd_ts = ld_max_dtWHEN NOT MATCHED THENINSERT ( pl.prs_cd_id, pl.prs_id, pl.apple_id,pl.acd_cre_ts, pl.acd_upd_ts, pl.prs_eff_upd_ts,pl.prs_email_addr, pl.cre_ts, pl.upd_ts )VALUES ( sl.prs_cd_id, sl.prs_id, sl.apple_id,sl.date_create, sl.date_update, sl.effective_update_date,sl.email_address, ld_max_dt, ld_max_dt );THANKS IN ADVANCE

Windows 2003 SP1 and Demo CD to have UDF working

mica.hallin — Mon, 25 Feb 2008 07:38:35 GMT

Hi,I need to compile one UDF function, So I try to install visual c++ 2005 but that need SP1 of windows server 2003. When I have install the SP1 teradata DBS doesn't start anymore "memory read error in application.." Must I do anything to get teradata working with SP1 or is there any free compiler that I can install to have UDF working without needed to have install SP1 ?Thanks you,Mica Hallin

JDBC Primary Index

newerakb — Tue, 19 Feb 2008 10:44:13 GMT

I'm attempting to write a Java application which creates test data in a table specified by the user. But my app needs to know which columns need to be unique, and which make up the index and/or primary index of the table. Since the Teradata JDBC driver does not support getIndexInfo, is there another way I can obtain this information?

Equivalent of %TYPE and %ROWTYPE in teradata

raj1983 — Wed, 13 Feb 2008 02:19:28 GMT

Hello All,In oracle Both %TYPE and %ROWTYPE are used to define variables inPL/SQL as it is defined within the database. If the datatype orprecision of a column changes, the program automically picks upthe new definition from the database without having to make anycode changes.whts equivalent of this in Teradata.

CONVERT THE MERGE STATEMENT INTO UPSERT STATEMENT

raj1983 — Tue, 12 Feb 2008 01:36:03 GMT

MERGE INTO cop_best_email pl USING (SELECT b.prs_cd_id, b.apple_id, b.effective_update_date, b.date_create, b.date_update, b.email_address, a.prs_id FROM sl_acd_best_email b , acd_person a WHERE b.prs_cd_id = a.prs_cd_id(+) AND b.upd_ts >= ld_last_insert AND b.upd_ts <= ld_max_dt) sl ON (pl.prs_cd_id = sl.prs_cd_id) WHEN MATCHED THEN UPDATE SET pl.prs_id = sl.prs_id, pl.apple_id = sl.apple_id, pl.prs_eff_upd_ts = sl.effective_update_date, pl.prs_email_addr = sl.email_address, pl.acd_cre_ts = sl.date_create, pl.acd_upd_ts = sl.date_update, pl.upd_ts = ld_max_dt WHEN NOT MATCHED THEN INSERT ( pl.prs_cd_id, pl.prs_id, pl.apple_id, pl.acd_cre_ts, pl.acd_upd_ts, pl.prs_eff_upd_ts, pl.prs_email_addr, pl.cre_ts, pl.upd_ts ) VALUES ( sl.prs_cd_id, sl.prs_id, sl.apple_id, sl.date_create, sl.date_update, sl.effective_update_date, sl.email_address, ld_max_dt, ld_max_dt );

JDBC driver (java.sql.Driver impl., version 03.03.00.04) does not handle correct the connect's "Properties" instance

logofatu — Wed, 27 Jun 2007 05:59:24 GMT

The driver's implementation of the method "Connection connect(String url, java.util.Properties info)"
does not read correctly the properties stored in the "info" input parameter.

The driver ignores the "user" and the "password" properties (and probably the other properties too)
if these properties are "default"/parent properties.

The following code fails to initialize the JDBC connection :

Class.forName("com.ncr.teradata.TeraDriver");
Properties parentProps = new Properties();
parentProps.setProperty("user","myUser");
parentProps.setProperty("password","myPassword");
Properties props = new Properties(parentProps);
//the connection establishment fails because the driver fails to find the user and the password:
Connection con = DriverManager.getConnection(dbUrl,props);

If parentProps are directly used, the connection creation succeeds !!!

This means that Teradata is not able to handle correctly the java.util.Properties objects !
Somewhere inside the driver, Hashtable methods are directly used (like get() or containsKey() ) and
parent/default properties are ignored !!
For getting a property or checking if it exists you should use only "getProperty()" !
Fragment from the java.util.Properties#getProperty(String key) javadoc:
* If the key is not found in this property list, the default property list,
* and its defaults, recursively, are then checked. The method returns
* null if the property is not found.

[NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory for a Concrete Step for this request

avishay — Thu, 09 Aug 2007 03:42:24 GMT

teradata db version 5.0
informatica is the etl tool that we use.
some of the connection to the terdata is with odbc - 2.8.2.5
informatica server is windows 2000

we want to upgrade the ttu version so we installed on the dev environment of informatica ttu 8.2
when we try to run insert with the new odbc driver we got the
following error:

FnName: Execute -- [NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory for a Concrete Step for this request.
FnName: Execute -- [Microsoft][ODBC Driver Manager] Function sequence error
ERROR 07/08/2007 10:53:32 node01_Test WRITER_1_*_1 WRT_8229 Database errors occurred:
FnName: Execute -- [NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory for a Concrete Step for this request.
FnName: Execute -- [Microsoft][ODBC Driver Manager] Function sequence error

the dev server is windows 2003
the same action is succeed with the old odbc driver.

Query regarding ODBC driver

lokhande.dinesh29 — Wed, 24 Oct 2007 07:16:51 GMT

Hi All, Just i want to know the ODBC driver version higher than 03.03.00.11 will work with teradata V2R4.x.xRegards,Dinesh

.NET Data Provider for Teradata error [Call-Level Interface, Version 2] [303]

SeanF — Tue, 22 May 2007 06:57:14 GMT

Hi,
We are trying to use NET Data Provider for Teradata 01.01.00.00 to connect to our data source.

We are running a test with Nquery (a .Net tool provided by NCR to test connectivity to the Teradata Database using Teradata.Client.Provider.dll)

The connection sting we are using is:
User Id=xxxxx;Password=xxxxx;Data Source=xx.xx.xx.xx;Database=databasename;

The error we get is:
Teradata.Client.Provider.TdException was unhandled
Message="[Call-Level Interface, Version 2] [303] "
Source="Call-Level Interface, Version 2"
ErrorCode=-2147467259
TxRolledBack=false

Any help is much appreciated.

Teradata ODBC adhoc sample program producing 'Bus Error'

rofeely — Tue, 28 Nov 2006 14:37:09 GMT

I've recently installed the TTU8.1 SOLARIS-sparc64 tdodbc.03.05.00.05 ODBC driver on two different 64-bit Solaris boxes (Solaris 8 & Solaris 10). On both boxes I'm getting a Bus Error and core dump when I issue a SQL command. The stack trace indicates that the crash happened in the driver when parsing the statement. I am connecting to a Teradata Database V2R5.0 (No problems were experienced connecting to the same database on Windows XP).

Has anyone experienced the same issue or know what the cause of it may be??

Is there any new teradata demo CD version available for VISTA?

Balamurugan B — Thu, 27 Dec 2007 06:27:36 GMT

Hi,Is there any new teradata demo CD version available for VISTA?Regards,Balamurugan

Can a UDF call an External Stored Procedure

sc250047 — Thu, 13 Dec 2007 05:09:57 GMT

Hi all,Is it possible to do the following:1. Call a UDF from another UDF.2. Call a Stored Procedure from a UDF.RegardsSalman Cheema

zScoring UDF

bhubin — Wed, 05 Dec 2007 12:00:34 GMT

This is an interesting question that a couple of us have. There is a calculation called zScoring that the retail business we support uses a lot. We are interested in creating a UDF that would allow this calculation to be done straight from SQL, however we are not even sure if it is possible. Here is a link that explains the formula:http://www.fourmilab.ch/rpkp/experiments/analysis/zCalc.htmlIt would have to return a result for each row however it needs to also run calculations on the whole database of values. I haven't really found anything like this so I'm not sure it's even possible. If anyone has any inspiration, direction, or advise it would be greatly appreciated.Thanks,Brent

Error with JDBC on SUN One Web: 08S01 804 : I/O Error, Socket closed.

gparraTD — Tue, 04 Dec 2007 15:25:52 GMT

I have following enviroment:OS: Solaris 9 on SUN (sparc)Web Server: SUN Web Server 6.1TD Driver: 12.00.00.00Classpath in server.xml (classpathsuffix)includes: /usr/local/TeraJDBC/terajdbc4.jar:/usr/local/TeraJDBC/tdgssjava.jar:/usr/local/TeraJDBC/tdgssconfig.jarAnd I am getting an exception when trying to establish a connection to Teradata using Teradata JDBC driver (type 4). This error does not occur if I run a stand alone Java DB class on command line; it only happens when running from SUN Web Server 6.1. See exception:[font=Courier New]com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata JDBC Driver] : 08S01 804 : I/O Error, Socket closed. Packet stream read error: local=/10.16.3.147:49670 remote=/10.18.48.112:1025 cid=e59895 sess=356389 Tue Dec 04 13:40:01 EST 2007 com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata JDBC Driver] : TeraEncrypt: Error tdgss-stack-trace-begin>>> java.lang.ArrayIndexOutOfBoundsException: 96 at com.ncr.teradata.jgssp2td2.Td2Context.unwrap(DashoA14*..) at com.ncr.teradata.jtdgss.TdgssContext.unwrap(DashoA14*..) at com.ncr.teradata.TeraEncrypt.decrypt(TeraEncrypt.java:474) at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.decryptIt(TDPacketStream1_3Impl.java:886) at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.readStream(TDPacketStream1_3Impl.java:817) at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.readStream(TDPacketStream1_3Impl.java:790) at com.ncr.teradata.jdbc_4.statemachine.ConnectRspState.action(ConnectRspState.java:67) at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:121) at com.ncr.teradata.jdbc_4.TDSession. (TeraLocalConnection.java:93) at com.ncr.teradata.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:50) at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.xc.portal.utils.TestTDConn.testTD(TestTDConn.java:32) at _jsps._etc._opt._SUNWps._desktop._cvs_en_US._cvsVendorMicrostrategyReports._html._channel_jsp._jspService(_channel_jsp.java:170) at com.sun.portal.providers.jsp.jasper3.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:908) at com.sun.portal.providers.jsp.JspServletWrapper.service(JspServletWrapper.java:182) at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:896) at com.sun.portal.providers.jsp.JSPProvider.includeJspPage(JSPProvider.java:954) at com.sun.portal.providers.jsp.JspRequestDispatcher.getJspResource(JspRequestDispatcher.java:167) at com.sun.portal.providers.jsp.JspRequestDispatcher.include(JspRequestDispatcher.java:97) at com.sun.portal.providers.jsp.jasper3.jasper.runtime.PageContextImpl.include(PageContextImpl.java:409) at _jsps._etc._opt._SUNWps._desktop._cvs_en_US._cvsVendorMicrostrategyReports._html._content_jsp._jspService(_content_jsp.java:190) at com.sun.portal.providers.jsp.jasper3.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:908) at com.sun.portal.providers.jsp.JspServletWrapper.service(JspServletWrapper.java:182) at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:896) at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:810) at com.sun.portal.providers.jsp.JSPProvider.getContent(JSPProvider.java:579) at com.cvs.corp.portal.CVSJSPProvider.getContent(CVSJSPProvider.java) at com.sun.portal.desktop.context.ReusableProviderCaller.run(ReusableProviderCaller.java:160) at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:140) at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:115) at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:190) at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.analyzeError(TDPacketStream1_3Impl.java:832) at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.readStream(TDPacketStream1_3Impl.java:822) at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.readStream(TDPacketStream1_3Impl.java:790) at com.ncr.teradata.jdbc_4.statemachine.ConnectRspState.action(ConnectRspState.java:67) at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:121) at com.ncr.teradata.jdbc_4.TDSession. (TDSession.java:193) at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection. (TeraLocalConnection.java:93) at com.ncr.teradata.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:50) at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.xc.portal.utils.TestTDConn.testTD(TestTDConn.java:32) at _jsps._etc._opt._SUNWps._desktop._cvs_en_US._cvsVendorMicrostrategyReports._html._channel_jsp._jspService(_channel_jsp.java:170) at com.sun.portal.providers.jsp.jasper3.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:908) at com.sun.portal.providers.jsp.JspServletWrapper.service(JspServletWrapper.java:182) at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:896) at com.sun.portal.providers.jsp.JSPProvider.includeJspPage(JSPProvider.java:954) at com.sun.portal.providers.jsp.JspRequestDispatcher.getJspResource(JspRequestDispatcher.java:167) at com.sun.portal.providers.jsp.JspRequestDispatcher.include(JspRequestDispatcher.java:97) at com.sun.portal.providers.jsp.jasper3.jasper.runtime.PageContextImpl.include(PageContextImpl.java:409) at _jsps._etc._opt._SUNWps._desktop._cvs_en_US._cvsVendorMicrostrategyReports._html._content_jsp._jspService(_content_jsp.java:190) at com.sun.portal.providers.jsp.jasper3.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:908) at com.sun.portal.providers.jsp.JspServletWrapper.service(JspServletWrapper.java:182) at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:896) at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:810) at com.sun.portal.providers.jsp.JSPProvider.getContent(JSPProvider.java:579) at com.cvs.corp.portal.CVSJSPProvider.getContent(CVSJSPProvider.java) at com.sun.portal.desktop.context.ReusableProviderCaller.run(ReusableProviderCaller.java:160)[/font]Can anyone let me know what the problem is, please? Is it a known issue with SUN Web Server 6.1 and Teradata JDBC driver?Thanks.

Error In Connecting Teradata Pmon

Praneet Kulkarni — Thu, 22 Nov 2007 06:08:21 GMT

I am unable to connect the Teradata Performance Monitor.Error Is 8071:Teradata Error Form :Main Proc:Logonparameters supplied are as followsdatabasename :user name :Password:databasename I have given is Praneet which is alias name in Hostfile for the server I am connection to.My hostfile is updated as follows172.19.87.209 praneet praneetcop1I also have one DSN name as praneet

CLIv2 and .NET

Ron Luebke — Fri, 09 Nov 2007 15:58:56 GMT

Are there any samples or documentation on using CLIv2 with a .NET language? Things I have already tried, > Looking at the samples in the devkit. these are in c++ and vb5 and while I can see what they are doing, getting them to translate to a more recent version is a bit difficult. > I tried to use interop with wincli32.exe and wincli32.dll with no success. Am I trying to reference the wrong DLLs?I am using the .NET provider already in other projects, but would like to get better performance out of some of our file exports. I really don't like shelling out or fork/exec to the external fastexport or fastload programs.R

Develop UDF's in Java

beachball — Tue, 06 Nov 2007 23:52:49 GMT

Hi,Where can i get hold of technical documentation of how to develop UDF's in Java.ThanksTheo