Corrupted Wishlists/Giftlists or Active Promotions List on the Profile (Doc ID 1950363.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Commerce Platform - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

This error is seen:

The data in the dcs_giftlist_item table would also show the problem:

GIFTLIST_IDSEQUENCE_NUMBERGIFTLISTITEM_ID
gl1735256727 58 gi188310224
gl1735256727 59 gi188310225
gl1735256727 60 gi188310386
gl1735256727 94 gi188380566
gl1735256727 95 gi188380567
gl1735256727 96 gi188380568

This is for "gift lists".  This issue may also be seen in the table dcs_usr_actvpromo for the "activePromotions" property.

The problem here is the gap in the sequence_number, which is considered corruption by the Oracle Commerce code and causes the "Error reading list or array index" error shown above.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms