Profile2 does not load

Description

When you click Profile in My Workspace, QA7-US and QA1-NL both say:

Internal Error
An error has occurred.

On QA8-US, the iframe is blank.

QA3-US and QA1-ZA load as expected.

Activity

Show:

Steve Swinsburg January 27, 2010 at 2:43 PM

Ok I'm going to close this one and move discussion to just so we can keep track of it all in one place.

Nicola Monat-Jacobs January 27, 2010 at 1:10 PM

Ah yes, can see the logs for QA1-NL and it is the same issue that Alan reported (stack trace below). However, I can't get to the logs for QA7-US and that one is DB2 not MySQL.

2010-01-27 22:07:44,326 WARN TP-Processor1 org.hibernate.util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02
2010-01-27 22:07:44,326 ERROR TP-Processor1 org.hibernate.util.JDBCExceptionReporter - Table 'sakai.SAKAI_PERSON_T' doesn't exist
2010-01-27 22:07:44,327 ERROR TP-Processor1 org.sakaiproject.profile2.logic.SakaiProxyImpl - SakaiProxy.getSakaiPerson(): Couldn't get SakaiPerson for: 6ae6ee1f-e975-49ac-822a-101b4245b27b : class org.springframework.dao.InvalidDataAccessResourceUsageException : could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
WARN: 2010-01-27 22:07:44,327 No SakaiPerson for 6ae6ee1f-e975-49ac-822a-101b4245b27b. Creating one. [TP-Processor1]
2010-01-27 22:07:44,331 WARN TP-Processor1 org.hibernate.util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02
2010-01-27 22:07:44,331 ERROR TP-Processor1 org.hibernate.util.JDBCExceptionReporter - Table 'sakai.SAKAI_PERSON_T' doesn't exist
2010-01-27 22:07:44,331 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-27 22:07:44,331 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 6ae6ee1f-e975-49ac-822a-101b4245b27b
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

Steve Swinsburg January 27, 2010 at 1:01 PM

Nicola do you have access to the Tomcat logs? If so, what is the exception thrown. I think this is related to and may be a db/driver issue.

Duplicate

Details

Priority

Affects versions

Components

Assignee

Reporter

Environment

Mac 10.6, Safari 4.0.4
Created January 27, 2010 at 12:28 PM
Updated July 15, 2014 at 7:11 AM
Resolved January 27, 2010 at 2:44 PM