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