Skip to Content
author's profile photo Former Member
Former Member

Sitemap job aborted error

Hi, We use v5.2.0.6 and have an enabled sitemap cronjob to genearete sitemap.xml s. Seems to be caught NPE during job execution. Here are the logs. Where should i look at? Thank you

 16.05.24 16:24:05:376    DEBUG    Starting CronJob koton-SiteMapMediaJob ( job:siteMapMediaJob )
 16.05.24 16:24:05:385    DEBUG    no registered access for de.hybris.platform.jalo.user.Employee.code - trying to find getter/setter via reflection
 16.05.24 16:24:05:385    DEBUG    query = 'SELECT {item:pk} FROM {StoresForCMSSite* AS rel JOIN BaseStore AS item ON {rel:target}={item:pk} } WHERE {rel:qualifier} = ?quali AND {rel:source} = ?item AND {rel:language} IS NULL ORDER BY {rel:sequenceNumber} ASC ,{rel:pk} ASC';signature = '[class de.hybris.platform.store.BaseStore]';principal = 'admin[8796093054980]';lang = '8796093055008';disabled = [R,GR];failOnUnknown=true;dontNeedTotal=true;start=0;count=-1;prefetch=100
 16.05.24 16:24:05:391    DEBUG    no registered access for de.hybris.platform.jalo.user.Employee.code - trying to find getter/setter via reflection
 16.05.24 16:24:05:391    DEBUG    query = 'SELECT {item:pk} FROM {CatalogsForBaseStores* AS rel JOIN Catalog AS item ON {rel:target}={item:pk} } WHERE {rel:qualifier} = ?quali AND {rel:source} = ?item AND {rel:language} IS NULL ORDER BY {rel:sequenceNumber} ASC ,{rel:pk} ASC';signature = '[class de.hybris.platform.catalog.jalo.Catalog]';principal = 'admin[8796093054980]';lang = '8796093055008';disabled = [R,GR];failOnUnknown=true;dontNeedTotal=true;start=0;count=-1;prefetch=100
 16.05.24 16:24:05:392    DEBUG    no registered access for de.hybris.platform.jalo.user.Employee.code - trying to find getter/setter via reflection
 16.05.24 16:24:05:392    DEBUG    query = 'SELECT {item:pk} FROM {CatalogsForCMSSite* AS rel JOIN ContentCatalog AS item ON {rel:target}={item:pk} } WHERE {rel:qualifier} = ?quali AND {rel:source} = ?item AND {rel:language} IS NULL ORDER BY {rel:sequenceNumber} ASC ,{rel:pk} ASC';signature = '[class de.hybris.platform.cms2.jalo.contents.ContentCatalog]';principal = 'admin[8796093054980]';lang = '8796093055008';disabled = [R,GR];failOnUnknown=true;dontNeedTotal=true;start=0;count=-1;prefetch=100
 16.05.24 16:24:05:399    DEBUG    Query preprocessor: userQueryPreprocessor
 16.05.24 16:24:05:399    DEBUG    Query preprocessor: searchRestrictionPreprocessor
 16.05.24 16:24:05:399    DEBUG    Query preprocessor: specificDbLimitSupportQueryPreprocessor
 16.05.24 16:24:05:399    DEBUG    Query preprocessor: localeQueryPreprocessor
 16.05.24 16:24:05:399    DEBUG    Query preprocessor: catalogVersionQueryPreprocessor
 16.05.24 16:24:05:399    DEBUG    no registered access for de.hybris.platform.jalo.user.Employee.code - trying to find getter/setter via reflection
 16.05.24 16:24:05:399    DEBUG    query = 'SELECT {catalogVersion.pk} FROM {CatalogVersion AS catalogVersion JOIN Catalog as catalog ON {catalog.pk}={catalog} } WHERE {catalog.id}=?id AND {catalogVersion.version}=?cv';signature = '[class de.hybris.platform.jalo.Item]';principal = 'admin[8796093054980]';lang = '8796093055008';disabled = [R,GR];failOnUnknown=true;dontNeedTotal=true;start=0;count=-1;prefetch=100
 16.05.24 16:24:05:400    DEBUG    no registered access for de.hybris.platform.jalo.user.Employee.code - trying to find getter/setter via reflection
 16.05.24 16:24:05:400    DEBUG    query = 'SELECT {item:pk} FROM {StoresForCMSSite* AS rel JOIN BaseStore AS item ON {rel:target}={item:pk} } WHERE {rel:qualifier} = ?quali AND {rel:source} = ?item AND {rel:language} IS NULL ORDER BY {rel:sequenceNumber} ASC ,{rel:pk} ASC';signature = '[class de.hybris.platform.store.BaseStore]';principal = 'admin[8796093054980]';lang = '8796093055008';disabled = [R,GR];failOnUnknown=true;dontNeedTotal=true;start=0;count=-1;prefetch=100
 16.05.24 16:24:05:401    DEBUG    no registered access for de.hybris.platform.jalo.user.Employee.code - trying to find getter/setter via reflection
 16.05.24 16:24:05:401    DEBUG    query = 'SELECT {item:pk} FROM {CatalogsForBaseStores* AS rel JOIN Catalog AS item ON {rel:target}={item:pk} } WHERE {rel:qualifier} = ?quali AND {rel:source} = ?item AND {rel:language} IS NULL ORDER BY {rel:sequenceNumber} ASC ,{rel:pk} ASC';signature = '[class de.hybris.platform.catalog.jalo.Catalog]';principal = 'admin[8796093054980]';lang = '8796093055008';disabled = [R,GR];failOnUnknown=true;dontNeedTotal=true;start=0;count=-1;prefetch=100
 16.05.24 16:24:05:405    DEBUG    copyViaSerialization: de.hybris.platform.util.ItemPropertyValueCollection
 16.05.24 16:24:05:418    DEBUG    Query preprocessor: userQueryPreprocessor
 16.05.24 16:24:05:418    DEBUG    Query preprocessor: searchRestrictionPreprocessor
 16.05.24 16:24:05:418    DEBUG    Query preprocessor: specificDbLimitSupportQueryPreprocessor
 16.05.24 16:24:05:418    DEBUG    Query preprocessor: localeQueryPreprocessor
 16.05.24 16:24:05:418    DEBUG    Query preprocessor: catalogVersionQueryPreprocessor
 16.05.24 16:24:05:419    DEBUG    no registered access for de.hybris.platform.jalo.user.Employee.code - trying to find getter/setter via reflection
 16.05.24 16:24:05:419    DEBUG    query = 'SELECT {catalogVersion.pk} FROM {CatalogVersion AS catalogVersion JOIN Catalog as catalog ON {catalog.pk}={catalog} } WHERE {catalog.id}=?id AND {catalogVersion.version}=?cv';signature = '[class de.hybris.platform.jalo.Item]';principal = 'admin[8796093054980]';lang = '8796093055008';disabled = [R,GR];failOnUnknown=true;dontNeedTotal=true;start=0;count=-1;prefetch=100
 16.05.24 16:24:05:422    DEBUG    Query preprocessor: userQueryPreprocessor
 16.05.24 16:24:05:422    DEBUG    Query preprocessor: searchRestrictionPreprocessor
 16.05.24 16:24:05:422    DEBUG    Query preprocessor: specificDbLimitSupportQueryPreprocessor
 16.05.24 16:24:05:422    DEBUG    Query preprocessor: localeQueryPreprocessor
 16.05.24 16:24:05:423    DEBUG    Query preprocessor: catalogVersionQueryPreprocessor
 16.05.24 16:24:05:423    DEBUG    no registered access for de.hybris.platform.jalo.user.Employee.code - trying to find getter/setter via reflection
 16.05.24 16:24:05:423    DEBUG    query = 'SELECT {pk} FROM {ContentPage} WHERE {homepage}=?homepage AND {catalogVersion} in (?catalogVersions)';signature = '[class de.hybris.platform.jalo.Item]';principal = 'admin[8796093054980]';lang = '8796093055008';disabled = [R,GR];failOnUnknown=true;dontNeedTotal=true;start=0;count=-1;prefetch=100
 16.05.24 16:24:05:425    DEBUG    original query='SELECT  item_t0.PK  FROM cmspage item_t0 WHERE ( item_t0.p_homepage =? AND  item_t0.p_catalogversion  in (?,?,?)) AND (item_t0.TypePkString=? )', modified query='SELECT  item_t0.PK  FROM cmspage item_t0 WHERE ( item_t0.p_homepage =? AND  item_t0.p_catalogversion  in (?,?,?)) AND (item_t0.TypePkString=? )', sig=[class de.hybris.platform.util.ItemPropertyValue], values=[true:Class java.lang.Boolean,PropertyValue:8796093186649:Class de.hybris.platform.util.ItemPropertyValue,PropertyValue:8796093219417:Class de.hybris.platform.util.ItemPropertyValue,PropertyValue:8796093153881:Class de.hybris.platform.util.ItemPropertyValue,8796093907026:Class de.hybris.platform.core.PK], , original range=[0,-1], rowcount=0, query=0ms, fetch=0ms
 16.05.24 16:24:05:427    DEBUG    copyViaSerialization: de.hybris.platform.util.ItemPropertyValueCollection
 16.05.24 16:24:05:436    DEBUG    Query preprocessor: userQueryPreprocessor
 16.05.24 16:24:05:436    DEBUG    Query preprocessor: searchRestrictionPreprocessor
 16.05.24 16:24:05:436    DEBUG    Query preprocessor: specificDbLimitSupportQueryPreprocessor
 16.05.24 16:24:05:436    DEBUG    Query preprocessor: localeQueryPreprocessor
 16.05.24 16:24:05:436    DEBUG    Query preprocessor: catalogVersionQueryPreprocessor
 16.05.24 16:24:05:436    DEBUG    no registered access for de.hybris.platform.jalo.user.Employee.code - trying to find getter/setter via reflection
 16.05.24 16:24:05:437    DEBUG    query = 'SELECT {catalogVersion.pk} FROM {CatalogVersion AS catalogVersion JOIN Catalog as catalog ON {catalog.pk}={catalog} } WHERE {catalog.id}=?id AND {catalogVersion.version}=?cv';signature = '[class de.hybris.platform.jalo.Item]';principal = 'admin[8796093054980]';lang = '8796093055008';disabled = [R,GR];failOnUnknown=true;dontNeedTotal=true;start=0;count=-1;prefetch=100
 16.05.24 16:24:05:437    DEBUG    Query preprocessor: userQueryPreprocessor
 16.05.24 16:24:05:437    DEBUG    Query preprocessor: searchRestrictionPreprocessor
 16.05.24 16:24:05:437    DEBUG    Query preprocessor: specificDbLimitSupportQueryPreprocessor
 16.05.24 16:24:05:437    DEBUG    Query preprocessor: localeQueryPreprocessor
 16.05.24 16:24:05:438    DEBUG    Query preprocessor: catalogVersionQueryPreprocessor
 16.05.24 16:24:05:438    DEBUG    no registered access for de.hybris.platform.jalo.user.Employee.code - trying to find getter/setter via reflection
 16.05.24 16:24:05:438    DEBUG    query = 'SELECT {pk} FROM {CatalogVersion*} WHERE {active}=?active ORDER BY {creationtime}';signature = '[class de.hybris.platform.jalo.Item]';principal = 'admin[8796093054980]';lang = '8796093055008';disabled = [R,GR];failOnUnknown=true;dontNeedTotal=true;start=0;count=-1;prefetch=100
 16.05.24 16:24:05:452    FATAL    Caught throwable null
 java.lang.NullPointerException
     at de.hybris.platform.commerceservices.url.impl.DefaultHomepageContentPageUrlResolver.getKey(DefaultHomepageContentPageUrlResolver.java:40)
     at de.hybris.platform.commerceservices.url.impl.DefaultHomepageContentPageUrlResolver.getKey(DefaultHomepageContentPageUrlResolver.java:1)
     at de.hybris.platform.commerceservices.url.impl.AbstractUrlResolver.resolve(AbstractUrlResolver.java:114)
     at de.hybris.platform.acceleratorservices.sitemap.populators.ContentPageModelToSiteMapUrlDataPopulator.populate(ContentPageModelToSiteMapUrlDataPopulator.java:31)
     at de.hybris.platform.acceleratorservices.sitemap.populators.ContentPageModelToSiteMapUrlDataPopulator.populate(ContentPageModelToSiteMapUrlDataPopulator.java:1)
     at de.hybris.platform.converters.impl.AbstractPopulatingConverter.populate(AbstractPopulatingConverter.java:61)
     at de.hybris.platform.commerceservices.converter.impl.AbstractPopulatingConverter.convert(AbstractPopulatingConverter.java:40)
     at de.hybris.platform.converters.Converters.convertAll(Converters.java:63)
     at de.hybris.platform.acceleratorservices.sitemap.generator.impl.HomePageSiteMapGenerator.getSiteMapUrlData(HomePageSiteMapGenerator.java:34)
     at de.hybris.platform.acceleratorservices.sitemap.generator.impl.AbstractSiteMapGenerator$2.execute(AbstractSiteMapGenerator.java:96)
     at de.hybris.platform.acceleratorservices.sitemap.generator.impl.AbstractSiteMapGenerator$2.execute(AbstractSiteMapGenerator.java:1)
     at de.hybris.platform.commerceservices.impersonation.impl.DefaultImpersonationService$1.execute(DefaultImpersonationService.java:82)
     at de.hybris.platform.servicelayer.session.impl.DefaultSessionService.executeInLocalView(DefaultSessionService.java:88)
     at de.hybris.platform.commerceservices.impersonation.impl.DefaultImpersonationService.executeInContext(DefaultImpersonationService.java:72)
     at de.hybris.platform.acceleratorservices.sitemap.generator.impl.AbstractSiteMapGenerator.render(AbstractSiteMapGenerator.java:91)
     at de.hybris.platform.acceleratorservices.cronjob.SiteMapMediaJob.generateSiteMapFiles(SiteMapMediaJob.java:179)
     at de.hybris.platform.acceleratorservices.cronjob.SiteMapMediaJob.perform(SiteMapMediaJob.java:95)
     at de.hybris.platform.acceleratorservices.cronjob.SiteMapMediaJob.perform(SiteMapMediaJob.java:1)
     at de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob.performCronJob(ServicelayerJob.java:38)
     at de.hybris.platform.cronjob.jalo.Job.execute(Job.java:1297)
     at de.hybris.platform.cronjob.jalo.Job.performImpl(Job.java:815)
     at de.hybris.platform.cronjob.jalo.Job.access$1(Job.java:772)
     at de.hybris.platform.cronjob.jalo.Job$JobRunable.run(Job.java:677)
     at de.hybris.platform.util.threadpool.PoolableThread.run(PoolableThread.java:198)
 
 16.05.24 16:24:05:459    DEBUG    setting CronJobResult (status: ABORTED, result: ERROR)
  
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 27, 2016 at 08:24 AM

    It was causing by homePage boolean attribute missing on any existing pages.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi , Did you customize the Home Page generator ? I am using the OOB one and getting the null pointer exception and job is getting aborted.

       java.lang.NullPointerException at de.hybris.platform.commerceservices.url.impl.DefaultHomepageContentPageUrlResolver.getKey(DefaultHomepageContentPageUrlResolver.java:40) at 
      
      

      Can you please share how did you fix your issue ?

      Thank You , Deepti

  • Posted on Jun 07, 2017 at 01:43 PM

    Hi, i had the same issue and solved as follows. Like Mustafa said, my contentPage "homepage" did not have its boolean attribute "homepage" set to true so i set to true in the hmc.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.