"SQL Operation Failed" Inserting a Member Formula

(Doc ID 2002798.1)

Last updated on MARCH 08, 2017

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

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