Event store structure, WebSphere Adapter for Flat Files

IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > Flat Files > Overview of WebSphere Adapter for Flat Files > Technical overview > Inbound processing > Event store
Event store structure

The event store is used by the adapter to track events.

The following event table notes the values that are stored for each event.

Event store structure
Column name Type (length) Description
EVNTID Varchar (255) Used to track events during inbound processing. Each event requires an event ID for tracking purposes. This event ID must be a unique identifier in the table.
EVNTSTAT Integer The status of the event. The adapter uses the status to determine whether an event is new or in process.
Event status values:

NEW (0)
The event is ready to be processed.

FETCHED (3)
The adapter picked up the event for processing.

PROCESSED (1)
The adapter successfully processed and delivered the event.

FAILED (-1)
The adapter was unable to process this event due to one or more problems.
XID Varchar (255) Used by the adapter for assured event delivery and recovery.
EVNTDATA Varchar (255) Used to track failed events so that they are not processed again during recoveries. Failed events are marked "ARCHIVED."

BOSRTPOS

Long

Used to store the starting file pointer position of the business object associated with this event.

BOENDPOS

Long

Used to store the ending file pointer position of the business object associated with this event.

TIMESTMP

Timestamp

Used to represent the time when the event was picked up for processing.

Event store

Column name	Type (length)	Description
EVNTID	Varchar (255)	Used to track events during inbound processing. Each event requires an event ID for tracking purposes. This event ID must be a unique identifier in the table.
EVNTSTAT	Integer	The status of the event. The adapter uses the status to determine whether an event is new or in process. Event status values: NEW (0) The event is ready to be processed. FETCHED (3) The adapter picked up the event for processing. PROCESSED (1) The adapter successfully processed and delivered the event. FAILED (-1) The adapter was unable to process this event due to one or more problems.
XID	Varchar (255)	Used by the adapter for assured event delivery and recovery.
EVNTDATA	Varchar (255)	Used to track failed events so that they are not processed again during recoveries. Failed events are marked "ARCHIVED."
BOSRTPOS	Long	Used to store the starting file pointer position of the business object associated with this event.
BOENDPOS	Long	Used to store the ending file pointer position of the business object associated with this event.
TIMESTMP	Timestamp	Used to represent the time when the event was picked up for processing.