Inability To Create Folders in UCM 11g with Folders_g when Using SQL Server (Doc ID 1359449.1)

Last updated on MAY 23, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Symptoms

Using UCM 11g with Microsoft SQL Server 2008r2, and the SQL Server is setup to be case-sensitive.

The Folders_g component was enabled.

The folder configuration is available in the UCM interface. For example, when looking at the administration menu's folder configuration, and clicking on system folder configuration, you  see Trash disabled and Contribution Folders enabled (green button).

However, the enabled folders do not appear in the "Browse Content" dropdown menu.

If you check the database, the Contributions Folder exists. The columns in the database are case-sensitive as expected.

Additionally, when that configuration page is accessed, it sporadically does not work and returns the following error message:

Content Server Request Failed
Error Unable to execute service COLLECTION_GET_ADMIN_MARKED_CONFIG and function loadMarkedCollections.
The error was caused by an internally generated issue. The error has been logged.


Other times it works just fine.

Error
Error 9/6/11 12:26 PM

Event generated by user 'weblogic' at host 'localhost:16200'. Unable to execute service COLLECTION_GET_ADMIN_MARKED_CONFIG and function loadMarkedCollections.
Unable to create the result set for query 'SELECT DNAME from CONFIG WHERE 1=0'. [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'CONFIG'. java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'CONFIG'.. [ Details ]

An error has occurred. The stack trace below shows more information.

!csUserEventMessage,weblogic,localhost:16200!$!csServiceDataException,COLLECTION_GET_ADMIN_MARKED_CONFIG,loadMarkedCollections!$!csDbUnableToCreateResultSet,SELECT DNAME from CONFIG WHERE 1=0!$[FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'CONFIG'.!syJavaExceptionWrapper,java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'CONFIG'.
intradoc.common.ServiceException: !csServiceDataException,COLLECTION_GET_ADMIN_MARKED_CONFIG,loadMarkedCollections!$
*ScriptStack COLLECTION_GET_ADMIN_MARKED_CONFIG
3:loadMarkedCollections,**no captured values**
at intradoc.server.ServiceRequestImplementor.buildServiceException(ServiceRequestImplementor.java:2115)
at intradoc.server.Service.buildServiceException(Service.java:2260)
at intradoc.server.Service.createServiceExceptionEx(Service.java:2254)
at intradoc.server.Service.createServiceException(Service.java:2249)
at intradoc.server.ServiceRequestImplementor.handleActionException(ServiceRequestImplementor.java:1766)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1716)
at intradoc.server.Service.doAction(Service.java:477)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
at intradoc.server.Service.doActions(Service.java:472)
at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391)
at intradoc.server.Service.executeActions(Service.java:458)
at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:737)
at intradoc.server.Service.doRequest(Service.java:1890)
at intradoc.server.ServiceManager.processCommand(ServiceManager.java:435)
at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1343)
at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1715)
at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:222)
at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at idcservlet.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
at idcservlet.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:305)
at idcservlet.common.ClassHelperUtils.executeMethodWithArgs(ClassHelperUtils.java:278)
at idcservlet.ServletUtils.executeContentServerIntegrateMethodOnConfig(ServletUtils.java:1600)
at idcservlet.IdcFilter.doFilter(IdcFilter.java:352)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
Caused by: intradoc.data.DataException: !csDbUnableToCreateResultSet,SELECT DNAME from CONFIG WHERE 1=0!$[FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'CONFIG'.
at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2461)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:791)
at collections.CollectionUserHandler.getRootCollection(CollectionUserHandler.java:256)
at collections.CollectionUserHandler.getRootCollection(CollectionUserHandler.java:238)
at collections.CollectionUserHandler.loadMarkedCollections(CollectionUserHandler.java:3624)
at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324)
at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
at intradoc.server.Service.doCodeEx(Service.java:533)
at intradoc.server.Service.doCode(Service.java:506)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)
at intradoc.server.Service.doAction(Service.java:477)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
at intradoc.server.Service.doActions(Service.java:473)
... 43 more
Caused by: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'CONFIG'.
at weblogic.jdbc.sqlserverbase.dda4.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.dda4.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.dda3.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.dda3.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddm.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddm.t(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddm.d(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddn.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.h(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.v(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.u(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.u(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.u(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeQuery(Unknown Source)
at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:487)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:763)
at collections.CollectionUserHandler.getRootCollection(CollectionUserHandler.java:256)
at collections.CollectionUserHandler.getRootCollection(CollectionUserHandler.java:238)
at collections.CollectionUserHandler.loadMarkedCollections(CollectionUserHandler.java:3623)
at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324)
at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
at intradoc.server.Service.doCodeEx(Service.java:533)
at intradoc.server.Service.doCode(Service.java:505)
... 47 more

Changes

Using Microsoft SQL Server in case-sensitive mode causes this issue.

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