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 MARCH 09, 2019

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.