My Oracle Support Banner

Soa_exec_interval_verify.sql Fails With ORA-02149: Specified Partition Does Not Exist (Doc ID 2606838.1)

Last updated on NOVEMBER 04, 2019

Applies to:

Oracle SOA Suite - Version 12.1.3.0.0 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.