Error (SQL) When Using Folder Migration Utility in UCM after11g Update (Doc ID 1461583.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 11.1.1.6.0 version, Content Server

When attempting to migrate contribution folders from folders_g to framework folders using the folders migration utility, migration fails and the following error occurs:
the following error occurs.

ERROR
-----------------------
!$Exception occured during migration!csDbUnableToExecuteSql,INSERT INTO FolderFolders (fFolderGUID\, fParentGUID\, fFolderName\, fInhibitPropagation\, fPromptForMetadata\, fIsContribution\, fTargetGUID\, fApplication\, fOwner\, fCreator\, fLastModifier\, fCreateDate\, fLastModifiedDate\,fSecurityGroup\, fDocAccount\, fClbraUserList\, fClbraAliasList\, fClbraRoleList ) SELECT F.fFolderGUID AS fFolderGUID\,P.fFolderGUID AS fParentGUID\,dCollectionName AS fFolderName\,case xForceFolderSecurity WHEN 'TRUE' THEN case xInhibitUpdate WHEN 'TRUE' THEN 17 ELSE 1END ELSE 17 END AS fInhibitPropagation\,dPromptForMetadata AS fPromptForMetadata\,case WHEN xReadOnly <> N'TRUE' THEN 1 WHEN xReadOnly IS NULL THEN 1 ELSE 0 END AS fIsContribution\, NULL AS fTargetGUID\,N'framework' AS fApplication\,COALESCE(dCollectionOwner\, dCollectionCreator\, dCollectionModifier\,N'weblogic') AS fOwner\,COALESCE(dCollectionCreator\, dCollectionOwner\, dCollectionModifier\,N'weblogic') AS fCreator\,COALESCE(dCollectionModifier\, dCollectionCreator\, dCollectionOwner\,N'weblogic') AS fLastModifier\,COALESCE (dCreateDate\, GetDate()) AS fCreateDate\,COALESCE (dLastModifiedDate\, GetDate()) AS fLastModifiedDate\,dSecurityGroup AS fSecurityGroup\,dDocAccount AS fDocAccount\,N'' AS fClbraUserList\,N'' AS fClbraAliasList\, N'' AS fClbraRoleList FROM Collections\, ColMeta\, FolderMigrationLegacyMappings F\, FolderMigrationLegacyMappings P WHERE Collections.dCollectionID=F.dCollectionID AND ColMeta.dCollectionID=F.dCollectionID AND F.dMigrationRun=0 AND Collections.dParentCollectionID=P.dCollectionID AND P.dMigrationRun=0 AND dSecurityGroup IS NOT NULL AND LEN(dSecurityGroup) > 0!$[FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'ND'.!syJavaExceptionWrapper,java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'ND'.
intradoc.data.DataException: !csDbUnableToExecuteSql,INSERT INTO FolderFolders (fFolderGUID\, fParentGUID\, fFolderName\, fInhibitPropagation\, fPromptForMetadata\, fIsContribution\, fTargetGUID\, fApplication\, fOwner\, fCreator\, fLastModifier\, fCreateDate\, fLastModifiedDate\,fSecurityGroup\, fDocAccount\, fClbraUserList\, fClbraAliasList\, fClbraRoleList ) SELECT F.fFolderGUID AS fFolderGUID\,P.fFolderGUID AS fParentGUID\,dCollectionName AS fFolderName\,case xForceFolderSecurity WHEN 'TRUE' THEN case xInhibitUpdate WHEN 'TRUE' THEN 17 ELSE 1END ELSE 17 END AS fInhibitPropagation\,dPromptForMetadata AS fPromptForMetadata\,case WHEN xReadOnly <> N'TRUE' THEN 1 WHEN xReadOnly IS NULL THEN 1 ELSE 0 END AS fIsContribution\, NULL AS fTargetGUID\,N'framework' AS fApplication\,COALESCE(dCollectionOwner\, dCollectionCreator\, dCollectionModifier\,N'weblogic') AS fOwner\,COALESCE(dCollectionCreator\, dCollectionOwner\, dCollectionModifier\,N'weblogic') AS fCreator\,COALESCE(dCollectionModifier\, dCollectionCreator\, dCollectionOwner\,N'weblogic') AS fLastModifier\,COALESCE (dCreateDate\, GetDate()) AS fCreateDate\,COALESCE (dLastModifiedDate\, GetDate()) AS fLastModifiedDate\,dSecurityGroup AS fSecurityGroup\,dDocAccount AS fDocAccount\,N'' AS fClbraUserList\,N'' AS fClbraAliasList\, N'' AS fClbraRoleList FROM Collections\, ColMeta\, FolderMigrationLegacyMappings F\, FolderMigrationLegacyMappings P WHERE Collections.dCollectionID=F.dCollectionID AND ColMeta.dCollectionID=F.dCollectionID AND F.dMigrationRun=0 AND Collections.dParentCollectionID=P.dCollectionID AND P.dMigrationRun=0 AND dSecurityGroup IS NOT NULL AND LEN(dSecurityGroup) > 0!$[FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'ND'.
  at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2546)
  at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:849)
  at intradoc.folders.migration.FoldersMigrationServiceHandler.doFolderMigration(FoldersMigrationServiceHandler.java:1666)
  at intradoc.folders.migration.FoldersMigrationServiceHandler.startFolderMigration(FoldersMigrationServiceHandler.java:838)
  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: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:603)
  at intradoc.server.Service.doCode(Service.java:576)
  at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)
  at intradoc.server.Service.doAction(Service.java:547)
  at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
  at intradoc.server.Service.doActions(Service.java:543)
  at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391)
  at intradoc.server.Service.executeActions(Service.java:528)
  at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:737)
  at intradoc.server.Service.doRequest(Service.java:1956)
  at intradoc.server.ServiceManager.processCommand(ServiceManager.java:437)
  at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
  at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1357)
  at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1731)
  at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:222)
  at sun.reflect.GeneratedMethodAccessor137.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:88)
  at idcservlet.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:305)
  at idcservlet.common.ClassHelperUtils.executeMethodWithArgs(ClassHelperUtils.java:278)
  at idcservlet.ServletUtils.executeContentServerIntegrateMethodOnConfig(ServletUtils.java:1704)
  at idcservlet.IdcFilter.doFilter(IdcFilter.java:457)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
  at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
  at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
  at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
  at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
  at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
  at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
  at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
  at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
  at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
  at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
  at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
  at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
  at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
  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: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'ND'.
  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.ddr.a(Unknown Source)
  at weblogic.jdbc.sqlserver.ddj.m(Unknown Source)
  at weblogic.jdbc.sqlserverbase.ddde.e(Unknown Source)
  at weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source)
  at weblogic.jdbc.sqlserverbase.ddde.v(Unknown Source)
  at weblogic.jdbc.sqlserverbase.ddde.x(Unknown Source)
  at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
  at weblogic.jdbc.wrapper.Statement.executeUpdate(Statement.java:511)
  at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:843)
  at intradoc.folders.migration.FoldersMigrationServiceHandler.doFolderMigration(FoldersMigrationServiceHandler.java:1666)
  at intradoc.folders.migration.FoldersMigrationServiceHandler.startFolderMigration(FoldersMigrationServiceHandler.java:838)
  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: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:603)
  at intradoc.server.Service.doCode(Service.java:575)
  ... 47 more


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Administration -> Folder Migration
2. See the following:
This Oracle WebCenter Content instance has both Folders_g and Framework Folders enabled. Having both enabled is not a supported configuration and some features will not work correctly, including webdav access. One of these components should be disabled for production use. Framework Folders replaces Folders_g and is therefore the preferred foldering solution as of 2011
folders to migrate: 3
Content items in folders: 4
Folders that will be excluded: 1
3. Click on "Migrate Folder Data"
4. Click on the info button to see how the run went - see the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot test migration

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