Changing the "Folders" Schema Relation from Its Default Values Causes New Local Folder Mapping Exception "!csUnableToExecMethod,schemaCreateNonLoopingPaths!csSystemError" (Doc ID 1097864.1)

Last updated on NOVEMBER 03, 2016

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

Upon attempt to map a local folder via the Folders Administration pages, the mapping fails with the below error. Other aspects of Content Server appear to function as-designed.


<UCM instance node>: helperservice: service exception in
FOLDERSLOCAL.BUILD_MOUNT_SUB[2] -32 schemaCreateNonLoopingPaths -
32 !csUnableToExecMethod,schemaCreateNonLoopingPaths!csSystemError,\!
syServiceRuntime\,java.lang.RuntimeException
at helper.HelperUtils$7.prime(HelperUtils.java:3967)
at helper.HelperUtils$7.hasNext(HelperUtils.java:3882)
at helper.HelperHandler$2.hasNext(HelperHandler.java:2616)
at helper.IteratorResultSet.<init>(IteratorResultSet.java:45)
at helper.HelperHandler.schemaCreateNonLoopingPaths(HelperHandler.java:2612)
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:585)
at intradoc.common.IdcMethodHolder.invokeMethod(ClassHelperUtils.java:617)
at intradoc.common.ClassHelperUtils.executeMethodReportStatus
(ClassHelperUtils.java:293)
at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
at intradoc.server.Service.doCodeEx(Service.java:490)
at intradoc.server.Service.doCode(Service.java:472)
at intradoc.server.ServiceRequestImplementor.doAction
(ServiceRequestImplementor.java:1360)
at intradoc.server.Service.doAction(Service.java:452)
at helper.HelperService.doAction(HelperService.java:757)
at helper.HelperService.doActions10g(HelperService.java:383)
at helper.HelperService.doActions(HelperService.java:119)
at intradoc.server.ServiceRequestImplementor.executeSubServiceCode
(ServiceRequestImplementor.java:1071)
at intradoc.server.Service.executeSubServiceCode(Service.java:3497)
at helper.HelperService.executeSubServiceCode(HelperService.java:1812)
at helper.HelperService.executeServiceEx(HelperService.java:1785)
at intradoc.server.Service.executeService(Service.java:3476)
at intradoc.server.Service.doSubService(Service.java:3465)
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:585)
at intradoc.common.IdcMethodHolder.invokeMethod(ClassHelperUtils.java:617)
at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:279)
at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:264)
at intradoc.server.Service.doCodeEx(Service.java:507)
at intradoc.server.Service.doCode(Service.java:472)
at intradoc.server.ServiceRequestImplementor.doAction
(ServiceRequestImplementor.java:1360)
at intradoc.server.Service.doAction(Service.java:452)
at helper.HelperService.doAction(HelperService.java:757)
at helper.HelperService.doActions10g(HelperService.java:383)
at helper.HelperService.doActions(HelperService.java:119)
at intradoc.server.ServiceRequestImplementor.executeActions
(ServiceRequestImplementor.java:1121)
at intradoc.server.Service.executeActions(Service.java:433)
at intradoc.server.ServiceRequestImplementor.doRequest
(ServiceRequestImplementor.java:635)
at intradoc.server.Service.doRequest(Service.java:1707)
at intradoc.server.ServiceManager.processCommand(ServiceManager.java:359)
at intradoc.server.IdcServerThread.run(IdcServerThread.java:197)
Caused by: java.lang.RuntimeException
at helper.HelperSchemaUtils$1.get(HelperSchemaUtils.java:158)
at helper.HelperUtils$7.prime(HelperUtils.java:3935)
... 44 more
Caused by: intradoc.data.DataException: \\\!csDbUnableToCreateResultSet\\\,SELECT
dCollectionID AS schInternalColumn\\\\\\\, dCollectionName AS
schLabelColumn\\\\\\\, Collections.dCollectionID\\\\\\\,
Collections.dParentCollectionID\\\\\\\, Collections.dCollectionName FROM
DocTypes\\\\\\\, Collections WHERE (Collections.null=685) ORDER BY
dCollectionName ASC\\\!$ORA-01747: invalid user.table.column\\\\\\\,
table.column\\\\\\\, or column specification
at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2371)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:806)
at helper.HelperSchemaUtils$1.get(HelperSchemaUtils.java:154)
... 45 more
Caused by: java.sql.SQLException: ORA-01747: invalid user.table.column\\\,
table.column\\\, or column specification
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe
(OracleStatement.java:1049)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1146)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon
(OracleStatement.java:4098)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery
(OracleStatement.java:4234)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1320)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:786)
... 46 more

Changes

The "Folders" Schema Relation was changed from its default values, or even simply "touched", via the Configuration Manager admin applet.

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