"The SQL operation failed" Error When Trying to Create New Version or Scenario Members
(Doc ID 1381473.1)
Last updated on JUNE 22, 2018
Applies to:Hyperion Planning - Version: 126.96.36.199.00 to 188.8.131.52.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!