Versions Compared

Version Old Version 2 New Version Current
Changes made by

Vincent Li

Vincent Li

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • There are 4 steps sync data from Yardi to Salesforce, here is the daily schedule:


StepTimeData flow
12:30 amYardi exports data to file (Path in CoT);
2unknown

Script copy the file to SSHA IT share path;Image Added

37:00 amSSHA IT imports the Yardi file to SSHA database (MS SQL);
48:25 amHSI Datasync application retrieves the delta records from SSHA database and uploads to Salesforce.


  • Contact List
DepartmentPerson
SSHA BASumathi Vasudevan

Eric Lee
SSHA ITClaudio Aretusi

Atul Medhekar (Manager)
CoTStephen Lew (need update)


  • Issue fix steps:
    if no RGI/Yardi email notice at 8:25 am, wait for while to check RGI logs, if error/exception found, contact Sumathi;
    If Sumathi found the issue, please re-run it (Step 1-3) and send email alert notice to related persons;
    Re-run schedule job is set 14:25, need monitor the email notice.
  • There is a ticket to track the issue: 
    Jira Legacy
    serverJIRA
    serverId171541f2-d15a-30f9-88a2-170d76c90864
    keyHSIF-2974

  • Here is an tracking timeline for RGI/Yardi transfer issue:

    DateEventFailed StepFollow up with SSHAwith CoTwith SSHA ITHSI
    2021-06-02HSI datasync deployed a new version to upload Yardi data to Salesforce




    2021-06-17at 8:30 am, found no email notice for Yardi uploadingYardiConfirmed with Sumathi;
    Sumathi confirmed Yardi team found a connection error and did manual transferring file.

    		Waiting for next day's uploading.
    2021-07-07at 8:30 am, found no email notice for Yardi uploadingYardiConfirmed with Claudio – the file was old;
    Confirmed with Sumathi:
    Same issue happened, did manual transfer;

    		Waiting for next day's uploading.
    2021-07-12Yardi setup an email notice for transfer status




    2021-07-15at 8:30 am, found no email notice for Yardi uploadingCoTConfirmed Sumathi/Eric,, Yardi transferred successfully.Eric followed up with Stephen Lew, found file transferring was pending, reset the password, did manual transferring.
    		Waiting for next day's uploading.
    2021-08-13Sumathi noticed that transfer failed of Yardi fileYardiManual transferred file.

    		Requested a manual uploading in the afternoon
    2021-08-20at 8:30 am, found no email notice for Yardi uploadingYardiFollow up with Sumathi/Eric (Sumathi is off today)
     Eric confirmed there was an error in Yardi transferring file.
    Claudio did manual uploading importing the file.

    		 Requested a manual uploading in the afternoon
    2021-10-14Sumathi found Yardi failed to transferYardiSumathi followed up re-run the exporting.
    		Claudio manual import the fileManual request TCS IT re-run the job
    2021-10-15at 8:30 am, found no email notice for Yardi uploadingYardiEric helped follow up re-run the exporting.
    		Claudio manual import the fileManual request TCS IT re-run the job
    2021-11-01Sumathi found Yardi failed to transferYardi


    		Skipped for non-weekday.
    2021-11-13Sumathi found Yardi failed to transferYardi


    		Skipped for non-weekday.
    2021-12-01at 8:30 am, found no email notice for Yardi uploadingunknown


    		Wait for next day
    2022-01-14/17at 8:30 am, found no email notice for Yardi uploadingCoTSumathi confirmed no issue.Sumathi followed up with CoT team to transfer the fileAtul manual import the file.re-run at 14:30.
    2022-02-01at 8:30 am, found no email notice for Yardi uploadingCoTSumathi confirmed no issue.Sumathi followed up with CoT team to transfer the fileAtul manual import the file.re-run at 14:30.