Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class
3008 views

Vertica error -could not get database metadata

Jump to solution

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

Labels (1)
Tags (3)
0 Likes
1 Solution

Accepted Solutions
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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.

 

View solution in original post

2 Replies
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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

0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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.

 

View solution in original post

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.