Clarity Rally Integration query limit of only pulling back 2K Project values

Products

• Clarity PPM On Premise

Issue/Introduction

Rally projects need to be loaded into Clarity with the Import Integration Mappings job. The out of box Rally Projects query is getting values and inserting into the Clarity table and seems the job would limit at 2000 records. The end result is that only 2000 records are loading in Clarity.

 

Lookup: Rally Projects

Lookup ID: RALLY_PROJECTS

SELECT DISTINCT

        @SELECT:ed.code:ext_opt_code@,

@SELECT:ed.name:ext_opt_name@,        

@SELECT:ed.external_opt_id:ext_opt_id@

FROM   int_external_data ed

        JOIN int_external_attributes ea ON ed.external_attr_id = ea.obj_uuid 

        JOIN int_external_objects eo ON ea.external_object_id = eo.id

        JOIN int_objectmappings om ON eo.code = om.external_object_id AND ed.im_id = om.im_id 

        JOIN int_integrationmappings im ON om.im_id = im.id

        JOIN inv_investments inv ON inv.odf_object_code = om.clarity_object_id

WHERE  ea.name = 'Project'

AND    ea.external_data_type = 'OBJECT'

AND    @FILTER@

@BROWSE-ONLY:

AND    ed.is_active = 1

AND   (@WHERE:PARAM:USER_DEF:STRING:INV_CODE_CONSTRAIN@ = inv.code)

AND   (@WHERE:PARAM:USER_DEF:STRING:IM_ID_CONSTRAIN@ = im.code)

:BROWSE-ONLY@

 

Steps to Reproduce:
1. Login as an administrator
2. Run the Import Integration Mappings job
3. Review the expected Rally Projects pulled

Expected Result: The job would go through all the record and load expected projects
Actual Result: The Job is only loading 2000 records
Workaround: none

Resolution

DE155910 is now fixed with a code change in Clarity 16.3.1 and 16.3.0.1 patch.