Teradata SQL Assistant going to Not responding state while querying a table

Database
Enthusiast

Teradata SQL Assistant going to Not responding state while querying a table

Hi,

When I am querying a particular table, Teradata SQL assistant is going to not responding state . Table record count is 19K

Table structure :

CREATE SET TABLE <TABLENAME> ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      COL1 VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL2 DATE FORMAT 'YYYY-MM-DD',

      COL3 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL4 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL5 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL6 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL7 VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL8 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL9 VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL10 VARCHAR(240) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL11 VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL12 VARCHAR(400) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL13 DATE FORMAT 'YYYY-MM-DD',

      COL14 DATE FORMAT 'YYYY-MM-DD',

      COL15 VARCHAR(4000) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL16 NUMBER DEFAULT 0 ,

      COL17 VARCHAR(150) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL18 VARCHAR(150) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL19 VARCHAR(80) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL20 VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL21 VARCHAR(260) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL22 VARCHAR(80) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL23 VARCHAR(80) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL24 VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL25 VARCHAR(80) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL26 VARCHAR(4000) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL27 VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL28 VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL29 VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL30 VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL31 VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL32 DATE FORMAT 'YYYY-MM-DD',

      COL33 DATE FORMAT 'YYYY-MM-DD',

      COL34 DATE FORMAT 'YYYY-MM-DD',

      COL35 NUMBER DEFAULT 0 ,

      COL36 NUMBER DEFAULT 0 ,

      COL37 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL38 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL39 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL40 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL41 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL42 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL43 DATE FORMAT 'YYYY-MM-DD',

      COL44 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL45 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL46 VARCHAR(80) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL47 VARCHAR(4000) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL48 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL49 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL50 VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,

      COL51 TIMESTAMP(0) NOT NULL,

      COL52 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      COL53 TIMESTAMP(0) NOT NULL,

      COL54 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      ATTRIBUTE1 VARCHAR(256) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'ATTRIBUTE1',

      ATTRIBUTE2 VARCHAR(256) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'ATTRIBUTE2')

PRIMARY INDEX ( COL1 );

Please help in finding the issue.

Thanks,

Meenakshi

6 REPLIES
Enthusiast

Re: Teradata SQL Assistant going to Not responding state while querying a table

Please help on this issue .

Enthusiast

Re: Teradata SQL Assistant going to Not responding state while querying a table

Meenakshi,

Please provide the version of SQLA. Did you try querying few records like top 10 or sample 10?

Thanks,

Dinesh

Enthusiast

Re: Teradata SQL Assistant going to Not responding state while querying a table

SQLA version is 13.11

TD database version is 14.10

I tried with Sample 10 , still its going to Not responding state .

Enthusiast

Re: Teradata SQL Assistant going to Not responding state while querying a table

Meenakshi,

SQLA 13.11 seems very old now. One of the reasons might be memory error. Try upgrate SQLA to new version.

Also, check SQLA error log, you might get some idea why it goes into not responding state.

Thanks,

Dinesh

Enthusiast

Re: Teradata SQL Assistant going to Not responding state while querying a table

Where can I see the SQLA error log ?

Enthusiast

Re: Teradata SQL Assistant going to Not responding state while querying a table

C:\Users\<Username>\AppData\Roaming\Teradata\SQL Assistant\SQLAError.txt