Purge Activity

The Purge activity handles the functionality related to deleting targeted single transmissions from a Transaction Insight® database.

Purge can be directed by using any of the three parameters (ID, Filename, or GUID) those Filename and GUID are our recommended identifiers. ID refers to Transmission ID and is generally only available when looking directly at the Transmission Table in the Transaction Insight database.

Note: Parameters entered into BusinessWorks will be passed directly along to the Purge executable installed with Transaction Insight.

General

The General tab contains the following fields:

Field Datatype Description
Name No (Required) The name to be displayed as the label for the activity in the process.
TI Binaries Directory String (Required) Location of Transaction Insight Java binaries.
Monitor Timeout Integer Number of minutes for Monitor thread timeout.

0 = Disable

30=Default

Description

The Description tab is used to provide a short description for the activity.

Input

The Input tab contains the following fields.

Input Item Datatype Description
DatabaseConnectString string Connection string for the Transaction Insight database:

Example: Oracle

jdbc:oracle:thin:username/password@dbserver:port:instance

Example: SqlServer

jdbc:sqlserver://dbserver:port;databaseName=dbname;user=myuser;password=mypass;

LogfileLocation string Specifies the path and filename to the log file.
Debug boolean Expands output to include additional information for debugging purposes.
PurgeID integer Purge data with the specified Transmission ID.
PurgeFilename string Purge data with the specified filename. Wildcards are invalid.
Note: If multiple files have the same name, only the first row is purged.
PurgeGUID string Purge data with the specified GUID.
Note: GUIDs are specified inside the TIBCO Foresight® Instream® results file, at the file level.

Output

The Output tab contains the following fields.

Output Item Datatype Description
ReturnCode string The Purge return code.

Refer toError Codes.

Fault

The Fault tab lists errors that might occur when you use this activity.

Error Schema Element Datatype Description
msg string Error message description.
msgCode string The error code.