FIELD_INTEGRITY_EXCEPTION

[rohitpatil1993]

Hi
I am not able to figure out on how this error will be resolved in Talend.
Kindly help me with identifying insights on how this issue can be resolved.
Please find the logs for analysis.

                +-------------------------------------------------------------------------------------------------------------------------------=|

|1   |null        |07142671860001       |GAM - VD Chaumont     |Mme                      |FRADIN Nicole       |07142671860001|79360              |PRISSE LA CHARRIERE   |null                      |null                |null         |USINE GROUPE  INTERV|22 Route de SURGERES    |null   |F            |PRODUITS PVC PORTES BAIES FENETRES|null             |null        |CH 30150        |null          |null              |null        |1316          |COUGNAUD     |false                      |ROUTE DU POIRE   |null                |F            |AIZENAY        |02 51 45 51 45     |02 51 09 43 81|0          |85190       |ART VERT LIVRAISON COUGNAUDX|2018-01-25T12:00:00Z |2018-01-31T12:00:00Z|null           |0118-01-18T12:00:00Z      |null          |0.0           |2018-01-25T12:00:00Z|null                     |null          |null                |false               |FIELD_INTEGRITY_EXCEPTION:Intervention commandée le: date non valide : Mon Jan 18 00:00:00 GMT 118:InterventionCommandeeLe__c --|

'----+------------+---------------------+-------


Let me know if you need more insights on this issue

[TRF]

For sure, "0118-01-18T12:00:00Z" is not a valid date from a salesforce point of view.

[rohitpatil1993]

---

@TRF wrote:

For sure, "0118-01-18T12:00:00Z" is not a valid date from a salesforce point of view

So what next ?
Is modification expected from salesforce or Talend ?
and, If "Yes" for Talend then where do I initiate the modification ?
Thank you for that information TRF !

[TRF · Accepted solution]

Valide dates for salesforce avec from 01-01-1700 to 12-31-4000.

https://help.salesforce.com/articleView?id=000240801&type=1

You have 2 options:

- let salesforce reject these incorrect values

- change these values in your job

This is your choice, depending of your use case.

[TRF]

@rohitpatil1993, thank's to mark your case as solved.

Kudos also accepted.