file persistence table, WebSphere Adapter for FTP

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 > FTP > Overview of IBM WebSphere Adapter for FTP > Technical overview > Inbound processing > File store
File store structure

The file table contains the entries for the files to be polled by the adapter. The entries in the table support the adapter to read only the file content required by the polling quantity. In addition, the last position of the file pointer after the partial read is recorded in this table.

The following table describes each file table column.

File table structure
Column name Type Description
FILENAME Varchar (255) Name of the event file to be processed.
FILESTAT Integer
Status of the file entry. The adapter uses the status to determine whether the file is a new event to be processed or if the event is being currently processed.

UNPROCESSED (0)

The new file is ready to be processed. WebSphere Adapter for FTP polls the event directory for files and creates an entry in the file table.

IN-PROCESS (1)

A file is in-process if the adapter is reading the file content. When the file status is 1, no other adapter is allowed to process the file. The timestamp is updated when the file is picked up for processing.

EVENTS UPDATED (2)

The adapter reads only the file content required by the polling quantity and generates the new events for the current set of business objects.

PROCESSED (3)

The file processing is complete and the event entries are generated in the event table for the business objects.

FAILED (4)

The adapter was unable to read the file because of an unexpected error. The file might be corrupted or invalid.

ARCHIVING (5)

The archiving process for this file is in progress.

LBOCOUNT Long Specifies the number of business objects that were processed until the file was previously read.
LREADPOS Long Indicates the end position of the file pointer up to the point where the file was previously read.
TIMESTAMP Timestamp Indicates the time when the file was picked up for processing.
LMDFTIME Timestamp Indicates the last modified time of the file.

File store

Column name	Type	Description
FILENAME	Varchar (255)	Name of the event file to be processed.
FILESTAT	Integer	Status of the file entry. The adapter uses the status to determine whether the file is a new event to be processed or if the event is being currently processed. UNPROCESSED (0) The new file is ready to be processed. WebSphere Adapter for FTP polls the event directory for files and creates an entry in the file table. IN-PROCESS (1) A file is in-process if the adapter is reading the file content. When the file status is 1, no other adapter is allowed to process the file. The timestamp is updated when the file is picked up for processing. EVENTS UPDATED (2) The adapter reads only the file content required by the polling quantity and generates the new events for the current set of business objects. PROCESSED (3) The file processing is complete and the event entries are generated in the event table for the business objects. FAILED (4) The adapter was unable to read the file because of an unexpected error. The file might be corrupted or invalid. ARCHIVING (5) The archiving process for this file is in progress.
LBOCOUNT	Long	Specifies the number of business objects that were processed until the file was previously read.
LREADPOS	Long	Indicates the end position of the file pointer up to the point where the file was previously read.
TIMESTAMP	Timestamp	Indicates the time when the file was picked up for processing.
LMDFTIME	Timestamp	Indicates the last modified time of the file.