FIELD_INTEGRITY_EXCEPTION

Highlighted
Five Stars

FIELD_INTEGRITY_EXCEPTION

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


Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

Re: FIELD_INTEGRITY_EXCEPTION

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

All Replies
Fifteen Stars TRF
Fifteen Stars

Re: FIELD_INTEGRITY_EXCEPTION

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


TRF
Five Stars

Re: FIELD_INTEGRITY_EXCEPTION


@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 !

Fifteen Stars TRF
Fifteen Stars

Re: FIELD_INTEGRITY_EXCEPTION

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
Fifteen Stars TRF
Fifteen Stars

Re: FIELD_INTEGRITY_EXCEPTION

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

Kudos also accepted.


TRF

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch