topic Re: Error in the execution of a query in Talend Studio https://community.qlik.com/t5/Talend-Studio/Error-in-the-execution-of-a-query/m-p/2265862#M45269 <P>Thanks Thomas, it works now. But I got another error&nbsp;<span class="lia-inline-image-display-wrapper" image-alt="0683p000009MPcz.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157233iD1A564EF62DE3BC2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MPcz.png" alt="0683p000009MPcz.png" /></span></P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="6.PNG" style="width: 707px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6V5.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153014i78B3DDB17641C522/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6V5.png" alt="0683p000009M6V5.png" /></span></SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 01 Aug 2019 12:43:01 GMT Hajar1 2019-08-01T12:43:01Z Error in the execution of a query https://community.qlik.com/t5/Talend-Studio/Error-in-the-execution-of-a-query/m-p/2265860#M45267 <P>Hi,</P> <P>I want to execute a job in which there is the following query:</P> <P>"SELECT "+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_request.seq_day_tmp,"<BR />"coalesce("+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_request.seq_request_tmp,(SELECT "+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".dim_request_scd.seq_request_scd FROM "+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".dim_request_scd"<BR />"WHERE "+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_dim_request_scd.seq_request=(select "+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_dim_request.seq_request from "+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_dim_request"<BR />"WHERE "+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_dim_request.cod_request='Non Renseigné'))) AS seq_request_tmp,"<BR />""+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_request.seq_request_scd_tmp,"<BR />""+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_request.seq_application_tmp,"<BR />""+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_request.deadlines_taking_charges_tmp,"<BR />""+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_request.deadlines_solving_tmp,"<BR />""+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_request.deadlines_delivery_tmp,"<BR />""+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_request.nb_resquest_tmp,"<BR />""+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_request.flag_successeful_delivery_tmp,"<BR />"FROM "+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_request"<BR />"left outer join "+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_dim_request_scd"<BR />"on "+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_request.seq_request_tmp="+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_dim_request_scd.seq_request"<BR />"and ("+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+\".\"+tmp_dim_request_scd.dat_begin = null or (select CURRENT_DATE) &gt;= "+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+".tmp_dim_request_scd.dat_begin)"<BR />"and ("+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+\".\"+tmp_dim_request_scd.dat_end = null or (select CURRENT_DATE)&lt;"+context.DW_ES_TMP_Database+\".\"+context.DW_ES_TMP_Schema+\".\"+tmp_dim_request_scd.dat_end);"</P> <P>&nbsp;</P> <P>But the execution I got the following error:</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="5.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6V0.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148619i38F0BBF3EB74D931/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6V0.png" alt="0683p000009M6V0.png" /></span></SPAN></P> Thu, 01 Aug 2019 09:26:26 GMT https://community.qlik.com/t5/Talend-Studio/Error-in-the-execution-of-a-query/m-p/2265860#M45267 Hajar1 2019-08-01T09:26:26Z Re: Error in the execution of a query https://community.qlik.com/t5/Talend-Studio/Error-in-the-execution-of-a-query/m-p/2265861#M45268 <P>Hi ra_2019,</P><P>&nbsp;</P><P>is there a + plus sign missing before "WHERE " (in lines 5 and 8)?</P><P>&nbsp;</P><P>Best regards,</P><P>&nbsp;</P><P>Thomas</P><P>&nbsp;</P> Thu, 01 Aug 2019 10:02:09 GMT https://community.qlik.com/t5/Talend-Studio/Error-in-the-execution-of-a-query/m-p/2265861#M45268 ThWabi 2019-08-01T10:02:09Z Re: Error in the execution of a query https://community.qlik.com/t5/Talend-Studio/Error-in-the-execution-of-a-query/m-p/2265862#M45269 <P>Thanks Thomas, it works now. But I got another error&nbsp;<span class="lia-inline-image-display-wrapper" image-alt="0683p000009MPcz.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157233iD1A564EF62DE3BC2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MPcz.png" alt="0683p000009MPcz.png" /></span></P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="6.PNG" style="width: 707px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6V5.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153014i78B3DDB17641C522/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6V5.png" alt="0683p000009M6V5.png" /></span></SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 01 Aug 2019 12:43:01 GMT https://community.qlik.com/t5/Talend-Studio/Error-in-the-execution-of-a-query/m-p/2265862#M45269 Hajar1 2019-08-01T12:43:01Z