SAKAI_PERSON_T table not being created at startup
GENERAL
TESTING
GENERAL
TESTING
Description
Attachments
1
- 28 Jan 2010, 03:38 AM
is duplicated by
is related to
Activity
Show:
John Bush November 4, 2010 at 4:18 PM
oops reopened wrong issue
Anthony Whyte July 27, 2010 at 1:48 PM
common-1.0.x, r79942. This was a manual merge of portions of trunk r78900 due to additional fields added to trunk by https://sakaiproject.atlassian.net/browse/SAK-17821#icft=SAK-17821 that are intended for Sakai 2.8.0+.
Sam Ottenhoff July 7, 2010 at 11:29 AM
Confirmed fixed in latest trunk. Tested with both MysqlDialect and MysqlInnoDBDialect.
Steve Swinsburg June 29, 2010 at 7:56 PM
I think this may need backporting to 2.7
Steve Swinsburg June 29, 2010 at 7:55 PMEdited
I believe I have fixed this as of r78900. Looks good on Oracle and MySQL if using:
hibernate.dialect=org.hibernate.dialect.MySQLDialect
or
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
but not
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
Fixed
Created January 26, 2010 at 3:02 AM
Updated March 27, 2012 at 7:00 AM
Resolved November 4, 2010 at 4:18 PM
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