Grokbase › Groups › Hadoop › scm-users › November 2013
FAQ
I keep getting this error when I try to log into Cloudera Manager

2013-11-19 12:13:05,740 WARN [85683656@agentServer-838:ipc.Responder@172]
system error
org.apache.avro.AvroRuntimeException: Unknown datum type:
org.hibernate.exception.SQLGrammarException: Table 'scm.HOSTS' doesn't exist
         at
org.apache.avro.generic.GenericData.getSchemaName(GenericData.java:574)
         at
org.apache.avro.generic.GenericData.resolveUnion(GenericData.java:539)
         at
org.apache.avro.generic.GenericDatumWriter.resolveUnion(GenericDatumWriter.java:137)
         at
org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:70)
         at
org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:57)
         at
org.apache.avro.ipc.specific.SpecificResponder.writeError(SpecificResponder.java:71)
         at org.apache.avro.ipc.Responder.respond(Responder.java:167)
         at org.apache.avro.ipc.Responder.respond(Responder.java:99)
         at
org.apache.avro.ipc.ResponderServlet.doPost(ResponderServlet.java:48)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
         at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
         at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
         at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
         at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
         at org.mortbay.jetty.Server.handle(Server.java:326)
         at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
         at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
         at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
         at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
         at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
         at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
         at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

I get the error org.hibernate.exception.SQLGrammarException: Table
'scm.USERS' doesn't exist on the CM webpage.. There are no tables in the
scm database I created for CM server to store the data

To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.

Search Discussions

  • Todd Grayson at Nov 19, 2013 at 8:23 pm ⇧
    Which step are you on following the installation instructions?

    http://www.cloudera.com/content/cloudera-content/cloudera-docs/CM4Ent/latest/Cloudera-Manager-Installation-Guide/Cloudera-Manager-Installation-Guide.html

    On 11/19/13 1:16 PM, sandeep.yarabarla@cloudwick.com wrote:
    I keep getting this error when I try to log into Cloudera Manager

    2013-11-19 12:13:05,740 WARN
    [85683656@agentServer-838:ipc.Responder@172] system error
    org.apache.avro.AvroRuntimeException: Unknown datum type:
    org.hibernate.exception.SQLGrammarException: Table 'scm.HOSTS' doesn't
    exist
    at
    org.apache.avro.generic.GenericData.getSchemaName(GenericData.java:574)
    at
    org.apache.avro.generic.GenericData.resolveUnion(GenericData.java:539)
    at
    org.apache.avro.generic.GenericDatumWriter.resolveUnion(GenericDatumWriter.java:137)
    at
    org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:70)
    at
    org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:57)
    at
    org.apache.avro.ipc.specific.SpecificResponder.writeError(SpecificResponder.java:71)
    at org.apache.avro.ipc.Responder.respond(Responder.java:167)
    at org.apache.avro.ipc.Responder.respond(Responder.java:99)
    at
    org.apache.avro.ipc.ResponderServlet.doPost(ResponderServlet.java:48)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at
    org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
    at
    org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
    at
    org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
    at
    org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    at org.mortbay.jetty.Server.handle(Server.java:326)
    at
    org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
    at
    org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
    at
    org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
    at
    org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
    at
    org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
    at
    org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

    I get the error org.hibernate.exception.SQLGrammarException: Table
    'scm.USERS' doesn't exist on the CM webpage.. There are no tables in
    the scm database I created for CM server to store the data
    To unsubscribe from this group and stop receiving emails from it, send
    an email to scm-users+unsubscribe@cloudera.org.

    --
    Todd Grayson
    Cloudera Support
    Customer Operations Engineering
    tgrayson@cloudera.com

    To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.
  • Sandeep Yarabarla at Nov 19, 2013 at 11:33 pm ⇧
    I installed Cloudera Manager and CDH.. I kind of understand what the
    problem is. I reinstalled CM server and agents and I recreated the database
    scm for storing CM server data. When I try to start the service, it is
    looking for tables in scm database but they aren't getting created. The
    database scm is empty even after following all the steps. I have attached a
    copy of the log too. Thanks.


    On Tuesday, November 19, 2013 12:23:29 PM UTC-8, Todd Grayson wrote:

    Which step are you on following the installation instructions?


    http://www.cloudera.com/content/cloudera-content/cloudera-docs/CM4Ent/latest/Cloudera-Manager-Installation-Guide/Cloudera-Manager-Installation-Guide.html

    On 11/19/13 1:16 PM, sandeep....@cloudwick.com <javascript:> wrote:
    I keep getting this error when I try to log into Cloudera Manager

    2013-11-19 12:13:05,740 WARN
    [85683656@agentServer-838:ipc.Responder@172] system error
    org.apache.avro.AvroRuntimeException: Unknown datum type:
    org.hibernate.exception.SQLGrammarException: Table 'scm.HOSTS' doesn't
    exist
    at
    org.apache.avro.generic.GenericData.getSchemaName(GenericData.java:574)
    at
    org.apache.avro.generic.GenericData.resolveUnion(GenericData.java:539)
    at
    org.apache.avro.generic.GenericDatumWriter.resolveUnion(GenericDatumWriter.java:137)
    at
    org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:70)
    at
    org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:57)
    at
    org.apache.avro.ipc.specific.SpecificResponder.writeError(SpecificResponder.java:71)
    at org.apache.avro.ipc.Responder.respond(Responder.java:167)
    at org.apache.avro.ipc.Responder.respond(Responder.java:99)
    at
    org.apache.avro.ipc.ResponderServlet.doPost(ResponderServlet.java:48)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at
    org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
    at
    org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
    at
    org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
    at
    org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    at org.mortbay.jetty.Server.handle(Server.java:326)
    at
    org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
    at
    org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
    at
    org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
    at
    org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
    at
    org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
    at
    org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
    I get the error org.hibernate.exception.SQLGrammarException: Table
    'scm.USERS' doesn't exist on the CM webpage.. There are no tables in
    the scm database I created for CM server to store the data
    To unsubscribe from this group and stop receiving emails from it, send
    an email to scm-users+...@cloudera.org <javascript:>.

    --
    Todd Grayson
    Cloudera Support
    Customer Operations Engineering
    tgra...@cloudera.com <javascript:>
    To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.
  • Vikas Singh at Nov 19, 2013 at 11:55 pm ⇧
    Hi Sandeep,

    The log when CM server starts is missing. Stop CM server, cleanup/backup
    existing logs and restart CM server. That will create a new log and we can
    see messages when CM server is starting. It prints out db connection
    information at that time.

    Also look into /etc/cloudera-scm-server/db.properties file and check what
    it has for db host, name, user and password. Can you use same credential to
    connect to database?

    Vikas

    On Tue, Nov 19, 2013 at 3:32 PM, wrote:

    I installed Cloudera Manager and CDH.. I kind of understand what the
    problem is. I reinstalled CM server and agents and I recreated the database
    scm for storing CM server data. When I try to start the service, it is
    looking for tables in scm database but they aren't getting created. The
    database scm is empty even after following all the steps. I have attached a
    copy of the log too. Thanks.



    On Tuesday, November 19, 2013 12:23:29 PM UTC-8, Todd Grayson wrote:

    Which step are you on following the installation instructions?

    http://www.cloudera.com/content/cloudera-content/
    cloudera-docs/CM4Ent/latest/Cloudera-Manager-Installation-
    Guide/Cloudera-Manager-Installation-Guide.html

    On 11/19/13 1:16 PM, sandeep....@cloudwick.com wrote:
    I keep getting this error when I try to log into Cloudera Manager

    2013-11-19 12:13:05,740 WARN
    [85683656@agentServer-838:ipc.Responder@172] system error
    org.apache.avro.AvroRuntimeException: Unknown datum type:
    org.hibernate.exception.SQLGrammarException: Table 'scm.HOSTS' doesn't
    exist
    at
    org.apache.avro.generic.GenericData.getSchemaName(GenericData.java:574)
    at
    org.apache.avro.generic.GenericData.resolveUnion(GenericData.java:539)
    at
    org.apache.avro.generic.GenericDatumWriter.resolveUnion(GenericDatumWriter.java:137)
    at
    org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:70)
    at
    org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:57)
    at
    org.apache.avro.ipc.specific.SpecificResponder.writeError(SpecificResponder.java:71)
    at org.apache.avro.ipc.Responder.respond(Responder.java:167)
    at org.apache.avro.ipc.Responder.respond(Responder.java:99)
    at
    org.apache.avro.ipc.ResponderServlet.doPost(ResponderServlet.java:48)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at
    org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
    at
    org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
    at
    org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
    at
    org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    at org.mortbay.jetty.Server.handle(Server.java:326)
    at
    org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
    at
    org.mortbay.jetty.HttpConnection$RequestHandler.
    content(HttpConnection.java:945)
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
    at
    org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
    at
    org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
    at
    org.mortbay.io.nio.SelectChannelEndPoint.run(
    SelectChannelEndPoint.java:410)
    at
    org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
    I get the error org.hibernate.exception.SQLGrammarException: Table
    'scm.USERS' doesn't exist on the CM webpage.. There are no tables in
    the scm database I created for CM server to store the data
    To unsubscribe from this group and stop receiving emails from it, send
    an email to scm-users+...@cloudera.org.

    --
    Todd Grayson
    Cloudera Support
    Customer Operations Engineering
    tgra...@cloudera.com

    To unsubscribe from this group and stop receiving emails from it, send
    an email to scm-users+unsubscribe@cloudera.org.
    To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedNov 19, '13 at 8:16p
activeNov 19, '13 at 11:55p
posts4
users3
websitecloudera.com
irc#hadoop

3 users in discussion

Sandeep Yarabarla: 2 posts Todd Grayson: 1 post Vikas Singh: 1 post

Content

People

Support

Translate

site design / logo © 2022 Grokbase