Error Occurs During WebCenter Content Schema Upgrade Using the Patch Set Assistant on MS SQL Server Database: "intradoc.data.DataException: !csMigrateInvalid10gDatabase" (Doc ID 1446542.1)

Last updated on MAY 18, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

You are trying to upgrade the WebCenter Content database schema running on Microsoft SQL Server by using the Patch Set Assistant.  When running the psa.bat script, the following error occurs:

[2012-03-29T12:38:49.365-07:00] [UCM] [INCIDENT_ERROR] [UPGCMP-06603] [upgrade.UCM.UCM] Error in upgrading Oracle WebCenter Content schema.
[2012-03-29T12:38:49.365-07:00] [UCM] [INCIDENT_ERROR] [upgrade.UCM.UCM] Cause: An unexpected upgrade error occurred during Oracle WebCenter Content schema upgrade.
[2012-03-29T12:38:49.365-07:00] [UCM] [INCIDENT_ERROR] [upgrade.UCM.UCM] Action: Check the error messages in Oracle WebCenter Content component log files. Correct the problem before running the Assistant again. Contact Oracle Support Services if you are unable to correct the problem.
[2012-03-29T12:38:49.365-07:00] [UCM] [INCIDENT_ERROR] [upgrade.UCM.UCM] [[
intradoc.data.DataException: !csMigrateInvalid10gDatabase
at intradoc.apputilities.installer.CoreMigrateHandler.verifyDatabaseSchema(CoreMigrateHandler.java:209)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at intradoc.apputilities.installer.Migrator.callMethods(Migrator.java:1067)
at intradoc.apputilities.installer.Migrator.initItemsForMigrate(Migrator.java:799)
at intradoc.apputilities.installer.Migrator.init(Migrator.java:189)
at oracle.ias.update.plugin.ucm.UCMUpdatePlugin.setupMigrator(UCMUpdatePlugin.java:428)
at oracle.ias.update.plugin.ucm.UCMUpdatePlugin.examine(UCMUpdatePlugin.java:199)
at oracle.ias.update.plugin.Plugin.examine(Plugin.java:321)
at oracle.ias.update.plan.PlanStep.examine(PlanStep.java:298)
at oracle.ias.update.UpgradeDriver.doExamines(UpgradeDriver.java:380)
at oracle.ias.update.gui.UAExamineThread.run(UAExamineThread.java:48)
Caused by: intradoc.data.DataException: !csDbUnableToCreateResultSet, SELECT dVersion FROM Config
WHERE dSection='DevUpdate' AND dName='updateDocMetaDefinitionV8'
!$[FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'Config'.
at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2546)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:810)
at intradoc.apputilities.installer.CoreMigrateHandler.verifyDatabaseSchema(CoreMigrateHandler.java:205)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'Config'.
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.ddm.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddm.t(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddm.d(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddn.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.h(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.u(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.u(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.u(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.executeQuery(Unknown Source)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:782)
at intradoc.apputilities.installer.CoreMigrateHandler.verifyDatabaseSchema(CoreMigrateHandler.java:205)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at intradoc.apputilities.installer.Migrator.callMethods(Migrator.java:1067)
at intradoc.apputilities.installer.Migrator.initItemsForMigrate(Migrator.java:799)
at intradoc.apputilities.installer.Migrator.init(Migrator.java:189)
at oracle.ias.update.plugin.ucm.UCMUpdatePlugin.setupMigrator(UCMUpdatePlugin.java:426)
at oracle.ias.update.plugin.ucm.UCMUpdatePlugin.examine(UCMUpdatePlugin.java:199)
at oracle.ias.update.plugin.Plugin.examine(Plugin.java:321)
at oracle.ias.update.plan.PlanStep.examine(PlanStep.java:297)
... 2 more


If you log in to the database as the OCS user and run the SQL statement from the script directly on the database, it also fails:

SELECT dVersion FROM Config
WHERE dSection='DevUpdate' AND dName='updateDocMetaDefinitionV8'


However, if you edit that SQL statement to add the database and user name, and again run the SQL statement from the script directly on the database, it succeeds:

SELECT dVersion FROM [database_name].[user_name].[Config]
WHERE dSection='DevUpdate' AND dName='updateDocMetaDefinitionV8'

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