Showing posts with label Category data fails to save in Management Center. Show all posts
Showing posts with label Category data fails to save in Management Center. Show all posts

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);

My Writings........

Salesforce | Administration | Email-to-Case | Create Cases using Email-to-Case

Email to Case Setup ·        Click on Email-to-Case ·         Enable the following flags, ·        Provide the Routing Addres...