repetitive get function calls while getWorkitem with multiple returned_prop

[rajueekgp]

returned_prop = "rtc_cm:defect_category, dc:identifier, rtc_cm:comments" wi = myclient.getWorkitem(225670, returned_properties=returned_prop)

Simillar behaviour is there while using queryWorkitems or runSavedQueryByUrl also and it resulting into taking huge time to fetch all workitems and sometime int token expire

Logs:

2020-06-26 13:07:01,451 DEBUG urllib3.connectionpool: https://www.sscd.rtc.jlrint.com:443 "GET /ccm/oslc/workitems/225670?oslc_cm.properties=dc%3Aidentifier%2C%20rtc_cm%3Acomments%2C%20rtc_cm%3Astate%2C%20dc%3Adescription%2C%20oslc_cm%3Aseverity%2C%20rtc_cm%3Adefect_category%2Crtc_cm%3AcontextId HTTP/1.1" 200 1719 2020-06-26 13:07:01,456 DEBUG workitem.Workitem: Get response from https://www.sscd.rtc.jlrint.com/ccm/oslc/enumerations/_XQN1EB5SEemIkKwQMoULUw/DefectCategory_e/DefectCategory_e.literal.l12 2020-06-26 13:07:01,460 DEBUG urllib3.connectionpool: Starting new HTTPS connection (1): www.sscd.rtc.jlrint.com 2020-06-26 13:07:02,430 DEBUG urllib3.connectionpool: https://www.sscd.rtc.jlrint.com:443 "GET /ccm/oslc/enumerations/_XQN1EB5SEemIkKwQMoULUw/DefectCategory_e/DefectCategory_e.literal.l12 HTTP/1.1" 200 467 2020-06-26 13:07:02,436 DEBUG workitem.Workitem: Get response from https://www.sscd.rtc.jlrint.com/ccm/oslc/workitems/225670/rtc_cm:comments 2020-06-26 13:07:02,440 DEBUG urllib3.connectionpool: Starting new HTTPS connection (1): www.sscd.rtc.jlrint.com 2020-06-26 13:07:03,328 DEBUG urllib3.connectionpool: https://www.sscd.rtc.jlrint.com:443 "GET /ccm/oslc/workitems/225670/rtc_cm:comments HTTP/1.1" 200 7502 2020-06-26 13:07:03,332 DEBUG workitem.Workitem: Get response from https://www.sscd.rtc.jlrint.com/ccm/oslc/enumerations/_XQN1EB5SEemIkKwQMoULUw/severity/severity.literal.l4 2020-06-26 13:07:03,339 DEBUG urllib3.connectionpool: Starting new HTTPS connection (1): www.sscd.rtc.jlrint.com 2020-06-26 13:07:04,196 DEBUG urllib3.connectionpool: https://www.sscd.rtc.jlrint.com:443 "GET /ccm/oslc/enumerations/_XQN1EB5SEemIkKwQMoULUw/severity/severity.literal.l4 HTTP/1.1" 200 626 2020-06-26 13:07:04,199 DEBUG workitem.Workitem: Get response from https://www.sscd.rtc.jlrint.com/ccm/oslc/workflows/_XQN1EB5SEemIkKwQMoULUw/states/com.ibm.team.workitem.workflow.lightWeightDefectWorkflow/com.ibm.team.workitem.workflow.lightWeightDefectWorkflow.state.s6 2020-06-26 13:07:04,203 DEBUG urllib3.connectionpool: Starting new HTTPS connection (1): www.sscd.rtc.jlrint.com 2020-06-26 13:07:05,223 DEBUG urllib3.connectionpool: https://www.sscd.rtc.jlrint.com:443 "GET /ccm/oslc/workflows/_XQN1EB5SEemIkKwQMoULUw/states/com.ibm.team.workitem.workflow.lightWeightDefectWorkflow/com.ibm.team.workitem.workflow.lightWeightDefectWorkflow.state.s6 HTTP/1.1" 200 618 2020-06-26 13:07:05,226 DEBUG client.RTCClient: Get response from https://www.sscd.rtc.jlrint.com/ccm/oslc/workitems/225663?oslc_cm.properties=dc%3Aidentifier%2C%20rtc_cm%3Acomments%2C%20rtc_cm%3Astate%2C%20dc%3Adescription%2C%20oslc_cm%3Aseverity%2C%20rtc_cm%3Adefect_category%2Crtc_cm%3AcontextId 2020-06-26 13:07:05,232 DEBUG urllib3.connectionpool: Starting new HTTPS connection (1): www.sscd.rtc.jlrint.com

[dixudx]

Simillar behaviour is there while using queryWorkitems or runSavedQueryByUrl also and it resulting into taking huge time to fetch all workitems and sometime int token expire

@rajueekgp From the log, it seems multiple workitems/queries are retrieved at the same time, such as 225670 and 225663.

resulting into taking huge time

Actually this library has reduced the times to access the server. Some of them are due to the bad design of RTC. You can refer to the code for details.