http-8080-5 2011-10-28 11:39:10 admin 127.0.0.1 ERROR(org.mirapolis.sql.exception.JDBCExceptionReporter):Could not execute query statement [SELECT P0.personid as personid
FROM (SELECT P0.personid as personid
FROM (SELECT personid
FROM (SELECT PERSONID, PERSONID as external_id
FROM PP$PERSON)
WHERE external_id = 0)P0)P0
INNER JOIN (SELECT P0.personid as personid
FROM (SELECT personid
FROM (SELECT PERSONID, PERSONID as external_id
FROM PP$PERSON)
WHERE external_id = 0)P0)P1 ON P1.personid = P0.personid
WHERE personid = 0 FOR READ ONLY:null]
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0203N  Задано неоднозначное имя столбца "PERSONID".  SQLSTATE=42702

	at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
	at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
	at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
	at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown Source)
	at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.mirapolis.db.jdbc.AbstractExecutor.getDataSet(AbstractExecutor.java:118)
	at org.mirapolis.db.Session.get(Session.java:227)
	at org.mirapolis.db.Session.get(Session.java:455)
	at lms.core.access.hierarchical.HierarchicalAccessService.resultContainsUser(HierarchicalAccessService.java:138)
	at lms.core.access.hierarchical.HierarchicalAccessService.hasUserSpecificAccessInHierarchy(HierarchicalAccessService.java:119)
	at lms.service.media.access.local.MediaResourceAccessLocalService.getAccessibleResourcesForCurrentUser(MediaResourceAccessLocalService.java:140)
	at lms.service.media.access.local.MediaResourceAccessLocalService.getAllAccessibleObjectsForCurrentUser(MediaResourceAccessLocalService.java:78)
	at lms.core.access.hierarchical.HierarchicalAccessService.modifyQueryData(HierarchicalAccessService.java:510)
	at lms.service.media.widgets.MediaResourceByViewWidget.getResourceByView(MediaResourceByViewWidget.java:64)
	at lms.service.media.widgets.MediaResourceByViewWidget.getResource(MediaResourceByViewWidget.java:51)
	at lms.service.media.widgets.MediaResourceWidgetBlock.preRender(MediaResourceWidgetBlock.java:121)
	at portal.widget.widgets.SafeWidgetWrapper.preRender(SafeWidgetWrapper.java:63)
	at portal.page.proxy.PageProxy.prerenderPageWidgets(PageProxy.java:664)
	at portal.PortalPageWrapperFrame.createUserPageView(PortalPageWrapperFrame.java:80)
	at portal.PortalPageWrapperFrame.createView(PortalPageWrapperFrame.java:51)
	at portal.page.utils.SysPageViewCreator.create(SysPageViewCreator.java:56)
	at lms.system.main.LMSSystemModule.getViewForPortal(LMSSystemModule.java:159)
	at lms.system.main.LMSSystemModule.getView(LMSSystemModule.java:149)
	at org.mirapolis.mvc.action.GoAction.getViewForFrame(GoAction.java:187)
	at org.mirapolis.mvc.action.GoAction.run(GoAction.java:177)
	at org.mirapolis.mvc.action.system.GoToFrameAction.run(GoToFrameAction.java:35)
	at org.mirapolis.mvc.action.Action.runLicensed(Action.java:200)
	at org.mirapolis.mvc.action.ControllerServlet.doPost(ControllerServlet.java:86)
	at org.mirapolis.mvc.action.ControllerServlet.doGet(ControllerServlet.java:47)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.mirapolis.mvc.action.FilterServlet.doFilter(FilterServlet.java:59)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Unknown Source)