Argus Upgrade Error: ORA-22332: a dependent object in schema "<Schema Name>" has errors.
(Doc ID 3037227.1)
Last updated on JULY 25, 2024
Applies to:
Oracle Life Sciences Argus Safety - Version 8.4.3 and laterInformation in this document applies to any platform.
Symptoms
Upgrading Argus application.
When executing changelogs, the upgrade terminated with below error message.
Running Changeset: changelogs/842_843/scripts/ddl_change_024.sql::20::safety-upgrade
Unexpected error running Liquibase: liquibase.exception.MigrationFailedException: Migration failed for changeset changelogs/842_843/scripts/ddl_change_024.sql::20::safety-upgrade:
Reason: liquibase.exception.DatabaseException: ORA-22324: altered type has compilation errors
ORA-22332: a dependent object in schema "<Scheme Name>" has errors.
ORA-01732: data manipulation operation not legal on this view
[Failed SQL: (22324) ALTER TYPE ESM_OWNER.REPORTACKNOWLEDGMENT_TY MODIFY ATTRIBUTE (REPORTMESSAGEDATE VARCHAR2(30 CHAR)) CASCADE]
For more information, please use the --logLevel flag
***ERROR: Unexpected error running Liquibase: liquibase.exception.MigrationFailedException: Migration failed for changeset changelogs/842_843/scripts/ddl_change_024.sql::20::safety-upgrade:
Reason: liquibase.exception.DatabaseException: ORA-22324: altered type has compilation errors
ORA-22332: a dependent object in schema "<Scheme Name>" has errors.
ORA-01732: data manipulation operation not legal on this view
[Failed SQL: (22324) ALTER TYPE ESM_OWNER.REPORTACKNOWLEDGMENT_TY MODIFY ATTRIBUTE (REPORTMESSAGEDATE VARCHAR2(30 CHAR)) CASCADE]
ALTER TYPE statement is unable to get executed due to some dependencies.
Unexpected error running Liquibase: liquibase.exception.MigrationFailedException: Migration failed for changeset changelogs/842_843/scripts/ddl_change_024.sql::20::safety-upgrade:
Reason: liquibase.exception.DatabaseException: ORA-22324: altered type has compilation errors
ORA-22332: a dependent object in schema "<Scheme Name>" has errors.
ORA-01732: data manipulation operation not legal on this view
[Failed SQL: (22324) ALTER TYPE ESM_OWNER.REPORTACKNOWLEDGMENT_TY MODIFY ATTRIBUTE (REPORTMESSAGEDATE VARCHAR2(30 CHAR)) CASCADE]
For more information, please use the --logLevel flag
***ERROR: Unexpected error running Liquibase: liquibase.exception.MigrationFailedException: Migration failed for changeset changelogs/842_843/scripts/ddl_change_024.sql::20::safety-upgrade:
Reason: liquibase.exception.DatabaseException: ORA-22324: altered type has compilation errors
ORA-22332: a dependent object in schema "<Scheme Name>" has errors.
ORA-01732: data manipulation operation not legal on this view
[Failed SQL: (22324) ALTER TYPE ESM_OWNER.REPORTACKNOWLEDGMENT_TY MODIFY ATTRIBUTE (REPORTMESSAGEDATE VARCHAR2(30 CHAR)) CASCADE]
ALTER TYPE statement is unable to get executed due to some dependencies.
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 |