While Trying to Add an Option List for a Custom Metadata Field the Following Error is Returned: Unable to Generate Data from the View '<view_name>'

(Doc ID 1053889.1)

Last updated on FEBRUARY 05, 2018

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.0 to 10.1.3.5.0 [Release 10gR3]
Information in this document applies to any platform.

Symptoms

1. While trying to add an Option List for a custom metadata field the following error is returned:

 

 "Unable to generate data from the view 'drms_casesegmentlist'.

 

 2. A java null pointer exception is generated when the schema is published:

 

Unable to publish the schema. Unable to publish the view 'drms_CaseSegmentList'. Exception type is 'java.lang.NullPointerException'. [ Details ]
An error has occurred. The stack trace below shows more information.

!csSchemaUnableToPublish!csSchemaUnableToPublishView,drms_CaseSegmentList!syExceptionType,java.lang.NullPointerException
intradoc.common.ServiceException: !csSchemaUnableToPublishView,drms_CaseSegmentList
at intradoc.server.schema.StandardSchemaPublisher.publishEntireView(StandardSchemaPublisher.java:550)
at intradoc.server.schema.StandardSchemaPublisher.publishViewValues(StandardSchemaPublisher.java:456)
at intradoc.server.schema.StandardSchemaPublisher.doPublishing(StandardSchemaPublisher.java:331)
at intradoc.server.schema.StandardSchemaPublisherThread.run(StandardSchemaPublisherThread.java:252)
Caused by: java.lang.NullPointerException
at intradoc.data.QueryUtils.createSubclause(QueryUtils.java:215)
at intradoc.server.schema.SchemaUtils.buildSubclause(SchemaUtils.java:243)
at intradoc.server.schema.SchemaUtils.appendBaseWhereClause(SchemaUtils.java:197)
at intradoc.server.schema.SchemaUtils.appendLoadQuery(SchemaUtils.java:670)
at intradoc.server.schema.ServerSchemaLoader.loadAllValues(ServerSchemaLoader.java:550)
at intradoc.shared.schema.SchemaViewData.syncViewValues(SchemaViewData.java:687)
at intradoc.shared.schema.SchemaViewData.getAllViewValuesEx(SchemaViewData.java:241)
at intradoc.shared.schema.SchemaViewData.getAllViewValues(SchemaViewData.java:234)
at intradoc.server.schema.StandardSchemaPublisher.publishEntireView(StandardSchemaPublisher.java:515)

 

 

3. The Columns are missing when editing the Configuration Manager --> Tables --> OptionsList table

 

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