My Oracle Support Banner

"SQL Operation Failed" Inserting a Member Formula (Doc ID 2002798.1)

Last updated on JUNE 25, 2018

Applies to:

Hyperion Planning - Version 11.1.1.3.00 and later
Information in this document applies to any platform.

Symptoms

When inserting a new member formula, an error occurs, but if one is deleted prior to inserting, it works.

SQL operation failed

Entry in the Planning log is a bit vague:

####<Apr 20, 2015 10:19:25 AM CEST> <Error> <HTTP> <server> <HyperionPlanning> <[ACTIVE] ExecuteThread: '39' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1429517965264> <BEA-101020> <[weblogic.servlet.internal.WebAppServletContext@2b58129 - appName: 'HyperionPlanning', name: 'HyperionPlanning', context-path: '/HyperionPlanning'] Servlet failed with Exception
java.lang.NullPointerException

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!

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