QMC Task Failure

[FrankC]

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?

[rohitk1609]

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

[Albert_Candelario]

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

[RafaelBarrios]

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,

[Albert_Candelario]

Hello @FrankC ,

Do you have a further update for the Community?

Cheers,

Albert

[FrankC · Accepted solution]

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

[Albert_Candelario · Accepted solution]

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

Cheers,

Albert