QUICK LINKS
Support
Issue Tracker
[Services]
Questions
[uAchieve 4.5 Applications]
[uAchieve 5.0 Application]
[uAchieve 5.1 Application]
Transferology
TES
[Training & Conferences]
Accessibility
This page provides troubleshooting information to resolve pending audits that were created by Transferology.
Check the ceg4.log
Please check the ceg4.log for any obvious errors. If the ceg4.log isn't available or the log doesn't contain obvious errors, then proceed with these instructions.
The JOB_QUEUE_LIST and JOB_QUEUE_DESTINATION tables provide information to assist troubleshooting pending Transferology audits.
When the Connector accepts an audit request, a row is inserted into the JOB_QUEUE_LIST and JOB_QUEUE_DESTINATION tables.
-- QUERY_1 : Provides overview status of audit requests during the last 24 hours select l.jobid, l.userid, l.status, l.servername, d.status, d.userid, d.destination_url, d.send_error_count , d.send_date, d.send_error_message from job_queue_list l left outer join job_queue_destination d on d.jobid = l.jobid where l.jobid >= to_char(sysdate-1,'yyyymmdd') and l.jobid < to_char(sysdate+1,'yyyymmdd') and l.userid like '%@TRAN%' order by 1; -- QUERY_2 : Identifies output for an audit select r.jobid, r.INT_SEQ_NO, count(o.jobq_seq_no) from job_queue_run r left outer join job_queue_out o on o.jobq_seq_no = r.INT_SEQ_NO where r.jobid >= to_char(sysdate-1,'yyyymmdd') and r.jobid < to_char(sysdate+1,'yyyymmdd') and r.userid like '%@TRAN%' group by r.jobid, r.INT_SEQ_NO order by 1;
-- QUERY_1 : Provides overview status of audit requests during the last 24 hours select l.jobid, l.userid, l.status, l.servername, d.status, d.userid, d.destination_url, d.send_error_count , d.send_date, d.send_error_message from job_queue_list l left outer join job_queue_destination d on d.jobid = l.jobid where l.jobid >= convert(varchar(8), getdate()-1, 112) and l.jobid < convert(varchar(8), getdate()+1, 112) and l.userid like '%@TRAN%' order by 1; -- QUERY_2 : Identifies output for an audit select r.jobid, r.INT_SEQ_NO, count(o.jobq_seq_no) from job_queue_run r left outer join job_queue_out o on o.jobq_seq_no = r.INT_SEQ_NO where r.jobid >= convert(varchar(8), getdate()-1, 112) and r.jobid < convert(varchar(8), getdate()+1, 112) and r.userid like '%@TRAN%' group by r.jobid, r.INT_SEQ_NO order by 1;
Status | Description |
---|---|
N | Initial status, indicates the audit request is available for processing by DARwin or uAchieve |
E | DARwin or uAchieve encountered an error during audit processing |
X | DARwin got stuck processing the audit |
D | The audit was processed |
Status | Description |
---|---|
A | Audit request was accepted by the Connector |
Q | Audit is queued to send output to Transferology |
R | Audit is waiting to retry a send of output to Transferology. Check the send_error_message from the first query. |
S | Audit output was successfully sent to Transferology |
JOB_QUEUE_LIST status | JOB_QUEUE_DESTINATION status | Meaning |
---|---|---|
no row | no row | The Connector has not received the audit request from Transferology; review the following:
|
N | A | The Connector has received the audit request but DARwin or uAchieve has not processed the request; review the following:
|
E | A | DARwin or uAchieve encountered an error while processing the audit request:
|
X | A | DARwin stopped processing the audit request:
|
D | A | DARwin or uAchieve processed the audit request, but possibly did not produce audit output:
|
D | R | DARwin or uAchieve processed the audit request, but the output has not been sent to Transferology; review the following:
|
D | Q | See above for status D / R |
D | S | The Connector has successfully returned the audit output to Transferology. If the completed audit in Transferology is not visible:
|