Problem in MC installation

Moderator: NorbertKrupa

Post Reply
karpagaraj
Newbie
Newbie
Posts: 2
Joined: Thu Sep 18, 2014 8:33 am

Problem in MC installation

Post by karpagaraj » Thu Sep 18, 2014 11:52 am

Hi,
I try to install management console as like as the same version of the vertica. But my browser shows me that wep page is not available error. Here below I provied my output.
=================
starting monitor thread
2014-09-18 04:49:51.402:INFO:oejs.Server:jetty-7.x.y-SNAPSHOT
2014-09-18 04:49:51.485:INFO:oejw.WebInfConfiguration:Extract jar:file:/opt/vconsole/lib/webui.war!/ to /opt/vconsole/temp/webapp
2014-09-18 04:50:01.902:INFO:/webui:Initializing Spring root WebApplicationContext
log4j:WARN No appenders could be found for logger (org.springframework.web.context.ContextLoader).
log4j:WARN Please initialize the log4j system properly.
java.sql.SQLSyntaxErrorException: Table/View 'CONFIGURATION.SCHEMA_VERSION' does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at com.vertica.admin.tools.webui.jobs.RepositoryDataCleanupTask.getLatestSchemaVer(RepositoryDataCleanupTask.java:164)
at com.vertica.admin.tools.webui.jobs.RepositoryDataCleanupTask.canStartCleanUp(RepositoryDataCleanupTask.java:126)
at com.vertica.admin.tools.webui.jobs.RepositoryDataCleanupTask.launchTask(RepositoryDataCleanupTask.java:93)
at com.vertica.admin.tools.webui.jobs.RepositoryDataCleanupJob.execute(RepositoryDataCleanupJob.java:32)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: java.sql.SQLException: Table/View 'CONFIGURATION.SCHEMA_VERSION' does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 16 more
Caused by: ERROR 42X05: Table/View 'CONFIGURATION.SCHEMA_VERSION' does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 10 more
---- Upgrading /opt/vconsole/config/console.properties ----


************************************************************************************************************

Please open the Vertica Management Console at https://ip-myipdetails.ec2.internal:5450/webui

************************************************************************************************************


2014-09-18 04:50:54.719:INFO:/webui:Set web app root system property: 'webapp.root' = [/opt/vconsole/temp/webapp]
2014-09-18 04:50:54.723:INFO:/webui:Initializing log4j from [/opt/vconsole/temp/webapp/WEB-INF/log4j-mc.xml]
2014-09-18 04:50:54.831:INFO:oejsh.ContextHandler:started o.e.j.w.WebAppContext{/webui,file:/opt/vconsole/temp/webapp/},file:/opt/vconsole/lib/webui.war
2014-09-18 04:50:55.199:INFO:/webui:Initializing Spring FrameworkServlet 'appServlet'
2014-09-18 04:51:02.749:INFO:oejhs.SslContextFactory:Enabled Protocols [SSLv2Hello, TLSv1, SSLv3] of [SSLv2Hello, SSLv3, TLSv1]
2014-09-18 04:51:02.792:INFO:oejs.AbstractConnector:Started SslSelectChannelConnector@0.0.0.0:5450 STARTING

Any one can share your ideas for resolve this and make MC installation succssfully happen.

Thanks
raj

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Problem in MC installation

Post by NorbertKrupa » Thu Sep 18, 2014 1:13 pm

Well, MC appears to be running. What's the name of the host or IP of the node MC is installed on and what is the URL you're using to try to access MC through the browser?
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “New to Vertica Database Administration”