ALM TIP HRESULT 0x8004025C
When performing different user actions in ALM11.x, the following error may occur:
Exception from HRESULT 0x8004025C
The error occurs only on projects created on an Oracle Database server.
When a project is created in ALM, the schema name associated with that project consists of the domain name and the project name in the following format: [DomainName]_[ProjectName]_db. ALM truncates the schema name to 30 characters since there is a limitation in Oracle that the schema names cannot exceed 30 bytes (characters). The "HRESULT 0x8004025C" error is caused by a defect in Oracle which limits the project owning schema name to 29 characters only, instead of 30. This is a known defect in Oracle versions 184.108.40.206 and 220.127.116.11. In order to fix the issue, the following solutions could be applied:
- Install the relevant patches for the appropriate version of Oracle:
- For Oracle 18.104.22.168 patch 11822454 should be installed;
- For Oracle 22.214.171.124 patch 13683125 for Linux/Unix or patch 13885389 for Windows;
Note: The above patches should be obtained by Oracle. For more information about this defect and the patches, please contact Oracle support.
- Rename the affected project's schema name to be less or equal to 29 characters.
Note: This information can be found in the following KB article: http://support.openview.hp.com/selfsolve/document/KM00776018
Krystal Mata U.
HP QC/ALM Support Team
(If this post or any other post helps to resolve your issue or query, please mark the thread as solved)
(Posts and opinions made here are my own and do not reflect the opinions of my employer HP in any way)