My Oracle Support Banner

Discoverer Upgrade Fails With "MigrateDiscoConnectionException: Copying Data From 10g to 11g Schema" When RCU Rolled Back (Doc ID 1536398.1)

Last updated on JUNE 29, 2023

Applies to:

Oracle Fusion Middleware - Version 11.1.1.2.0 and later
Oracle Discoverer - Version 11.1.1.2.0 and later
Information in this document applies to any platform.
Tested on Solaris Sparc 10
Upgrade of Discoverer 10.1.2.3 to 11.1.1.6 fails to upgrade Schema
RCU Does not fully rollback database, retry may leave schema's and tables with invalid values.

Symptoms

 

While running the Upgrade Assistant, the Discoverer upgrade fails with the following errors:

 


The installactions.log shows:

2013-02-22T14:23:09.922-08:00] [DISCOVERER] [ERROR] [] [upgrade.DISCOVERER] [tid: <tid>] [ecid: <ecid>] Cause: An error occurred either during Discoverer precheck run or upgrade run. Action: Contact Oracle Support Services.
[2013-02-22T14:23:09.925-08:00] [DISCOVERER] [NOTIFICATION] [] [upgrade.DISCOVERER] [tid: <tid>] [ecid: <ecid>] oracle.ias.mrua.plugin.discoverer.MigrateDiscoConnectionException: Error while copying data from 10g to 11g schema.[[
    at oracle.ias.mrua.plugin.discoverer.MigrateDiscoConnection.bulkCopyPstoreDataTo_11g(MigrateDiscoConnection.java:376)
    at oracle.ias.mrua.plugin.discoverer.MigrateDiscoConnection.copyDataFrom10gTo11g(MigrateDiscoConnection.java:324)
    at oracle.ias.mrua.plugin.discoverer.MigrateDiscoConnection.doMigrate(MigrateDiscoConnection.java:121)
    at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.massageData(DiscovererPlugin.java:639)
    at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.discoUpgrade(DiscovererPlugin.java:564)
    at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.doUpgrade(DiscovererPlugin.java:147)
    at oracle.ias.mrua.MRUA.executePlugins(MRUA.java:3576)
    at oracle.ias.mrua.MRUA.internal_driver(MRUA.java:2357)
    at oracle.ias.mrua.MRUA.driver(MRUA.java:1621)
    at oracle.ias.upgrade.gui.UAUpgradeThread.run(UAUpgradeThread.java:390)
Caused by: java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "BI_DISCOVERER_PS.WWSSO_UTL", line 506
ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error
ORA-06512: at "BI_DISCOVERER_PS.WWSSO_API_PRIVATE", line 420

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
    at oracle.ias.mrua.plugin.discoverer.Utils.copyUserinfo(Utils.java:145)
    at oracle.ias.mrua.plugin.discoverer.Utils.migratePstoreData(Utils.java:68)
    at oracle.ias.mrua.plugin.discoverer.MigrateDiscoConnection.bulkCopyPstoreDataTo_11g(MigrateDiscoConnection.java:372)
    ... 9 more

Changes

In this particular case, it was found that the first run of RCU failed, (e.g. in this case due to NLS setting), by default it rolls back. However this left tables in the Database. Even though subsequent RCU succeeds, corrupted tables are left in the Database which will cause Install or Upgrade issues.

This may not be the only errors we see as a result of this: Depending on why RCU failed the first time, and allowing the rollback and retry to continue will vary on errors and component being installed. (In general, allowing RCU rollback is not a good idea)

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
Changes
Cause
Solution
References


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