Excessive Locking After Upgrading An 184.108.40.206 SQL Server Environment During Last Stage Of Data Load
(Doc ID 2433008.1)
Last updated on FEBRUARY 17, 2019
Applies to:Hyperion Financial Close Management - Version 220.127.116.11.000 to 18.104.22.168.250 [Release 11.1]
Information in this document applies to any platform.
After upgrading to 22.214.171.124.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
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