Applies To:

HP ALM Templates


Issue:  

When trying to verify a template, the verification fails and in the verification report it is indicated that a memo field could not be applied because the field was a type CHAR.  Deleting the record (rq_user_template_85) in SYSTEM_FIELD causes an HRESULT error when trying to verify the project again.  It also disables the ability to login to the project.  


Solution:  

If the field was deleted from the project, add the record back to the project: 

 NOTE: The ID 1710 needs to be added to the next available primary key.

Insert into SYSTEM_FIELD (SF_ID, SF_TABLE_NAME, SF_COLUMN_NAME, SF_COLUMN_TYPE, SF_IS_SYSTEM, SF_IS_CANFILTER, SF_IS_KEY, SF_IS_EDIT, SF_IS_ACTIVE, SF_IS_HISTORY, SF_IS_MAIL, SF_IS_VERIFY, SF_IS_BY_CODE, SF_IS_REQUIRED, SF_GRANT_MODIFY, SF_IS_TRANSITION_LOGIC, SF_USER_COLUMN_TYPE, SF_IS_KEEP_VALUE, SF_IS_CUSTOMIZABLE, SF_CAN_CHANGE_PERMISSIONS, SF_FIELD_SIZE, SF_IS_VISIBLE_IN_NEW_BUG, SF_IS_VISIBLE_FOR_GROUPS, SF_IS_TO_SUM, SF_IS_UNDER_VCS, SF_OWNER_SENSIBLE, SF_CAN_GROUP,  SF_IS_SEARCHABLE, SF_IS_VIRTUAL, SF_IS_MULTIVALUE, SF_IS_CROSS_SUBTYPE, SF_IS_SUPPORTS_HISTORY, SF_IS_SUPPORTS_REQUIRED)
VALUES
(1710, 'BUG', 'BG_USER_22', 'char','N', 'Y','N','Y','N','N','N','N','N','N',11110,'Y','char','N','Y','Y',40,11111,11111,'N','N',00000,'N','N','N','N','Y','Y','Y');

   


NOTE: type, length and SF_ID need to be changed based on your needs. 

After the field is added back to the SYSTEM_FIELD table, simply modify the characteristics of the field using the below query: 


 

UPDATE SYSTEM_FIELD set SF_COLUMN_TYPE = 'memo', SF_USER_COLUMN_TYPE = 'memo', SF_FIELD_SIZE = -1
where SF_ID = 10085

  

You may need to add the field to the entity table as well.  Memo field is nVARCHAR(max): 

 

ALTER TABLE table_name
ADD column_name datatype