How do I see the _entire_ error message

Toad Data Point & Toad Intelligence Central
1

I’m still new to TDP. How do I see the entire error message? Messages are too often truncated. Below is what I see. Right clicking and chosing ‘Select All’ and pasting to a text editor doesn’t work, nor does ‘Send to Editor’ and ‘Text Output’. Thanks in advance for the help.

Teradata exception: [Teradata Database] [3707] Syntax error, expected something like an integer or a decimal number or a floating point number or a ‘WHEN’ keyword between the

FYI, This is what’s creating the error. I figured out I have to pull the sample as a sub-query and it must have an alias. (Where in the world might this sort of thing be documented? I couldn’t evem find sample in TD’s online docs.)

This fails-- select count(*) as nrecs from WFPDMHM.V_HM_ACCT_BAP sample .25;

This works-- select count(*) from (select * from WFPDMHM.V_HM_ACCT_BAP sample .25) as A;

2

I am not familiar with Teradata but if you automate the query (create a job to run it), you can set the error log location via the first step in automation and even set it to verbose which will give you all the detail in the log file. Automation is pretty easy to set up and run and in your case you don’t even have to schedule it, just run it. Automation by the way is by far the best feature of Toad. Play with it and have fun. Here is a link to getting started with Toad:

http://dev.toadforsqlserver.com/TDPVideos/TDPVideo.html

The link at the bottom of the page will bring you to the Automation video.

For more videos on advanced automation topics use this link:

http://www.toadworld.com/products/toad-data-point/m/media-library/tags/Toad%2BData%2BPoint/Automation

3

Oh and one more link to Debie Peabody’s blog on Toad Data Point Automation series. She is the master, queen of TDP, Automation goddess, etc. I think you get the point.

http://www.toadworld.com/members/debbie-peabody/blogs

4

Thanks for the note Greg. I use Toad for one-off data exploration and query debugging so automation isn’t a real good solution. That said, I could automate problem queries like this to see the full error log… it might be faster and less irritating than searching the web for an answer.

5

Hi John,

I cannot reproduce the issue. For me the following query

select count*(__) as nrecs from quest_dev.address sample .25;

runs without error.

Could you provide more information? What is the version of TDP? What Teradata version do you use? What client do you use to connect to Teradata - Ado .Net provider or ODBC?

Regards

Aleksey

6

It doesn’t surprise me that you can’t reproduce the error… that’s pretty much the way it goes.

The problem I need help with is that the error message was truncated.

I’m using Teradata 15.10 but have no idea as to what client I’m using other than it’s not ODBC. Maybe whatever came with TD 15.10 or maybe with Toad?

Thanks for trying to help.

John Bentley

-----Original Message-----

From: Aleksey Bazhenov [mailto:bounce-AlekseyBazhenov@toadworld.com]

Sent: Tuesday, November 29, 2016 5:04 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] How do I see the entire error message

Hi John,

I cannot reproduce the issue. For me the following query select count(*) as nrecs from quest_dev.address sample .25; runs without error.

Could you provide more information? What is the version of TDP? What Teradata version do you use? What client do you use to connect to Teradata - Ado .Net provider or ODBC?

Regards

Aleksey

View this message online or reply to this message (www.toadworld.com/…/63750.)

Toad Data Point - Discussion Forum

7

What version of Toad do you use? You will find it on Help | About dialog.

Could you check with the latest beta if the issue exists in that version?

Thanks

Aleksey

8

I have version Toad Data Point 3.8.0.575.

My IT partners don’t allow Beta versions for the line of business users like me and getting updated to version 4 is so difficult that it’s just not going to happen.

John

-----Original Message-----

From: Aleksey Bazhenov [mailto:bounce-AlekseyBazhenov@toadworld.com]

Sent: Wednesday, November 30, 2016 2:34 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] How do I see the entire error message

What version of Toad do you use? You will find iton Help | About dialog.

Could you check with the latest betaif the issue exists in that version?

Thanks

Aleksey

View this message online or reply to this message (www.toadworld.com/…/63764.)

Toad Data Point - Discussion Forum