[opencms-dev] lists not functioning post upgrading from opencms 10.0 to 11.0

Gratian Francis gfrancis2 at cancercare.mb.ca
Thu Sep 26 21:38:09 CEST 2019 

Thanks Daniel,

Deleting all the subfolders in the WEB-INF/index folder then rebuilding the search indexes solved the issue. 

Gratian Francis
Junior Programmer Analyst
CancerCare Manitoba
CC40-825 Sherbrook Street
Winnipeg, MB R3A 1M5
Cell: 204-794-1230
gfrancis2 at cancercare.mb.ca



Planned Absences 2019:
July 2nd
July 19th 
Afternoon of August 30th
October 18th to November 1st

-----Original Message-----
From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Daniel Seidel
Sent: Thursday, September 26, 2019 6:53 AM
To: opencms-dev at opencms.org
Subject: Re: [opencms-dev] lists not functioning post upgrading from opencms 10.0 to 11.0

Hi Gratian,

not sure this will solve your issue, but try to delete the subfolders of 
{webapp home}/WEB-INF/index and then rebuild the search indexes.

Best, Daniel

Am 24.09.19 um 17:44 schrieb Gratian Francis:
> So from looking more into it, it seems my lists issue isn't necessarily due to the lists but due something wrong with the search, when using the list app in version 11, I get the following error message say that the execution of my query failed
>
> Execution of query "q={!tag=q type=edismax qf="content_en Title_prop Description_dprop Description.html_dprop spell"}*&fl=path,instancedate_en_dt,instancedateend_en_dt,instancedatecurrenttill_en_dt,id,solr_id,disptitle_en_sort,link,type&qt=edismax&rows=400&fq=expired:[NOW TO *]&fq=released:[* TO NOW]&fq=parent-folders:("/")&fq=type:("jobposts")&fq=search_exclude:"false"&TZ=America/Winnipeg&start=0&sort=instancedate_en_dt asc&facet=true&facet.field={!key=parent-folders facet.mincount=1 facet.limit=200 facet.sort=index ex=parent-folders,category_exact,instancedate,q}parent-folders&facet.field={!key=category_exact facet.mincount=1 facet.limit=200 facet.sort=index ex=parent-folders,category_exact,instancedate,q}category_exact&facet.range={!key=instancedate facet.range.start=NOW/YEAR-20YEARS facet.range.end=NOW/MONTH 2YEARS facet.range.gap= 1MONTHS facet.range.hardend=false facet.mincount=1 ex=parent-folders,category_exact,instancedate,q}instancedate_en_dt" failed.
>
> org.opencms.search.CmsSearchException: Execution of query "q={!tag=q type=edismax qf="content_en Title_prop Description_dprop Description.html_dprop spell"}*&fl=path,instancedate_en_dt,instancedateend_en_dt,instancedatecurrenttill_en_dt,id,solr_id,disptitle_en_sort,link,type&qt=edismax&rows=400&fq=expired:[NOW TO *]&fq=released:[* TO NOW]&fq=parent-folders:("/")&fq=type:("jobposts")&fq=search_exclude:"false"&TZ=America/Winnipeg&start=0&sort=instancedate_en_dt asc&facet=true&facet.field={!key=parent-folders facet.mincount=1 facet.limit=200 facet.sort=index ex=parent-folders,category_exact,instancedate,q}parent-folders&facet.field={!key=category_exact facet.mincount=1 facet.limit=200 facet.sort=index ex=parent-folders,category_exact,instancedate,q}category_exact&facet.range={!key=instancedate facet.range.start=NOW/YEAR-20YEARS facet.range.end=NOW/MONTH 2YEARS facet.range.gap= 1MONTHS facet.range.hardend=false facet.mincount=1 ex=parent-folders,category_exact,instancedate,q}instancedate_en_dt" failed.
> 	at org.opencms.search.solr.CmsSolrIndex.search(CmsSolrIndex.java:1265)
> 	at org.opencms.search.solr.CmsSolrIndex.search(CmsSolrIndex.java:800)
> 	at org.opencms.search.solr.CmsSolrIndex.search(CmsSolrIndex.java:772)
> 	at org.opencms.ui.apps.lists.CmsListManager.executeSearch(CmsListManager.java:2114)
> 	at org.opencms.ui.apps.lists.CmsListManager.search(CmsListManager.java:1597)
> 	at org.opencms.ui.apps.lists.CmsListManager.search(CmsListManager.java:1537)
> 	at org.opencms.ui.apps.lists.CmsListManager.getComponentForState(CmsListManager.java:1658)
> 	at org.opencms.ui.apps.A_CmsWorkplaceApp.openSubView(A_CmsWorkplaceApp.java:297)
> 	at org.opencms.ui.apps.A_CmsWorkplaceApp.onStateChange(A_CmsWorkplaceApp.java:283)
> 	at org.opencms.ui.apps.lists.CmsListManager.onStateChange(CmsListManager.java:1463)
> 	at org.opencms.ui.apps.CmsAppView.enter(CmsAppView.java:240)
> 	at org.opencms.ui.apps.CmsAppView.enter(CmsAppView.java:253)
> 	at com.vaadin.navigator.Navigator.performNavigateTo(Navigator.java:778)
> 	at com.vaadin.navigator.Navigator.lambda$navigateTo$9a874efd$1(Navigator.java:702)
> 	at com.vaadin.navigator.ViewBeforeLeaveEvent.navigate(ViewBeforeLeaveEvent.java:54)
> 	at com.vaadin.navigator.View.beforeLeave(View.java:79)
> 	at com.vaadin.navigator.Navigator.runAfterLeaveConfirmation(Navigator.java:730)
> 	at com.vaadin.navigator.Navigator.navigateTo(Navigator.java:701)
> 	at org.opencms.ui.apps.CmsAppNavigator.navigateTo(CmsAppNavigator.java:65)
> 	at com.vaadin.navigator.Navigator.navigateTo(Navigator.java:678)
> 	at org.opencms.ui.apps.CmsAppWorkplaceUi.showApp(CmsAppWorkplaceUi.java:492)
> 	at org.opencms.ui.actions.CmsDisplayAction.executeAction(CmsDisplayAction.java:75)
> 	at org.opencms.ui.components.CmsFileTable.handleFileItemClick(CmsFileTable.java:957)
> 	at org.opencms.ui.components.CmsFileTable$2.itemClick(CmsFileTable.java:393)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:498)
> 	at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:499)
> 	at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:273)
> 	at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:237)
> 	at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1014)
> 	at com.vaadin.v7.ui.Table.handleClickEvent(Table.java:3118)
> 	at com.vaadin.v7.ui.Table.changeVariables(Table.java:2912)
> 	at com.vaadin.server.communication.ServerRpcHandler.changeVariables(ServerRpcHandler.java:625)
> 	at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:471)
> 	at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:414)
> 	at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:274)
> 	at com.vaadin.server.communication.UidlRequestHandler.synchronizedHandleRequest(UidlRequestHandler.java:90)
> 	at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:40)
> 	at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1602)
> 	at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:445)
> 	at org.opencms.main.CmsUIServlet.service(CmsUIServlet.java:328)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> 	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> 	at org.opencms.main.OpenCmsUrlServletFilter.doFilter(OpenCmsUrlServletFilter.java:132)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
> 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
> 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
> 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
> 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
> 	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
> 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
> 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
> 	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394)
> 	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
> 	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
> 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
> 	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
> 	at java.lang.Thread.run(Thread.java:748)
> Caused by: java.lang.NullPointerException
> 	at org.opencms.search.solr.CmsSolrIndex.search(CmsSolrIndex.java:996)
> 	... 68 more
>
>
> I've tried rebuilding the index, and when trying site search/search configuration I get the following message:
>
>
> The search failed. Possibly because of an erroneous final search query.
>
> Your original query test was transformed to {!tag=q}content_en:test OR content_de:test OR spell:test OR Title_prop:test.
>
>
> Not sure what in solr is failing or how the query is being transformed causing it to fail.
>
>
> Gratian Francis
> Junior Programmer Analyst
> CancerCare Manitoba
> CC40-825 Sherbrook Street
> Winnipeg, MB R3A 1M5
> Cell: 204-794-1230
> gfrancis2 at cancercare.mb.ca
>
>
>
> Planned Absences 2019:
> July 2nd
> July 19th
> Afternoon of August 30th
> October 18th to November 1st
>
> -----Original Message-----
> From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Gratian Francis
> Sent: Thursday, September 05, 2019 8:54 AM
> To: opencms-dev at opencms.org
> Subject: Re: [opencms-dev] lists not functioning post upgrading from opencms 10.0 to 11.0
>
> Yes I rebuilt the search indexes as per the instructions the in upgrade readme, also rebuilt them after seeing the broken lists and rebuilding them had no effect.
>
> Gratian Francis
> Junior Programmer Analyst
> CancerCare Manitoba
> CC40-825 Sherbrook Street
> Winnipeg, MB R3A 1M5
> Cell: 204-794-1230
> gfrancis2 at cancercare.mb.ca
>
>
>
> Planned Absences 2019:
> July 2nd
> July 19th
> Afternoon of August 30th
>
> -----Original Message-----
> From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Tobias Herrmann
> Sent: Thursday, September 05, 2019 1:13 AM
> To: opencms-dev at opencms.org
> Subject: Re: [opencms-dev] lists not functioning post upgrading from opencms 10.0 to 11.0
>
> Hi,
>
> try rebuilding the search indexes. The SOLR and Lucene search engine has
> been updated in OpenCms 11 and requires an index rebuild.
>
>
> Kind regards,
>
> Tobias
>
> -------------------
>
> Tobias Herrmann
>
> Alkacon Software GmbH & Co. KG  - The OpenCms Experts
> http://www.alkacon.com - http://www.opencms.org
> Am 04.09.19 um 21:41 schrieb Gratian Francis:
>> Hi List,
>>
>> I recently upgraded my site from opencms 10.0 to 11, the upgrade seemed
>> to have gone smoothly however we quickly noticed that none of our lists
>> and detail pages seem to work anymore.
>>
>> In place of our lists we received the following error message:
>>
>> Container-page element "/general-info/.content/my-lists/l_00001.xml"
>> could not be rendered with formatter
>> "/system/modules/my.ccmb.template.formatters/formatters/list.jsp".
>>
>> javax.servlet.jsp.JspException: javax.servlet.ServletException:
>> javax.servlet.jsp.JspException: org.apache.jasper.JasperException:
>> /WEB-INF/jsp/offline/system/modules/my.ccmb.template.formatters/elements/list/new.jsp
>> (line: [6], column: [26]) The attribute prefix [fn] does not correspond
>> to any imported tag library
>>
>> after looking at the error we tried adding the tag library to new.jsp as
>> follows:
>>
>> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
>>
>> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
>>
>> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
>>
>> This seem to have worked as the list's html was rendered however the
>> list is not populating with intended content types and remains empty.
>>
>> The list formatters and resources are from a cloned and edited verison
>> of the opencms 10 apollo modules,
>>
>> Is there some step I missed in the upgrade process or is there another
>> process to updating the lists from opencms 10 to the lists in opencms 11
>>
>> *Gratian Francis*
>>
>> Junior Programmer Analyst
>>
>> CancerCare Manitoba
>>
>> CC40-825 Sherbrook Street
>>
>> Winnipeg, MB R3A 1M5
>>
>> Cell: 204-794-1230
>>
>> gfrancis2 at cancercare.mb.ca <mailto:gfrancis2 at cancercare.mb.ca>
>>
>> CCMB-transparent-small
>>
>> *Planned Absences 2019:*
>>
>> *July 2^nd*
>>
>> *July 19^th *
>>
>> *Afternoon of August 30^th *
>>
>>
>> This email and/or any documents in this transmission is intended for the
>> addressee(s) only and may contain legally privileged or confidential
>> information.  Any unauthorized use, disclosure, distribution, copying or
>> dissemination is strictly prohibited.  If you receive this transmission
>> in error, please notify the sender immediately and return the original.
>>
>> Ce courriel et tout document dans cette transmission est destiné à la
>> personne ou aux personnes à qui il est adressé. Il peut contenir des
>> informations privilégiées ou confidentielles. Toute utilisation,
>> divulgation, distribution, copie, ou diffusion non autorisée est
>> strictement défendue. Si vous n'êtes pas le destinataire de ce message,
>> veuillez en informer l'expéditeur immédiatement et lui remettre l'original.
>>
>>
>> _______________________________________________
>> This mail is sent to you from the opencms-dev mailing list
>> To change your list options, or to unsubscribe from the list, please visit
>> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>>
>>
>>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
> This email and/or any documents in this transmission is intended for the addressee(s) only and may contain legally privileged or confidential information.  Any unauthorized use, disclosure, distribution, copying or dissemination is strictly prohibited.  If you receive this transmission in error, please notify the sender immediately and return the original.
>
> Ce courriel et tout document dans cette transmission est destiné à la personne ou aux personnes à qui il est adressé. Il peut contenir des informations privilégiées ou confidentielles. Toute utilisation, divulgation, distribution, copie, ou diffusion non autorisée est strictement défendue. Si vous n'êtes pas le destinataire de ce message, veuillez en informer l'expéditeur immédiatement et lui remettre l'original.
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
> This email and/or any documents in this transmission is intended for the addressee(s) only and may contain legally privileged or confidential information.  Any unauthorized use, disclosure, distribution, copying or dissemination is strictly prohibited.  If you receive this transmission in error, please notify the sender immediately and return the original.
>
> Ce courriel et tout document dans cette transmission est destiné à la personne ou aux personnes à qui il est adressé. Il peut contenir des informations privilégiées ou confidentielles. Toute utilisation, divulgation, distribution, copie, ou diffusion non autorisée est strictement défendue. Si vous n'êtes pas le destinataire de ce message, veuillez en informer l'expéditeur immédiatement et lui remettre l'original.
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
-- 
Kind Regards,
Daniel.
  
-------------------

Daniel Seidel

Alkacon Software GmbH & Co. KG - The OpenCms Experts
http://www.alkacon.com - http://www.opencms.org


_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev



This email and/or any documents in this transmission is intended for the addressee(s) only and may contain legally privileged or confidential information.  Any unauthorized use, disclosure, distribution, copying or dissemination is strictly prohibited.  If you receive this transmission in error, please notify the sender immediately and return the original.

Ce courriel et tout document dans cette transmission est destiné à la personne ou aux personnes à qui il est adressé. Il peut contenir des informations privilégiées ou confidentielles. Toute utilisation, divulgation, distribution, copie, ou diffusion non autorisée est strictement défendue. Si vous n'êtes pas le destinataire de ce message, veuillez en informer l'expéditeur immédiatement et lui remettre l'original.

More information about the opencms-dev mailing list