topic Re: QMC Task Failure in Management & Governance

QMC Task Failure

FrankC — Wed, 21 Sep 2022 17:28:49 GMT

A little confused here

I can run the load manually and it completes successfully. But the scheduled task fails for a table not being there (Drop table statement. I comment out the drop table statement and the task completes successfully.

Any thoughts?

Re: QMC Task Failure

rohitk1609 — Thu, 22 Sep 2022 14:26:28 GMT

Frank, Ideally, Execution manually and by Tasks QMC is same. Probably you have multi node system and when you schedule the task and where app run, from there table is not reachable

Thanks,
Rohit

Re: QMC Task Failure

Albert_Candelario — Mon, 26 Sep 2022 13:56:29 GMT

Hello @FrankC ,

Is there a chance you can add a screenshot of the issue?

You said that if you do not drop it works fine, what happen if you add an sleep(10) before dropping the table, will continue to fail? I would be curious.

Cheers,

Albert

Re: QMC Task Failure

RafaelBarrios — Mon, 26 Sep 2022 17:59:17 GMT

Hi @FrankC

It seems to me that we all need more information, but I can only think in two options here.

The first is that you are using partial reloads, so when you run the standart reload from QMC the table does not exist because you used add, replace or merge with an ONLY prefix.

The second is that your table is being concatenated with another that has the same fields, BUT this should happen from the HUB or the QMC.
Try adding a noconcatenate before the load of the table you're trying to drop later.

Best,

Re: QMC Task Failure

Albert_Candelario — Wed, 12 Oct 2022 13:39:14 GMT

Hello @FrankC ,

Do you have a further update for the Community?

Cheers,

Albert

Re: QMC Task Failure

FrankC — Wed, 12 Oct 2022 13:43:13 GMT

Not sure what the really was, but we change the load to QVD instead of pulling from the database and it worked

Re: QMC Task Failure

Albert_Candelario — Wed, 12 Oct 2022 18:42:14 GMT

Thanks @FrankC for letting us know the issue was resolved via an alternative approach.

Cheers,

Albert