Promotions policy for one group incorrectly applied
to all groups
|
Technote
(troubleshooting)
Problem(Abstract)
|
You create a new promotion, but the promotion appears to
have a policy for another group applied to it. The promotion policy is
evaluated twice, but one time it includes promotions in different groups.
For example, for a shipping promotion policy, with promotions debugging
on, the following appears in the log:
Policy: [Shipping: Any order item can only participate in one promotion]
Applies to:
Promotion[ProductPromo]
Promotion[OrderPromo]
Promotion[ShippingPromo]
Policy: [Shipping: Any order item can only participate in one promotion]
Applies to:
Promotion[ShippingPromo]
|
Cause
|
The promotion policy to group relationships are incorrect.
One probable cause of this is that a PX_POLICY or PX_GROUP entry was
deleted, then recreated manually. PX_GRPPOLICY has a CASCADE constraint
defined on PX_POLICY_ID and PX_GROUP_ID, so the association would be lost
from the delete.
With the group to policy association corrupted, the promotions engine
defaults to applying the policy to all groups.
|
Resolving the
problem
|
Manually go through your PX_POLICY and PX_GROUP tables,
and ensure that each group is associated with the policies created for
that group.
|
|
|
Cross Reference information
|
Segment
| Product
| Component
| Platform
| Version
| Edition
|
Commerce
| WebSphere Commerce Business Edition
| | AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux
zSeries, Solaris, Windows
| 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3
| |
|
Current web document: http://www.ibm.com/support/docview.wss?uid=swg21286383
|