ProfileBulkInsert

Description

This activity allows to massively insert profiles in DocsMarshal given a list of ProfileForInsert. If any error occurs, then no profile is inserted and the activity throws an exception.

Videos:


Advanced Options

CheckConstraints InArgument<Boolean>

Specifies that all constraints on the inserted profiles must be checked during the bulk-insert operation.

DbBatchSize InArgument<Int32>

Default: 4000. Specifies the number of rows in a batch. Each batch is copied to the server as one transaction.

LockTables InArgument<Boolean>

Default: false. Specifies that a table-level lock is acquired for the duration of the bulk-import operation. A table can be loaded concurrently by multiple clients if the table has no indexes and TABLOCK is specified. Holding a lock for the duration of the bulk-import operation reduces lock contention on the table, in some cases can significantly improve performance.

ProfilesBatchCount InArgument<Int32>

RetryCount InArgument<Int32>

The maximum time the activity have to retry the bulk insert operation.

TableTimeout InArgument<TimeSpan>

Default: 30s. If it is set to 0 the time out will be infinite


DocsMarshal Connection

Orchestrator InArgument<IManager>

The orchestrator object represents the connection to a DocsMarshal installation.

If this argument is left null the activity will work on the running installation. To work on another installation you must get its orchestrator by the activity DatabaseOrchestrator.

Feedback

AttemptsMade OutArgument<Int32>

The number of attempts the activity made for completing successfully the operation.

DebugInfo OutArgument<String>

A string value usefull for debug operations.


Misc

ProfilesForInsert InArgument<List<IProfileForInsert>> REQUIRED

The list of the profile to be inserted.

RaiseWorkflowEvents InArgument<Boolean>

Default is TRUE. Set it to False if you don't want to raise the OnInsert events for the workflows.