Timeout reached before MultiLoad opened

[bhaskarjha]

Hi,
I have a job which fails regularly on weekend, but its running fine over weekdays.

ODBC => Transformer => TD Mload

We have two target table stage on Output. Though there are no rows to fetch Job is running for 25 min & fails with above error.

Please help if we need to set some parameter at admin level or at Database.

Thanks,
Bhaskar

[chulett]

So... it runs ok when there are records to load but doesn't when there aren't? Worst case you could split the job - land the data and only issue the MLoad if there's date to load.

Or you could just wait for someone who actually knows something about Teradata to respond.