Viewpoint Time in State and Total duration from SQLS coming through procedure

Viewpoint
Enthusiast

Viewpoint Time in State and Total duration from SQLS coming through procedure

We have seen a situation where in which we observed Request count increased from a session who is submitting SQLs from a procedure and Time in State value is added up however what we see in the manual is that should be per SQL. is this a bug ?

Below are abstract from Viewpoint 14 manual

TIME IN STATE How long the query has been in the current state, displayed as HH:MM:SS

TOTAL DURATION How long the query has run, displayed as HH:MM:SS

Thanks

Abhijit

4 REPLIES
Teradata Employee

Re: Viewpoint Time in State and Total duration from SQLS coming through procedure

Thanks Abhijit.  We received the exact same feedback a few weeks ago from another customer.  We have an open request for the calculation for Time In State to be reset any time the request count increases for a session.

Enthusiast

Re: Viewpoint Time in State and Total duration from SQLS coming through procedure

Thanks Steve for quick feedback is there any JIRA which we can refer and follow up for fix ? Any idea on possible fix timelines ?
Teradata Employee

Re: Viewpoint Time in State and Total duration from SQLS coming through procedure

The JIRA is VP-25371.  The fix has not yet been made so I can't give you a timeline on when this might be fixed at this time.

Enthusiast

Re: Viewpoint Time in State and Total duration from SQLS coming through procedure

Thanks Steve