ProductDisplay.jsp page results in error after removing catentry record Technote
(troubleshooting)Problem(Abstract) When you remove the catentry record with catentry_id=0 from the catentry table, you cannot view the ProductDisplay.jsp page and it results in a Generic Error Page.
If you view the source of the return HTML it contains this exception:
Exception Type: 1
Message Key: _ERR_PROD_NOT_EXISTING
Message: CMN3101E The system is unavailable due to "CMN1032E".
System Message: Product "10001" does not exist.
Originating Command:
Corrective Action:Cause When catentry_id=0 was removed from the catentry table, this cascaded a delete command into the attrvalue table, causing it to remove all product attribute data associated with it. All products will now have non-existing descriptions, causing the failure. Resolving the problem To recover the missing attribute data, restore the database from a backup copy.
Cross Reference information
Segment Product Component Platform Version Edition Commerce WebSphere Commerce Enterprise Implementation / Usage AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, Solaris, Windows 6.0 Commerce WebSphere Commerce Business Edition General AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, Solaris, Windows 5.6, 5.6.1 Business Edition Commerce WebSphere Commerce Professional Edition General AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, Solaris, Windows 5.6, 5.6.1, 6.0 Professional Edition
Document Information Current web document: http://www.ibm.com/support/docview.wss?uid=swg21252744