Page Comparison

Anh’s Status 9/9/2016 - 9/22/2016

ETL: 

• Jira Legacy
  server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1495

  Added changes to s_m_ods_kbm_postInfo_Load_Ldgr_Only_T to filter out 'BALANC'.   Completed.  Closed  this jira.  
• Month-end CAFP, CFSBAL:  I informed Jarrod that his triggers were not available as scheduled.  Then he sent them manually.  Our jobs ran as expected.  Completed and verified.
• SBS Aging Month-end: 

on 9/12 SBS aging month-end records were duplicating due to triggers firing twice within 1 minute (at 04:02 am, then at 04:03 am).  I discussed, debugged this issue with Jarrod.   We haven’t discovered the cause yet, and continue to monitor this.  I removed duplicates in the backend.  These records maintain unique in these tables .  In the meantime I’ve been talking to Tu Dang on SBS data and columns in order for me to alter the sbs aging tables to add keys, also to enhance ETL to prevent duplicate records inserting into these tables. 

Annual DW Password changes (last group on production): 

Granted view access in secret server DB to appropriate owners who needed to view the new password to perform their changes.  Completed DW password changes for proper, dssoper, dwhoper, ppsoper. 

UAT:   

Today we received Analytix’s responses and fixes after I emailed the list of jiras to them.  We now can continue with UATs. 

https://jira.oit.uci.edu/browse/KFSDW-1416: Completed and ready to deploy

Below are the remaining jiras that both Analytix and we are waiting for resolution when Pramod comes back from his vacation:

https://jira.oit.uci.edu/browse/KFSDW-1361

Not able to continue with uat due to column DOC_NBR_ID  not exists in the ETL Rule:  If PDP_PMT_DTL_T.FDOC_TYP_CD =  PREQ, CM, or DVCA then get corresponding CUST_PMT_DOC_NBR and lookup with KS_D_DOC_HDR.DOC_NBR_ID and get SID.

https://jira.oit.uci.edu/browse/KFSDW-1362: KFS_F_DSBRMNT_ITM_ACCTNG.  Invalid object name 'D_DATE'.".  Both etl developer, uat tester need Pramod’s solution on this.

Bryce will continue UATs while I'm away in Miami to help my niece and her newborn from 9/28 - 10/11.

Attended weekly DSS meeting

Attended weekly Analytix meeting

Anh’s Status 8/29/2016 - 9/8/2016

...

1) Completed fixing staging krns job

2) Pager duty this week. 

3)  Completed

     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. 

...

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

• 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: 

6) Pager duty next week. 

Anh’s Status 3/16/2015 – 3/27/2015

...