Schema Upgrade Step Failed for index_drop.ddl Unavailability While Upgrading OAS
(Doc ID 3033301.1)
Last updated on JULY 16, 2024
Applies to:
Oracle Analytics Server - Version 2022 (6.4) and laterInformation in this document applies to any platform.
Symptoms
OAS upgrade failed at the schema upgrade step with below error:
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Initialzing ConnectionManager...
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Setting derived constants
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] DAC domain home set to /scratch
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] DAC binary home set to /scratch
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] /scratch/conf-shared/jvm_system.properties not found!
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] CONNECTION_ISSUE "Repository" pool will try to create each connection up to 3 times
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] CONNECTION_ISSUE "Repository" pool will close connections open longer than 30 minutes
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Creating connection pool "Repository" with up to 1 connections.
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Application booting up...
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Connection established.
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] ==============================
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Generic schema upgrade
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] ==============================
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] reading upgrade stage...
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] nothing found - starting upgrade
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Verifying whether repository is unicode...
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Verifying unicode
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] upgrading schema...
ANOMALY INFO::: Could not initialize ddl file
MESSAGE ::: /scratch/log/scripts/index_drop.ddl (No such file or directory)
EXCEPTION CLASS ::: java.io.FileNotFoundException
java.io.FileOutputStream.open0(Native Method)
java.io.FileOutputStream.open(FileOutputStream.java:270)
java.io .FileOutputStream.<init>(FileOutputStream.java:213)
Changes
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 |
Changes |
Cause |
Solution |
References |