My Oracle Support Banner

WCC 11.1.1.8 - Error with View After Removing a Column in a Table (Doc ID 1910760.1)

Last updated on NOVEMBER 12, 2024

Applies to:

Oracle WebCenter Content - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Symptoms

 

Reproduce the error in the Configuration Manager applet:
1. Create a new table: TestTable1
  A. Add new columns Testcolumn1, Testcolumn2
2. Create a new View: TestView1
  A. Select TestTable1 > Check both columns Testcolumn1, Testcolumn2 > Finish
  B. View Name and Description: TestView1
3. Go to the Views > select TestView1 > Edit Values... > Add... > Enter: One, Two > OK > Close
4. Go to Options > Publish schema.  It publishes without a problem.
5. Go to Tables > Select TestTable1 > Edit Table > Select Testcolumn1 > Delete > OK.
6. Go to the Views > Edit Values...
7. The error is displayed:

Unable to get edit information for view 'TestView1'. The view column field 'Testcolumn1' in the table 'TestTable1' for the view 'TestView1' is missing. Please reconfigure the view 'TestView1' with respect to the table.

 

Changes

 A columns ws removed in a table.  The view was using the column to generate values.

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.