re7425353
Error
statusCode: 500
message: null
requestURI: /portal/templates/csstemplate/page/html/template.jsp
servletName: jsp
exceptionType: null
exception: CONTAINER:atg.servlet.jsp.ContainerJspException: javax.servlet.ServletException: atg.servlet.jsp.ContainerJspException: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLException: ORA-00918: column ambiguously defined
[++SQLQuery++]
SELECT t1.service_id
FROM eipf_service t1, eipf_service_def t2, paf_folder t3, paf_community t4
WHERE t2.service_def_id=t1.SERVICE_DEF_ID
AND t3.folder_id=t2.parent_folder
AND t4.community_id=t1.COMMUNITY_ID
AND ((community_id = ?)
AND (ENABLED = ?)
AND (name = ?)
AND (t2.name = ?))
-- Parameters --
p[1] = {pd: id} re7128002 (java.lang.String)
p[2] = {pd: active} true (java.lang.Boolean)
p[3] = {pd: name} Landing Page (java.lang.String)
p[4] = {pd: name} Cookie Redirect Page (java.lang.String)
[--SQLQuery--]
; SOURCE:org.apache.jasper.JasperException: javax.servlet.ServletException: atg.servlet.jsp.ContainerJspException: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLException: ORA-00918: column ambiguously defined
[++SQLQuery++]
SELECT t1.service_id
FROM eipf_service t1, eipf_service_def t2, paf_folder t3, paf_community t4
WHERE t2.service_def_id=t1.SERVICE_DEF_ID
AND t3.folder_id=t2.parent_folder
AND t4.community_id=t1.COMMUNITY_ID
AND ((community_id = ?)
AND (ENABLED = ?)
AND (name = ?)
AND (t2.name = ?))
-- Parameters --
p[1] = {pd: id} re7128002 (java.lang.String)
p[2] = {pd: active} true (java.lang.Boolean)
p[3] = {pd: name} Landing Page (java.lang.String)
p[4] = {pd: name} Cookie Redirect Page (java.lang.String)
[--SQLQuery--]
stackTrace:
CONTAINER:atg.servlet.jsp.ContainerJspException: javax.servlet.ServletException: atg.servlet.jsp.ContainerJspException: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLException: ORA-00918: column ambiguously defined
[++SQLQuery++]
SELECT t1.service_id
FROM eipf_service t1, eipf_service_def t2, paf_folder t3, paf_community t4
WHERE t2.service_def_id=t1.SERVICE_DEF_ID
AND t3.folder_id=t2.parent_folder
AND t4.community_id=t1.COMMUNITY_ID
AND ((community_id = ?)
AND (ENABLED = ?)
AND (name = ?)
AND (t2.name = ?))
-- Parameters --
p[1] = {pd: id} re7128002 (java.lang.String)
p[2] = {pd: active} true (java.lang.Boolean)
p[3] = {pd: name} Landing Page (java.lang.String)
p[4] = {pd: name} Cookie Redirect Page (java.lang.String)
[--SQLQuery--]
; SOURCE:org.apache.jasper.JasperException: javax.servlet.ServletException: atg.servlet.jsp.ContainerJspException: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLException: ORA-00918: column ambiguously defined
[++SQLQuery++]
SELECT t1.service_id
FROM eipf_service t1, eipf_service_def t2, paf_folder t3, paf_community t4
WHERE t2.service_def_id=t1.SERVICE_DEF_ID
AND t3.folder_id=t2.parent_folder
AND t4.community_id=t1.COMMUNITY_ID
AND ((community_id = ?)
AND (ENABLED = ?)
AND (name = ?)
AND (t2.name = ?))
-- Parameters --
p[1] = {pd: id} re7128002 (java.lang.String)
p[2] = {pd: active} true (java.lang.Boolean)
p[3] = {pd: name} Landing Page (java.lang.String)
p[4] = {pd: name} Cookie Redirect Page (java.lang.String)
[--SQLQuery--]
at atg.taglib.dspjsp.IncludeTag.doEndTag(IncludeTag.java:591)
at org.apache.jsp.templates.csstemplate.page.html.template_jsp._jspx_meth_dsp_005finclude_005f0(template_jsp.java:3112)
at org.apache.jsp.templates.csstemplate.page.html.template_jsp._jspService(template_jsp.java:542)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at eipf.taglib.i18n.filter.RepositoryLocaleFilter.doFilter(RepositoryLocaleFilter.java:92)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:414)
at atg.portal.servlet.StrutsFilterDispatcher.doFilter(StrutsFilterDispatcher.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at eipf.transformer.botsupport.DisableSessionIdFilter.doFilter(DisableSessionIdFilter.java:136)
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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
at atg.servlet.DispatchServlet.serviceDispatch(DispatchServlet.java:245)
at atg.servlet.DispatchServlet.serviceDispatchByPath(DispatchServlet.java:363)
at atg.servlet.DispatchServlet.serviceDispatchByPath(DispatchServlet.java:380)
at eipf.portal.servlet.PageTemplateDispatchServlet.dispatchPageTemplate(PageTemplateDispatchServlet.java:205)
at eipf.portal.servlet.PageTemplateDispatchServlet.handleService(PageTemplateDispatchServlet.java:376)
at eipf.portal.servlet.PageTemplateDispatchServlet.handleService(PageTemplateDispatchServlet.java:382)
at atg.servlet.GenericServletService.service(GenericServletService.java:409)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at eipf.filter.OnlyLiveCommunitiesOnProductionFilter.doFilter(OnlyLiveCommunitiesOnProductionFilter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at eipf.filter.SetServletResponseLocaleFilter.doFilter(SetServletResponseLocaleFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at eipf.taglib.i18n.filter.RepositoryLocaleFilter.doFilter(RepositoryLocaleFilter.java:133)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at eipf.filter.UserAccessLogFilter.doFilter(UserAccessLogFilter.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at eipf.filter.nostatic.NoStaticEipfPageViewEventFilter.doFilter(NoStaticEipfPageViewEventFilter.java:20)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at eipf.filter.nostatic.NoStaticPortletActionFilter.doFilter(NoStaticPortletActionFilter.java:20)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at eipf.filter.nostatic.NoStaticCommunityPageFilter.doFilter(NoStaticCommunityPageFilter.java:20)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at eipf.filter.nostatic.NoStaticOfflineFilter.doFilter(NoStaticOfflineFilter.java:20)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at eipf.filter.nostatic.NoStaticAccessFilter.doFilter(NoStaticAccessFilter.java:20)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at atg.portal.servlet.EipfPageFilter.doFilter(EipfPageFilter.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at eipf.filter.nostatic.NoStaticCommunityFilter.doFilter(NoStaticCommunityFilter.java:19)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at eipf.filter.nostatic.NoStaticPortalFilter.doFilter(NoStaticPortalFilter.java:20)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.GenericFilterService.doFilterChain(GenericFilterService.java:599)
at atg.servlet.GenericFilterService.handleDoFilter(GenericFilterService.java:462)
at atg.servlet.GenericFilterService.doFilter(GenericFilterService.java:409)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:414)
at atg.portal.servlet.StrutsFilterDispatcher.doFilter(StrutsFilterDispatcher.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at eipf.xss.XssFilter.doFilter(XssFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at atg.servlet.pipeline.TailPipelineServlet.service(TailPipelineServlet.java:148)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.servlet.pipeline.DispatcherPipelineServletImpl.service(DispatcherPipelineServletImpl.java:253)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.servlet.http.CookieBufferServlet.service(CookieBufferServlet.java:97)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.userprofiling.ExpiredPasswordServlet.service(ExpiredPasswordServlet.java:356)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.servlet.pipeline.MimeTyperPipelineServlet.service(MimeTyperPipelineServlet.java:206)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.droplet.DropletEventServlet.service(DropletEventServlet.java:565)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.servlet.sessionsaver.SessionSaverServlet.service(SessionSaverServlet.java:2442)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.servlet.pipeline.DispatcherPipelineServletImpl.service(DispatcherPipelineServletImpl.java:253)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at eipf.portal.servlet.cookie.CookiesChainServlet.service(CookiesChainServlet.java:36)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.userprofiling.AccessControlServlet.service(AccessControlServlet.java:602)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.userprofiling.PageEventTriggerPipelineServlet.service(PageEventTriggerPipelineServlet.java:169)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.userprofiling.SessionEventTrigger.service(SessionEventTrigger.java:477)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.userprofiling.ProfileRequestServlet.service(ProfileRequestServlet.java:480)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at eipf.filter.AutoLoginRequestFilter.service(AutoLoginRequestFilter.java:163)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.servlet.pipeline.ServletPathPipelineServlet.service(ServletPathPipelineServlet.java:186)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at eipf.search.NewSearchRedirector.service(NewSearchRedirector.java:42)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at eipf.portal.i18n.NucleusToHTTPRequestLocaleSetter.service(NucleusToHTTPRequestLocaleSetter.java:53)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.servlet.pipeline.DynamoPipelineServlet.service(DynamoPipelineServlet.java:469)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.servlet.pipeline.URLArgumentPipelineServlet.service(URLArgumentPipelineServlet.java:280)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.servlet.pipeline.PathAuthenticationPipelineServlet.service(PathAuthenticationPipelineServlet.java:370)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.userprofiling.sso.PassportServlet.service(PassportServlet.java:561)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.servlet.security.ThreadUserBinderServlet.service(ThreadUserBinderServlet.java:91)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:135)
at atg.servlet.pipeline.HeadPipelineServlet.passRequest(HeadPipelineServlet.java:1123)
at atg.servlet.pipeline.HeadPipelineServlet.service(HeadPipelineServlet.java:805)
at atg.servlet.pipeline.PipelineableServletImpl.service(PipelineableServletImpl.java:250)
at atg.filter.dspjsp.PageFilter.doFilter(PageFilter.java:227)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at eipf.transformer.DigestedFilter.doFilter(DigestedFilter.java:67)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at eipf.transformer.HTMLTransformerFilter.doFilter(HTMLTransformerFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at eipf.transformer.botsupport.DisableSessionIdFilter.doFilter(DisableSessionIdFilter.java:136)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
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:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.apache.jasper.JasperException: javax.servlet.ServletException: atg.servlet.jsp.ContainerJspException: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLException: ORA-00918: column ambiguously defined
[++SQLQuery++]
SELECT t1.service_id
FROM eipf_service t1, eipf_service_def t2, paf_folder t3, paf_community t4
WHERE t2.service_def_id=t1.SERVICE_DEF_ID
AND t3.folder_id=t2.parent_folder
AND t4.community_id=t1.COMMUNITY_ID
AND ((community_id = ?)
AND (ENABLED = ?)
AND (name = ?)
AND (t2.name = ?))
-- Parameters --
p[1] = {pd: id} re7128002 (java.lang.String)
p[2] = {pd: active} true (java.lang.Boolean)
p[3] = {pd: name} Landing Page (java.lang.String)
p[4] = {pd: name} Cookie Redirect Page (java.lang.String)
[--SQLQuery--]
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:521)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:397)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at eipf.taglib.i18n.filter.RepositoryLocaleFilter.doFilter(RepositoryLocaleFilter.java:92)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:414)
at atg.portal.servlet.StrutsFilterDispatcher.doFilter(StrutsFilterDispatcher.java:30)
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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:557)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:481)
at atg.servlet.WrappingRequestDispatcher.include(WrappingRequestDispatcher.java:94)
at atg.taglib.dspjsp.IncludeTag.doEndTag(IncludeTag.java:585)
... 204 more
Caused by: javax.servlet.ServletException: atg.servlet.jsp.ContainerJspException: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLException: ORA-00918: column ambiguously defined
[++SQLQuery++]
SELECT t1.service_id
FROM eipf_service t1, eipf_service_def t2, paf_folder t3, paf_community t4
WHERE t2.service_def_id=t1.SERVICE_DEF_ID
AND t3.folder_id=t2.parent_folder
AND t4.community_id=t1.COMMUNITY_ID
AND ((community_id = ?)
AND (ENABLED = ?)
AND (name = ?)
AND (t2.name = ?))
-- Parameters --
p[1] = {pd: id} re7128002 (java.lang.String)
p[2] = {pd: active} true (java.lang.Boolean)
p[3] = {pd: name} Landing Page (java.lang.String)
p[4] = {pd: name} Cookie Redirect Page (java.lang.String)
[--SQLQuery--]
at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
at org.apache.jsp.templates.csstemplate.page.html.cookie_jsp._jspService(cookie_jsp.java:484)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
... 221 more
Caused by: javax.servlet.ServletException: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLException: ORA-00918: column ambiguously defined
[++SQLQuery++]
SELECT t1.service_id
FROM eipf_service t1, eipf_service_def t2, paf_folder t3, paf_community t4
WHERE t2.service_def_id=t1.SERVICE_DEF_ID
AND t3.folder_id=t2.parent_folder
AND t4.community_id=t1.COMMUNITY_ID
AND ((community_id = ?)
AND (ENABLED = ?)
AND (name = ?)
AND (t2.name = ?))
-- Parameters --
p[1] = {pd: id} re7128002 (java.lang.String)
p[2] = {pd: active} true (java.lang.Boolean)
p[3] = {pd: name} Landing Page (java.lang.String)
p[4] = {pd: name} Cookie Redirect Page (java.lang.String)
[--SQLQuery--]
at eipf.service.PortalServiceImpl.getListOfServiceEnabled(PortalServiceImpl.java:165)
at eipf.portal.framework.droplet.EipfServiceForEach.service(EipfServiceForEach.java:65)
at atg.servlet.DynamoServlet.service(DynamoServlet.java:123)
at atg.taglib.dspjsp.DropletTag.invokeServlet(DropletTag.java:349)
at atg.taglib.dspjsp.DropletTag.doAfterBody(DropletTag.java:616)
at org.apache.jsp.templates.csstemplate.page.html.cookie_jsp._jspService(cookie_jsp.java:431)
... 224 more
Caused by: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLException: ORA-00918: column ambiguously defined
[++SQLQuery++]
SELECT t1.service_id
FROM eipf_service t1, eipf_service_def t2, paf_folder t3, paf_community t4
WHERE t2.service_def_id=t1.SERVICE_DEF_ID
AND t3.folder_id=t2.parent_folder
AND t4.community_id=t1.COMMUNITY_ID
AND ((community_id = ?)
AND (ENABLED = ?)
AND (name = ?)
AND (t2.name = ?))
-- Parameters --
p[1] = {pd: id} re7128002 (java.lang.String)
p[2] = {pd: active} true (java.lang.Boolean)
p[3] = {pd: name} Landing Page (java.lang.String)
p[4] = {pd: name} Cookie Redirect Page (java.lang.String)
[--SQLQuery--]
at atg.adapter.gsa.GSAItemDescriptor.executeQuery(GSAItemDescriptor.java:7346)
at atg.adapter.gsa.GSAView.executeUncachedQuery(GSAView.java:332)
at atg.repository.query.QueryCache.executeUncachedQuery(QueryCache.java:693)
at atg.repository.query.QueryCache.populateEntry(QueryCache.java:905)
at atg.repository.query.QueryCache.executeCachedQuery(QueryCache.java:609)
at atg.adapter.gsa.GSAView.executeQuery(GSAView.java:1110)
at atg.adapter.gsa.GSAView.executeQuery(GSAView.java:1049)
at atg.adapter.gsa.GSAView.executeQuery(GSAView.java:897)
at eipf.service.PortalServiceImpl.getListOfServiceEnabled(PortalServiceImpl.java:159)
... 229 more
Caused by: java.sql.SQLException: java.sql.SQLException: ORA-00918: column ambiguously defined
[++SQLQuery++]
SELECT t1.service_id
FROM eipf_service t1, eipf_service_def t2, paf_folder t3, paf_community t4
WHERE t2.service_def_id=t1.SERVICE_DEF_ID
AND t3.folder_id=t2.parent_folder
AND t4.community_id=t1.COMMUNITY_ID
AND ((community_id = ?)
AND (ENABLED = ?)
AND (name = ?)
AND (t2.name = ?))
-- Parameters --
p[1] = {pd: id} re7128002 (java.lang.String)
p[2] = {pd: active} true (java.lang.Boolean)
p[3] = {pd: name} Landing Page (java.lang.String)
p[4] = {pd: name} Cookie Redirect Page (java.lang.String)
[--SQLQuery--]
at atg.adapter.gsa.SQLStatement.executeQuery(SQLStatement.java:613)
at atg.adapter.gsa.GSAItemDescriptor.executeSingleQuery(GSAItemDescriptor.java:8544)
at atg.adapter.gsa.GSAItemDescriptor.executeQuery(GSAItemDescriptor.java:8392)
at atg.adapter.gsa.GSAItemDescriptor.executeQuery(GSAItemDescriptor.java:7334)
... 237 more