Database Collection Agent Events(3.0)
Agent Message Events
An information message from the agent, stated according to the configuration done in the Event Notification Editor.
For further information about the agent message event type, see Agent Event(3.0).
Ready with table:
tablename
Reported, along with the name of the working table, when all rows are collected from it.
Debug Events
Debug messages are dispatched in debug mode. During execution, the messages are displayed in the Workflow Monitor.
You can configure Event Notifications that are triggered when a debug message is dispatched. For further information about the debug event type, see Debug Event(3.0).
The agent produces the following debug events:
Start collecting
Indicates that possible cleanup procedures are finalized and that the actual collection begins.
No rows selected from table
tablename
Reported, along with the name of the working table, if no rows have been selected for collection.
Avoids reading the following pending txn ids:
list of ids
Reported, along with a list of Transaction IDs, if the constructed SQL
select
statement finds any pending Transaction IDs in the pending transaction table. Rows marked with these transaction IDs will be excluded by the query.Marking collected data as cancelled
Reported when a Cancel Batch is received.
Deleting collected data
Reported when collected rows are removed after collection, if Remove is selected in After Collection.
Has deleted
n
rows intablename
Subevent to the
Deleting collected data
event, stating the number of rows removed by each SQLcommit
command. The maximum number depends on the Commit Window Size.Marking collected data
Reported when collected rows are marked, if Mark as Collected is selected in After Collection.
Has updated
n
rows intablename
Subevent to the
Marking collected data
event, stating the number of rows marked as collected by each SQLcommit
command.Taking care of collected data via
SPname
Reported, along with the name of the stored procedure, when it is called after collection, if After Collection.
is selected inTry to force running Stored Procedure to Stop
Reported when stopping a workflow that has a Stored Procedure running.
Agent Message Events
An information message from the agent, stated according to the configuration done in the Event Notification Editor.
For further information about the agent message event type, see Agent Event(3.0).
Ready with table:
tablename
Reported, along with the name of the working table, when all rows are collected from it.
Debug Events
Debug messages are dispatched in debug mode. During execution, the messages are displayed in the Workflow Monitor.
You can configure Event Notifications that are triggered when a debug message is dispatched. For further information about the debug event type, see Debug Event(3.0).
The agent produces the following debug events:
Start collecting
Indicates that possible cleanup procedures are finalized and that the actual collection begins.
No rows selected from table
tablename
Reported, along with the name of the working table, if no rows have been selected for collection.
Avoids reading the following pending txn ids:
list of ids
Reported, along with a list of Transaction IDs, if the constructed SQL
select
statement finds any pending Transaction IDs in the pending transaction table. Rows marked with these transaction IDs will be excluded by the query.Marking collected data as cancelled
Reported when a Cancel Batch is received.
Deleting collected data
Reported when collected rows are removed after collection, if Remove is selected in After Collection.
Has deleted
n
rows intablename
Subevent to the
Deleting collected data
event, stating the number of rows removed by each SQLcommit
command. The maximum number depends on the Commit Window Size.Marking collected data
Reported when collected rows are marked, if Mark as Collected is selected in After Collection.
Has updated
n
rows intablename
Subevent to the
Marking collected data
event, stating the number of rows marked as collected by each SQLcommit
command.Taking care of collected data via
SPname
Reported, along with the name of the stored procedure, when it is called after collection, if After Collection.
is selected inTry to force running Stored Procedure to Stop
Reported when stopping a workflow that has a Stored Procedure running.