SAP Knowledge Base Article - Preview

2719533 - Side effects of deleting catalogs directly from DB - empty catalog value for catalogVersions table

Symptom

- Backoffice cannot be accessed due to Error 500

- Similar error stacktrace can be found in logs being generated after accessing Backoffice.

INFO | jvm 1 | main | 2018/11/13 12:04:56.407 | SEVERE: Servlet.service() for servlet [zkLoader] in context with path [/backoffice] threw exception
[Error while processing internal filterchain. Exception occurred at chain position: 9 of 10. Current filter: 'DynamicCatalogVersionProcessor[ hashCode: 1415634035 ]'!; nested exception is java.lang.NullPointerException: while trying to invoke the method de.hybris.platform.catalog.model.CatalogModel.getUrlPatterns() of a null object loaded from local variable 'catalog']  with root cause
INFO | jvm 1 | main | 2018/11/13 12:04:56.407 | java.lang.NullPointerException: while trying to invoke the method de.hybris.platform.catalog.model.CatalogModel.getUrlPatterns() of a null object loaded from local variable 'catalog'
INFO | jvm 1 | main | 2018/11/13 12:04:56.407 | at de.hybris.platform.servicelayer.web.DynamicCatalogVersionActivationFilter.filterByURL(DynamicCatalogVersionActivationFilter.java:157)

- In database in table 'CatalogVersion' can be found one or many rows with empty value in mandatory column 'Catalog'.

- Flexible search queries may not work in HAC resulting in error:

INFO | jvm 1 | main | 2018/11/13 13:36:12.605 | [m[33mWARN [hybrisHTTP106] [10.34.20.158] [DefaultHandlerExceptionResolver]
Failed to write HTTP message: org.springframework.http.converter.HttpMessageNotWritableException: Could not write JSON: while trying to invoke the method de.hybris.platform.catalog.model.CatalogModel.getId() of a null object returned from de.hybris.platform.catalog.model.CatalogVersionModel.getCatalog(); nested exception is com.fasterxml.jackson.databind.JsonMappingException: while trying to invoke the method de.hybris.platform.catalog.model.CatalogModel.getId() of a null object returned from de.hybris.platform.catalog.model.CatalogVersionModel.getCatalog() (through reference chain: de.hybris.platform.hac.data.dto.SqlSearchResultData["catalogVersionsAsString"])


Read more...

Environment

n/a

Product

SAP Commerce 1811 ; SAP Hybris Commerce 1808 ; SAP Hybris Commerce 6.0 ; SAP Hybris Commerce 6.1 ; SAP Hybris Commerce 6.2 ; SAP Hybris Commerce 6.3 ; SAP Hybris Commerce 6.4 ; SAP Hybris Commerce 6.5 ; SAP Hybris Commerce 6.6 ; SAP Hybris Commerce 6.7 ; SAP hybris Commerce 5.0.3 ; SAP hybris Commerce 5.0.4 ; SAP hybris Commerce 5.7 ; SAP hybris Commerce Suite 5.2 ; SAP hybris Commerce Suite 5.3 ; SAP hybris Commerce Suite 5.4 ; SAP hybris Commerce Suite 5.5 ; SAP hybris Commerce Suite 5.5-1 ; SAP hybris Commerce Suite 5.6 ; hybris Commerce Suite 4.4 ; hybris Commerce Suite 4.5 ; hybris Commerce Suite 4.6 ; hybris Commerce Suite 4.7 ; hybris Commerce Suite 4.8 ; hybris Commerce Suite 5.0 ; hybris Commerce Suite 5.1 ; hybris Commerce Suite 5.1.1

Keywords

Cleaning inconsistency NullPointerException DynamicCatalogVersionProcessor HttpMessageNotWritableException DynamicCatalogVersionActivationFilter , KBA , CEC-COM-CPS-CAS , CPS Catalog & Sync (SAP Commerce) , CEC-HCS-INF-DBA , HCS Database Administration , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.