The Lookup component can not be edited

Document ID : KB000123470
Last Modified Date : 07/01/2019
Show Technical Document Details
Issue:
r17.1.RU2 The Lookup field can’t be edited.
s long as the element can’t be edited, the methods onBlur, onChange or onClick can’t be used.
Differs completely from 14.1.
As jumping to the Lookup-Field, it can’t be edited.
The dialog "Enter-Parameter" is called immediately, even without using the magnifier.
That causes methods like onblur or onFocus completely useless.
Environment:
Windows, running CA Service Catalog r17.1.RU2
Cause:
For existing forms with the Lookup component, it's attribut named 'Editable' is empty.
Nor false, nor true which causes the issue as described.
Resolution:
Next for the Lookup component the attribute name 'Editable' is empty by default/patch installation.
With this attribute set to "true", the Lookup Field works as usual/correct.

The attribute "Editable" has been empty so far for existing forms.
There is a default value set(false) for new forms.
So, all existing forms need to be changed through an mdb update query:
The first query to be executed is the 'overall' select query as mentioned earlier:
select fe.form_entity_id,fe.form_entity_name,fe.form_entity_type,fca.form_comp_id,fca.attr_name,attr_value 
from usm_form_entities fe, usm_form_component_attributes fca 
where fca.form_comp_id = fe.form_entity_id 
and fe.form_entity_type = 17 
and fca.attr_name = 'editable' 

With my local mdb result:
form_entity_id, form_entity_name, form_entity_type, form_comp_id,attr_name
15507 | userid       | 17 | 15507 | editable | true
15515 | Lookup Field | 17 | 15515 | editable | false
21519 | Suchfeld     | 17 | 21519 | editable | false
21634 | Suchfeld     | 17 | 21634 | editable | false
21937 | Lookup Field | 17 | 21937 | editable | false

The following query then needs to be executed per form_comp_id  (15507,15515,21519,21634,21937):
select * from usm_form_component_attributes where form_comp_id = 15507 and attr_name = 'editable'
603082 | 15507 | _system | editable | true | 1

Finally, the 'update query to set the value to 'true' (per form_comp_id (15507,15515,21519,21634,21937)):
update usm_form_component_attributes set attr_value = 'true' where form_comp_id = 15507 and attr_name = 'editable'