Customer was finishing up an upgrade of Adaptive Authentication (On-Premise) V6 SP3 P4 to V7.3. They were attempting an Analyze Soap call, and were getting an error:
java.sql.BatchUpdateException: ORA-14400: inserted partition key does not map to any partition
- Database partitioning (USING_DATABASE_PARTITIONS) was enabled in the AAOP database - A run of the CHECK_PARTITIONING.SQL script was run, and everything looked in order. - Confirmed all of the steps were completed as shown in the Install Guide for partitioning
However, when we ran a query against the ALL_TAB_PARTITIONS:
select PARTITION_NAME,HIGH_VALUE,NUM_ROWS from all_tab_partitions where table_name='EVENT_LOG';
It was noticed that only two partitions existed for a two-node Oracle RAC cluster. There should be three - I0 (eye-zero) plus one for each RAC node. It was later learned that the customer had run the upgrade with only one node in their cluster, and then added the second node post-installation, but had not run the ADD_NODE procedure as documented in the Install Guide.
The customer ended up re-running the upgrade with both nodes in the cluster, and the partitioning was created normally & successfully.