topic Re: FIELD_INTEGRITY_EXCEPTION in Talend Studio https://community.qlik.com/t5/Talend-Studio/FIELD-INTEGRITY-EXCEPTION/m-p/2276067#M52259 <BLOCKQUOTE> <HR /> <A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG">@TRF</A>&nbsp;wrote: <BR /> <P>For sure, "<SPAN>0118-01-18T12:00:00Z" is not a valid date from a salesforce point of view</SPAN></P> </BLOCKQUOTE> <P>So what next ?<BR />Is modification expected from salesforce or Talend ?<BR />and, If "Yes" for Talend then where do I initiate the modification ?<BR />Thank you for that information TRF !</P> Tue, 23 Oct 2018 11:36:16 GMT rohitpatil1993 2018-10-23T11:36:16Z FIELD_INTEGRITY_EXCEPTION https://community.qlik.com/t5/Talend-Studio/FIELD-INTEGRITY-EXCEPTION/m-p/2276065#M52257 <P>Hi<BR />I am not able to figure out on how this error will be resolved in Talend.<BR />Kindly help me with identifying insights on how this issue can be resolved.<BR />Please find the logs for analysis.</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +-------------------------------------------------------------------------------------------------------------------------------=|</P> <P>|1&nbsp;&nbsp; |null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |07142671860001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |GAM - VD Chaumont&nbsp;&nbsp;&nbsp;&nbsp; |Mme&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |FRADIN Nicole&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |07142671860001|79360&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |PRISSE LA CHARRIERE&nbsp;&nbsp; |null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |USINE GROUPE&nbsp; INTERV|22 Route de SURGERES&nbsp;&nbsp;&nbsp; |null&nbsp;&nbsp; |F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |PRODUITS PVC PORTES BAIES FENETRES|null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;|null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |CH 30150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |1316&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |COUGNAUD&nbsp;&nbsp;&nbsp;&nbsp; |false&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |ROUTE DU POIRE&nbsp;&nbsp; |null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |AIZENAY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |02 51 45 51 45&nbsp;&nbsp;&nbsp;&nbsp; |02 51 09 43 81|0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |85190&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |ART VERT LIVRAISON COUGNAUDX|2018-01-25T12:00:00Z |2018-01-31T12:00:00Z|null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |0118-01-18T12:00:00Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |0.0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2018-01-25T12:00:00Z|null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |false&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;|<STRONG>FIELD_INTEGRITY_EXCEPTION:Intervention commandée le: date non valide&nbsp;: Mon Jan 18 00:00:00 GMT 118:InterventionCommandeeLe__c --</STRONG>|</P> <P>'----+------------+---------------------+-------<BR /><BR /><BR />Let me know if you need more insights on this issue</P> Tue, 23 Oct 2018 08:15:26 GMT https://community.qlik.com/t5/Talend-Studio/FIELD-INTEGRITY-EXCEPTION/m-p/2276065#M52257 rohitpatil1993 2018-10-23T08:15:26Z Re: FIELD_INTEGRITY_EXCEPTION https://community.qlik.com/t5/Talend-Studio/FIELD-INTEGRITY-EXCEPTION/m-p/2276066#M52258 <P>For sure, "<SPAN>0118-01-18T12:00:00Z" is not a valid date from a salesforce point of view.</SPAN></P> Tue, 23 Oct 2018 08:48:46 GMT https://community.qlik.com/t5/Talend-Studio/FIELD-INTEGRITY-EXCEPTION/m-p/2276066#M52258 TRF 2018-10-23T08:48:46Z Re: FIELD_INTEGRITY_EXCEPTION https://community.qlik.com/t5/Talend-Studio/FIELD-INTEGRITY-EXCEPTION/m-p/2276067#M52259 <BLOCKQUOTE> <HR /> <A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG">@TRF</A>&nbsp;wrote: <BR /> <P>For sure, "<SPAN>0118-01-18T12:00:00Z" is not a valid date from a salesforce point of view</SPAN></P> </BLOCKQUOTE> <P>So what next ?<BR />Is modification expected from salesforce or Talend ?<BR />and, If "Yes" for Talend then where do I initiate the modification ?<BR />Thank you for that information TRF !</P> Tue, 23 Oct 2018 11:36:16 GMT https://community.qlik.com/t5/Talend-Studio/FIELD-INTEGRITY-EXCEPTION/m-p/2276067#M52259 rohitpatil1993 2018-10-23T11:36:16Z Re: FIELD_INTEGRITY_EXCEPTION https://community.qlik.com/t5/Talend-Studio/FIELD-INTEGRITY-EXCEPTION/m-p/2276068#M52260 <P>Valide dates for salesforce avec from 01-01-1700 to 12-31-4000.</P><P><A href="https://help.salesforce.com/articleView?id=000240801&amp;type=1" target="_blank" rel="nofollow noopener noreferrer">https://help.salesforce.com/articleView?id=000240801&amp;type=1</A></P><P>You have 2 options:</P><P>- let salesforce reject these incorrect values</P><P>- change these values in your job</P><P>This is your choice, depending of your use case.</P> Tue, 23 Oct 2018 14:06:35 GMT https://community.qlik.com/t5/Talend-Studio/FIELD-INTEGRITY-EXCEPTION/m-p/2276068#M52260 TRF 2018-10-23T14:06:35Z Re: FIELD_INTEGRITY_EXCEPTION https://community.qlik.com/t5/Talend-Studio/FIELD-INTEGRITY-EXCEPTION/m-p/2276069#M52261 <P><A href="https://community.qlik.com/s/profile/005390000069IaWAAU">@rohitpatil1993</A>, thank's to mark your case as solved.</P> <P>Kudos also accepted.</P> Thu, 25 Oct 2018 17:26:58 GMT https://community.qlik.com/t5/Talend-Studio/FIELD-INTEGRITY-EXCEPTION/m-p/2276069#M52261 TRF 2018-10-25T17:26:58Z