Archives of the TeradataForum

Message Posted: Thu, 29 Nov 2012 @ 16:39:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Which version of the viewpoint you are using? Actually there is a known issue with upgrading the Viewpoint server to 13.11 and some data collectors are not working. FYI, the similar problem description looks like this.

If the Lock Info Data Collector is not working and the error indicates "Access to utility dumplocklogb denied", then the problem is most likely insufficient permissions for the viewpoint user to execute the dumplocklogb macro. Following are excerpts from the DCS log which will identify the issue:

     2011-04-25 17:44:28,190 [QuartzScheduler_Worker-7] ERROR
     collectors.LockInfoCollector.EATEST - Unable to get lock information from dumplocklog
     utility!
     org.springframework.dao.DataRetrievalFailureException:
     *** SQLException caught **
     SQL State = HY000, Error Code = 1218
     com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC
     13.10.00.10] [Error 1218] [SQLState HY000] A failure occurred while executing a
     statement. Details of the failure can be found in the exception chain that is accessible
     with getNextException.
     ......
     *** SQLException caught **
     SQL State = HY000, Error Code = 1296
     com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC
     13.10.00.10] [Error 1296] [SQLState HY000] A failure occurred while fetching rows from
     the database. Details of the failure can be found in the exception chain that is
     accessible with getNextException.
     ......
     *** SQLException caught **
     SQL State = 42000, Error Code = 3190
     com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.10.00.10]
     [Error 3190] [SQLState 42000] Access to utility dumplocklogb denied.

To correct the Lock Info Data Collector, try the below:

     replace macro console.dumplocklogb as (;);
     grant exec on console.dumplocklogb to viewpoint;

Geeta Kudumula
TERADATA Certified Master
AMEX IDN TERADATA DBA

	<Prev	Next>		<<First	<Prev	Next>	Last>>