Hyperion Planning Application Deployment Fails At 90% With Error "System.Data.OracleClient.OracleException: ORA-01010: invalid OCI operation" (Doc ID 1547549.1)

Last updated on JULY 28, 2016

Applies to:

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

Symptoms

On : 11.1.1.3.00 version, BPM Architect

Hyperion Planning Application Deployment Fails at 90%

Intermittent issue with Planning Application deployments failing. It does not appear to be specific to a particular application.
Restarting the instance and then trying again allows to complete the process.

ERROR
-----------------------
2013-04-09 13:25:07,226 [ApplicationExportJob] Hyperion.CommonServices.Exceptions.BaseException.LogException(:0) - ORA-01010: invalid OCI operation

System.Data.OracleClient.OracleException: ORA-01010: invalid OCI operation

  at Hyperion.DimensionServer.Dimension.LoadMembers()
  at Hyperion.DimensionServer.Library.Load()
  at Hyperion.DimensionServer.LibraryManager.FindBaselineLibrary(Int32 libraryID, Int32 transactionID, Boolean throwOnError)
  at Hyperion.DimensionServer.ApplicationExport.LoadPreviousBaseline()
  at Hyperion.DimensionServer.ApplicationExport.RenderApplication()
  at Hyperion.DimensionServer.ApplicationExport.Execute()
2013-04-09 13:25:07,804 [6] Hyperion.CommonServices.Exceptions.BaseException.LogException(:0) - SVR_ERR_JOB_ABORTED:There are no results available for job Exporting application NRPL2. because an error was encountered while processing the job. See the Job Console or the Event Viewer for more information.
Hyperion.DimensionServer.Interface.Exceptions.ApplicationExportException: There are no results available for job Exporting application NRPL2. because an error was encountered while processing the job. See the Job Console or the Event Viewer for more information.
  at Hyperion.DimensionServer.ApplicationExport.GetExportResult(ServerJob job)
  at Hyperion.DimensionServer.Proxies.ApplicationsProxy.GetExportResult(ServerJob job)

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