All Forums Viewpoint
varanasianup 14 posts Joined 09/14
09 Jul 2015
Not able to view SQL explain in Query monitor

Hi All
In the Data collectors setup : Enable SQL Explain collector is checked,
And i could see the error as below :
Unable to collect SQL and Explain for session xxxx . SQL error code :3296
 
can somebody explain on how to get it corrected or redirect 
 

Tags:
gryback 271 posts Joined 12/08
13 Jul 2015

Do you also have the Sessions collector enabled? Are both collectors running without error? As the documentation states "The SQL Explain collector is dependent on the Session collector running because it uses previously gathered data from the Session Collector"

varanasianup 14 posts Joined 09/14
14 Jul 2015

Hi 
 
Yes both
Session Collector and SQL explain Collector  are enabled.

abhishek.jadhav 28 posts Joined 02/08
14 Jul 2015

You should also check the following settings
Setttings > RoleManager > Click on the appropriate role > Click on portlets > Query Monitor > Click on Set Permissions > Permissions for Query Monitor 

Make sure “View SQL” and “View Explain” is Checked here.

 

 

Thanks

Abhishek Jadhav

 

Thanks
Abhishek Jadhav

varanasianup 14 posts Joined 09/14
15 Jul 2015

Hi Abhishek
Yes in the set permissions option for query monitor, both 'VIew SQL' and 'View Explain' are checked.
 
 

gryback 271 posts Joined 12/08
15 Jul 2015

What version of Viewpoint are you running? 

varanasianup 14 posts Joined 09/14
15 Jul 2015

Teradata 15.0

gryback 271 posts Joined 12/08
21 Jul 2015

Well it should work. At this point, you should submit an incident for further analysis and resolution.

varanasianup 14 posts Joined 09/14
28 Jul 2015

Hi I have submitted an incident,
Teradata says due to large/complicated queries running all the time(yes there are few SPs which runs 24*7) viewpoint is unable to fetch the info ..and was throwing Timeout error.
Teradata has changed the PMPC_timeout to zero ..increased it to 600 secs..but there were NO positives out of it..
Is this related to bandwidth of network ? 

You must sign in to leave a comment.