Config / Data/Buffer Tables / EDI Processing Queue

EDI Processing Queue

The processing queue stores information about the status of data transformations and other actions. The table is used to log the outstanding processing steps and the processed transformations. It also contains information about the current progress and status.

Every important step is logged in the EDI Processing Queue. It is the central point for checking the system state. The number of open processing requests gives you an overview about the current workload of the system. If there are errors, you will find them in the EDI Processing Queue.

Fields

Entry No.

Auto assigned number to identify the entry. The number is normally assigned without any gaps.

Processing Type

Represents the processing type.

Test Convert

Test conversion of mapping by a user

Manual Convert

Mapping conversion by user (click on convert in the mapping page)

Upgrade Mapping

Automatic upgrade of an mapping

Import Sample Data

Mapping structure analyzed by assistant

Update From Sample Data

Mapping structure build by assistant

Receive and Send

Combined send and received on communication channel

Change Comm. Settings

Changes to communication channel settings

Receive/List New Transmissions

Search for new files to receive

Receive Transmission

Receive Message

Send Transmission

Send Message

Archive Transmission

Archive Message

Delete Transmission

Delete Message

Project Code

Project code of the mapping

Format Code

Format code of the mapping

Mapping Code

Code of the mapping

Mapping Version

Version of the mapping or empty GUID to use the best available version

Description

The description field is only used for fallbacks. The description is retrieved from the mapping / post-processing that created the mapping. This way the value is multi-language enabled.

Status

The status represents the current status of the processing queue

Waiting

Not used.

Processing

In processing. If a processing queue entry is stuck on this value, you can reset it. This can happen, if the service tier is restarted during the conversion.

Processed

The entry is processed successfully.

Failed

The processing failed.

Do not execute

The entry was marked for not processing. Either because another mapping of the same execution group was successfully converted, or by user.

Failed (Hidden)

The entry failed. The user decided to hide this entry from the page.

Interaction Required

The entry is on hold and requires an interaction. This is the case, if the post-processing is set to manually.

Creation Date/Time

The date/time when the step was created.

Processing Date/Time

The last date/time the processing of this entry started.

Earliest Processing Date/Time

Usually not set.

Due Date/Time

When this entry shoiuld be converted successfully.

Latest Processing Date/Time

Usually not set.

Processing End Date/Time

The end date/time when the processing queue was either successfully converted or failed.

Processing Duration

The duration of the processing.

TableViews

Used internally. BLOB field containing the data views. Not accessible to the user. There is a ShowFilter() function in the table, that can be used for debug purposes.

Message Entry No.

Used internally. The primary key of the processed EDI message.

Transmission Entry No.

Used internally. The primary key of the processed EDI Transmission.

Transmission Folder Code

Used internally. The primary key of the EDI transmission folder.

Communication Channel

Used internally. The primary key of the used EDI communication channel.

User Transaction ID

The assigned User Transaction ID. Used to group several processing queues.

Business Transaction Entry No.

Used internally. The assigned EDI business transaction.

Process Synchronously

Whether the processing step was executed in the context of another mapping.

Run with Priority

Whether the processing queue should be executed before other post-processings.

Run Mode

Used internally.

Breakpoint

The mapping stopped on a breakpoint.

SingleStep

The mapping is in single step mode.

Breakpoint Line

Used internally.

Breakpoint Count

Used internally.

Last Line No.

Used internally.

Sorting

Currently not used.

Processing User ID

The User ID of the user, who processed this entry last.

Modified by User ID

The User ID of the user that has modified the processing queue last.

Created by User ID

The User ID, who created the processing queue.

EDI Document Type

Deprecated. Do not use anymore.

EDI Document No.

Deprecated. Do not use anymore.

EDI Document Version

Deprecated. Do not use anymore.

Belongs to Record ID

The document this processing queue belongs to. If you click on “Process” in a buffer document it will search for all entries that belong tho the buffer document.

Post-processing Code

In case the processing queue entry is created as a post-processing this contains the value of the Code property.

Post-processing Group Code

In case the processing queue entry is created as a post-processing this contains the value of the Processing Group property.

Created by Mapping Project

The mapping that has created this entry.

Created by Mapping Format

The mapping that has created this entry.

Created by Mapping Code

The mapping that has created this entry.

Created by Mapping Version

The mapping that has created this entry.

Created by Mapping Line No.

The mapping that has created this entry.

Parent Entry No.

Not used.

Status Image

Used to display the icon in the page. This field should not have a value in the database. For backward compatibility only.

Expected Results

Used internally.

Test Execution

Used internally.

Indent

Not used.

Debug Count

This is a FlowField. Count of debug messages for this entry.

Hints Count

This is a FlowField. Count of hints for this entry. (Not used)

Information Count

This is a FlowField. Count of information messages for this entry.

Warning Count

This is a FlowField. Count of warning messages for this entry.

Error Count

This is a FlowField. Count of error messages for this entry.

First Error Text

This is a FlowField. The text of the first error message that is still relevant.