My Oracle Support Banner

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

Last updated on SEPTEMBER 27, 2021

Applies to:

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


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(
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.migrateInstance(
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.migrateInstanceKey(
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.migrate(
at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.massageData(
at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.discoUpgrade(
at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.doUpgrade(
at oracle.ias.mrua.MRUA.executePlugins(
at oracle.ias.mrua.MRUA.internal_driver(
at oracle.ias.mrua.MRUA.driver(
Caused by: java.sql.SQLException: SQL string is not Query
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.executeQuery(
... 10 more


Oracle Fusion Middleware 11g was upgraded from to or to


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

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