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

(Doc ID 1122623.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

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.

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