It's all about the answers!

Ask a question

query timeout when running Quality Management etl job


Robin Parker (32633738) | asked Oct 13 '13, 5:12 a.m.
edited Oct 13 '13, 5:12 a.m.
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
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




One answer



permanent link
Robin Parker (32633738) | answered Oct 14 '13, 3:20 a.m.
Ah, its OK.... the job did finish after all

Your answer


Register or to post your answer.