I came across this type of issue many times and finally thought of sharing this on how to go ahead and fix the error.
When you deploy the Planning application in EPMA you will get below error.
System.Web.Services.Protocols.SoapException: Server was unable to process request. —> Hyperion.DimensionServer.Interface.Exceptions.ApplicationExportException: There are no results available for job Exporting application KDD_FIN. because an error was encountered while processing the job. See the Job Console or the Event Viewer for more information.
Server stack trace:
at Hyperion.DimensionServer.ApplicationExport.GetExportResult(ServerJob job)
at Hyperion.DimensionServer.Global.HandleThreadContext(Guid sessionID, ThreadContextDelegate method)
at Hyperion.DimensionServer.BaseProxy.HandleAPICall(Guid sessionID, ThreadContextDelegate method)
at Hyperion.DimensionServer.Proxies.ApplicationsProxy.GetExportResult(ServerJob job)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at :
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Hyperion.DimensionServer.Interface.IApplications.GetExportResult(ServerJob job)
at Hyperion.DimensionServer.WebServices.Applications.GetExportResult(ServerJob job)
— End of inner exception stack trace —
Solution – The above error generally means we have not done the changes in EPMA dimension library so it is not able to deploy but its the other way we have done the changes but epma database is not able to update the setting as not sync.
to fix the issue -> right click on application -> Diagnostics
Select all and run the task to check which is passed and fail.
In my case we have got one task status as failed. “Deployed status but not in product”.
Click on the task and on the other side you will see some option to fix.
Kindly note please try to have valid back up of epma app and DB before going ahead.
Please try to use the second option like “Retrieve potential deployment locations and click apply.
The application which is showing invalid deploy status
1. Retrieve the instance name and cluster for potential deployed locations.
2. Select the correct deployment location and synchronize the deployment data with the
Click apply and go ahead with deployment and your application will be deployed successfully.