It's all about the answers!

Ask a question

query timeout when running Quality Management etl job

Robin Parker (32633438) | 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/]  WARN                               - query has expired. rerunning the Query _r9j70TO_EeOoSdt1w3qmDQ expired.        at        at        at sun.reflect.GeneratedMethodAccessor736.invoke(Unknown Source)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(        at java.lang.reflect.Method.invoke(       ...

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,


One answer

permanent link
Robin Parker (32633438) | 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.