2 Replies Latest reply on Sep 19, 2019 4:36 PM by hari venkata suresh appala

    Salesforce read issue

    hari venkata suresh appala Active Member

      Hi All

       

      Today we have faced issue where we are running a mapping task for reading the data from SF object from 3 am to next day 3AM and loading it to a table . during the job run the SF record got an update from SF end  and the  same  updated information has flown down to the table. is this an expected behavior of a sales force connection . Ideally that record should have holded older time stamp due to the update it flow down with update time stamp value . Any one came across the similar issue?

        • 1. Re: Salesforce read issue
          Nitin KN Guru

          pls share timestamps of the task start time, end time, record updated time and also check the timestamp filter with which SOQL ran frrom the task. I assume you are talking about DRS.

          • 2. Re: Salesforce read issue
            hari venkata suresh appala Active Member

            Hi Nitin,

             

             

            please find the timing details of mapping task execution  9/17/2019 05:35 AM – 05:41 AM GMT and the record update in the sales force at 2019-09-17 05:39 AM GMT before that there are few updates on same record at  2019-09-17 01:29 AM GMT and the mapping filter conditions has timing (LastModifiedDate >= 2019-09-16T04:00:00.000Z and LastModifiedDate < 2019-09-17T04:00:00.000Z). But the update date in target loaded as 2019-09-17 05:39 AM GMT .