query timeout when running Quality Management etl job
Hi all,
While trying to do a full load of our data warehouse the Quality Management job seems to be taking a very long time....1 day, 12 hours so far....
What concerns me are the messages in the qm.log .... every 2 - 4 hours I get a
I am concerned that this query (for all the execution results?) is never going to complete as it's been producing this message every 4 hours for over a day already.
Any idea how I can resolve this?
Many Thanks,
Robin
While trying to do a full load of our data warehouse the Quality Management job seems to be taking a very long time....1 day, 12 hours so far....
What concerns me are the messages in the qm.log .... every 2 - 4 hours I get a
2013-10-13 08:38:17,508 [http-bio-9443-exec-17665 @@ 08:38 dwuser /qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/EBS+%28Quality+Management%29/executionresult] WARN com.ibm.rqm.execution - query has expired. rerunning the query.com.ibm.team.repository.common.QueryExpiredException: Query _r9j70TO_EeOoSdt1w3qmDQ expired. at com.ibm.team.repository.service.internal.QueryService.doFetchPage(QueryService.java:456) at com.ibm.team.repository.service.internal.QueryService.fetchPage(QueryService.java:205) at sun.reflect.GeneratedMethodAccessor736.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:600) ...
I am concerned that this query (for all the execution results?) is never going to complete as it's been producing this message every 4 hours for over a day already.
Any idea how I can resolve this?
Many Thanks,
Robin