Mixed Case Table Columns Cause Schema Exception "csSchViewColumnsMissing" Post Migration to Another Instance
(Doc ID 451086.1)
Last updated on APRIL 10, 2024
Applies to:
Oracle WebCenter Content - Version 7.5.1 to 10.1.3.5.0 [Release Stellent to 10gR3]Information in this document applies to any platform.
Symptoms
The below exception is thrown after you migrated Schema Tables and Views from an older version of Content Server into a newer version (typically 7.1.1 to 7.5.x, or 7.5.x to 10g) and attempted to edit a migrated Table's values
!csSchViewColumnsMissing,DTOPICNAME,TestOneView,TESTONE-exception stack
intradoc.data.DataException: !csSchViewColumnsMissing,DTOPICNAME,TestOneView,TESTONE
at intradoc.server.schema.SchemaUtils.buildViewFields(Unknown Source)
at intradoc.server.SchemaService.computeViewResultSet(Unknown Source)
at intradoc.server.SchemaService.retrieveViewValues(Unknown Source)
at intradoc.server.SchemaService.getSchemaViewInfo(Unknown Source)
at intradoc.server.SchemaService.getViewEditInfo(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at intradoc.server.Service.doCodeEx(Unknown Source)
at intradoc.server.Service.doCode(Unknown Source)
at intradoc.server.Service.doAction(Unknown Source)
at intradoc.server.Service.doActions(Unknown Source)
at intradoc.server.Service.doRequest(Unknown Source)
at intradoc.server.ServiceManager.processCommand(Unknown Source)
at intradoc.server.IdcServerThread.run(Unknown Source)
intradoc.data.DataException: !csSchViewColumnsMissing,DTOPICNAME,TestOneView,TESTONE
at intradoc.server.schema.SchemaUtils.buildViewFields(Unknown Source)
at intradoc.server.SchemaService.computeViewResultSet(Unknown Source)
at intradoc.server.SchemaService.retrieveViewValues(Unknown Source)
at intradoc.server.SchemaService.getSchemaViewInfo(Unknown Source)
at intradoc.server.SchemaService.getViewEditInfo(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at intradoc.server.Service.doCodeEx(Unknown Source)
at intradoc.server.Service.doCode(Unknown Source)
at intradoc.server.Service.doAction(Unknown Source)
at intradoc.server.Service.doActions(Unknown Source)
at intradoc.server.Service.doRequest(Unknown Source)
at intradoc.server.ServiceManager.processCommand(Unknown Source)
at intradoc.server.IdcServerThread.run(Unknown Source)
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 |
| Cause |
| Solution |