"The SQL operation failed" Error When Trying to Create New Version or Scenario Members
Last updated on JULY 28, 2016
Applies to:Hyperion Planning - Version: 22.214.171.124.00 to 126.96.36.199.00 - Release: 9.3 to 9.3
Information in this document applies to any platform.
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.
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