07-0116-2015 - 07-1524-2015
DWH:
In Progress: Incident#0031497: problem from SOM-JoeJIRA#1648: create temp table and check the difference and blank KFS fields.
In Progress: Incident#0029563
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.
Completed: request from Robert to update department codes for some fund codes.
In Progress: sending missing FS department codes from account and fund.: 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:
...