PSA Tool To Upgrade SOA Schema For SQLSever Throws Errors On SOA Schema Upgrade
(Doc ID 1567071.1)
Last updated on AUGUST 23, 2018
Applies to:
Oracle SOA Suite - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11gR1]Information in this document applies to any platform.
Symptoms
On : 11.1.1.7.0 version, Product Installation
Running psa tool to upgrade SOA schema throws errors on SOA schema upgrade
We're upgrading our SOA suite from 11.1.1.5 to 11.1.1.7 When running the updated psa.bat tool to upgrade our SOA/BPM schema, the MDS and ORASDPM schema updated okay, but we get errors on the SOA schema.
This is the error we get from the psa log file
[2013-05-03T12:58:33.098-07:00] [RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [tid: 13] [ecid: 0000JtfyKrtBT8iEl76iKJ1HX1Oe000004,0] [[
java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]The object 'DS_PK' is dependent on column 'SUBSCRIBER_ID'.
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.m(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.e(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.r(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.execute(Unknown Source)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.runSqlStatement(JDBCEngine.java:1090)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.callRunSqlStatement(JDBCEngine.java:779)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:794)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:773)
at oracle.sysman.assistants.common.dbutil.jdbc.SQLServerDDLStatement.execute(SQLServerStatementType.java:241)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeNextSQLStatement(JDBCEngine.java:1468)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1372)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:982)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:857)
at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade_soainfra_one_patchset(SOAINFRAPlugin.java:378)
at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade_soainfra(SOAINFRAPlugin.java:320)
at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade(SOAINFRAPlugin.java:215)
at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:348)
at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:295)
at oracle.ias.update.UpgradeDriver.doUpgrades(UpgradeDriver.java:474)
at oracle.ias.update.gui.UAUpgradeThread.run(UAUpgradeThread.java:41)
]]
java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]The object 'DS_PK' is dependent on column 'SUBSCRIBER_ID'.
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.m(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.e(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.r(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.execute(Unknown Source)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.runSqlStatement(JDBCEngine.java:1090)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.callRunSqlStatement(JDBCEngine.java:779)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:794)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:773)
at oracle.sysman.assistants.common.dbutil.jdbc.SQLServerDDLStatement.execute(SQLServerStatementType.java:241)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeNextSQLStatement(JDBCEngine.java:1468)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1372)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:982)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:857)
at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade_soainfra_one_patchset(SOAINFRAPlugin.java:378)
at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade_soainfra(SOAINFRAPlugin.java:320)
at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade(SOAINFRAPlugin.java:215)
at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:348)
at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:295)
at oracle.ias.update.UpgradeDriver.doUpgrades(UpgradeDriver.java:474)
at oracle.ias.update.gui.UAUpgradeThread.run(UAUpgradeThread.java:41)
]]
The issue can be reproduced at will with the following steps:
1. install soa RCU on windows sql server
2.- run psa.bat in order to upgrade (ran the PSA.bat file in %middlewarehome%\oracle_common\bin)
2.- run psa.bat in order to upgrade (ran the PSA.bat file in %middlewarehome%\oracle_common\bin)
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 |