Teradata Forums / Drivers and UDFs / Teradata

SSIS 2008 Vs Teradata Via .NET Driver

offshoot — Wed, 04 Nov 2009 12:12:47 GMT

Hi,I am trying to pull somedata from Teradata 12 by SSIS 2008 using .NET provider for Teradata 13...02 on 64Bit Windows Server.I can save and add connection managers (and also "Test Connection" was successful) but when i try to execute my package, it immediately fails by giving the error below:Here is the output window for SSIS Package:------------------------------------------------SSIS package "Import stores.dtsx" starting.Information: 0x4004300A at Stores, SSIS.Pipeline: Validation phase is beginning.Error: 0xC0047062 at Stores, ADO NET Source 1 [9891]: Teradata.Client.Provider.TdException: [.NET Data Provider for Teradata] [115009] Message truncation error, not all data was received. at Teradata.Client.Provider.WpTcpTransport.ReadLanHeader(Buffer buffer, Int32 timeout, Int32 readBytes) at Teradata.Client.Provider.WpTcpTransport.Receive(Buffer buffer, Int32 timeout) at Teradata.Client.Provider.WpSession.Receive(Buffer buffer, Int32 timeout) at Teradata.Client.Provider.WpMessageManager.Receive(Int32 timeout) at Teradata.Client.Provider.WpLogonManager.Action() at Teradata.Client.Provider.WpSession.ManagerAction(WpMessageManager manager, Stopwatch watch, Int32 connectionTimeout) at Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout, String password) at Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout) at Teradata.Client.Provider.Connection.Open(UtlConnectionString connectionString, UInt32 timeout) at Teradata.Client.Provider.ConnectionPool.CreateConnection(UInt32 timeout) at Teradata.Client.Provider.ConnectionPool.GetConnectionFromPool(Object owningObject) at Teradata.Client.Provider.ConnectionFactory.GetConnection(Object owningObject, UtlConnectionString connStr) at Teradata.Client.Provider.TdConnection.Open() at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction) at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)Error: 0xC0047017 at Stores, SSIS.Pipeline: component "ADO NET Source 1" (9891) failed validation and returned error code 0x80004005.Error: 0xC004700C at Stores, SSIS.Pipeline: One or more component failed validation.Error: 0xC0024107 at Stores: There were errors during task validation.SSIS package "Import stores.dtsx" finished: Failure.The program '[6492] Import stores.dtsx: DTS' has exited with code 0 (0x0).----------------------------------------------------------Anyone has experienced an error like before? I would appreciate any help coz i could'nt find any documentation in Teradata site for this error explaination.Best RegardsOnur

ODBC driver for Windows Itanium 64-bit OS

mmcgaha — Wed, 07 Oct 2009 09:00:15 GMT

I need to install a Teradata ODBC driver to run on a Windows Server 2003 Datacenter Edition OS. Our Teradata databases are currently v12. I see Windows IA64 ODBC drivers on the downloads page, but they are in TTU 8 packages. Have all Teradata 64-bit drivers now been packaged together (no longer singling out Itanium 64-bit)? Does the driver I need exist?

Teradata Teradata SQL Assistant client installation error in x64 windows system

santoshmagapu — Thu, 24 Sep 2009 11:28:06 GMT

Hi,I have installed Teradata SQL Assistant client in Microsoft Windows server 2003 R2 Enterprise x64 Edition.When I am trying to connect through SQL Assistant it is giving the below error:160: Specified driver could not be loaded due to system error 193 (Teradata).Please help me to resolve this.Thanks in Advance,Santosh

Query about SESSIONS parm for JDBC Driver

akshayku — Wed, 23 Sep 2009 11:13:51 GMT

Hi,I am exploring the various options to speed up the data loading to a Teradata database using JDBC Driver.from the description of SESSIONS parm, it looks like, it is applicable to only FastLoad and FastExport mode of operation.Is that interpretation correct? or does it happen that number of sessions can speed up the data loading over normal JDBC mode ?Thanks,Akshay

Query Timeout again....

mwoodall — Mon, 28 Sep 2009 16:47:36 GMT

Hello, I am creating a reporting application that requires me to connect to a Teradata DW. know on small queries it works great but when it comes to the larger ones is where i have the issues. I know the default is 30 Sec but nothing i do seems to fix the problem. I have tried the TDcommand.connection timeout but it doesn't seem to like me it say the connection does exist even though i just pull info from it on a small query here is a sample: Dim ds As System.Data.DataSet = New System.Data.DataSet Dim OConn As Teradata.Client.Provider.TdConnection = New TdConnection() Dim da As Teradata.Client.Provider.TdDataAdapter Dim sql1 As String = "select names from empolyees" OConn.ConnectionString = "Data Source=Teradatatest.net;User ID=123456;Password=teradata;" da = New Teradata.Client.Provider.TdDataAdapter(sql1, OConn) OConn.Open() Dim cmd As Teradata.Client.Provider.TdCommand = New Teradata.Client.Provider.TdCommand cmd.CommandTimeout = 0 <- errors here "Connection doesn't exist" da.Fill(ds) Me.GridView1.DataSource = ds Me.GridView1.DataBind()as you can see above i am running a query against the TDW and filling a DS which i attach to a Gridview so i can make sure its working. my questions are.1) what am i doing wrong above? 2) can i set the Teradata connection/query timeout another way? as i would rather create the dataset files in VS gui so i can attached to my control instead of coding everything.thanks,Matt

Error while loggin in Teradata Demo version

varun marolia — Sun, 15 Mar 2009 08:20:03 GMT

Hi ,I Installed teradata demo version 12. first time when I started SQL assistant it got connected with error History database not set.I uninstall and then agin installed teradata.But now I am not able to connect to database thriugh SQL assistant.It gives following error.ODBC HY000: Major Status=0x04bd Minor Status=0xe0000007-Success/Continue neededODBC HY000: Major Status=0x04bd Minor Status=0xe0000007-loadtdgss could not load the tdgss library.ODBC HY000: Cannot find terasso library.ODBC 28000: Not enough information to log onPleas ehelp me with this problem.ThanksVarun

Date formatting issues - maybe new ODBC

Michele — Mon, 14 Sep 2009 18:33:14 GMT

We migrated to a new production Windows ETL server and a new ODBC version 3.01.00.06. There was no change to the d/bTeradata: V2R.05.01.02.43.We now have a job that is returning current_date in a different format and we do not understand why.Until today we could compare a date from a table to the current_date but now the log is showing a new format from the SQL statementCAST(Current_Date as CHAR(10)) AS Actual_DtLOG: Extracted Current_Dt:2009-09-14 Actual Date: 09/09/14 - Extracted Current_Dt Does NOT EQUAL Actual_DtWe run the select in SQL Assistant and see the same format as the script outputselect current_date returns 09/14/2009select current_date (format 'yyyy-mm-dd') returns 09/14/2009select CAST(Current_Date as CHAR(10)) AS Actual_Dt returns 09/09/14 What can we do to get the format to come back as 2009-09-14.

Trusted Connection in .Net data provider Driver

MuruganMohan — Tue, 08 Sep 2009 02:17:59 GMT

Hi, I a trying to connect to Teradata using Teradata.Client.Provider driver. When I provide user name and password it connects without any problem, but I want to connect to the database using my OS account. I have my access to the Data base from OS account. I specify Integrated security = YES if I wish to connect to oracle using my OS account. I want to know if I can do same here. Thanks

ODBC characters tarnslation issue

tsnr — Thu, 03 Sep 2009 18:55:50 GMT

Hi ,I'm using ODBC driver 3.04.00.00 for connecting Teradata V12 database from Siebel 7.8.2 application. I could able to retrieve the data but I'm not able getting the Chinese characters instead of English Characters.The Siebel application is on Solaris SPARC machine.Below is the odbc.ini file configurationDriver=tdata.soDescription=NCR 3600 running Teradata V1R5.2DBCName=TDDEVLastUser=Username=Password=Database=DefaultDatabase=Is there anything missing in above file?Any help/thoughts will be appreciated.ThanksSiva.

Trying to set up ODBC connection

Sociodude — Wed, 28 Jun 2006 12:41:14 GMT

I've been trying to set up the ODBC connection for Teradata while using the program Advanced Query Tool. I've already downloaded the latest driver and installed it on the computer. When I go to add a new system data source and click on teradata, it gives me the following error message: "Unknown error occurred in terasso library."

Then it pulls up the window that allows me to enter information such as name, description, Teradata Server Info, Default database, Username, Password, and Account String. After entering this information, I get another error message: "Unable to write Accountstring into private profile."

Does anyone have any ideas?

Oracle Transparent Gateway

Ansu — Fri, 21 Aug 2009 02:48:28 GMT

Hi all , I want to know about . I have a Little Information that this Actually helps us to connect Oracle from TD. If my Info is true.. Please help me with the process of Connecting to oracle and laod data into one of the tables there.Please help me with this as iam in bad need of this Information.

ODBC character set tranlation problem

David57 — Tue, 07 Jul 2009 12:27:39 GMT

I have been successfully extracting non-ASCII characters from Teradata V2R6 on Windows using the ODBC 3.2.0.1 driver with the session character set UTF8. After upgrading to Teradata 12 and ODBC v12 all non-ASCII characters are getting corrupted even though the character set in the ODBC DSN is set to UTF8. Choosing UTF16 has the same problem. The problem occurs back to at least ODBC 3.4.0.1 and it makes no difference whether I connect to Teradata 12 or V2R6.The ODBC 12 user guide says that "Teradata UTF8 and UTF16 session character sets on Windows work with the Translation DLL selected by the Translation DLL= keyword". I assume that refers to an entry in the odbc.ini file, but it doesn't describe what the options are. There are also fields in the ODBC DSN for "Translation DLL Name" and "Translation Option", but the user guide doesn't say what DLL to use.Is the translation DLL included in the ODBC installation? If not, where do I find one to translate to UTF8?Thanks.David

JDBC cannot get the result of select

tomato — Tue, 14 Jul 2009 01:46:13 GMT

I used preparedStatement to select the data, but I was told cannot find the table object and in fact, the object is exist. Anybody have the same problem？

TD server connections

soujanya.kota — Mon, 06 Jul 2009 11:51:56 GMT

The TD server is in France.We are not able to connect to Teradata server using SQL Assistant from India . People who are in France are able to connect it. None of them from India are able to connect to it . But from India , we are able to connect to the TD database in Unix - ie, with a Bteq . Could you please let us know as to what could be the problem with SQL Assistant .

not able to connect server

Praneet Kulkarni — Sat, 20 Jun 2009 00:33:54 GMT

i have installed teradata software.Terada server is running correctly but not able to connect to the server from any of the client tools bteq/sqlassistant.Terdata V2R5 Version 5.0Sqlassistant 6.1.0Operating system windows 2003

Not able to connect to Teradata on Windows from Linux box

jj40191 — Fri, 03 Jul 2009 07:47:26 GMT

Hi Experts Background: Datastage in RHEL 64 bit, Teradata Demo 12.0 in Windows xp and we have Installed Odbc Driver for Teradata( tdodbc_Linux_X8664.12.00.00.01.rpm ) also Configured ODBCiniAim : To connect teradata in Windows Xp through datastage in linux .Issue: when we are trying to connect teradata SQL from datastage in Linux machine using teradata stage it is not connecting. Also we tried to connect teradata SQL from linux using isql command . But we are getting the error message .[ISQL]ERROR: Could not SQLConnectPlease guide me to how to proceed .. Thanks & RegardsJoe

PreparedIndicProtocol incompatible with PreparedIndicMultiPartProtocol

akshayku — Mon, 22 Jun 2009 07:45:15 GMT

Hi,I am getting this exception when trying to execute a batch with Teradata JDBC PreparedStatement. Is there anything that I can change the way I create PreparedStatement or something?Thanks,com.ncr.teradata.jdbc_4.statemachine.PreparedIndicProtocol incompatible with com.ncr.teradata.jdbc_4.statemachine.PreparedIndicMultiPartProtocol java.lang.ClassCastException com.ncr.teradata.jdbc_4.statemachine.PreparedIndicProtocol incompatible with com.ncr.teradata.jdbc_4.statemachine.PreparedIndicMultiPartProtocol| at com.ncr.teradata.jdbc_4.statemachine.PreparedBatchStatementSendState.initSubclassParcels(PreparedBatchStatementSendState.java:94)| at com.ncr.teradata.jdbc_4.statemachine.StatementSendState.action(StatementSendState.java:78)| at com.ncr.teradata.jdbc_4.statemachine.PreparedBatchStatementSendState.action(PreparedBatchStatementSendState.java:53)| at com.ncr.teradata.jdbc_4.statemachine.StatementController.runBody(StatementController.java:100)| at com.ncr.teradata.jdbc_4.statemachine.PreparedBatchStatementController.run(PreparedBatchStatementController.java:58)| at com.ncr.teradata.jdbc_4.Statement.executeStatement(Statement.java:286)| at com.ncr.teradata.jdbc_4.PreparedStatement.executeBatch(PreparedStatement.java:114)| at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalPreparedStatement.executeBatch(TeraLocalPreparedStatement.java:326)|at ....preparedStatement.executeBatch()

Teradata database size

sangeeth — Mon, 22 Jun 2009 16:37:39 GMT

Hello evrybody, Can i know the approximate size of teradata base currently using...?.

The provider reported an unexpected catastrophic failure

camilo_mctorres — Wed, 10 Jun 2009 09:38:19 GMT

Just updated my OLEDB driver to TDOLEDB_Provider_windows_i386.12.00.00.01. Recreated the Linked Server, I can see all my Teradata objects. However, a simple scripting request of one of my tables initially returned an out memory error. Then, any other attempt to run a simple query returns:...The provider reported an unexpected catastrophic failure.sample queriesselect * from openquery(mylinkedserver, 'select * from mydb.mytable');select * from mylinkedserver..mydb.mytableAny hints or past forum entry?

Issue with Teradata ODBC installation on solaris Sparse Root zone.

YvanL — Fri, 17 Apr 2009 14:11:37 GMT

I want to install Teradata ODBC driver (tdodbc__solaris_sparc64.03.06.00.06) on a Solaris (10) Small zone - (also known as a "Sparse Root zone"). It install successfully in the Global zone but fail when continuing for the small zone (QDAP0073A). It fails with the first dependency component (TeraGSS).[b]Server info:[/b] uname -aSunOS QDAP0073A 5.10 Generic_137111-01 sun4u sparc SUNW,Sun-Fire-880 isainfo -kv64-bit sparcv9 kernel modules[b]The ERROR:[/b].....Installation of was successful.## Installing package TeraGSS in zone QDAP0073A Teradata GSS client package(Solaris/SPARC) 06.02.00.00Using as the package base directory.## Processing package information.## Processing system information. 71 package pathnames are already properly installed.Installing Teradata GSS client package as TeraGSS## Installing part 1 of 1.[ verifying class none ]## Executing postinstall script./var/sadm/pkg/TeraGSS/install/postinstall: /usr/teragss/solaris-sparc/06.02.00.00/version: cannot createpkginstall: ERROR: postinstall script did not complete successfullyInstallation of TeraGSS on zone QDAP0073A failed.Any thoughts, ideas, suggestions would be appreciated.

odbc/ sql server linked server connection problem

garrett_s — Wed, 03 Jun 2009 14:55:25 GMT

We are using the SQL Server 2000 linked server functionality (openquery) from stored procedures to get data from teradata through the odbc driver 3.06.We tried an upgrade to TTU 12.0 and no relief.We can duplicate this by running stored procedures in rapid succession that access this linked server.We get this error:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSDASQL' reported an error. Authentication failed.[OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Not enough information to log on][OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Cannot find a compatible package match between client and gateway in terasso library.][OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Major Status=0x04b6 Minor Status=000000-The operation completed successfully.][OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Invalid connection string attribute][OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed][OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed][OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Major Status=0x04b6 Minor Status=000000-No Routine error/No calling error]OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].Anyone have any ideas?We can't seem to get a trace of a failure which isn't helping much. We can trace ODBC when connecting via vb script but not through linked server.

Conflict between Teradata and Sybase

Teradata1 — Wed, 27 May 2009 11:11:57 GMT

Is there someone who can help me solve this problem, I have ODBC driver conflict between Teradata and Sybase.On a Solaris SPARC 32-bit ODBC driver 3.5 we did not have this conflict and to support the data type BIGINT it took to install ODBC 3.6 but since I have this conflictI have traces of the following errors:05/20/2009 10:44:52.292 [E] [TABLE ACC] Erreur de la base de données (5) : SQL call failed.Code fournisseur BDD : -100Message fournisseur BDD : 08001Code supplémentaire : 1Message supplémentaire : [Sybase][ODBC Driver][Adaptive Server Anywhere]Database server not found05/20/2009 10:44:52.293 [E] [TABLE ACC] Erreur de la base de données (5) : SQL call failed.Message fournisseur BDD : 08003Code supplémentaire : 1Message supplémentaire : [Sybase][ODBC Driver]Connection not open05/20/2009 10:44:52.293 [E] [TABLE ACC] DATA_SOURCE_CONNECT à KENOBI(KENOBI) comme LB_CMPINT : ÉCHEC.: CODE 11518: Erreur de connexion à base de donnéeAbdelThanks

Connect Teradata to MS Access

BryceMT — Tue, 26 May 2009 15:19:39 GMT

Hi - I am trying to Connect Teradata to MS Access in VBA. I am using ADODB connection string but I haven't been able to establish the connection. oConn.Open "Provider= Teradata;" & _ "DBCName= P5450;" & _ "Database= MWAD_USERDB;" & _ "Uid= Username;" & _ "Pwd= password"Which drivers should I install to connect MS Access to Teradata server?Thanks!Bryce

DBD::Teradata (Perl Driver) Problem with MLOAD work tables

giulio bertani — Wed, 27 May 2009 06:50:48 GMT

Hello to all,I'm trying to use module DBD::Teradata as shown:[font=Courier New]my $ctldbh = DBI->connect( 'dbi:Teradata:'.$server.';database=jedi_kbo_db' , $username , $password , { RaiseError => 0 , PrintError => 0 , tdat_lsn => 0 , tdat_no_cli => 'NO' , tdat_mode => 'TERADATA' } ) || die "NON CONNESSO !!!";my $total = $ctldbh->tdat_UtilitySetup( { Utility => 'MLOAD', Sessions => $sesscount, SQL => [ "MARK DUPLICATE ROWS;MARK MISSING ROWS; INSERT INTO jedi_kbo_db.T_TEST_T VALUES( :col1 );", ], SourceFields => 'USING (col1 varchar(30))', LogTables => { 'jedi_kbo_db.T_TEST_T' => [ qw(T_TEST_T_wt T_TEST_T_et T_TEST_T_uv) ], }, Source => "VARTEXT '|' ".$filenameF , MP => 1 , });print "ORRORE!!!!:"."str:".$ctldbh->errstr.""."err:".$ctldbh->err."" unless ($total && ($total > 0));[/font]And the program give the message:ORRORE!!!!:str:Failure 3807: Object 'T_TEST_T_uv' does not exist. on Statement 1.err:3807Any idea?I think Mload Should create and Drop T_TEST_T_uv , Shouldn't?Thanks in advanceGiulio

Cannot find terasso library

nichunchun — Wed, 01 Apr 2009 14:56:40 GMT

Hi, Since I installed "Teradata Tools and Utilities v12.1 (TTU v12)". I can't use queryman anymore. The error message "Cannot find terasso library", not enough information to log onAnybody knows how to fix it? Thanks

how to search for char ' and remove from the string "venkat's house"

Venkatesh G — Mon, 18 May 2009 05:32:51 GMT

Hi,Please let me know how to search for the character ' in a string and remove it.data we have in teradata is "venkat's house"i neet to remove ' and convert it into "venkts house".please help me in this regardemail: venkatesh.gubba@gmail.com

How to use cursors in UDF

vshar — Thu, 16 Apr 2009 11:16:57 GMT

We are converting MS -SQL code to Teradata. In my SQL code we have a view which calls a function to calculate the column value. This function uses a cursor on one of the tables.CREATE VIEW vw_1ASSELECT tab1.col1, tab2.col2, tab1.col3, calc_func(tab1.col2, tab1.col3, tab1.col4)FROM tab1INNER JOIN tab2ON tab1.col1 = tab2.col1;[b]Function calc_func calls a cursor on tab3 and calculates the return value based on input parameters.[/b]Can I call cursor in a UDF. I could not find it anywhere on the web or is there any other options like( calling stored procedure from the function)Thanks

.NET Provider performance

Ron Luebke — Wed, 11 Jun 2008 10:11:27 GMT

Is there anyway to get the .NET provider to perform anywhere near as well as fastload for loading data? We have several applications, in c#, that need to monitor directories and then load those files into a Teradata warehouse. I would prefer not to have to shell out to call fastload. Currently I am reading/parsing the file into a dataset and then using a dataadapter to update the table. Performance is no where near what fastload accomplishes. Does anyone have any suggestions/tips/tricks as to how to improve the .NET provider performance?R

Teradata JDBC fastload hangs after approximately 50 batch insert

pganelin — Fri, 17 Apr 2009 22:10:02 GMT

I took the example T20206JD [url=http://www.teradata.com/DownloadCenter/Topic9347-99-1.aspx][/url]provided by Teradata and slightly modified it.I increased number of the batches and size of each batch. Each batch has 1000 inserts and I have about 200 batches. See below.After running for a few iterations the program hangs. Usually it happens after approximately 50 batches. For example here are the last lines from one of the runs ADDED: Batch 46 Inserting data rows...Debugger shows that java program waits on socket for Teradata Server response. No warning messages is returned be the previous batchUpdateTeradata JDBC driver: 12.108Teratata Server: Windows 12.01.24[code] for (int j = 0; j < 209; j++) { int batchCount = 0; for (int i = 0; i < 1000; i++) { pstmt.setInt(1, 1); pstmt.setString(2, strBuf); pstmt.addBatch(); batchCount++; pstmt.setInt(1, 2); pstmt.setString(2, strBuf); pstmt.addBatch(); batchCount++; } System.out.println( "ADDED: Batch " + j); int updateCounts[] = pstmt.executeBatch(); ... }[/code]

perl DBI driver for Teradata DBD::Teradata

Georg G. — Mon, 20 Apr 2009 03:51:50 GMT

I just wanted to let you know that there is the enhanced perl modul DBD::Teradata v12.001 available under GNU GPL sinc Dec. 2008.Up to now an ancient version with reduced functionality has been availalbe on cpan.org.This module can be used to access Teradata directly from a perl program. Using this functionality you can develop applications, automated dataflows, dynamic sql, etc.Details, docu and free download @ http://www.presicient.com/tdatdbd/Note: "Note that Presicient has discontinued development of and support for Teradata products"Anybody using this already, successfully ?

JDBC FastLoad failed: Found 0 AMP(s) and created 0 FastLoadConnection(s) and 0 FastLoadPreparedStatement(s)

pganelin — Fri, 17 Apr 2009 11:39:56 GMT

I got the following error when I tried to use FastLoad:JDBC driver: 12.106 Teradata Server: Windows Demo. 12.0[i]com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 12.00.00.106] [Error 1205] [SQLState HY000] The next failure(s) in the exception chain occurred while creating FastLoad resources for database table "TDUSER"."TEST". Found 0 AMP(s) and created 0 FastLoadConnection(s) and 0 FastLoadPreparedStatement(s) with SESSIONS=0, but all FastLoad resources that were created have now been closed.[/i]The same code runs fine against real Teradata Server (i.e. Teradata/NCR hardware)I suspect that that I need to configure Windows Demo server but I did not find anything about it in the documentation about FastLoadAny hint where to look would be greatly appreciated.Thank you,Pavel

Teradata.Client.Provider.tdException: [Teradata Database] [3939]

Neeraj shukla — Wed, 08 Apr 2009 00:21:52 GMT

Teradata.Client.Provider.tdException: [Teradata Database] [3939] There is a mismatch between the number of parameters specified and the number of parameters required.My update is generated through the .net 2005 dataAdapter config wizard based upon a select stmt i give to it. The select statement is:"select hierarchy_Name from functionalHierarchy where parent_Hierarchy =" + "'" + parent + "'";The wizard generates the update as follows:SELECT hierarchy_Name, hierarchy_Desc, parent_Hierarchy, operation_Type, operation_Reason, create_By, last_Updated_By FROM functionalHierarchy WHERE (hierarchy_Name = ?)Any ideas what I or indeed the config wizard am doing wrong?Is it just me or does the .NET Provider for TeraData not do what it claims it can do!?!

Default ODBC install location on Solaris Opteron x86-64

ddeng — Wed, 08 Apr 2009 22:19:16 GMT

I successfully installed the ODBC client on Solaris Opteron, and it is listed in the pkginfo -l output: PKGINST: tdodbc64 NAME: Teradata ODBC Driver CATEGORY: application ARCH: solaris-x8664 VERSION: 12.00.00.01 BASEDIR: / VENDOR: NCR Corporation PSTAMP: esasol80020071019184432 INSTDATE: Apr 08 2009 14:56 STATUS: completely installed FILES: 48 installed pathnames 2 shared pathnames 14 directories 3 executables 48765 blocks used (approx)However, i have no idea what location it got installed to. What is the default folder on this platform, and what is the 64-bit driver library name to search for?

Error selecting Date when using jdbc

twc87 — Wed, 01 Apr 2009 10:32:33 GMT

I have a table with a few columns of DATE type. I am able to select data from this table using BTEQwin. However, as soon as I use something which connects via the jdbc driver I get the message "TeraResultSet:getTimestamp function failed".I am using driver 12.00.00.107.This error turns up both when I connect using the SQL Explorer plugin in Eclipse and through my application which is running in Tomcat (and uses hibernate, if that matters).I found a workaround by casting to a timestamp and then a char(10) like so:(cast(cast(m_.misson_date as Timestamp(0)) as char(10)))However, I am also forced to have String as my type in hibernate instead of Date.Is there something I can do to make this work while preserving the Date type?

Terasso Error?

nahuna — Tue, 24 Mar 2009 12:24:23 GMT

I'm using SQL Assistant and recently had some "systematic updates" pushed to my machine that appear to have affected my teradata configuration. Not sure if one of my config/dll files was deleted/moved but it appears that might be the case. I could probably troubleshoot if i knew what a baseline set of config files should be...

Teradata ODBC & Oracle BI - issues

patmason — Tue, 25 Nov 2008 15:36:46 GMT

I have installed the Teradata ODBC on the server (solaris) and have added the Teradata paths to the LD_LIBRARY_PATH and specified the ODBCINI parm within the .profile for the id used by the BI Servers.Added the ODBC info into the file.Tested ODBC using Teradata's adhoc program, works like a charm.Recycled SA & SAW, attempted to access Teradata tables (update row count) and get the following:NQODBCSQL_STATE: HY000nQSError: 10058 A general error has occurred.nQSError: 43093 An error occurred while processing the EXECUTE PHYSICAL statementnQSError: 16023 The ODBC function has returned an error. The database may not be available, or the network may be down.I'm not familiar with BI but was told it is in 64bit mode.We have tried with both the 64bit and 32bit Teradata Drivers with same errors.Any thoughts, ideas, suggestions would be appreciated.

OBIEE on Linux odbc.ini

stc944 — Tue, 17 Mar 2009 13:30:32 GMT

Is anyone using OBIEE on top of TD? Can you provide the odbc.ini format for TD?

32 and 64-bit GSS / ICU Client Utilities

gunican — Tue, 11 Nov 2008 08:02:38 GMT

Hi I have an AIX installation that has to use the 64-bit version of the Terdata ODBC driver (tdata.so). My $LIBPATH references all of the 64-bit libraries for GSS and ICU. Unfortunately, I get the following error when I try to use mload:========================================================================= == Processing Control Statements == =========================================================================.logtable test;0002 .logtable test;**** 12:08:39 UTY1006 CLI error: 235, MTDP: EM_GSSINITFAIL(235): call to gss_init failed.**** 12:08:39 UTY2410 Total processor time used = '0.036889 Seconds' . Start : 12:05:32 - TUE NOV 11, 2008 . End : 12:08:39 - TUE NOV 11, 2008 . Highest return code encountered = '12'.$ I believe that I also need to use the 32-bit GSS and ICU environment for mload / fload etc...and I should be able to set my new $LIBPATH to point to the 32-bit stuff in my mload shell script. I need to know if both 32 and 64-bit GSS and ICU environments can co-exist in the same installation?Thanks for any responsesG

Query Server error ODBC 12.0.0.1 invalid string or buffer length

smreisiger — Fri, 06 Mar 2009 10:02:42 GMT

Most people that install have no issues. However, just a few experience this error and have had to go back to previous ODBC version in order to keep working. They upgraded from version 03.02.00.12. Did not remove the old version first. Installed over the old just like all the other users that had no problems did. Thanks for any information.

.Net Teradata Drivers

bhavsp — Wed, 04 Mar 2009 13:48:13 GMT

We have a upload limit of a 1000 rows in my company using an ODBC Connection.I have a .net app which loads to teradata from sql server using Teradata.Client.Provider.Does anyone know if this driver is still using an ODBC connection or someother connection type?