Technote

(troubleshooting)
PersistenceObjectNotFoundException occurs referring to PromotionPolicyKey in WebSphere Commerce log file
Problem(Abstract)
You see the following exception in the WebSphere Commerce log file:

[2/17/06 15:12:22:024 EST] d6aec6ce CommerceSrvr E com.ibm.commerce.registry.StoreRegistry find CMN0411E: The following Finder Exception occurred during processing: "javax.ejb.ObjectNotFoundException".
[2/17/06 15:12:22:124 EST] d6aec6ce SystemErr R com.ibm.commerce.marketing.promotion.persistence.PersistenceObjectNotFoundException: com.ibm.commerce.marketing.promotion.policy.PromotionPolicyKey@12891e96
Cause There are invalid values in the <StoreKey> element of the XMLPARAM fields in either the PX_POLICY or PX_GROUP tables. Resolving the problem

  1. Determine the correct values for the <StoreKey> element (see Note on how to determine correct values)

  2. Copy the correct values into the PX_POLICY and PX_GROUP tables

  3. Restart the Commerce server for the changes to take effect.



To determine the correct values for the <DN> and <Identifier> elements within the <StoreKey> element of the XMLPARAM fields for the PX_POLICY and PX_GROUP tables, create a new promotion through WebSphere Commerce Accelerator. The XMLPARAM field in the PX_PROMOTION table for the newly created promotion will contain correct values for the <StoreKey> element. An example of the <StoreKey> element is:

<StoreKey><DN>o=seller organization,o=root organization </DN><Identifier>SampleStore</Identifier></StoreKey>


Special Considerations for Extended Sites:
Note that if this exception occurs with an Extended Sites setup, then there could be multiple <StoreKey> elements for the PX_POLICY and PX_GROUP tables.

In the PX_GROUP table, each <AssociatedPromotionPolicies> <PromotionPolicy> element must have a corresponding entry in the PX_POLICY table. The PX_GROUP table's <StoreKey> must identify the store corresponding to the STOREENT_ID from the PX_POLICY table, and the <PolicyName> must be the same as the NAME field from the PX_POLICY table.

The PX_GRPPOLICY table must also have entries connecting the promotion group to each associated promotion policy.
Cross Reference information
Segment Product Component Platform Version Edition
Commerce WebSphere Commerce Professional Edition Configuration AIX, i5/OS, 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, 6.0.0.4 Professional Edition
Commerce WebSphere Commerce - Express Configuration AIX, i5/OS, 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, 6.0.0.4 Express
Commerce WebSphere Commerce Business Edition Configuration AIX, i5/OS, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3
   

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21234599