07-0116-2015 - 07-1524-2015
DWH:
In Progress: Incident#0029563:DWH-PPS: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:
...
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
...