Adobe Experience Manager Sites & More

rahuls80678827 · 8/3/18

Hello Everyone,

I am facing below issue in AEM 6.3 Server:

Here, I have written XPATH query to read the store nodes from JCR and do the processing accordingly

private static final String STORE_LOOKUP_QUERY = "/jcr:root/content/data/stores/%s/%s/%s/%s//*[@sling:resourceType='consumer/common/store']";

String query = String.format(STORE_LOOKUP_QUERY, country, state, city, storeName);

logger.info("Query for searching store is:::" + query);

Iterator<Resource> it = request.getResourceResolver().findResources(query, XPATH);

I am getting below error for the nodes which starts with "numeric" and which have "&" character in the node name in JCR. Some of the examples are:

106-street-tire-and-wheel-21072

3-j-s-discount-21500

1st-tire-wheel-14574

best-one-&-service-of-bryan

Here, the problem is.. These nodes have been deleted from AEM now but for these nodes we are getting 500 errors in the Google Search Console instead of 404 errors.

Could anyone please suggest to fix these issue So, that we get 404 error instead of 500 errors for these type of nodes -

03.08.2018 03:09:58.272 *INFO* [103.81.79.35 [1533280198270] GET /bin/consumer/api/v1/stores/storedata.es_va_galax_county-&-automotive-service.html HTTP/1.1] com.consumer.api.v1.stores.StorePopulationServlet Query for searching store is:::/jcr:root/content/data/stores/us/va/galax/county-&-automotive-service//*[@sling:resourceType='consumer/common/store']

03.08.2018 03:09:58.275 *ERROR* [103.81.79.35 [1533280198270] GET /bin/consumer/api/v1/stores/storedata.es_va_galax_county-&-automotive-service.html HTTP/1.1] org.apache.sling.engine.impl.SlingRequestProcessorImpl service: Uncaught SlingException

javax.jcr.query.InvalidQueryException: java.text.ParseException: Query:

/jcr:root/content/data/stores/us/va/galax/twin-county-tire-&-(*)automotive-service//*[@sling:resourceType='consumer/common/store']; expected: <end>

at org.apache.jackrabbit.oak.jcr.query.QueryManagerImpl.executeQuery(QueryManagerImpl.java:148)

at org.apache.jackrabbit.oak.jcr.query.QueryImpl$2.perform(QueryImpl.java:104)

at org.apache.jackrabbit.oak.jcr.query.QueryImpl$2.perform(QueryImpl.java:100)

at org.apache.jackrabbit.oak.jcr.delegate.SessionDelegate.perform(SessionDelegate.java:208)

at org.apache.jackrabbit.oak.jcr.query.QueryImpl.execute(QueryImpl.java:99)

at org.apache.sling.jcr.resource.internal.helper.JcrResourceUtil.query(JcrResourceUtil.java:56)

at org.apache.sling.jcr.resource.internal.helper.jcr.BasicQueryLanguageProvider.findResources(BasicQueryLanguageProvider.java:80)

at org.apache.sling.resourceresolver.impl.providers.stateful.AuthenticatedResourceProvider.findResources(AuthenticatedResourceProvider.java:260)

at org.apache.sling.resourceresolver.impl.helper.ResourceResolverControl.findResources(ResourceResolverControl.java:456)

at org.apache.sling.resourceresolver.impl.ResourceResolverImpl.findResources(ResourceResolverImpl.java:734)

at com.api.v1.stores.StorePopulationServlet.getStore(StorePopulationServlet.java:181)

at com.api.v1.stores.StorePopulationServlet.doGet(StorePopulationServlet.java:105)

at org.apache.sling.api.servlets.SlingSafeMethodsServlet.mayService(SlingSafeMethodsServlet.java:270)

at org.apache.sling.api.servlets.SlingSafeMethodsServlet.service(SlingSafeMethodsServlet.java:346)

at org.apache.sling.api.servlets.SlingSafeMethodsServlet.service(SlingSafeMethodsServlet.java:378)

at org.apache.sling.engine.impl.request.RequestData.service(RequestData.java:552)

at org.apache.sling.engine.impl.filter.SlingComponentFilterChain.render(SlingComponentFilterChain.java:44)

at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:77)

at com.day.cq.wcm.core.impl.WCMDebugFilter.doFilter(WCMDebugFilter.java:156)