Hyperion Planning Application Deployment Hangs in EPMA and SQL Server Database Becomes Locked

(Doc ID 1122623.1)

Last updated on MARCH 21, 2018

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.


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