'Product "12345" does not exist.javax.ejb.ObjectNotFoundException' when hitting Product Display in WebSphere Commerce Technote
(troubleshooting)Problem(Abstract) You cannot access the ProductDisplay page in WebSphere Commerce for any category of a particular store. It gives a Generic Error page. Viewing the source code of the HTML at the bottom of the Generic Error page source shows an exception similar to: Product "12345" does not exist.javax.ejb.ObjectNotFoundException Symptom In the SystemOut.log you see an exception similar to:
[1/5/06 16:46:31:948 CST] 336181c3 CommerceSrvr E
com.ibm.commerce.catalog.commands.ProductDisplayCmdImpl performExecute
CMN1032E: Product "43602" does not exist.javax.ejb.ObjectNotFoundException
at
com.ibm.commerce.catalog.objects.EJSJDBCPersisterCMPProductPageRelationBean 57d67083.findByStoreCatEntryMemberGroupLanguageId( EJSJDBCPersisterCMPProductPageRelationBean_57d67083.java:474)
at
com.ibm.commerce.catalog.objects.EJSCMPProductPageRelationHomeBean 57d67083.findByStoreCatEntryMemberGroupLanguageId( EJSCMPProductPageRelationHomeBean_57d67083.java:81)
at
com.ibm.commerce.catalog.objects.EJSRemoteCMPProductPageRelationHome 57d67083.findByStoreCatEntryMemberGroupLanguageId( EJSRemoteCMPProductPageRelationHome_57d67083.java:146)Cause The root cause of the problem is an exception coming from the ProductPageRelationAccessBean.findByStoreCatEntryMemberGroupLanguageId() method.
This access bean corresponds to the DISPENTREL database table. This table holds the page names used to display CatalogEntries.
If there is no entry in the DISPENTREL table that matches the given criteria when trying to display the product, the above exception will occur.Resolving the problem At least one entry needs to be in the DISPENTREL for any given CATENTRY_ID and STORE_ID combination. While you can specify a different JSP to be used for each product/item, a single entry with CATENTRY_ID = 0 can also be used to indicate that all products for a specified store will use the same JSP. For the store that the exception is occurring in, either add an entry for each product catentry (CATENTRY_ID) in the catalog, or define a default entry for all categories with CATENTRY_ID = 0 if they will all share the same JSP file.
Cross Reference information
Segment Product Component Platform Version Edition Commerce WebSphere Commerce Enterprise Configuration AIX, Linux, Solaris, Windows 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3 Commerce WebSphere Commerce Business Edition Configuration AIX, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3 Business Edition Commerce WebSphere Commerce - Express Configuration AIX, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3 Express Commerce WebSphere Commerce Professional Edition Configuration AIX, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3 Professional Edition Commerce WebSphere Commerce Developer Enterprise Configuration AIX, Linux, Solaris, Windows 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3 Commerce WebSphere Commerce Developer Business Edition Configuration AIX, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3 Developer Business Edition Commerce WebSphere Commerce Developer Professional Edition Configuration AIX, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 6.0 Developer Professional Edition Commerce WebSphere Commerce Developer Express Configuration AIX, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3 Developer Express
Document Information Current web document: http://www.ibm.com/support/docview.wss?uid=swg21285771