My Oracle Support Banner

Unable to Remove Some Images from Collections with "ORA-02292: integrity constraint (XXXXX_ADMINCAT.CC_CAT_IMAGES2_F) violated - child record found" Error (Doc ID 2439000.1)

Last updated on AUGUST 24, 2018

Applies to:

Oracle Commerce Cloud Service - Version N/A and later
Information in this document applies to any platform.
Reported Version: 18.2.0.1

Symptoms

Unable to remove images from some collections. The following error is displayed on Admin UI.

Reproducible Steps:
1 In occs-admin, go to Catalog
2 Right click on the problem collection and Edit
3 Open 'Media' tab
4. Hover over the problem image and press 'x' to remove image.
5. "Remove Images" warming message is displayed, press 'Remove'  --> The error occurs.

Changes

The environment was upgraded to 18B recently.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.