My Oracle Support Banner

Excessive Locking After Upgrading An 11.1.2.4 SQL Server Environment During Last Stage Of Data Load (Doc ID 2433008.1)

Last updated on AUGUST 08, 2018

Applies to:

Hyperion Financial Close Management - Version 11.1.2.4.000 to 11.1.2.4.250 [Release 11.1]
Information in this document applies to any platform.

Symptoms

After upgrading to 11.1.2.4.xx, SQL Server appears to run into extensive locking issues during the last stage of a data load. The locks appear to be on the ARM_SUMMARY_AMOUNTS table, lock looks similar to this:

(@P1 numeric(38,0))SELECT SUMMARY_AMOUNT_ID, RECONCILIATION_ACCOUNT_ID, PERIOD_ID, BUCKET_ID, SUMMARY_TYPE, AMOUNTS, OBJECT_VERSION_NUMBER, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE FROM ARM_SUMMARY_AMOUNTS WITH (HOLDLOCK, ROWLOCK) WHERE SUMMARY_AMOUNT_ID=@P1

NOTE: This is specific to SQL Server environments.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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