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 APRIL 09, 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
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
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 |