ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions in SOA Suite 12.2.1.0.0

Issue –> While invoking a SOA composite from Oracle Service Bus , i got the below error.

Error –> 

An error occurred while executing SOA’s Instance Tracking Audit interceptor. See nested exception for root cause.[[
java.lang.NullPointerException
at oracle.soa.tracking.fabric.interceptors.AuditInterceptor.processRequest(AuditInterceptor.java:425)
at oracle.integration.platform.common.ExtendedInterceptorChainImpl$1.run(ExtendedInterceptorChainImpl.java:149)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:549)

…………………

JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@68ebb48c

Internal Exception: java.sql.SQLException: ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions

Solution –> 

We are seeing this error as we can not insert null in to SOAINFRA.AUDIT_DETAILS.CI_PARTITION_DATE

To resolve this we need to apply the patch # 21549249

Once after applying the patch in test environment and tested successfully  move the patch to other environments.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s