For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
We're seeing the following error in HFM. What would be the cause?
Failed to added lock into the DB. It's possible that the same thread can ask for the same lock twice
Please take a look at the following.
SOLUTION
An in-depth review of the network between the HFM application server(s) and the database server(s) is required to identify the cause of the dropped or reset connections.
Workaround:
On Oracle databases, if a firewall or load balancer is between tiers, tune the parameters for Dead Connection Detection (DCD) at the database side (SQLNET.EXPIRE_TIME). In ORACLE_HOME/network/admin/sqlnet.ora file set DCD interval. Interval should be set to at least half the idle connection timeout to ensure connection remains active. So if idle timeout is 30 minutes, set the DCD interval to 15 minutes eg:
sqlnet.expire_time = 10
More details about DCD can be found in Resolving Problems with Connection Idle Timeout With Firewall Document 257650.1
Hi there,
We have similar issues but we have not managed to identify the issue.
Try to confirm if 2 or more consolidations were running at the same time in the same POV.
Cheers,
Thanos
@"983332" and @"Thanos A." - What release of HFM are you running? 11.1.2.4.??? .200-.208?
Have you checked out this KB article yet for any applicable issues?
Oracle Support Document 2408794.1 (Hyperion Financial Management (HFM) Performance Slow and Tasks Fail or Abort with Errors in System Messages: "Database connection failure" "Stale DB connection found!! Replaced with new DB connection." "Wait time expired. Block") can be found at:
https://support.oracle.com/epmos/faces/DocumentDisplay?id=2408794.1
Can you provide any more details on the issue? Any event log snippets, etc? Please ensure you cleanse anything client specific though before posting.
Let us know if we can help!
Kind Regards,
Joe Malewicki
Please remember to click “Mark as Answered” on the post that helps you. This can be beneficial to other community members reading the thread.
Does anyone still have the Oracle document Document 2408794.1? We have the same issues, but I don't seem to have access to this document.
Hi all,
We had this issue with 205 and I think that this issue is fixed in 206.
Unfortunately, this document is not accessible to me.