DCC long running jobs
Hi,
After making changes on Enumerations, Attribute Customization scripts, etc. the DCC jobs take longer than expected (sometimes 6 hours) to run. This impacts our client when it comes to reporting as they need the data to be copied across the Database in time. Is there any way to sort this out? What could be the reason for the jobs to take so long?
Thanks.
The DCC logs show the following as the reason why it takes so long:
11/29/2017 10:26:58,528 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 14000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:28:24,013 [dcc_etl_RTC_Workitem_RTCResourceGroup0_fetcher_0] INFO The fetcher of the resource "RTC_WorkitemProjectArea_R : /rpt/repository/workitem?size=1 : /workitem/projectArea" about to send the query URL => https://jazz.mtn.co.za:9443/ccm/rpt/repository/workitem?fields=workitem%2FprojectArea%2F%28enumerations%2F%28literals%2F%28name%7Cid%29%7Cid%29%7Cstates%2F%28workflow%2Fid%7Cid%7Cname%7Cgroup%29%7CworkItemTypes%2F%28id%7Cname%29%7Cresolutions%2F%28workflow%2Fid%7Cid%7Cname%29%7CapprovalStates%2F%28stateName%7CstateId%29%7CapprovalTypes%2F%28typeName%7CtypeId%29%7CworkItemTypeMappings%2F%28oslcTypeId%7CworkItemTypeId%29%7CuniqueId%7CitemId%7Carchived%29&id=_nOSNwNTbEeeP1czxXL0eTw&modifiedsince=2017-11-29T08%3A50%3A26.001%2B0200&size=1&pos=529 11/29/2017 10:28:41,646 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 15000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:30:12,800 [dcc_etl_RTC_Workitem_RTCResourceGroup0_fetcher_0] INFO The fetcher of the resource "RTC_WorkitemProjectArea_R : /rpt/repository/workitem?size=1 : /workitem/projectArea" about to send the query URL => https://jazz.mtn.co.za:9443/ccm/rpt/repository/workitem?fields=workitem%2FprojectArea%2F%28enumerations%2F%28literals%2F%28name%7Cid%29%7Cid%29%7Cstates%2F%28workflow%2Fid%7Cid%7Cname%7Cgroup%29%7CworkItemTypes%2F%28id%7Cname%29%7Cresolutions%2F%28workflow%2Fid%7Cid%7Cname%29%7CapprovalStates%2F%28stateName%7CstateId%29%7CapprovalTypes%2F%28typeName%7CtypeId%29%7CworkItemTypeMappings%2F%28oslcTypeId%7CworkItemTypeId%29%7CuniqueId%7CitemId%7Carchived%29&id=_nOSNwNTbEeeP1czxXL0eTw&modifiedsince=2017-11-29T08%3A50%3A26.001%2B0200&size=1&pos=530 11/29/2017 10:30:17,680 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 16000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:30:18,062 [dcc_etl_RTC_Workitem_RTCResourceGroup0_fetcher_0] INFO The fetcher of the resource "RTC_WorkitemProjectArea_R : /rpt/repository/workitem?size=1 : /workitem/projectArea" about to send the query URL => https://jazz.mtn.co.za:9443/ccm/rpt/repository/workitem?fields=workitem%2FprojectArea%2F%28enumerations%2F%28literals%2F%28name%7Cid%29%7Cid%29%7Cstates%2F%28workflow%2Fid%7Cid%7Cname%7Cgroup%29%7CworkItemTypes%2F%28id%7Cname%29%7Cresolutions%2F%28workflow%2Fid%7Cid%7Cname%29%7CapprovalStates%2F%28stateName%7CstateId%29%7CapprovalTypes%2F%28typeName%7CtypeId%29%7CworkItemTypeMappings%2F%28oslcTypeId%7CworkItemTypeId%29%7CuniqueId%7CitemId%7Carchived%29&id=_nOSNwNTbEeeP1czxXL0eTw&modifiedsince=2017-11-29T08%3A50%3A26.001%2B0200&size=1&pos=531 11/29/2017 10:32:03,930 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 17000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:32:09,934 [dcc_etl_RTC_Workitem_RTCResourceGroup0_fetcher_0] INFO The fetcher of the resource "RTC_WorkitemProjectArea_R : /rpt/repository/workitem?size=1 : /workitem/projectArea" about to send the query URL => https://jazz.mtn.co.za:9443/ccm/rpt/repository/workitem?fields=workitem%2FprojectArea%2F%28enumerations%2F%28literals%2F%28name%7Cid%29%7Cid%29%7Cstates%2F%28workflow%2Fid%7Cid%7Cname%7Cgroup%29%7CworkItemTypes%2F%28id%7Cname%29%7Cresolutions%2F%28workflow%2Fid%7Cid%7Cname%29%7CapprovalStates%2F%28stateName%7CstateId%29%7CapprovalTypes%2F%28typeName%7CtypeId%29%7CworkItemTypeMappings%2F%28oslcTypeId%7CworkItemTypeId%29%7CuniqueId%7CitemId%7Carchived%29&id=_nOSNwNTbEeeP1czxXL0eTw&modifiedsince=2017-11-29T08%3A50%3A26.001%2B0200&size=1&pos=532 11/29/2017 10:32:09,960 [dcc_etl_RTC_Workitem_RTCResourceGroup0_fetcher_0] INFO CRRCD2801I The data fetcher of the RTC_WorkitemProjectArea_R : /rpt/repository/workitem?size=1 : /workitem/projectArea resource finishes retrieving 532 resources. It took 43848 ms to read and 1751574 ms to parse. 11/29/2017 10:32:19,019 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 3000 rows are updated in the RIODS."REQUEST_STATE" database table. 11/29/2017 10:33:54,484 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 18000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:35:41,931 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 19000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:37:25,894 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 20000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:39:15,309 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 21000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:39:37,626 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 4000 rows are updated in the RIODS."REQUEST_STATE" database table. 11/29/2017 10:40:17,443 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 1000 rows are updated in the RIODS."REQUEST_RESOLUTION" database table. 11/29/2017 10:41:16,987 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 22000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:43:08,997 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 23000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:44:50,762 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 24000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:46:24,755 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 25000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:48:08,203 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 26000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:48:30,298 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 5000 rows are updated in the RIODS."REQUEST_STATE" database table. 11/29/2017 10:49:55,013 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 27000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:51:37,841 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 28000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:53:21,600 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 29000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:55:13,637 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 30000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:56:49,946 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 31000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 10:58:35,942 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 32000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:00:24,597 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 33000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:02:06,007 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 34000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:02:57,915 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 6000 rows are updated in the RIODS."REQUEST_STATE" database table. 11/29/2017 11:03:51,069 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 35000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:05:34,767 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 36000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:07:15,792 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 37000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:09:04,523 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 38000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:09:50,075 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 1000 rows are updated in the RIODS."REQUEST_TYPE" database table. 11/29/2017 11:10:53,570 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 39000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:12:43,047 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 40000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:13:49,472 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 7000 rows are updated in the RIODS."REQUEST_STATE" database table. 11/29/2017 11:14:28,028 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 41000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:16:13,317 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 42000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:18:02,837 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 43000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:19:49,664 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 44000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:21:34,976 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 45000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:23:35,217 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 46000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:24:08,132 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 8000 rows are updated in the RIODS."REQUEST_STATE" database table. 11/29/2017 11:25:19,417 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 47000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table. 11/29/2017 11:27:13,757 [dcc_etl_RTC_Workitem_RTCResourceGroup0_consumer_0] INFO CRRCD2706I 48000 rows are updated in the RICALM."REQUEST_ENUMERATION" database table |
One answer
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
If I'm not mistaken, the above messages cover only one hour. I don't see anything out of the place here.