UCM 10g to WCC 11g CMU Export/Import Fails when Exporting/Importing Standard 10g Components (Doc ID 1487305.1)

Last updated on APRIL 09, 2024

Applies to:

Symptoms

On : 10.1.3.5.0 version, Content Server

When attempting to export a CMU bundle, the export fails and
the following error occurs.

ERROR
-----------------------
Event generated by user 'sysadmin' at host '<server name>'. intradoc.common.ServiceException: csCmuErrorRetrievingSectionItems Possible database connection failure encountered. Error message: (!csDbUnableToCreateResultSet,Qroles(SELECT DISTINCT dRoleName FROM RoleDefinition)!$ORA-00600: internal error code\, arguments: [qernsRowP]\, [1]\, []\, []\, []\, []\, []\, []). java.sql.SQLException: ORA-00600: internal error code, arguments: [qernsRowP], [1], [], [], [], [], [], [] [ Details ]

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

!csUserEventMessage,sysadmin,efs.iowa.gov!$!syExceptionType2,intradoc.common.ServiceException,csCmuErrorRetrievingSectionItems!csJdbcConnectionFailure,\!csDbUnableToCreateResultSet\,Qroles(SELECT DISTINCT dRoleName FROM RoleDefinition)\!$ORA-00600: internal error code\\\, arguments: [qernsRowP]\\\, [1]\\\, []\\\, []\\\, []\\\, []\\\, []\\\, []
!syExceptionType2,java.sql.SQLException,ORA-00600: internal error code\, arguments: [qernsRowP]\, [1]\, []\, []\, []\, []\, []\, []

intradoc.common.ServiceException: csCmuErrorRetrievingSectionItems
at cmu.sections.DefaultCmuSection.retrieveSectionItems(DefaultCmuSection.java:216)
at cmu.CmuSection.retrieveSectionItems(CmuSection.java:104)
at cmu.CmuManager.getTaskSectionInfoSet(CmuManager.java:663)
at cmu.CmuService.getTaskSectionItems(CmuService.java:175)
at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source)
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 intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1201)
at intradoc.server.Service.doActions(Service.java:447)
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: intradoc.data.DataException: !csJdbcConnectionFailure,\!csDbUnableToCreateResultSet\,Qroles(SELECT DISTINCT dRoleName FROM RoleDefinition)\!$ORA-00600: internal error code\\\, arguments: [qernsRowP]\\\, [1]\\\, []\\\, []\\\, []\\\, []\\\, []\\\, []

at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2371)
at intradoc.jdbc.JdbcWorkspace.createResultSet(JdbcWorkspace.java:714)
at cmu.sections.DefaultCmuSection.retrieveSectionItems(DefaultCmuSection.java:159)
... 21 more
Caused by: java.sql.SQLException: ORA-00600: internal error code, arguments: [qernsRowP], [1], [], [], [], [], [], []

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:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4055)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4195)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1279)
at intradoc.jdbc.JdbcWorkspace.createResultSet(JdbcWorkspace.java:692)
... 22 more


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Choose items to export
2. Continue with the process and choose export
3. Process continues but at the end errors out with: Error creating export Unable to copy the file 'e:\oracle\ucm\custom\ExtranetLook\manifest.zip' to 'e:\oracle\ucm\cmu\efiling\bundles\temp-cmubundle\components\custom\ExtranetLook\manifest.zip'. The source file does not exist.

4. Looking at the Action History, it says that it was able to complete the export, but the bundle does NOT exist in the filesystem

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot test 11g due to being unable to finish migration

Cause

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