Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

Processing Log and Deletion Log

This page shows what SQL Connector has sent to the external data store, what is waiting and what failed, and which deletions and renames are waiting for the next synchronization.

Processing Log

The processing log serves both as a queue for data packages awaiting dispatch and as a history of all operations that have already been performed. For administrators it offers the ability to export and edit the command sent to the external data store.

Processing log

Columns

ColumnDescription
Entry No.Unique auto-incrementing entry identifier
Process CodeTable setup code that the entry belongs to
Server CodeServer setup code
Process TypeType of operation sent/to be sent to the external server (e.g. Insert/Update, Delete, Create Table)
Log Date TimeWhen the entry was created
Log TextDescription derived from the table synchronization
Statement SizeSize of stored data packages in bytes
Process StatusCurrent status: Pending, In progress, Completed, Failed or Blocked
Process Date TimeWhen processing (dispatch) started
Process Finish Date TimeWhen processing finished
Process DurationHow long the dispatch took
Process MessageResponse message from processing
Response Status CodeHTTP response code from the server that handled the dispatch
Response Is SuccessWhether the HTTP response indicates success
Response Reason PhraseReason phrase of the HTTP response (e.g. OK, Unauthorized, Forbidden)
Retry CountNumber of retries that have been made for this entry

Status Flow

Each entry goes through the following statuses:

  1. Pending: data package generated and queued, has not been sent
  2. In progress: currently being sent
  3. Completed: execution succeeded
  4. Failed: dispatch or execution failed; can be retried up to the maximum retry count per server settings.
  5. Blocked: entry is blocked because a prior entry for the same package failed. The system is configured to stop sending for a package when an error occurs (see "Stop Package on Error" in server setup).

Actions

Processing

ActionDescription
Process EntrySends the selected processing log entry to the configured connected server
Process All Unprocessed EntriesSends all pending entries to connected servers
Retry PackageResets all failed and blocked entries for the selected package to Pending, allowing them to be processed again

Management

These actions are available for administrators: users with write permissions on server setup.

ActionDescription
Export WrappedDownloads the wrapped payload of the entry — a JSON envelope containing the SQL command and connection metadata — as a file
Export PayloadDownloads the raw data package as a file for troubleshooting
Upload PayloadUploads a data package file and inserts it into the existing entry.
Delete Old EntriesDeletes completed and failed entries older than the configured retention period
Purge All CompletedDeletes all completed entries regardless of age

Deletion Log

The deletion log specifically tracks deletions and renames of records in tables that have been set up for synchronization. It is then used in the next synchronization to deliver commands to remove the records from the external data store. Such commands are then visible in the processing log like any other.

Deletion log

Columns

ColumnDescription
Entry No.Unique auto-incrementing identifier
Table No.Number of the BC table where the deletion/rename occurred
Primary KeyPrimary key text of the affected record (up to 2048 characters)
RecordIdBC RecordId of the deleted/renamed record
ActionType of operation: Delete or Rename
Created byThe user who performed the deletion/rename
Created onWhen the deletion/rename occurred

Actions

ActionDescription
Delete Old EntriesDeletes deletion log entries according to the retention settings of all servers. The longest retention period found in server settings is used.