Testing of interfaces - DEV migration
This list is taken from the K:\ISAPPS\dsg\Projects\HRS081\HRS081 Interfaces Implementation Plan.docx and may not be complete. It has been copied and edited from the version used for the LIVE migration.Please add any interfaces that are missing.
| Interface | Summary of DEV before Migration (Include JIRA if applicable) | Before Migration - Tested By | Before Migration - Successfull | After Migration - Tested By | After Migration - Successfull |
| Concurrent Jobs | |||||
| Concurrent Job - EPP0078- albacs | |||||
| Workflow Control Queue Cleanup. this gets run scheduled) | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y | |
| Purge Concurrent Request and/or Manager Data. this gets run scheduled) | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y | |
| Synchronise WF Tables (UOE request Set). this gets run scheduled) | John Chan 02/12/14
| Y | John Chan 12/12/14 | Y | |
| Gather Schema Statisics (this gets run scheduled) | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y | |
| Security List Maintenance (this gets ran adhoc) | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y | |
| EPP4220 IDM Interface. this gets run scheduled) | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y | |
| UOE MRCP Pension - Load data. this gets run scheduled) | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y | |
| Database Scheduler Job | |||||
| eRecruitment - Successfull Applicants | |||||
| Outgoing Interfaces | |||||
| Events Booking | John Chan 02/12/14 | Page Unavailable | |||
| Card View | |||||
| eRecruitment - Interfaces Database Scheduler Jobs | John Chan 02/12/14 | Last run on 04-AUG-2014 06.09.47
| |||
| eTime - crontab.sh | |||||
| Pure | |||||
| Jobsched job in eFinancials - livejs_staffbacs | |||||
| OPAS (mis-ford server) | John Chan 02/12/14 | N/A There is only a LIVE instanc of OPAS. | |||
| Apphr crons on Glamis | |||||
| cron_infoed.sh | |||||
| cron_ppip_daily_changes.sh | |||||
| Cron_library.sh | |||||
| Cron_vrs.sh | |||||
Cron_salfor_grades_copy.sh | |||||
Cron_salfor_ppip_copy.sh | |||||
Cron_transpar.sh | |||||
| cron_ebis.sh | |||||
Cron_fis1.sh | |||||
Cron_prefaddr.sh | |||||
| cron_uun.sh | |||||
| cron_ppipmi_daily.sh | |||||
| cron_ppipmi.sh | |||||
| cron_ppipmi_data_mart.sh | |||||
Cron_roslin.sh | |||||
| cron_hr2opas.sh | |||||
| cron_uoe_uss_pension_extract.sh | |||||
| cron_license_usage.sh | |||||
| apphr Cron on Fenton | |||||
cron_roslin.sh
| |||||
| cron_copy_payroll_reports.sh | |||||
| Cron_check_concurrent_manager.sh | |||||
| Packages Valid | |||||
| list packages that require ddl changes and confirm all valid before migration | |||||
| EU_REVENUE_INTERFACE | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y | |
| TRANSPAR_EXTRACT | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y | |
| Procedures Valid | |||||
| list procedures that require ddl changes and confirm all valid befire migration | |||||
| EPP0071 | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y | |
| EPP1320 | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y | |
| EPP1600_pkg | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y | |
| MIDAS_DOWNLOAD | John Chan 02/12/14 | Y | John Chan 12/12/14 | Y |
We also need to test the LIVE URL and LIVE MyEd links to verify they are all working.
Other tests
| HOLDING PAGES IN PLACE FOR CHANNELS 27/11/14 | Before Migration - Tested By | Before Migration - Successfull | After Migration - Tested By | After Migration - Successfull |
| Application Access https://www.epeople-fin.humanresources.ed.ac.uk | John Chan 02/12/2014 | Y | John Chan 12/12/14 | Y |
| Self Service channel via myEd | John Chan 02/12/2014 | N - Self Service Launcher Button points to LIVE Oracle HR. | John Chan 12/12/14 | N - Self Service Launcher Button points to LIVE Oracle HR. |
| Business Objects | John Chan 02/12/2014 | N/A | ||
| Apex reports | John Chan 02/12/2014 | Y | John Chan 12/12/14 | N HRS081-83 |
| HR Manager Workflow Portlet | John Chan 02/12/2014 | Cannot find HR Manager Workflow portlet in MyEd DEV | John Chan 12/12/14 | N - connection details still to be updated |
| Absence History | John Chan 02/12/2014 | Cannot find Absence History portlet in MyEd DEV | John Chan 12/12/14 | N - connection details still to be updated |
| Staff Details | John Chan 02/12/2014 | Y | John Chan 12/12/14 | N - connection details still to be updated |
Test Plan
All HR Application Concurrent Jobs
To be tested after the migration by Applications Management. Prior to the migration the following jobs were confirmed to be running successfully:
· IDM changes
Outgoing Interfaces
Events Booking
To be tested after the migration by Applications Management. Prior to the migration, the application works successfully.
Double-check that the CF DSN is updated correctly and that the DSN verifies successfully in the CF Administrator.
Test that the public and admin applications still work. Keep an eye on the events_logs table and any error emails.
Check the nightly CF Scheduled task is not failing. Keep an eye on the events_logs table and any error emails.
Card View
To be tested after the migration by Applications Management. Prior to the migration the staff_pop_org.sh was run manually on Test and appears to be ok (it is not setup as a cron though). The staff_pop_dets script fails in Test – works in live though. The error is:
ERROR at line 34:
ORA-06550: line 34, column 10:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 18, column 3:
PL/SQL: SQL Statement ignored
ORA-06550: line 17, column 8:
PLS-00341: declaration of cursor 'GET_STAFF' is incomplete or malformed
ORA-06550: line 37, column 11:
PL/SQL: Item ignored
ORA-06550: line 45, column 26:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 40, column 3:
PL/SQL: SQL Statement ignored
ORA-06550: line 64, column 5:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 64, column 15:
PL/SQL: ORA-00984: column not allowed here
ORA-06550: line 54, column 4:
PL/SQL: SQL Statement ignored
ORA-06550: line 81, column 32:
Log in as the card unix user and execute the following scripts:
· Staff_pop_org.sh
· Staff_pop_dets.sh
eRecruitment
To be tested after the migration by Apps Management and HR. Last execution confirmed on Test today (3/11). Data errors but no job errors.. Same for the two EJOB jobs.
Log in to the HR database as Apps and manually run the Oracle scheduled job called SuccessfulApplicantInterface.
There are also two Oracle scheduler jobs on EJOB* database – log in as user COREINT and manually run:
· EmployeeCheckInterfaceRefresh
· ReferenceDataInterfaceRefresh
eTime
To be tested after the migration by Applications Management and Finance. Logs confirm this job ran fine at midnight 3/11.
Log in as database user etime on the FIN* database and manually run the Oracle scheduler job called ETIME_FEEDS.
Jobsched
To be tested after the migration by Applications Management. Last successful run was 11 September.
Manually run a job called livejs_staffbacs using an eFinancials menu system.
Tested successfully by Applications Management 04/11/14 – run livejs_staffbacs via the jobsched menu.
Logon to fin-app-kb* as jobsched user
add job by :- nat -x livejs_staffbacs -q night -k -td 10:40 (change time )
Albacs
To be tested after the migration by Payroll. Prior to the migration, nothing was tested.
Manually run the concurrent request called EPP0087.
Database Cron Jobs
To be tested after the migration by Applications Management. Prior to the migration, the following problems were noted:
· https://www.jira.is.ed.ac.uk/browse/HRS081-24
List the current crontab to verify that they have all been re-enabled.
Run each cron script manually:
· Cron_infoed.sh
· Cron_ppip_daily_changes.sh
· Cron_library.sh – This is expected to fail at the point of SCP’ing
· Cron_vrs.sh
· Cron_salfor_grades_copy.sh
· Cron_salfor_ppip_copy.sh
· Cron_transpar.sh
· Cron_ebis.sh
· Cron_fis1.sh
· Cron_prefaddr.sh
· Cron_uun.sh
· Cron_ppipmi_daily.sh
· Cron_ppipmi.sh
· Cron_ppipmi_data_mart.sh
· Cron_roslin.sh
· Cron_hr2opas.sh
· Cron_uoe_uss_pension_extract.sh
· Cron_license_usage.sh
Application Cron Jobs
To be tested after the migration by Applications Management. Prior to the migration, nothing was tested.
List the current crontab to verify that they have all been re-enabled.
Run each cron script manually:
· Roslin extract
· Cron_copy_payroll_reports.sh
· Cron_check_concurrent_manager.sh
Packages and Procedures
To be tested after the migration. Prior to migration each of the following packages and procedures to be changed compiled successfully.
UOEPP Packages
- EU_REVENUE_INTERFACE
- TRANSPAR_EXTRACT
- EPP071
- EPP1320
- EPP1600_pkg
- MIDAS_DOWNLOAD