07-16-2015 - 07-24-2015
DWH:
In Progress: JIRA#1648: create temp table and check the difference and blank KFS fields.
In Progress: JIRA#1649: Finished writing job mssql for ldap_people_his_new both doing insert and update table.
In Progress: testing Talend jobs from Jasper. For dwhs_pps and dwhs_ppscurr it all works exception home_department and FS&ODS job
In Progress: writing wiki Trouble shooting DWH jobs
DWH-PPS:
In progress: run utility job to create new fiscal year
LDAP:
Completed: missing campus id for Ryan
PPS:
none
UCPath:
Completed: answering question
Kuali:
none
Training:
none
07-01-2015 - 07-15-2015
DWH:
Completed: Incident#0032442 - PCS - missing FS department code
Completed: Incident#0032171 - PCS - missing FS department code
Completed: Incident#0032173 -PCS - missing PI name for chancellor
Completed: Incident#0032178 - PCS - update department code
In progress: Incident#0031496 - Payroll records with no KFS accounts
In Progress: Incident#0031497: problem from getHealthSci & gethealthSciBen queries - java error
In Progress: testing new server for JasperETL- sd-dwhetl01.serverad.adcom.uci.edu- test one job it looks for Sybase jdbc-dwh_fs/ods,
try 2nd job pps home department it did not like one field and correct it to null but still error out. Other jobs for dwhs_ppscurr works.
In Progress: Incident#0029563 - test user id's for Facility testing- Tom B will ask NSP to release some new test id's.
In Progress: sending missing FS department codes from account and fund.
In Progress: JIRA#1648: testing ldap_people_new in mssql sd-nebula. Create spreadsheet and load to MySQL the missing KFS values.
In Progress: JIRA#1649: create new ldap_people_his one time script in sd-nebula and inserting to the new ldap_people_his table. Question on the update if it need to create a new row daily for the uciCampusID that is matching or just update the rows with the daily information.
In Progress: writing in wiki Trouble shooting DWH-PPS jobs
On Call from 07/04-07/10
DWH-PPS:
Completed: Incident#0031496: EX cycle have empty files, request to OP and load to DWH
In Progress: documenting DWH-PPS trouble shooting
In Progress: Preparing New Fiscal year
In Progress: Downloading PAR &HDB data for June after July 1.
LDAP:
LDAP deploy and node3dev did not run - rerun on node3dev: done
PPS:
Completed: question which database to used for compute this fiscal year.
UCPath:
Kuali:
In progress: question for PPS work study flow
Training:
None
06-16-2015 - 06-30-2015
DWH:
Completed: JIRA#1629-Orbit to sd-orbit-db
Completed: JIRA#1636 - Prod turn over for sd-orbit-db - modify property file on 06/29.
In progress: JIRA#1642-add temp_kfs_fund_oper
In Progress: populating uc_account_t with 2 new cols using Informatica -testing
In Progress: populating temp_kfs_account_oper, run manually and create job to check missing department codes
In progress: sending missing FS dept codes to Accounting
Completed: Darla request list
Completed: Incident#0030279-adding FS dept code for PCS
Closed: Incident#0026159: Linkserver for MySQL people_m database not necessary for analytics.
In Progress: PCS could not be created for fund: 78701
In Progress: Incident#0029563- Adding testid's for Facility from test0401-0430 - reply to Tom to used other userid
Completed: Vacation: 06/22-06/28
DWH-PPS:
In progress: check pps_expearn job not sending email
LDAP:
In progress: create summary of ldap_people table in sd-lunar.dss_kfs
NSP-qidata missing 9 employees-send to NSP error list.
PPS:
In progress: Incident#0029163-UCOP PPS screen error - add David to ticket
UCPath:
Kuali:
Training:
Continue: Informatica part 2
06-01-2015-06-15-2015
DWH:
Completed: JIRA#1628-SOM separation list from 2005-April 2015
Completed: JIRA#1630-Zenith to sd_zenith_db.oit.uci.edu
Completed: USGHelp#1901-dwhm_par and dwhm_hdb are uptodate at m3k2 till 2014.
Completed: Update fs_fund_oper request from Robert
In progress: JIRA#1629-Orbit to sd-orbit-db.oit.uci.edu
In progress: Jira#1636-Orbit changed in production
DWH-PPS:
Completed: fixed mssql_expearn for sd-nebula
Completed: download PAR &HDB for May, 2015
In Progress:deploy not sending email for pps_expearn job
LDAP:
Completed: adding 2 employee's missing from history, 1 was from 1997
PPS:
DWH-UCPATH:
Completed: List per-request UCPath-HR communication for PPS users-Inc#0024888.
DWH-KUALI:
TRAINING:
05-16-2015 - 06-01-2015
DWH:
...
Completed Pager week: 04/15-04/22/2015
In Progress: Pager week: 05/29-06/04/2015
In Progress: JIRA DWH#1628, DWH#1629, DWH#1630
DWH-PPS:
Completed: loading PAR data for 2013 & 2014 at m3k0
...
In Progress: USGHelp#1901 to copy to m3k2 from m3k0 dwhm_par and dwhm_hdb.
LDAP:
LDAP:
In progress: new table ldap_people missing KFS Org level4 and name columns, missing test id's
PPS:
Completed: question from David for PPS Home department and control points
...
Completed: question for survey from Academic Senate
DWH-KUALI:
In Progress: JIRA KFSDW#718: adding columns to kfs_account_oper. Due to uc_account_t missing 2 columns for MySQL, it is in nova to test it.
Send to Victor C., KFS org codes without department codes.
Training:
Completed: AB1825 -2 hours
...