Cross Project Customization Issue

Question ID: 108895
0
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:
For input string: "9223372036854775807";
I did find an error in the logs at the time of applying the customization. Failed to enforce policy on project.

Low level reason:

com.hp.alm.platform.db.CTdDbException

Messages:
Can’t hide the field AS_LOGICAL_NAME as it does not support data hiding.;

I appreciate any information you can share regarding this issue.

Marked as spam
Posted by (Questions: 219, Answers: 23)
Asked on February 21, 2019 3:38 pm
29 views
Answers (1)
0
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 (Questions: 2, Answers: 280)
Answered on February 21, 2019 3:40 pm
The query resolved the issue. I am now able to apply the customizations from the template to liked projects without any issues. Thank you for your help!
( at February 21, 2019 3:41 pm)