My Oracle Support Banner

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 JANUARY 05, 2023

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.