FIELD_INTEGRITY_EXCEPTION

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
Highlighted
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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’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

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog