Testing of interfaces - LIVE 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 TEST migration.Please add any interfaces that are missing.
| Interface | Summary of live before Migration (Include JIRA if applicable) [Refers to Test migration] | After Migration - Tested By | After Migration - Successfull |
| Concurrent Jobs | ALL PAUSED 27/11/14 | ||
| Concurrent Job - EPP0078- albacs | Fails - file not being copied over from fenton to albacs on oratestkb1. | Henry Emmanuel To be done on 02/12/2014 | Henry to run this process tomorrow. |
| Workflow Control Queue Cleanup. this gets run scheduled) | Scheduled request had not been set up on HRTEST. I created a one off request and it competed successfully. | John Chan 01/12/14 | Pass |
| Purge Concurrent Request and/or Manager Data. this gets run scheduled) | Last run 04-NOV-2014 09:20:10 - completed successfully | John Chan 01/12/14 | Pass |
| Synchronise WF Tables (UOE request Set). this gets run scheduled) | Not been set up on HRTEST. Does not exist in HRLIVE either. | John Chan 01/12/14 | Pass |
| Gather Schema Statisics (this gets run scheduled) | Last run 02-NOV-2014 10:06:05 - completed successfully - Takes 2 hours. | John Chan 01/12/14 | Pass |
| Security List Maintenance (this gets ran adhoc) | Ran this for Security Profile SP AS Catering and completed successfully. | John Chan 01/12/14 | Pass |
| EPP4220 IDM Interface. this gets run scheduled) | Logs showed two messages processed on 31st Oct
Concurrent request last completed on 04-NOV-2014 15:08:02 | John Chan 01/12/14 | Pass |
| UOE MRCP Pension - Load data. this gets run scheduled) | Concurent request last completed on 03-NOV-2014 17:04:34 | John Chan 01/12/14 | Pass |
| Database Scheduler Job | DISABLED 27/11/14 | ||
| eRecruitment - Successfull Applicants | Triggered SuccessfullApplicantsInterface dbms scheduler job manually and received the automated email. | John Chan 01/12/14 | Pass |
| Outgoing Interfaces | DISABLED 27/11/14 | ||
| Events Booking | Can log in successfully to the test application and browse events | ||
| Card View | manually run 'ksh /home/mis/card/scripts/staff_pop_dets.sh' resulted in failure in error log. See below for error. manually run 'ksh /home/mis/card/scripts/staff_pop_org.sh'. Success email was sent to Adam Wheavil. | Adam Wheavil 01/12/2014 | Pass |
| eRecruitment - Interfaces Database Scheduler Jobs | Check Log table on coreint schema on EJOB* or manually run the packages and then check log table.
| John Chan 02/12/2014 | Will check tomorrow |
| eTime - crontab.sh | cronjob on finance side calls etime_feeds.sh, uses a dblink. log file created for this morning. | Will check tomorrow | |
| Pure | has been running daily at 9pm. I did not run manually but checked the refresh logs for PUREINT schema on PURETEST/APPSTEST schema. | Will check tomorrow. Stuart Craig to be involved | |
| Jobsched job in eFinancials - livejs_staffbacs | amended my bank details on efin, ran job, bank details updated from hr | Gordon Forbes
| Email sent. Wil confirm on 02/12/2014 |
| OPAS (mis-ford server) | No TEST OPAS system - To be tested on LIVE. Must be tested after cron_hr2ops has been run first. manually run the 'Cass Import' windows scheduled task. The hr2opas.csv file will be copied to C:\Program Files\WICS\hr2opas.csv Manually check file for special characters.
| John Chan 01/12/2014 | Pass |
| Apphr crons on Glamis | ALL DISABLED ON GLAMIS 27/11/14 | ||
| cron_infoed.sh | John Chan 01/12/14 | Pass | |
| cron_ppip_daily_changes.sh | John Chan 01/12/14 | Pass | |
| Cron_library.sh | Pre-existing issue https://www.jira.is.ed.ac.uk/browse/HRS081-24 | John Chan 01/12/14 | Pass |
| Cron_vrs.sh | John Chan 01/12/14 | Pass | |
Cron_salfor_grades_copy.sh | John Chan 01/12/14 | Pass | |
Cron_salfor_ppip_copy.sh | John Chan 01/12/14 | Pass | |
Cron_transpar.sh | John Chan 01/12/14 | Pass | |
| cron_ebis.sh | Initial problems resolved by https://www.jira.is.ed.ac.uk/browse/HRS081-25 | John Chan 01/12/14 | Pass |
Cron_fis1.sh | Initial problems resolved by https://www.jira.is.ed.ac.uk/browse/HRS081-26 | John Chan 01/12/14 | Pass |
Cron_prefaddr.sh | Initial problems resolved by https://www.jira.is.ed.ac.uk/browse/HRS081-27 | John Chan 01/12/14 | Pass |
| cron_uun.sh | Initial problems resolved by https://www.jira.is.ed.ac.uk/browse/HRS081-28 | John Chan 01/12/14 | Pass |
| cron_ppipmi_daily.sh | John Chan 01/12/14 | Pass | |
| cron_ppipmi.sh | John Chan 01/12/14 | Pass | |
| cron_ppipmi_data_mart.sh | John Chan 01/12/14 | Pass | |
Cron_roslin.sh | Initial problems resolved by https://www.jira.is.ed.ac.uk/browse/HRS081-29 | John Chan 01/12/14 | Pass |
| cron_hr2opas.sh | John Chan 01/12/14 | Pass | |
| cron_uoe_uss_pension_extract.sh | John Chan 01/12/14 | Pass | |
| cron_license_usage.sh | John Chan 01/12/14 | Pass | |
| apphr Cron on Fenton | ALL DISABLED ON FENTON 27/11/14 | ||
cron_roslin.sh
| Ran the cron job and then run command 'ssh ri-uoe@ris-vlx01.roslin.ed.ac.uk'. The three copied files found here /mnt/ris-fas1a/linux_users/ri-uoe/incoming
| John Chan 01/12/14 | Pass |
| cron_copy_payroll_reports.sh | Transferred dummy file (john.sql) to /home/hrout/payfunc using payfunc login and ran /u03/software/apphr/uoe_cron/hrcron/cron_copy_payroll_reports.sh as apphr login. john.sql copied to /u03/software/apphr/apps/apps_st/appl/uoe/1.0/sql
| John Chan 01/12/14 | Pass |
| Cron_check_concurrent_manager.sh | John Chan 01/12/14 | Pass | |
| Packages Valid | |||
| list packages that require ddl changes and confirm all valid before migration | |||
| EU_REVENUE_INTERFACE | Compiles in UOEPP LIVE | John Chan 01/12/14 | Pass |
| TRANSPAR_EXTRACT | Compiles in UOEPP LIVE | John Chan 01/12/14 | Pass |
| Procedures Valid | |||
| list procedures that require ddl changes and confirm all valid befire migration | |||
| EPP0071 | Compiles in UOEPP LIVE | John Chan 01/12/14 | Pass |
| EPP1320 | Compiles in UOEPP LIVE | John Chan 01/12/14 | Pass |
| EPP1600_pkg | Compiles in UOEPP LIVE | John Chan 01/12/14 | Pass |
| MIDAS_DOWNLOAD | Compiles in UOEPP LIVE | John Chan 01/12/14 | Pass |
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 | After Migration - Tested By | After Migration - Successfull |
| Application Access https://www.epeople-fin.humanresources.ed.ac.uk | John Chan 01/12/14 | Pass |
| Self Service channel via myEd | John Chan 01/12/14 | Pass |
| Business Objects | N/A - Database is NEWSLIVE | |
| Apex reports | John Chan 01/12/14 | Pass |
| HR Manager Workflow Portlet | John Chan 01/12/14 | Pass |
| Absence History | John Chan 01/12/14 | Pass |
| Staff Details | John Chan 01/12/14 | Pass |
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