VERIFIED SOLUTION i

Contractor Access XML Agent has produced no export files from Confirm and there are no entries for the export batch in the Contractor Access XML Agent log

Products affected: Confirm®
Product Feature: Non-routine Maintenance

 

Issue

In Confirm® the Contractor Access XML Agent has produced no export files, with no errors reported and no entries added to the Contractor Access XML Agent Log. You need to recreate the missing export files but are unable to do so.

Cause

Possible causes are that the export directory does not exist or is inaccessible, or that the stylesheet does not exist or is inaccessible.

If the Contractor Access XML Agent attempts to export a file and the export path cannot be created (for example if the path is invalid) or the stylesheet does not exist, Orders are marked as completed but no Export Log is created. This means that the Order is not re-exported automatically and there is no way to manually retry the export.

Resolution

UPDATED: November 13, 2018
Check that both the export directory and the style sheet exist and are accessible.

Use the following SQL to identify the CAXML Export batch number from the job Order number, remember to qualify the datasource with the required order number:

SELECT
   order_job.contract_code,
   order_job.order_number,
   order_header.cont_export_batch,
   order_header.contractor_code,
   order_job.order_job_number
FROM
   order_header,
   order_job
WHERE
   order_header.contract_code = order_job.contract_code AND
   order_header.order_number = order_job.order_number


The following SQL will identify missing export records/retrieve the affected batches:

select cont_export_batch
from order_header
where cont_export_batch> (select MIN(batch_no) from agent_export_log) and
not exists(select batch_no
from agent_export_log
where agent_export_log.batch_no = cont_export_batch);

select cont_export_batch
from variation_header
where cont_export_batch> (select MIN(batch_no) from agent_export_log) and
not exists(select batch_no
from agent_export_log
where agent_export_log.batch_no = cont_export_batch);

select cont_export_batch
from payment_batch
where cont_export_batch> (select MIN(batch_no) from agent_export_log) and
not exists(select batch_no
from agent_export_log
where agent_export_log.batch_no = cont_export_batch);

The above SQL should return batches for which there has been no row inserted in the export log. Please either:

1. Run each statement using the Data Source screen within Confirm, the results of which can then be exported, e.g. to Excel

-OR-

2. Run each statement against the Confirm database itself.

 Send the results of the SQL statements to the Confirm Technical Support team.