Occasional SQL Exceptions in SOA Logs: ORA-01031: insufficient privileges (Doc ID 1446332.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

A database issue is reflected in the SOA log files as the following exception:

[APP: soa-infra] oracle.fabric.common.FabricException: oracle.fabric.common.FabricInvocationException: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.4.0) (Build 101210)): oracle.toplink.exceptions.DatabaseException[[
Internal Exception: java.sql.BatchUpdateException: ORA-01031: insufficient privileges

Error Code: 1031: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.4.0) (Build 101210)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-01031: insufficient privileges

Error Code: 1031
at oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.createCompositeInstance(WebServiceEntryBindingComponent.java:1403)
at oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.doMessageProcessing(WebServiceEntryBindingComponent.java:1243)



Although the schema user's privileges have been checked, the datasource configuration is correct, the error keeps re-appearing from time to time.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms