Versions Compared

Version Old Version 65 New Version 66
Changes made by

Kim Anh Thi Le

Oluwasemilore Ajibola

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Repair Jira Macros

Anh's Status 11/18 - 12/11

...

https://jira.oit.uci.edu/browse/KFSDW-1537  (Load CG_AGENCY_ADDR_T to dwhs_ods db on nebula/nova):  This task was completed, verified and was migrated to production.

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1443
(KFS_F_TEM_ACCTNG):  I was asked to help the Analytix team with the issue of the unique index on the field (TEM_ACCNT_LN_ID) of the KFS_F_TEM_ACCTNG fact table rejecting rows.  After analysis, Austin confirmed that the index is not required.  I removed it.  They were able to continue until they encountered another issue with the duplicate records in the source table.  These dup. records  are stemmed from an Oracle table.  A new jira KFSI-13867 was created for KFS to fix this issue.

...

https://jira.oit.uci.edu/browse/KFSDW-1549 (SBS aging data files to the Informatica production server)

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1496
 (Modify Balance ETL for all ITD balances to remove SFG 2xxxxx)

...

Anh’s Status 9/23/2016 - 10/20/2016 (took vacation 9/28 - 10/11)

ETL: 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1530
(Old SBS aging data files for previous month were sent to DW for this month-end October)

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1532
 (Need to enhance the SBS Aging task to avoid duplicate records)

UAT:

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1415
Waiting for Analytix to fix error found in their queries.  I already reminded them again today.  Both Bryce and I have been waiting for this fix first due to task dependencies in order to perform UATs for jiras
Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1417
,
Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1418
 

 

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

ETL: 

  • Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-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: 

...

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

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1395
(KFS_F_PREQ_ITM_ACCTNG):  Same error “Incorrect syntax near '$' “ occured after their fix today, already informed them to fix.

...

https://services.adcom.uci.edu/jira/browse/KFSDW-1403

 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1421

https://services.adcom.uci.edu/jira/browse/KFSDW-1439

...

Fix SBS Aging task every month-end until the ODS Informatica jobs go live because Talend jobs overwrite my fixes for previous month-end from JIRA

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1387

Add to post-informatica mapping to include Valerie’s additional requirement for KBM in jira https://services.adcom.uci.edu/jira/browse/KFSDW-731

...

Add tables: AP_PMT_RQST_T, PUR_COMM_T, PDP_CUST_PRFL_T, PDP_PMT_GRP_T, PDP_PMT_DTL_T, all tables on Eufemia’s , Matt’s lists.

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1290
 

Modified the rafg code dimension mapping to expand length of the rafg code column from 3 to 4 characters in order to load all records from user’s data this month when they sent rafg codes with more than 3 characters.  Completed this task.  Verified.  It's ready for test.

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1292

Add GOE and OOE tables to OLTP ODS for Web Services.

...

Completed adding new columns KFS_ORG_COA_CD, KFS_ORG_CD to ods_kfs.UC_ACCOUNT_T, modifing UC_ACCOUNT_T ETL.  

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1149
 is on production, closed.

Completed user acceptance test for the new rafg dimention and new changes in gl entries and balance fact tables 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1089
.  It's now ready to deploy.

Completed fixing missing fund names.  Tested and verified. 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1183
 is ready to deploy.

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-974
 is now ready for test after completing below:

...

Anh’s Status 11/12/2015 – 11/25/2015

Closed

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-899

Closed

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-895

Closed

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-973
.

Closed

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-972
 

Closed

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-590

Completed on dev.  Need to verify before turning over to production

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-586

Anh’s Status 10/01/2015 – 10/29/2015

...

Work is in progress with Outbound: 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-727
 
Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-750
Completed setting file trigger for uciBud100PopulateTablesJob,uciStf100PopulateTablesJob.  For testing purpose, these jobs ran when their trigger files are created then it moved them to a directory for archiving purpose.  Because the Informatica scheduler doesn’t have option for month end date, these jobs are currently scheduled to run monthly on the 5th.  Because we have jobs that run every 2 months, 6 months, quarterly, etc.  I think that it’s a better approach to have a batch file to turn the flag true or false when it sees the file trigger then when the flag is true then it'll trigger to run the job.    I wrote a batch script to return value true if it finds the file otherwise false.  I need to research how to make informatica event trigger to see this value.   

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-588

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-746
Completed OLTP jobs.  Only job that failed is uci load title because of the Oracle table has primary key criteria causing duplicate key error in this job.  

...

Remaining fact jobs to verify: Need to add more tests on gl entries fact, AssetFact, AssetPaymentFact, Account dimension. 

 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-727

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-746

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-761

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-768

Export all talend jobs on new server

...

Completed

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-740

Completed

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-660

Completed

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-486

Completed

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-747

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

...

Need to work with DBA to restore data to dss schema.  Plan for informatica jobs to run on production to test.

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-744

 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-727

          

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-743

          

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-745

          

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-748

          

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-746

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-761

Export all talend jobs on new server

...

  • Completed section:

    Push all kfs jobs (1 by 1) back 1 hour: 

    Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-726

    Completed modifying unix cripts to push back as well to alert when jobs are not done. 

    Created service now ticket INC0025478 to request zena installation on informatica server so that Jarrod's app can create etl file triggers.  Update:  Jason Lin said that there's no more license.  We're replanning this task.

    Provided input to Analytix regarding ods jobs, mysql linked server.

    Resolved discrepancies in ODS jobs with Analytix. 

    Completed integrating tests for all staging jobs which took double amount of time to run.  They're fixing these so that the can complete running nightly within 1-hour window. 

    Created ldap_people,ldap_people_his under schema 'people_m' in MYSQL per Analytix's request.

  • Not complete yet section: 
    Talend pager duty week 6/6 - 6/12.

    Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-744

    Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-727

    Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-740

          

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-743

          

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-745

          

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-747

          

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-748

          

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-746

          

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-486
 same as
Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-660
    

Export all talend jobs on new server

...

System DSN Connection was created, inform them.

 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-697

 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-686
 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-722

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-712

  • Not complete yet section: 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-711

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-723

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-698

Talked to Jarrod to have trigger files created on the Informatica server (Windows) for Informatica jobs to run for month-end.  He mentioned that the best approach is to have Zena agent install on this server so his app can tell Zena to create files there.  We need to discuss this more as soon as Analytix finishes their tests with smsfeed jobs which they already imported in our repository.

...

  • Completed section:

    Competed
    Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-676

    Completed:
    Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-660

    Completed
    Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-686

    Completed sending DDL script to create ldap_peole table to Analytix
    Completed
    Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-693


    Informatica Conversion:  Analytix sent the first job, staging_uci.   This job encountered errors (timestamp type columns, non-existing tables in kfscfg).  After debugging it, I sent them the errors with suggestions to resolve.

    Updated
    Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-590


  • Not complete yet section: 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-697

Informatica Conversion:  ongoing task. 

...

1) Completed fixing staging krns job

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-672

2) Pager duty this week. 

3)  Completed

Jira Legacy
server
OIT
System JIRA
serverId
252346bd
d1c6a489-
c418
217f-
34af
3ae9-
94a0
bd3a-
0709b2108812
01dc24609c18
keyKFSDW-671
. 

     Completed setting up to schedule this job to run nightly.

 

4)  Emailed ddls scripts to Analytix per their request to create tables below:

...

5)  Completed 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-486

6) Completed new job syncInvoiceNumberSundryDebtors for  

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-660

7) Completed the change to sd-nebula to remaining talend jobs

...

5)  Need to fix 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-676

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
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-633

2)  dwhreader: 

...

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
System JIRA
serverId
252346bd
d1c6a489-
c418
217f-
34af
3ae9-
94a0
bd3a-
0709b2108812
01dc24609c18
keyKFSDW-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: 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-486
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. 

6) Pager duty next week. 

 

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

...