RGI/Yardi Issue

Flow of Yardi data:

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

Step	Time	Data flow
1	2:30 am	Yardi exports data to file (Path in CoT);
2	unknown	Script copy the file to SSHA IT share path;
3	7:00 am	SSHA IT imports the Yardi file to SSHA database (MS SQL);
4	8:25 am	HSI Datasync application retrieves the delta records from SSHA database and uploads to Salesforce.

Contact List

Department	Person
SSHA BA	Sumathi Vasudevan
	Eric Lee
SSHA IT	~~Claudio Aretusi~~
	Atul Medhekar (Manager)
CoT	~~Stephen 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:
Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.

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

Date	Event	Failed Step	Follow up with SSHA	with CoT	with SSHA IT	HSI
2021-06-02	HSI datasync deployed a new version to upload Yardi data to Salesforce
2021-06-17	at 8:30 am, found no email notice for Yardi uploading	Yardi	Confirmed with Sumathi; Sumathi confirmed Yardi team found a connection error and did manual transferring file.			Waiting for next day's uploading.
2021-07-07	at 8:30 am, found no email notice for Yardi uploading	Yardi	Confirmed with Claudio – the file was old; Confirmed with Sumathi: Same issue happened, did manual transfer;			Waiting for next day's uploading.
2021-07-12	Yardi setup an email notice for transfer status
2021-07-15	at 8:30 am, found no email notice for Yardi uploading	CoT	Confirmed 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-13	Sumathi noticed that transfer failed of Yardi file	Yardi	Manual transferred file.			Requested a manual uploading in the afternoon
2021-08-20	at 8:30 am, found no email notice for Yardi uploading	Yardi	Follow 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-14	Sumathi found Yardi failed to transfer	Yardi	Sumathi followed up re-run the exporting.		Claudio manual import the file	Manual request TCS IT re-run the job
2021-10-15	at 8:30 am, found no email notice for Yardi uploading	Yardi	Eric helped follow up re-run the exporting.		Claudio manual import the file	Manual request TCS IT re-run the job
2021-11-01	Sumathi found Yardi failed to transfer	Yardi				Skipped for non-weekday.
2021-11-13	Sumathi found Yardi failed to transfer	Yardi				Skipped for non-weekday.
2021-12-01	at 8:30 am, found no email notice for Yardi uploading	unknown				Wait for next day
2022-01-14/17	at 8:30 am, found no email notice for Yardi uploading	CoT	Sumathi confirmed no issue.	Sumathi followed up with CoT team to transfer the file	Atul manual import the file.	re-run at 14:30.
2022-02-01	at 8:30 am, found no email notice for Yardi uploading	CoT	Sumathi confirmed no issue.	Sumathi followed up with CoT team to transfer the file	Atul manual import the file.	re-run at 14:30.