Pages
![]() |
I have installed teradata 64bit drivers, unixODBC 2.3.4 and perl DBD::ODBC 1.52 on RHEL 6 linux.
30 Aug 2016
,
|
![]() |
Hi all, Select * from tbl where col2 like '%abc%' However, if I attempt to run the following:
14 Oct 2015
| 4 comments
,
|
![]() |
I wanted to install from this link http://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-installation-package. Teradata tool and utilities - base 15.00000 but get error "The installation of shared ICU-32 bit appears to have failed. Do you want to continue?"
08 Sep 2015
| 4 comments
,
|
![]() |
I've upgraded to Teradata SQL Assistanct to 14.01. I'm getting a "system failed to initialize" error. I can run sql but can't view the db tree. Found this in an old post but the solution of deleted the dbtree.config did not work. Any help would be greatly appreciated.
22 Jul 2015
| 1 comment
,
|
![]() |
Hi all,
09 Jun 2015
| 1 comment
,
|
![]() |
Hi!
27 Mar 2015
,
|
![]() |
Hello. Unfortunatelly the net is really empty with that information. I didn't find anything right about that. Please, help me with that common problem. I can't connect my Teradata SQL Assistant to ODBC Teradata Source. I'm working alone at my home pc (local host). I've got mysql client and database where i was studying sql first.
24 Jan 2015
| 11 comments
,
|
![]() |
Friends, I need to export a table between two servers, but I get the following error in trasnfer history: Starting Load... Starting Export... Copy Table Data Task Opening connection... Writing data... Data extracted successfully with Warning(s) 539133 Rows Exported
22 Nov 2014
| 11 comments
,
|
![]() |
SUBSTING function is giving error in Teradata Studio which was working fine in Teradata SQL Assistant.
07 Nov 2014
| 1 comment
,
|
![]() |
Issue description:
29 Oct 2014
| 3 comments
,
|
![]() |
Hello,
01 Oct 2014
| 9 comments
,
|
![]() |
Hi,
16 Sep 2014
| 8 comments
,
|
![]() |
Hi. I am receiving the above error when trying to perform a password change via a third party password reset tool. We are using Windows Server 2012 R2 and the password software requires the 32 bit version of the ODBC driver. We are using 15. We have confirmed that the ODBC connection is working.
25 Aug 2014
,
|
![]() |
Hello,
27 Jun 2014
| 2 comments
,
|
![]() |
We have a query that we know will return nulls for a certain column. However, in the result set, sometimes we see null and sometiems it returns <Error> in the column when the value should be null. When I hover over the <Error> value, the below message is displayed.
24 Jun 2014
| 3 comments
,
|
![]() |
Hello
28 Apr 2014
| 1 comment
,
|
![]() |
Hello I looked at this part... left join (select CCT_External_ID, CCT_Agent_ID from GDW_VIEWS. CCT_AGENT where CCT_External_ID between '0' and '999999') Rep_Trans_IDs on Rep_Emp_IDs.emp_id=Rep_Trans_IDs.CCT_External_ID
22 Apr 2014
| 4 comments
,
|
![]() |
We have an external .net application feeding data to our DWH system. While doing inserts/updates with more than 1 record sometimes we are getting the below error :-
04 Apr 2014
| 5 comments
,
|
![]() |
View Display Error
17 Mar 2014
| 7 comments
,
|
![]() |
Hi, DELETE FROM Employee WHERE EmpNo <> :EmpNo and EmpName <> :Empname; UTY0805 RDBMS failure, 3537: A MultiLoad DELETE Statement is Invalid.
04 Mar 2014
| 1 comment
,
|
![]() |
Is there any way we can specifically identify the error line number in Nexus Query Chameleon?
12 Feb 2014
| 2 comments
,
|
![]() |
Hi, Could some help me out what is .quit 66 usage in the below statement. .IF ERRORCODE <> 0 THEN .QUIT 66; Thanks
10 Jan 2014
| 2 comments
,
|
![]() |
Hello All, CREATE TABLE dummy (a INTEGER); INSERT INTO dummy VALUES (986);
SELECT '(' || TO_CHAR(a+1) || ')' FROM dummy;
05 Sep 2013
| 8 comments
,
|
![]() |
I got the package installed correctly but it will not open because it says I need version 1.6 or greater. I tried going out online and finding this download and when I think I have it installed, I still get the error. Has anyone run into this and if so what can be done to get this error fixed.
15 Jul 2013
| 4 comments
,
|
![]() |
I received this error when i run the query on my app, but when i run the same query on teradata studio, it run fine. Why???
15 Jun 2013
| 4 comments
,
|
![]() |
Hi All,
I have to implement a soft ri in one of my project.
Following are the tables in PER_DATA:
person_mst with columns p_num bigint p_dt date p_status char(1)
composite key is defined on columns p_num and p_dt person_mst was created by user xyz.
08 Jun 2013
| 4 comments
,
|
![]() |
Does anyone know if there is a way to trap/display line numbers from stored procedures during execution errors (much in the way that a line number is displayed during a compile error)? I don’t see anything in any forum or documentation that indicates this capability exists (and for 7 years I haven’t heard of anything like this).
28 May 2013
,
|
![]() |
Hi All,
12 Apr 2013
| 9 comments
,
|
![]() |
I am trying to install teradata studio express v14 in my Windows 7 32 bit pc and I always get a JRE not found/JDK not found error after installation. My PC is upto date with JRE and I update to the most recent JRE using Java automatic downloads. Can somebody please help?
19 Mar 2013
,
|
![]() |
Greetings! I'm trying to run a macro during a connection or with teradata using SAS and when I run the code I'm getting the error. What can be the reason? Error in teradata?
12 Mar 2013
| 1 comment
,
|
![]() |
|
![]() |
Hi all,
28 Feb 2013
| 2 comments
,
|
![]() |
Hi Experts,
24 Feb 2013
| 1 comment
,
|
![]() |
Hi,
13 Feb 2013
| 3 comments
,
|
![]() |
Hi,
29 Nov 2012
| 2 comments
,
|
![]() |
Please help me -
logon server/ dbc, "dbc"; copy data tables (db1.table) (FROM(db.table)),RELEASE LOCK, file=file.dat; logoff;
Sometimes - in random occurrence - during table restore from FS (previously correctly dumped) apears this error message:
02 Jul 2012
| 1 comment
,
|
![]() |
Here is what I have that is causing the error........
CREATE MULTISET TABLE DLAB_MARKETING.Click, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( AccountID INTEGER, OYBAccountID INTEGER, JobID INTEGER,
21 Jun 2012
| 10 comments
,
|
![]() |
Hi, SQLA fails to load the saved DB tree when the table description has line breaks in it. It throws:
25 Mar 2012
,
|
![]() |
Hello Everyone, I am trying to import data from a flat file to teradata table with FASTLOAD, but after a few seconds throws error. The log :
24 Mar 2012
| 3 comments
,
|
![]() |
In SQL Assistant Version 13.10.0.04 whenever I've been disconnected by a timeout (our's is set to 15 minutes) and I attempt to use the new reconnect feature I get an error window titled Teradata TDATA.DLL with a message saying 10054 WSA E ConnReset: Connection reset by peer.
18 Jan 2012
| 1 comment
,
|
![]() |
|
![]() |
Hi everyone, I am trying to create a recursive view and get the ERROR REPLACE VIEW Failed. 6926: definitions, views, triggers or stored procedures. Added the code, has anybody any suggestions? Thank you in advance.
13 Dec 2011
| 1 comment
,
|
![]() |
I have been fighting with this for weeks now. Basically I have .NET application that is using a teradata backend. I cannot for the life of me figure out why I keep getting this error, and it's random. The application itself does not specify any auto increment. I'm leaving that up to Teradata using the following create statement. Again - this has been completely random. It can be from updating a record or creating a new record. CREATE TABLE BCPM_DDBO.LTC_FBS
03 Aug 2011
| 1 comment
,
|
![]() |
Hello I'm trying to run the following query and keep getting the above error message after the query has been running for a minute or so. I've tried running it one where clause at a time, have removed the case when and fiddled around with it to try and identify where it is going wrong. If anyone could help me I'd really appreciate it. SELECT
08 Jul 2011
| 1 comment
,
|
![]() |
Hello, NOTE: Teradata SQL Assistant 12.0 worked over the past year and just started giving me an issue in the past month or two. I am running on Windows XP Professional 32-bit. I am running into an interesting error that I cannot seem to find a solution to. When trying to run Teradata SQL Assistant 12.0, I am receiving the following error prompt: Error received: "Error occurred during GetIniData. Code=339 Component 'POWERE~1.OCX' or one of its dependencies not correctly registered: a file is missing or invalid
07 Jul 2011
,
|
![]() |
I have a Talend job that is using JDBC to connect to Teradata. I think the driver being used is 13.00.00.27 and I know the Teradata system I am connecting to is 12.00.1.29 I think only the top most generic error message is being passed from the Teradata driver to Talend for all errors that are being returned: [Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch request. Details of the failure can be found in the exception chain that is accessible with getNextException.
12 Apr 2011
| 1 comment
,
|
![]() |
Hi there, Could anybody help me to look at this? Thanks in advance! I met some problems when I use fastload: Error messages: fast export script: .logtable DP_DEDW_MDB.XM_ACCOUNT_LOAD_LOG; .begin export sessions 8; select
15 Feb 2011
,
|
![]() |
Hi, SHOW VERSION ; logon tdpid/username,password; drop table DBNAME.Bday_reminder ; create table DBNAME.Bday_reminder ( SET RECORD vartext " "; define First_Name (VARCHAR(50)) ,
13 Jan 2011
| 2 comments
,
|
![]() |
Hello everyone, I'm trying to get a Teradata ODBC driver to work on an Oracle/AIX platform instead of windows. I've gotten the Tnsping working, however when I go to use the link I recieve the following error message: ERROR at line 1:
21 Dec 2010
| 4 comments
,
|
![]() |
Hi, SESSIONS 4; create table DBNAME.id_unit_fload ( SET RECORD UNFORMATTED; define id (VARCHAR(18)), file=insert.input; SHOW; BEGIN LOADING DBNAME.id_unit_fload errorfiles DBNAME.err_1, DBNAME.err_2; insert into DBNAME.id_unit_fload END LOADING; logoff;
29 Nov 2010
| 2 comments
,
|