6 Replies Latest reply on Mar 13, 2019 2:14 PM by 996981

    exportFoldersGData fails oracle.stellent.ridc.protocol.ServiceException: Unable to open folder

    996981

      We are in the processes of upgrading webcenter portal 11.1.1.9 to 12.2.1.3.  When we installed 11.1.1.9 we only enabled Folders_g.  So now the  prerequisite for

      upgrade is to Framework Folders. When I tried to do

      exportFoldersGData(appName='webcenter',server='WC_Spaces',connectionName='WebcenterContent',directoryPath='/export/home/oracle/migration')

      I am getting the error  in diagnostics.log shos unable to open folder.

      Created file PreMigrationData.csv and MigrationDiagnostic.log.

       

      Anyone has experienced this issue?

       

      Thanks

      Kamala

        • 1. Re: exportFoldersGData fails oracle.stellent.ridc.protocol.ServiceException: Unable to open folder
          Daniel Merchán

          Hi,

           

          I experienced all kind of exotic issues migrating things,
          Can you share the complete stacktrace of the logs and specific error durign exportFoldersGData?

           

          Thanks.

          • 2. Re: exportFoldersGData fails oracle.stellent.ridc.protocol.ServiceException: Unable to open folder
            996981

            Thanks for your reply. Here is the MigrationDiagnostic.log.  There is a file created PreMigrationData.csv

             

            TRACE]: Entering class: FrameworkFoldersMigration, method: exportFoldersGData
            [TRACE]: Parameters provided are: appName: webcenter, server: WC_Spaces, connectionName: WebcenterContent, directoryPath: /export/home/oracle/migration/, applicationVersion:
            [TRACE]: The migration directory default/specified: /export/home/oracle/migration/has necessary permissions
            [TRACE]: Entering class: FwkAppMigration, method: _getUCMConnectionUrl
            [TRACE]: Exiting method: _getUCMConnectionUrl, returning:: ucmUrl: idc://XXXX.XXXX.XXX.XXX:4444
            [TRACE]: Following attributes were derived, ucmConnectionUrl: idc://xxx.xxx.xxx.xxxx:4444, Portal Server Root Folder: /csccontent
            [TRACE]: Entering method: _getDoclibBean, params:: appName: webcenter
            [TRACE]: Entering method: _getMBeanArray, params:: pattern: *oracle.webcenter.doclib:*
            [TRACE]: Exiting method: _getMBeanArray
            [TRACE]: Exiting method: _getDoclibBean
            [TRACE]: Successfully got hold of Doclib MBean
            [TRACE]: Executing Doclib MBean method, getPreMigrationData

            [TRACE]: Entering the class: oracle.webcenter.doclib.migration.FrameworkFolderMigrationLogic, method: getPreMigrationData with parameters, rootFolder: /csccontent, connectionName: WebcenterContent, connectionUrl: idc://xxx.xxx.xxx.xxx.xxx:4444, directoryPath: /export/home/oracle/migration/PRE_MIGRATION/,isCustomApp:false
            [TRACE]: Total number of child folders for path: csccontent is 7
            [TRACE]: Total number of child folders for path: /PersonalSpaces/ is 2
            [ERROR]: Following exception occured in the class: oracle.webcenter.doclib.migration.FrameworkFolderMigrationLogic, method: getPreMigrationData
            oracle.stellent.ridc.protocol.ServiceException: Unable to open folder.
            at oracle.stellent.ridc.protocol.ServiceResponse.getResponseAsBinder(ServiceResponse.java:142)
            at oracle.stellent.ridc.protocol.ServiceResponse.getResponseAsBinder(ServiceResponse.java:108)
            at oracle.webcenter.doclib.core.WCPServiceResponse.getResponseAsBinder(WCPServiceResponse.java:85)
            at oracle.webcenter.doclib.migration.FrameworkFolderMigrationLogic.listFolders_FoldersG(FrameworkFolderMigrationLogic.java:2399)
            at oracle.webcenter.doclib.migration.FrameworkFolderMigrationLogic.getPreMigrationData(FrameworkFolderMigrationLogic.java:337)
            at oracle.webcenter.doclib.migration.FrameworkFolderMigrationLogic.getPreMigrationData(FrameworkFolderMigrationLogic.java:275)
            at oracle.webcenter.doclib.mxbeans.DoclibMXBeanImpl.getPreMigrationData(DoclibMXBeanImpl.java:65)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:606)
            at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.doInvoke(OracleStandardEmitterMBean.java:1026)
            at oracle.adf.mbean.share.AdfMBeanInterceptor.internalInvoke(AdfMBeanInterceptor.java:104)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.security.AbstractMBeanSecurityInterceptor.internalInvoke(AbstractMBeanSecurityInterceptor.java:191)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.security.jps.ee.jmx.JpsJmxInterceptor$2.run(JpsJmxInterceptor.java:406)
            at java.security.AccessController.doPrivileged(Native Method)
            at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
            at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464)
            at oracle.security.jps.ee.jmx.JpsJmxInterceptor.internalInvoke(JpsJmxInterceptor.java:446)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.interceptors.ContextClassLoaderMBeanInterceptor.internalInvoke(ContextClassLoaderMBeanInterceptor.java:103)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.interceptors.MBeanRestartInterceptor.internalInvoke(MBeanRestartInterceptor.java:116)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.invoke(OracleStandardEmitterMBean.java:938)
            at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
            at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$16.run(WLSMBeanServerInterceptorBase.java:449)
            at java.security.AccessController.doPrivileged(Native Method)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:447)
            at weblogic.management.mbeanservers.internal.JMXContextInterceptor.invoke(JMXContextInterceptor.java:263)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$16.run(WLSMBeanServerInterceptorBase.java:449)
            at java.security.AccessController.doPrivileged(Native Method)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:447)
            at weblogic.management.mbeanservers.internal.SecurityInterceptor.invoke(SecurityInterceptor.java:444)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServer.invoke(WLSMBeanServer.java:323)
            at weblogic.management.mbeanservers.internal.JMXConnectorSubjectForwarder$11$1.run(JMXConnectorSubjectForwarder.java:663)
            at java.security.AccessController.doPrivileged(Native Method)
            at weblogic.management.mbeanservers.internal.JMXConnectorSubjectForwarder$11.run(JMXConnectorSubjectForwarder.java:661)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
            at weblogic.management.mbeanservers.internal.JMXConnectorSubjectForwarder.invoke(JMXConnectorSubjectForwarder.java:654)
            at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1488)
            at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:97)
            at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1329)
            at java.security.AccessController.doPrivileged(Native Method)
            at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1428)
            at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:849)
            at javax.management.remote.rmi.RMIConnectionImpl_WLSkel.invoke(Unknown Source)
            at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:667)
            at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:522)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
            at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
            at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:518)
            at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
            at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

            • 3. Re: exportFoldersGData fails oracle.stellent.ridc.protocol.ServiceException: Unable to open folder
              Daniel Merchán

              Hi,

               

              This is usually a missmatch between Portal MDS and the folder structure. (corruption where the Portal still thinks some WebCenter Content folder exists).

              During this execution, can you also check the WebCenter Content logs (such us the idccs_[yourservername]_current.log) to check which is the folder who is affecting your migration export data.

              If the error does not appear clear where is the issue then we can enable DEBUG traces in WebCenter Content side to detect the corrupted folder Portal is asking for.

               

              When knowing it we can try to fix it by:

              • Re-creating the folder
              • Or fixing manually the MDS document demanding this folder.

               

              Another approach is opening an Oracle SR to be guided to detect where the corruption is.

               

              Kind regards.

              • 4. Re: exportFoldersGData fails oracle.stellent.ridc.protocol.ServiceException: Unable to open folder
                Daniel Merchán

                I am going to have a double check in the internal logic in the source code also if by any luck I can point in something more specific.

                • 5. Re: exportFoldersGData fails oracle.stellent.ridc.protocol.ServiceException: Unable to open folder
                  Daniel Merchán

                  Can you send me your version of doclib-service-core.jar which you can find in your WCP Oracle_Home \webcenter\modules\oracle.webcenter.framework

                  The one I have is patched and is not align with your exception.

                   

                  The operation exectued is COLLECTION_DISPLAY, so track it in WebCenter Content logs which params is using .


                  Thanks.

                  • 6. Re: exportFoldersGData fails oracle.stellent.ridc.protocol.ServiceException: Unable to open folder
                    996981

                    Thanks for your prompt reply

                     

                    1. checked content server logs logging into /cs ... Adminstration .. Log files

                    An error occurred during indexing. Encountered an exception while executing a query. java.sql.BatchUpdateException: error occurred during batching: ORA-02292: integrity constraint (xxxx_xxxx.SYS_C0092964) violated - child record found. csJdbcGenericErrorWithCode(ORA-02292) [ Details ]

                    Indexing aborted. Unable to do clean up. Encountered an exception while executing a query. java.sql.BatchUpdateException: error occurred during batching: ORA-02292: integrity constraint (xxx_xx.SYS_C0092964) violated - child record found. csJdbcGenericErrorWithCode(ORA-02292) [ Details ]

                    2.I started SR with oracle. He is working Development Team

                    3. doclib-service-core.jar. Unjar /META-INF . is this one you are looking for it.

                    Implementation-Version: 11.1.1.9.0
                    Implementation-Label: WORKPLACE_11.1.1.9.0WCPBP_GENERIC_190110.0936