Cross Project Customization Issue
| ♥ 0 |
Hello. When attempting to apply template customization to 2 projects I get the following error: System.InvalidCastException: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)) So far, I have tried the following in an attempt to resolve the issue… Added the MAX_QUERY_LENGTH parameter, starting out with the value 2000000 in Site Admin – I then raised the length to the max Value listed in the ALM Site Parameters Guide, 9223372036854775807 and I currently have the value set to the max java int size of 2147483647 I ran a Verify and Repair on both the template and the linked projects, but the issue still occurs. I am also finding the following error message in the logs after running the verify and repair, then retesting to see if the issue still occurs… Messages: Low level reason: com.hp.alm.platform.db.CTdDbException Messages: I appreciate any information you can share regarding this issue.
Marked as spam
|
Posted by |
Private answer
Hello. I have seen this issue before, and it was resolved by performing the following. You may need to get your DBA involved during this process. First, you will need to run the following query against the 'GROUPS' table for the affected project in Site Admin to see if the 'SF_IS_VISIBLE_FOR_GROUPS' field contains any 1's. When functioning correctly, the field should display all 0's. The query that follows will provide you with the information you need. Before you perform any of the following, it is recommended that you backup a copy of the affected project repository, as well as the project database in case any unforeseen issue occurs. SELECT SF_IS_VISIBLE_FOR_GROUPS FROM SYSTEM_FIELD where SF_COLUMN_NAME = 'AS_LOGICAL_NAME' If there are any 1's displayed in the 'SF_IS_VISIBLE_FOR_GROUPS' field for 'AS_LOGICAL_NAME', then you will need to run the following query to set it back to all 0's. Before running the query, please be sure to make a backup copy of the project repository and database, in case any unforeseen issue occurs. UPDATE SYSTEM_FIELD SET SF_IS_VISIBLE_FOR_GROUPS = '0000000000000' where SF_COLUMN_NAME = 'AS_LOGICAL_NAME' It is recommended to run these queries on a copy of the project or test environment, and test the behavior before implementing it in your production environment. Marked as spam
 Posted by jameslcoleman (Questions: 2, Answers: 300) Answered on February 21, 2019 3:40 pm
|