Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-17838

SAKAI_PERSON_T table not being created at startup

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.7.0
    • Fix Version/s: 2.7.1, 2.8.0
    • Component/s: Common
    • Labels:
      None
    • Environment:
      QA7-US and QA1-NL (2-7-b1, MySQL), error.
      QA8-US, the iframe is blank.
      QA3-US and QA1-ZA load as expected.
    • Conversion Script Required:
      Yes
    • Previous Issue Keys:
      PRFL-217

      Description

      AutoDLL appears not to have created a table Table 'sakai.SAKAI_PERSON_T'
      Please fix for 2.7-b2

      And then profile2 does not work. With error

      010-01-26 11:54:21,526 WARN TP-Processor1 org.hibernate.util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02
      2010-01-26 11:54:21,526 ERROR TP-Processor1 org.hibernate.util.JDBCExceptionReporter - Table 'sakai.SAKAI_PERSON_T' doesn't exist
      2010-01-26 11:54:21,527 ERROR TP-Processor1 org.sakaiproject.profile2.logic.SakaiProxyImpl - SakaiProxy.getSakaiPerson(): Couldn't get SakaiPerson for: 84dc5d53-54f6-4982-a2ac-a024cfc59a36 : class org.springframework.dao.InvalidDataAccessResourceUsageException : could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
      WARN: 2010-01-26 11:54:21,527 No SakaiPerson for 84dc5d53-54f6-4982-a2ac-a024cfc59a36. Creating one. [TP-Processor1]
      2010-01-26 11:54:21,533 WARN TP-Processor1 org.hibernate.util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02
      2010-01-26 11:54:21,533 ERROR TP-Processor1 org.hibernate.util.JDBCExceptionReporter - Table 'sakai.SAKAI_PERSON_T' doesn't exist
      2010-01-26 11:54:21,534 ERROR TP-Processor1 org.sakaiproject.profile2.logic.SakaiProxyImpl - SakaiProxy.createSakaiPerson(): Couldn't create SakaiPerson: class org.springframework.dao.InvalidDataAccessResourceUsageException : could not insert: [org.sakaiproject.component.common.edu.person.SakaiPersonImpl]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [org.sakaiproject.component.common.edu.person.SakaiPersonImpl]
      ERROR: 2010-01-26 11:54:21,534 Can't instantiate page using constructor public org.sakaiproject.profile2.tool.Dispatcher() [TP-Processor1]
      org.apache.wicket.WicketRuntimeException: Can't instantiate page using constructor public org.sakaiproject.profile2.tool.Dispatcher()
      at org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:168)
      at org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:58)
      at org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:92)
      at org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.newPage(BookmarkablePageRequestTarget.java:278)
      at org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.getPage(BookmarkablePageRequestTarget.java:293)
      at org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.processEvents(BookmarkablePageRequestTarget.java:210)
      at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91)
      at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1220)
      at org.apache.wicket.RequestCycle.step(RequestCycle.java:1297)
      at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1399)
      at org.apache.wicket.RequestCycle.request(RequestCycle.java:529)
      at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356)
      at org.apache.wicket.protocol.http.WicketServlet.doGet(WicketServlet.java:124)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:580)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
      at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:461)
      at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:364)
      at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
      at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:486)
      at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1216)
      at org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:198)
      at org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:96)
      at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:768)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:641)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:581)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
      at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      at org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:149)
      ... 49 more
      Caused by: class org.sakaiproject.profile2.exception.ProfileNotDefinedException: Couldn't create a SakaiPerson for 84dc5d53-54f6-4982-a2ac-a024cfc59a36
      at org.sakaiproject.profile2.tool.pages.MyProfile.renderMyProfile(MyProfile.java:88)
      at org.sakaiproject.profile2.tool.pages.MyProfile.<init>(MyProfile.java:48)
      at org.sakaiproject.profile2.tool.Dispatcher.<init>(Dispatcher.java:11)
      ... 54 more

      Looking at startup, the table is not mentioned, so autoDLL does not try and make table. This is for MySQL version 5

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  jbush John Bush
                  Reporter:
                  a.m.berg@uva.nl Alan Berg
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration