Oracle Fmw 11g 11.1.1.4 or 11.1.1.6 Upgrade Assistant Fails while upgrading Discoverer Repository Schemas (Doc ID 1338382.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Discoverer - Version 11.1.1.2.0 to 11.1.1.6.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

You are upgrading Application Sever 10g/Discoverer 10g(10.1.2) to Fusion Middleware 11g(11.1.1).

While trying to upgrade Discoverer metadata repository schemas using Oracle Fusion Middleware Upgrade Assistant, it fails with the following messages in the log file,

[2011-07-13T06:59:34.874+00:00] [DISCOVERER] [ERROR] [] [upgrade.DISCOVERER] [tid: 13] [ecid: 0000J4YITMq52jk5Ozg8yd1E7K76000002,0:12] Cause: Specified Discoverer 10g metadata record is corrupt. Action: Delete the corrupted record and rerun metadata repository upgrade.
[2011-07-13T06:59:34.875+00:00] [DISCOVERER] [NOTIFICATION] [] [upgrade.DISCOVERER] [tid: 13] [ecid: 0000J4YITMq52jk5Ozg8yd1E7K76000002,0:12] oracle.ias.mrua.plugin.discoverer.PortletMetadataMigrationException: Error while executing query: UPDATE TST_DISCOVERER.ptm5_instance SET ins_property = EMPTY_BLOB() WHERE ins_surrgt_pk = ? [[
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.executeQuery(PortletMetadataMigration.java:320)
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.migrateInstance(PortletMetadataMigration.java:164)
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.migrateInstanceKey(PortletMetadataMigration.java:153)
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.migrate(PortletMetadataMigration.java:122)
at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.massageData(DiscovererPlugin.java:615)
at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.discoUpgrade(DiscovererPlugin.java:560)
at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.doUpgrade(DiscovererPlugin.java:145)
at oracle.ias.mrua.MRUA.executePlugins(MRUA.java:2711)
at oracle.ias.mrua.MRUA.internal_driver(MRUA.java:1757)
at oracle.ias.mrua.MRUA.driver(MRUA.java:1205)
at oracle.ias.upgrade.gui.UAUpgradeThread.run(UAUpgradeThread.java:380)
Caused by: java.sql.SQLException: SQL string is not Query
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1442)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.executeQuery(PortletMetadataMigration.java:316)
... 10 more

Changes

Oracle Fusion Middleware 11g was upgraded from 11.1.1.2.0 to 11.1.1.4.0 or to 11.1.1.6.0.

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