Topic
  • 3 replies
  • Latest Post - ‏2015-08-19T06:57:57Z by MetDelon
SystemAdmin
SystemAdmin
603 Posts

Pinned topic BigSheets not working

‏2013-03-22T21:54:53Z |
I've been working with BS from some time, but now suddently I get this message every time I call a BS link:
Exception thrown by application class 'org.apache.m2.webapp.controller.FrontController.initDataBaseandContext():220'
org.apache.m2.exceptions.M2Exception: java.lang.reflect.InvocationTargetException
at org.apache.m2.webapp.controller.FrontController.initDataBaseandContext(FrontController.java:220)
at org.apache.m2.webapp.controller.FrontController.processRequest(FrontController.java:95)
at org.apache.m2.webapp.controller.FrontController.doPost(FrontController.java:269)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
Updated on 2013-03-22T22:45:56Z at 2013-03-22T22:45:56Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    603 Posts

    Re: BigSheets not working

    ‏2013-03-22T22:45:56Z  
    This error occurs when the BigSheets back-end derby database is inaccessible, usually because the derby server has been shut down. Can you please verify that the derby network server has been started? If you ssh into the web console server you can start the derby service via the command: start.sh derby. You can also try to inspect why the derby server may have stopped unexpectedly by looking at derby's log file at /var/ibm/biginsights/derby/derby.log
  • YahaSun
    YahaSun
    8 Posts

    Re: BigSheets not working

    ‏2014-07-31T14:07:40Z  

    in V3.0 to enable bigsheets, start "catalog"

    $BIGINSIGHTS_HOME/bin/start.sh hadoop console catalog

  • MetDelon
    MetDelon
    1 Post

    Re: BigSheets not working

    ‏2015-08-19T06:57:57Z  

    *** Need Advise and Help***

    I am facing the same issue with Bigsheet is not working.

    I have tried to start up the services (including Hadoop Console and Catalog), and I am still having the error -

     

    Exception thrown by application class 'org.apache.m2.webapp.controller.FrontController.initDataBaseandContext:229'
    javax.servlet.ServletException: org.apache.m2.exceptions.M2Exception: java.lang.reflect.InvocationTargetException
    at org.apache.m2.webapp.controller.FrontController.initDataBaseandContext(FrontController.java:229)
    at org.apache.m2.webapp.controller.FrontController.processRequest(FrontController.java:95)
    at org.apache.m2.webapp.controller.FrontController.doGet(FrontController.java:278)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1240)
    at [internal classes]
    at org.apache.m2.webapp.filter.auth.CurrentUserFilter.doFilter(CurrentUserFilter.java:43)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:194)
    at [internal classes]
    Caused by: org.apache.m2.exceptions.M2Exception: java.lang.reflect.InvocationTargetException
    at org.apache.m2.model.context.M2ContextFactory.getM2Context(M2ContextFactory.java:57)
    at org.apache.m2.webapp.controller.FrontController.initDataBaseandContext(FrontController.java:211)
    ... 9 more
    Caused by: java.lang.reflect.InvocationTargetException: 
    at sun.reflect.GeneratedConstructorAccessor68.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:57)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:541)
    at org.apache.m2.model.context.M2ContextFactory.getM2Context(M2ContextFactory.java:37)
    ... 10 more
    Caused by: org.apache.m2.exceptions.M2Exception: java.sql.SQLInvalidAuthorizationSpecException: [jcc][t4][2013][11249][4.17.36] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000 DSRA0010E: SQL State = 28000, Error Code = -4,214
    ... 18 more
    Caused by: java.sql.SQLInvalidAuthorizationSpecException: [jcc][t4][2013][11249][4.17.36] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000 DSRA0010E: SQL State = 28000, Error Code = -4,214
    at com.ibm.db2.jcc.am.hd.a(hd.java:745)
    at com.ibm.db2.jcc.am.hd.a(hd.java:66)
    at com.ibm.db2.jcc.am.hd.a(hd.java:128)
    at com.ibm.db2.jcc.t4.b.f(b.java:2445)
    at com.ibm.db2.jcc.t4.b.b(b.java:1808)
    at com.ibm.db2.jcc.t4.z.r(z.java:955)
    at com.ibm.db2.jcc.t4.z.k(z.java:492)
    at com.ibm.db2.jcc.t4.z.c(z.java:142)
    at com.ibm.db2.jcc.t4.b.k(b.java:1384)
    at com.ibm.db2.jcc.t4.b.b(b.java:1297)
    at com.ibm.db2.jcc.t4.b.a(b.java:6437)
    at com.ibm.db2.jcc.t4.b.b(b.java:847)
    at com.ibm.db2.jcc.t4.b.a(b.java:764)
    at com.ibm.db2.jcc.t4.b.a(b.java:422)
    at com.ibm.db2.jcc.t4.b.a(b.java:397)
    at com.ibm.db2.jcc.t4.b.(b.java:335)
    at com.ibm.db2.jcc.DB2DataSource.getSimpleConnection(DB2DataSource.java:142)
    at com.ibm.db2.jcc.DB2DataSource.getConnection(DB2DataSource.java:118)
    at com.ibm.db2.jcc.DB2DataSource.getConnection(DB2DataSource.java:93)
    at com.ibm.ws.rsadapter.spi.WSRdbDataSource$1.run(WSRdbDataSource.java:238)
    at [internal classes]
    at org.apache.m2.model.database.DB.createConnection(DB.java:73)
    at org.apache.m2.model.dataaccess.BaseDataAccessManager.getConnection(BaseDataAccessManager.java:40)
    at org.apache.m2.model.context.M2Context.(M2Context.java:35)
    ... 16 more