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>'
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)
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