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

  • KM03661931
  • 01-Jul-2020
  • 01-Jul-2020

Summary

MF Connect - Unable to map 'Assigned To' in ALM Defects There is no error, simply that mapping the field is not possible

Error

There is no error, simply that mapping the field is not possible

Cause

This is caused by an integer value in the SF_ROOT_ID field within the SYSTEM_FIELD table for the field BG_RESPONSIBLE (Assigned To) in the ALM project db/schema

This field, by default, is null and having an integer value in the SF_ROOT_ID field for the BG_RESPONSIBLE field isn't usually a problem.

However, in the case of MF Connect, perhaps other contexts, it can present an issue.

In this case the field cannot be mapped.

Fix

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'

  1. 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....

  1. Click Tools>Customize
  2. Select “Project Entities” in the left column
  3. In the main view expand the “Defect” item
  4. Select “User Fields”
  5. Select the field added in Step 6, note the lookup list its using
  6. Click “Delete Field” in the top toolbar, click yes to confirm
  7. Click the “Save” button in the top toolbar
  8. In the left column select “Project Lists”
  9. In the Project Lists view select the list created in Step 9
  10. Click “Delete List” button in the top toolbar, click Yes to confirm
  11. Click the “Save” button in the top toolbar
  12. Exit the project customization
  13. In the Customization Changes dialog select the “Major Change” radio button, then click OK.