DFM Document Queue Query
This program lets you view and edit the documents that were retrieved by the SYSPRO 8 Document Flow Manager Folder Poller service and placed in the queue.
Exploring
Where it fits in?
Things you can do in this program include:
- View queue contents.
- View failed XML documents and determine the cause.
- Edit the input XML, if this caused the failure.
- Resubmit the failed XML document, if the system allows this.
This program is accessed from the Program List pane of the SYSPRO menu:
-
Program List > Administration > Document Flow Manager
Solving
Why don't you drop us a line with some useful information we can add here?
Using
Status Codes
DFM status codes
The following outlines the DFM status codes and when they are applied:
| Status Code | Description |
|---|---|
| 00 |
In the queue awaiting processing. The SYSPRO 8 Document Flow Manager Folder Poller calls DFMTQU to add the transaction to the queue. |
| 90 |
Picked up by the queue poller and passed to the business object to process. The SYSPRO 8 Document Flow Manager Queue Poller polls the AQL queues |
| 01 |
Reading the queue detail table for given transaction ID. |
| 02 |
Reading the DFM Master table for the associated contract. |
| 03 |
Performing XSL transform on input XML. |
| 04 |
Calling business object defined against the contract (calls it using operator specified against contract). |
| 05 |
Performing XSL transform on the output XML. |
| 06 |
Saving relevant files to the history folders. |
| 07 |
Sending message to the SYSPRO Inbox. |
| 08 |
Saving output XML. |
| 09 |
Sending relevant email messages. |
| 96 |
Pre-processing of the transaction failed (failure in status 01, 02 or 03). |
| 97 |
Post-processing of the transaction failed (failure in status 05 through 09). |
| 98 |
Processing of the transaction failed (failure in status 04). |
| 99 |
Transaction is complete. |
Referencing
Menu and Toolbar
| Field | Description |
|---|---|
|
File |
|
|
Exit |
This exits the program. |
|
Options |
|
| Show all records |
Select this to view all records. |
| Record limit |
This lets you limit the number of records you see in the list. This defaults to 1000. |
|
Functions |
|
|
Purge |
Select this to purge the records displayed in the DFM Queue Messages pane. |
|
Time filter |
This lets you select a time reference to filter the list of queue messages. |
|
Edit Input XML |
This lets you edit the input XML of the selected file, typically if the transformation of the document fails. |
|
Edit Parameter XML |
This lets you edit the parameter XML of the selected file, typically if the transformation of the document fails. |
DFM Queue Messages
| Field | Description |
|---|---|
|
Date and time |
This indicates the date and time the file was placed in the queue. |
|
Status |
This indicates the status code and current position of the document in the queue. |
|
Contract name |
This indicates the name of the DFM contract that was specified when the contract was created. |
| Action |
Select the Resubmit link to resubmit a failed queue item. This link is only available if the queue item failed and the system allows you to resubmit it. When resubmitting an item, the queue status on the queue and detail tables is reset to zero so that the item can be processed the next time the folder poller scans the folders. |
| Delete | Select this to delete the queue message. |
|
Company code |
This indicates the SYSPRO company for which this document was polled and transformed. |
|
Input XML length |
This indicates the length of the body of the file in the queue. |
|
Input XML path |
This indicates the path of the input XML. |
| Time | This indicates the time the file was placed in the queue. |
|
Workflow path |
This indicates the workflow of the DFM business object when processing a transaction. There are various status codes listed against each transaction that indicate the workflow path of each document in the queue. The last code in the list matches the code in the Status field. |
| Status code | This indicates the status code of the XML document. |