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:
Oracle WebCenter Content - Version 10.0 and laterInformation in this document applies to any platform.
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
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 |
Cause |
Solution |
References |