0 - 50 of 55 tags for error

Pages

I have installed teradata 64bit drivers,  unixODBC 2.3.4 and perl DBD::ODBC 1.52 on  RHEL 6 linux.
Everything is working with short single line queries from both isql and perl.  However, multi-line queries fail with
set_err: state ('400') is not a 5 character string, using 'S1000' instead at /usr/local/lib64/perl5/DBD/ODBC.pm line 229.

Hi all,
I've got an interesting issue going on with Teradata. Suppose I have a table tbl with columns col1, col2, col3 with col1 being the primary key.
I can run 

Select * from tbl where col2 like '%abc%'

However, if I attempt to run the following:

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?"
 

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.

Hi all, 
 
I can't get Tearadat Studio to start after the installation. 
During installation, I got an error message saying that 'Due to an error, desktop short cut cannot be created, please manually create a shortcut"

Hi!
I have on SQL2008 server linked server Teradada. I select from this linked server and for many tables is ok, but
when I select some tables I see error:

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.

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

 

 

SUBSTING function is giving error in Teradata Studio which was working fine in Teradata SQL Assistant.
My Query is like this : SEL SUBSTRING('ABC',1,2)
I do not want to use SUBSTR instead of SUBSTRING as it involves making changes in a lot of Queries. Please suggest a work around for this issue.
 
Thanks!
Anirudh

Issue description:
When a job that is loading an empty table through FastLoad Functionality (Teradata Connector) aborts, it causes the mentioned table to be left in an irrecoverable Lock state, which cannot be cleared using an empty FastLoad, and which only workaround is to drop and recreate the table.

Hello,
We are trying to load a pipe delimited flat with qulaifiers as " utlizing the TPT script but our loads seems to be failing since there is a embedded " in certain fields. Its just sending the error record to a error file and failing after that. Do we have some option or add on in the TPT script to load this data as is.

Hi,
I'm new to TeraData. Following is the script i am using to create to While loop in Stored Procedure.
But TeraData Studio is giving me Syntax Error:
can we use loop in Stored Procedure or is there any other way to do that.
Kindly suggest.
CREATE PROCEDURE proc (
        IN i INTEGER,

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.

Hello,
I've recently upgraded to SQL Assistant v14.0. In v13.10 I had no trouble running the following query (statement by statment). Now I'm having trouble because I get an error that says "Error executing query for record 1: 3706: Syntax error: expected something between ')' and the integer '1'.
Here is the sql:

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.
 

Hello
I'm trying to run this recursive query but it's giving me an error:

Hello
I keep getting the above error message after the query below has been running for a minute or so.

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

 

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 :- 
 
6908   Iterated request: Multi-statement requests not supported.
 

Hi,
I need to delete the rows from table in mload script which are not matching in the file.
Tried couples of ways but couldn't succeed.

DELETE FROM Employee WHERE EmpNo <> :EmpNo and EmpName <> :Empname;

UTY0805 RDBMS failure, 3537: A MultiLoad DELETE Statement is Invalid.

Is there any way we can specifically identify the error line number in Nexus Query Chameleon?
If not, can we somehow code this in or run a statement before running our actual code?
I know SQL Assistant can do it.

Hi,

Could some help me out what is .quit 66 usage in the below statement.

.IF ERRORCODE <> 0 THEN .QUIT 66;

Thanks
balu

Hello All,
I have created a dummy table and inserted one record in that table. When i simply select that record it gives me unwanted leading space in the answer set. 

CREATE TABLE dummy (a INTEGER);

INSERT INTO dummy VALUES (986);

 

SELECT '(' || TO_CHAR(a+1) || ')' FROM dummy;

 

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.
 
Thanks!

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???
I use jdbc driver for run this query.

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.

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).

Hi All,
I am trying to cast a column into decimal but its failing with the error

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?
thanks

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?

Hi All,

 Hi all,
     I have this below statement.
 
sel case when date  is not null then
cast(extract(month from date) as smallint) || substring(cast(extract(year from date) as varchar(4)),3,2)
else null
end as Temp
 

Hi Experts,
I'm getting the below error while loading flat file to Table using FL facility.  I'm new to TD and tried all the options to resolve the issue.  But, no luck.
My input file (EMP_FLAT) looks like below:
1xxx101000
2yyy202000
3zzz303000
My FL code is:
.SET RECORD UNFORMATTED;
SESSIONS 2;

Hi,
i am calling a utility stored procedure within my application and its failing due to error code 7693.
The following is what i see in SQL assistant :  
"CALL Failed. 7693: ......."
Can someone share why TERADATA throws error code 7693. I might be able to debug further.
 

Hi,
I am running a sql query using SAS EG. It is essentially an explicit sql query that is wrapped within sas commands that make it run on the teradata engine. I need help resolving this error.
NOTE: There were 144405 observations read from the data set XXX.MCID_TMP.

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:

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,

Hi,

SQLA fails to load the saved DB tree when the table description has line breaks in it.

It throws:

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 :

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. 

Hello,

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.

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
(FBS_ID INTEGER not null GENERATED BY DEFAULT AS IDENTITY
(START WITH 1
INCREMENT BY 1),
DBS_NM varchar(50),

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
T1.Call_Date
,(t1.Trading_Code||((t1.Account_Number/10)(FORMAT '9999999')))
,T1.Call_Type
,T1.BU_Desc
,SUM(CASE WHEN T4.Department_Group_Code IN ('M','W') THEN 'Fashion'
WHEN T4.Department_Group_Code IN ('F') THEN 'Footwear'

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

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.

Hi there,

Could anybody help me to look at this? Thanks in advance!

I met some problems when I use fastload:

Error messages:
Fastload: Incorrect number of bytes returned from a File Read

fast export script:

.logtable DP_DEDW_MDB.XM_ACCOUNT_LOAD_LOG;
.LOGON 11.11.11.1/user,pass;

.begin export sessions 8;
.export outfile fast.out mode record format fastload;

select
trim(TRAILING '0D'XC FROM trim(TRAILING '0A'XC from TRIM(coalesce (cast (feed as VARCHAR(50)) ,''))))|| '|' ||

Hi,
I am running the following fastload script to read from a csv file:

SHOW VERSION ;
SESSIONS 4;
ERRLIMIT 2000;

logon tdpid/username,password;

drop table DBNAME.Bday_reminder ;

create table DBNAME.Bday_reminder (
First_Name VARCHAR(50),
Last_Name VARCHAR(50),
Mail_Id VARCHAR(50),
Emp_id INTEGER,
Extn_No INTEGER,
Mobile_No INTEGER,
Mobile_No_Home INTEGER
)
PRIMARY INDEX Bday_reminder ( Emp_id );

SET RECORD vartext " ";

define

First_Name (VARCHAR(50)) ,
Last_Name (VARCHAR(50)),
Mail_Id (VARCHAR(50)),

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:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from LINK_TDDEV

Hi,
I am executing a fastlaod script which is as follows:

SESSIONS 4;
ERRLIMIT 2000;
.logon tdpid/username,password;

create table DBNAME.id_unit_fload (
id VARCHAR(18),
units VARCHAR(18)
)
PRIMARY INDEX UPI_id_unit_fload ( id );

SET RECORD UNFORMATTED;

define

id (VARCHAR(18)),
units (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
(
:id,
:units
);

END LOADING;

logoff;