"The SQL operation failed" Error When Trying to Create New Version or Scenario Members (Doc ID 1381473.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Planning - Version: 9.3.1.0.00 to 9.3.3.0.00 - Release: 9.3 to 9.3
Information in this document applies to any platform.

Symptoms

When trying to add a new member to the Scenario or Version dimension in a Planning classic application, the following error is displayed:

The SQL operation failed. Check logs for details.

An example of the error in the Planning log is:

[11/17/11 11:20:25:393 EST] 00000024 SystemErr R java.sql.SQLException: [Hyperion][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'ENABLED_FOR_PM', table 'HyperionPLAN1.dbo.HSP_SCENARIO'; column does not allow nulls. INSERT fails.

The log extract above shows an attempt to add a new scenario member when using Microsoft SQL Server as the relational database.

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