MF Connect - Unable to map 'Assigned To' in ALM Defects

Use the following procedure to correct this issue...

In Oracle directly…

update <schema_id>.system_field set sf_root_id = null where sf_column_name = 'BG_RESPONSIBLE';

commit;

In MSSQL Mgmt Studio directly...

update dbo.system_field set sf_root_id = null where sf_column_name = 'BG_RESPONSIBLE'

Or...

update td.system_field set sf_root_id = null where sf_column_name = 'BG_RESPONSIBLE'

Or within the ALM Site Administration...

1. Select the Project in question
2. Expand the table structure
3. Select the SYSTEM_FIELD table
4. Paste the following query in the query textbox…

             update system_field set sf_root_id = null where sf_column_name = 'BG_RESPONSIBLE'

5. Click the “Execute SQL” button to the right of the query textbox

Note: a successful run of the query will display “Empty Table” in the main view

Next, because values are cached we need to alter the customization in ALM to refresh the cache..

1. Login to the ALM project in question
2. Click Tools>Customize
3. Select “Project Entities” in the left column
4. In the main view expand the “Defect” item
5. Select “User Fields”
6. Click the “New Field” button on the top toolbar
7. In the field details change the “Type” to “Lookup List”
8. In the lower area click the “New List” button
9. Give the list a name, something like “TempList”
10. Click okay, the Project List Dialog should open
11. Click “New Item”, give it some value like “a”
12. Click OK
13. Click the “Save” button in the top toolbar
14. Exit the project customization
15. In the Customization Changes dialog select the “Major Change” radio button, then click OK.

Back in the project view we need to reverse what was done above....

16. Click Tools>Customize
17. Select “Project Entities” in the left column
18. In the main view expand the “Defect” item
19. Select “User Fields”
20. Select the field added in Step 6, note the lookup list its using
21. Click “Delete Field” in the top toolbar, click yes to confirm
22. Click the “Save” button in the top toolbar
23. In the left column select “Project Lists”
24. In the Project Lists view select the list created in Step 9
25. Click “Delete List” button in the top toolbar, click Yes to confirm
26. Click the “Save” button in the top toolbar
27. Exit the project customization
28. In the Customization Changes dialog select the “Major Change” radio button, then click OK.