The query getting twice results

Connectivity
Enthusiast

The query getting twice results

 
Hi ,   
I have a WIREPORT connecting teradata .the queries of the users are visible twice in DBQLOgtbl. users are complaining that the queries are executing twice and first one doesnt give any results and second one sends results . I really need help on this .I am not sure why thats happening .   Please kindly suggest me on the solution.  
 
Thanks, Suri.
2 REPLIES
Teradata Employee

Re: The query getting twice results

First, take a look at the RequestMode and AMPCpuTime columns for the two rows in DBQL. Chances are, the first time is only doing a "Prepare" to parse the query and retrieve metadata about the result set. The second time is executing the (prepared) query. This is common behavior for many tools, not just WebI.

Enthusiast

Re: The query getting twice results

if the same query ran for the first time its not showing any results second time that is after 10 mins its showing results ?

Not sure why it is happeneing for the same query .