My Oracle Support Banner

Hyperion Planning Application Deployment Hangs in EPMA and SQL Server Database Becomes Locked (Doc ID 1122623.1)

Last updated on SEPTEMBER 23, 2019

Applies to:

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


After deleting a shared member from the Entity dimension in Enterprise Performance Management Architect (EPMA), the subsequent re-deployment of the Planning application freezes at 9% and never completes. The following details are shown in the Job Console:

Initiating Product Action
Inspecting Deployment History
Retrieving Deployment Instance Information
Generating Headers and callback information
Generating Application Data
Preparing Product Request
Posting Product Request
Product Response: 200
Waiting for Status Updates

At this point it is also noticed that there are locks on the Planning application tables in the SQL Server 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!

In this Document

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