Vertica error -could not get database metadata

[BSM_546]

Hello all,

I iam trying to install vPV and I am having the below error in pvhibernate.log. This is a fresh install . Any idea what could be the issue?

Nov 26 11:14:35 - 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.pm.core.adapter.alert.AbstractAlertAdapter.getAlerts(Unknown Source)
at com.hp.pm.core.dashboard.AlertsComponent.loadAlerts(Unknown Source)
at com.hp.pm.core.dashboard.AlertsComponent.getJSONObject(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getLatestComponentData(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getComponentCacheWithLock(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getComponentData(Unknown Source)
at com.hp.pm.web.command.json.GetDashboardDataCommand.doAction(Unknown Source)
at com.hp.pm.web.command.ServiceExcecutor.execute(Unknown Source)
at com.hp.pm.web.URLRouter.routeURL(Unknown Source)
at com.hp.perf.web.URLRouter.routeURL1(Unknown Source)
at com.hp.perf.web.URLRouter.routeURL(Unknown Source)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:80)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:612)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.vertica.util.ServerException: [Vertica][VJDBC](4566) ERROR: Relation "pg_class" does not exist
... 53 more
Nov 26 11:14:35 - ERROR - could not complete schema update
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.pm.core.adapter.alert.AbstractAlertAdapter.getAlerts(Unknown Source)
at com.hp.pm.core.dashboard.AlertsComponent.loadAlerts(Unknown Source)
at com.hp.pm.core.dashboard.AlertsComponent.getJSONObject(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getLatestComponentData(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getComponentCacheWithLock(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getComponentData(Unknown Source)
at com.hp.pm.web.command.json.GetDashboardDataCommand.doAction(Unknown Source)
at com.hp.pm.web.command.ServiceExcecutor.execute(Unknown Source)
at com.hp.pm.web.URLRouter.routeURL(Unknown Source)
at com.hp.perf.web.URLRouter.routeURL1(Unknown Source)
at com.hp.perf.web.URLRouter.routeURL(Unknown Source)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:80)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:612)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.vertica.util.ServerException: [Vertica][VJDBC](4566) ERROR: Relation "pg_class" does not exist
... 53 more
Nov 26 11:14:35 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Infrastructure__Node" does not exist
Nov 26 11:14:35 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Cluster" does not exist
Nov 26 11:14:35 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Datastore" does not exist
Nov 26 11:14:35 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Infrastructure__Enclosure" does not exist
Nov 26 11:14:36 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Capacity__DataCenter" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Datacenter" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_Infrastructure__Node" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__NodeDSRelation" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__NodeDSRelation" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Datastore" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Infrastructure__Node" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Cluster" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Datastore" does not exist
Nov 26 11:14:43 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Infrastructure__Node" does not exist

Many thanks,

SGS

[BSM_546]

I suspect the table itself is not getting created. I can see below error during installation

2015-11-26 11:10:41,123 INFO - Logfile for package HPPVCore is located at : /tmp/HPOvInstaller/HPPV_2.20.388/Package_rpm_HPPVCore_install.log
2015-11-26 11:10:41,128 INFO - Checking existence of :/tmp/VpV/packages/HPPVCore-02.20.388.rpm
Found :/tmp/VpV/packages/HPPVCore-02.20.388.rpm
rpm command returned : 0
warning: /tmp/VpV/packages/HPPVCore-02.20.388.rpm: Header V3 RSA/SHA1 Signature, key ID b564a643: NOKEY
Preparing packages for installation...
HPPVCore-2.20.388-1
chown root /var/opt/OV/databases/pv
chmod 777 /var/opt/OV/databases/pv
su pv_vertica -c /opt/vertica/bin/adminTools -t create_db -s localhost -d pv -c /var/opt/OV/databases/pv/catalog -D /var/opt/OV/databases/pv/data
Info: no password specified, using none
Database with 1 or 2 nodes cannot be k-safe and it may lose data if it crashes
Distributing changes to cluster.
127.0.0.1 OK [vertica][(7, 1, 1)][000][x86_64]
Creating database pv
Starting bootstrap node v_pv_node0001 (127.0.0.1)
Starting nodes:
v_pv_node0001 (127.0.0.1)

Starting Vertica on all nodes. Please wait, databases with large catalogs may take a while to initialize.

Node Status: v_pv_node0001: (INITIALIZING)
Node Status: v_pv_node0001: (INITIALIZING)
Node Status: v_pv_node0001: (UP)
Database pv created successfully.
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
OUTPUT
--------
1
(1 row)

OUTPUT
--------
1
(1 row)

CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
vsql:/opt/OV/newconfig/DataDir/conf/PV/Model/DMLMetaMetaSchema:74: WARNING 4116: No super projections created for table public.Events.
HINT: Default super projections will be automatically created with the next DML
CREATE PROJECTION
CREATE TABLE
/var/tmp/rpm-tmp.TBnbDh: line 6574: pv: command not found
INFO: Current vPV version is
/var/tmp/rpm-tmp.TBnbDh: line 6576: [: ==: unary operator expected
odbcinst: Driver installed. Usage count increased to 1.
Target directory is /etc
/var/tmp/rpm-tmp.TBnbDh: line 4818: [: too many arguments
/var/tmp/rpm-tmp.TBnbDh: line 4823: [: too many arguments
/var/tmp/rpm-tmp.TBnbDh: line 4828: [: too many arguments
INTERNAL ERROR: Log variable OVCSL_LOG_APPLICATION is not set. Logging is disabled.
Error:
(xpl-81) Could not open '/opt/OV/newconfig/OVPM/smepack'.
(RTL-2) No such file or directory
Traceback (most recent call last):
File "/opt/OV/lbin/PV/ChangeAlertSensitivity.py", line 44, in <module>
CopyConfigFiles("medium")
File "/opt/OV/lbin/PV/ChangeAlertSensitivity.py", line 11, in CopyConfigFiles
for dirName in os.listdir("/opt/OV/newconfig/OVPM/smepack"):
FileNotFoundError: [Errno 2] No such file or directory: '/opt/OV/newconfig/OVPM/smepack'

Caught exception:
(sec.core-76) Could not decrypt data. Incorrect padding.Completed installation
Fixing RPM db. Leaving : HPPVCore warning: /tmp/VpV/packages/HPPVCore-02.20.388.rpm: Header V3 RSA/SHA1 Signature, key ID b564a643: NOKEY
2.20.388
Completed the HP OpenView Component Package Installation : 0

System.txt

<rolled=0>
0: INF: Thu Nov 26 11:50:12 2015: ovcd (15547/140308701091584): (ctrl-212) ovbbccb has been started. PID: 15555
0: INF: Thu Nov 26 11:50:12 2015: ovcd (15547/140308676364032): (sec.cm.client-50) Configuration setting CERTIFICATE_SERVER is not set. Certificate request cannot be sent.
0: INF: Thu Nov 26 11:50:17 2015: ovcd (15547/140308057679616): (ctrl-212) pvcd has been started. PID: 15608
0: INF: Thu Nov 26 11:50:18 2015: pvcd (15608/139877065549600): pvcd.pvc Server is started.
0: INF: Thu Nov 26 11:50:31 2015: ovcd (15547/140308057679616): (ctrl-212) ovtomcatB has been started. PID: 16141

[BSM_546 · Accepted solution]

Sorted out the issue. 

Issue-  vPV related database was not getting created. Vertica installation was successful. 

Reason - Smepack was not extracted properly. (scripts.zip/sql.zip was not extracted to /opt/OV/newconfig/OVPM/smepack

'unzip' utility should be a prerequisite for the OS.  After installing unzip, and following installation, sme pack was extracted successfully.