WebSphere Commerce 7 | Management Center | Failed to update/insert Catgroup information from Management Centre

I did some data cleanup activity in my local database for catgroups and after that, I was not able to perform any Catgroup data updates from Management Center. It is throwing the following exception in the console,

[2/5/14 17:11:46:498 IST] 00000039 servlet       E com.ibm.ws.webcontainer.servlet.ServletWrapper service SRVE0068E: Uncaught exception created in one of the service methods of the servlet /jsp/commerce/catalog/restricted/GetCatalogEntryOfferPrice.jsp in application WC. Exception created : com.ibm.websphere.servlet.error.ServletErrorReport: com.ibm.commerce.price.facade.client.PriceListException
    at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:693)
    at com.ibm._jsp._GetCatalogEntryOfferPrice._jspService(_GetCatalogEntryOfferPrice.java:371)
    at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:99)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
    .........
    .........

   
Later, realized few Out of Box entries of CATGROUP & CATGRPTPC was also got deleted as part of cleanup activity. After inserting the missing entries, It started working fine,   
insert into catgroup(catgroup_id, member_id, identifier, markfordelete) values (0, 0, 'group0', 0);
insert into catgrptpc(catalog_id, catgroup_id, tradeposcn_id, store_id) values (10001, 0, 10001, 10051);
insert into catgrptpc(catalog_id, catgroup_id, tradeposcn_id, store_id) values (10001, 0, 10101, 10151);

1 comment:

My Writings........

HCL Commerce v9.1 | Local Store Vs Remote Store

  Local Store Remote Store Project Type Migrated (Lift & Shift) - Newly Imp...