Soa_exec_interval_verify.sql Fails With ORA-02149: Specified Partition Does Not Exist
(Doc ID 2606838.1)
Last updated on NOVEMBER 16, 2023
Applies to:
Oracle SOA Suite - Version 12.1.3.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3.0.0 version, Product Installation
After applying Patch 29422187 (SOA Bundle Patch 12.1.3.0.190416), and running the soa_exec_interval_verify.sql for Group 1 partitions,
the following error occurs:
ERROR
-----------------------
ERROR at line 1:
ORA-02149: Specified partition does not exist
ORA-06512: at "SOABPM_SOAINFRA.VERIFY_MEDIATOR", line 704
ORA-06512: at "SOABPM_SOAINFRA.VERIFY_MEDIATOR", line 1239
ORA-06512: at "SOABPM_SOAINFRA.VERIFY_SOA", line 329
ORA-06512: at "SOABPM_SOAINFRA.VERIFY_SOA", line 493
ORA-06512: at line 108
STEPS:
1.] Go to /refresh/home/Oracle/Middleware/Oracle_Home/soa/common/sql/soainfra/sql/oracle/121300/verify12
2.] Open soa_exec_interval_verify.sql
3.] Edit soa_max_timestamp := to_timestamp('2013-08-15','YYYY-MM-DD'); to soa_max_timestamp := to_timestamp('2019-09-27','YYYY-MM-DD');
4.] Open terminal and connect to SQLPlus
5.] Run command @/refresh/home/Oracle/Middleware/Oracle_Home/soa/common/sql/soainfra/sql/oracle/121300/verify12/soa_exec_interval_verify.sql
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 |