Skip to main content
CollegeSource Production

Support Notes, 4.3.9 Release

JOB_QUEUE_DESTINATION Table

Releases prior to 4.3.9 did not require the JOB_QUEUE_DESTINATION table, but that deployment option is no longer available. Most Connector sites already have that table, but several do not. See details about upgrading from 4.2 or 4.1 for a link to the DARwin table scripts.

  • The 3.5.8 script creates the table

Nightly Audit Cleanup

The default configuration now executes a background nightly delete on the job_queue tables to remove older degree audits that are completed and previously returned to Transferology. This was due to database contention on some servers during higher audit request processing. If the background delete causes a problem, it can be disabled by adding the following line into the cas4.properties file:

# disables nightly audit delete
xservice.auditCleanupEnabled=false

If the background delete is disabled, the following deletes should be executed periodically by the school to remove the older sent audits:

DARwin
DELETE FROM job_queue_accept WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_course WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_subreq WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_req WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_out WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_run WHERE jobid in 
  (SELECT jobid FROM job_queue_destination d WHERE d.jobid like '20%' and d.STATUS='S');
DELETE FROM job_queue_sysin WHERE jobid in 
  (SELECT jobid FROM job_queue_destination d WHERE d.jobid like '20%' and d.STATUS='S');
DELETE FROM job_queue_detail WHERE jobid in 
  (SELECT jobid FROM job_queue_destination d WHERE d.jobid like '20%' and d.STATUS='S');
DELETE FROM job_queue_list WHERE jobid in 
  (SELECT jobid FROM job_queue_destination d WHERE d.jobid like '20%' and d.STATUS='S');
DELETE FROM job_queue_destination d WHERE d.jobid like '20%' and d.STATUS='S';

u.achieve
DELETE FROM job_queue_exceptions WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_incl_text WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_markers WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_report WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_accept WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_course WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_subreq_text WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_subreq WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_req_text WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_req WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_out WHERE jobq_seq_no IN 
  (SELECT int_seq_no FROM job_queue_destination d, job_queue_run r WHERE d.jobid like '20%' and d.STATUS='S' and d.JOBID=r.jobid);
DELETE FROM job_queue_run WHERE jobid in 
  (SELECT jobid FROM job_queue_destination d WHERE d.jobid like '20%' and d.STATUS='S');
DELETE FROM job_queue_sysin WHERE jobid in 
  (SELECT jobid FROM job_queue_destination d WHERE d.jobid like '20%' and d.STATUS='S');
DELETE FROM job_queue_detail WHERE jobid in 
  (SELECT jobid FROM job_queue_destination d WHERE d.jobid like '20%' and d.STATUS='S');
DELETE FROM job_queue_list WHERE jobid in 
  (SELECT jobid FROM job_queue_destination d WHERE d.jobid like '20%' and d.STATUS='S');
DELETE FROM job_queue_destination d WHERE d.jobid like '20%' and d.STATUS='S';

 

  • Was this article helpful?