2 Known Issues and Workarounds

Here are the known issues and workarounds for Release 14c (14.1.2.0.0) of Oracle Enterprise Scheduler:

ESS Schema Upgrade from 12.2.1.4.0 to 14.1.2.0.0 Fails if User has References in ESS Schemas with Noneditioned Dependent Objects

Issue

Bug Number: 36743549

Impacted Releases: 14.1.2.0.0

Impacted Platforms: All

When the customer has created references to non-editionable objects from editionable objects in ESS schema, upgrade from 12.2.1.4.0 to 14.1.2.0.0 fails with the below mentioned error. This issue occurs since the upgrade is trying to enable schemas for Edition based redefinition (EBR). In 14.1.2.0.0, all the schemas are EBR-enabled by default to support ZDT upgrade during upcoming releases. This issue does not occur if user has not modified default ESS schemas by adding custom references which are not compatible with EBR upgrade.

[2024-06-18T00:11:09.810-07:00] [Framework] [NOTIFICATION] [upgrade.Framework]
      upgradeScript=C:\ESS14c\mw\oracle_common\common\sql\ess\oracle\upg_122150_122160.sql ESS43_ESS
      [2024-06-18T00:11:10.147-07:00] [RCU] [ERROR] [upgrade.RCU.jdbcEngine]  SQLException:
      ORA-38819: user ESS43_ESS owns one or more objects whose type is editionable and that have
      noneditioned dependent objects ORA-06512: at line 2  https://docs.oracle.com/error-help/db/ora-38819/ ]] [2024-06-18T00:11:10.147-07:00] [RCU] [ERROR] [upgrade.RCU.jdbcEngine]
      java.sql.SQLException: ORA-38819: user ESS43_ESS owns one or more objects whose type is
      editionable and that have noneditioned dependent objects ORA-06512: at line 2  https://docs.oracle.com/error-help/db/ora-38819/  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:709)  at
      oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:609)  at
      oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1347)  at
      oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1101)  at
      oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:409)  at
      oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:499)  at
      oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:274)  at
      oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1469)  at
      oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1995)  at
      oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1608)  at
      oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3953)
      at oracle.jdbc.driver.OraclePreparedStatement.doExecute(OraclePreparedStatement.java:4420)  at
      oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4406)

Workaround

Remove the incompatible references with EBR (for example, non-editionable objects from editionable objects) and try upgrade again.