topic TAC issue for TalendDate function in Talend Studio

TAC issue for TalendDate function

Prakhar1 — Sat, 16 Nov 2024 01:56:17 GMT

Hi,

My job was running fine for few days in Talend, but all of a sudden it is failing now with syntax error.

I have created a query where it pickups date from TalendDate function and use it in WHERE condition.

Is it because of server issue or artifact issue? because the job is working fine in studio.

Re: TAC issue for TalendDate function

Anonymous — Tue, 27 Apr 2021 15:51:14 GMT

Can you provide the where statement and strip any confidential information. Is it possible that you are using implicit context loads and that is being pulled from a file or database that then has changed breaking your where statement. Check the where statement again and just repubublish it again would be my 2 cents if the job is still working in the studio though.

Re: TAC issue for TalendDate function

Prakhar1 — Wed, 28 Apr 2021 05:22:36 GMT

Hi @Evan Teitelbaum ,

So basically everything was right and we republished it in snapshot ( previously it was published as released ) and it worked for one more week, and then again stopped working.

In that time republished was the only option then after some new update done by Admin team on TAC we never see the issue again.

Thanks for your feedback.