Overview
1, Students take their Math Placement on the ALEKS dashboard.
2, The GoAnywhere process is scheduled to run at 8:00 am each morning which pulls previous days test scores.
3, GoAnywhere writes into a flat szralmt.dat which gets loaded into oracle external table SATURN.SZEAXLD one time and gets overwritten each morning.
4, UC4 job is scheduled to run sql script at 8:30 am each morning – szralmt.
Szralmt sql script reads each record from this external table SATURN.SZEAXLD, validates against general.gobtpac, gobtpac_external_user is the NetID on the OU and Student_ID on the ALKS side.
If the record does not exist in SORTEST, It creates else it overwrites.
The highest score and date/time is created/updated on SATURN.SORTEST banner table for that day.
Troubleshooting
Please review the logs in Goanywhere as admin,
1,Navigate to menu item workflow, complete jobs - search/pull up the name of the job Mth.ALEKS.UncommonHttpRequest.
2, Under the status column, look for red X., green check mark defines the job ran successfully.
Please review the logs under /banjobs/PROD.
1, ls -ltr szralmt*.log
2, review the log for any ORA - errors, validate the file count against the external table SATURN.SZEAXLD and review SATURN.SORTEST banner table against the external table if all the records were created appropriately in this table.
For example:-
A ticket comes from the Math department and take a look at /banjobs/PROD for the date mentioned in the ticket. UC4 jobs might have been cancelled due to some reason.
The file transfer team can run the file from Math placement scores on GoAnywhere manually and EA team checks if the missing records are in SATURN.SZEAXLD and work with the DBA team to run the SZRALMT process in PROD.