Anh’s Status 8/17/2015 – 8/28/2015
Worked with the DBA, Middle Ware teams on INC0037523 INC0037600. They now completed, closed.
Rolled out the Informatica jobs that load KFS Web Services successfully to production. They’ve been running nightly without any issue.
Completed, closed the following jiras:
https://services.adcom.uci.edu/jira/browse/KFSDW-848
https://services.adcom.uci.edu/jira/browse/KFSDW-821
https://services.adcom.uci.edu/jira/browse/KFSDW-743
https://services.adcom.uci.edu/jira/browse/KFSDW-785
https://services.adcom.uci.edu/jira/browse/KFSDW-848
https://services.adcom.uci.edu/jira/browse/KFSDW-853
https://services.adcom.uci.edu/jira/browse/KFSDW-850
https://services.adcom.uci.edu/jira/browse/KFSDW-852
https://services.adcom.uci.edu/jira/browse/KFSDW-786
Fixed the informatica SMS Feed workflow because the design was not correct, truncated the sms feed detail table, wiped out history of data. I recovered all history data to the table. It now loads new records, keeping history data from previous months.
I was able to size the memory needed as 3G for the Unix talend dimension jobs to run on node3dev after getting error “…insufficient memory…”. After that the jobs ran without error, updated current data to all the dimension tables. Analytix needed them to verify against their Informatica dimension jobs.
Created queries to give Bryce to connect to mysql through the linked server because he doesn’t have mysql client installed on his PC.
Investigated with Analytix the 3 ods jobs that failed all of a sudden today after they ran every night without any issue for the last couple weeks. We should hear from them soon.
Anh’s Status 7/27/2015 – 7/31/2015 (1 week status)
...
1) Completed fixing staging krns job
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
2) Pager duty this week.
3) Completed
. Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-671
Completed setting up to schedule this job to run nightly.
4) Emailed ddls scripts to Analytix per their request to create tables below:
...
6) Need to schedule syncInvoiceNumberSundryDebtors to run on production
Anh’s Status 3/28/2015 – 4/10/2015
...
1) Fixed uciSmsGIFeed. ods_kfs.UCI_SMS_FEED_DETAIL_T table now has all records for Feb. data with batch date ’06-MAR-15’, matching Oracle side: 31,647 records, debit amount total is $3,647,165,482.52.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...
5) Analytix: Provided our versions of our DBs that they asked. They confirmed access to talenddev server. Attended weekly status meeting this Friday morning. They're going to send me a list of sqlsver tables so I can send them DDLs to them to create these tables.
6) uciSmsGIFeed: The job loaded month-end data this month without problem. FYI - Following day, this was the 2nd time this month that Jarrod reran, regenerated the trigger. The job ran fine 2nd time.
7) Completed Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-656
Not complete yet section:
1) Staging krns job loaded all tables but Talend sent false notification. I need to debug this job.
2) Export all talend jobs on new server
3) ACCOUNT_CG_PRPSL_NBR not being populated in dss_kfs.KFS_D_ACCOUNT
...
5) SBSO:
with the newest revision to the re-mapping logic: When I came back from my 1-day vacation (due to many accumulated vacation hours, use it or loose it), I was told that we hold off on this task until further direction. Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-486
6) Pager duty next week.
Anh’s Status 3/16/2015 – 3/27/2015
...