/var/opt/OV/log/pvhibernate.log => Relation "pg_class" does not exist

[RiverRat_1]

This is showing up more than a few times.  Anyone know what this means and make it go away ?

May 14 14:48:03 - ERROR - could not get database metadata
java.sql.SQLException: [Vertica][VJDBC](4566) ERROR: Relation "pg_class" does not exist
at com.vertica.util.ServerErrorData.buildException(Unknown Source)
at com.vertica.dataengine.VQueryExecutor.executeSimpleProtocol(Unknown Source)
at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source)
at com.vertica.jdbc.SStatement.executeNoParams(Unknown Source)
at com.vertica.jdbc.SStatement.executeQuery(Unknown Source)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:151)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:69)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:62)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:170)
at com.hp.reporter.db.HibernateManager.updateSchema(Unknown Source)
at com.hp.reporter.db.HibernateManager.<init>(Unknown Source)
at com.hp.reporter.db.HibernateManager.getInstance(Unknown Source)
at com.hp.reporter.db.HibernateHelper.executeSQLListQuery(Unknown Source)
at com.hp.pm.core.po.DBUtil.getSQLResultUsingTemplateQuery(Unknown Source)
at com.hp.pm.core.po.DBUtil.getEventsList(Unknown Source)
at com.hp.pv.alerts.AlertAdapter.getLatestAlerts(Unknown Source)
at com.hp.reporter.collector.CollectionStatusTask.run(Unknown Source)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.vertica.util.ServerException: [Vertica][VJDBC](4566) ERROR: Relation "pg_class" does not exist
... 24 more

[PFerreira]

Hi,

We have vPV installed on RHEL 6.2 and we're facing this same problem.

Did you get to fix this issue?

Thanks and best regards,

Paulo Ferreira

[Kandlur]

Hello,

I guess this error is not resulting in any funcationality impact and you can safely ignore the exception in log file.

Currently there is no support for Vertica dialect from Hiberanate.  This request is still in open state.

Using postgresql dialect works for Vertica as well with exception logged in log file. 

https://hibernate.atlassian.net/browse/HHH-9560

Note: Postgres dialet is compatible with Vertica.   Dialect is a Hibernate feature that generate the appropriate SQL for a chosesn database for Java applications.  Since vPV uses Vertica DB resulting exception in log file.

Regards,

Udupa