After you run a bulk
load transaction, the transaction log is available on the user interface.
Administration Tools > Transaction. The log
displays bulk load transactions:
In the list
view, the bulk load is shown in the Action column of the log. If the bulk load
was scheduled, this is shown as a schedule with the detail column indicating it
to be a bulk load.
start, and stop time for the entire bulk load transaction is shown in the
In the list
view, the Detail section displays the name of the file that is bulk loaded as
well as the timestamp of the bulk load. For scheduled bulk loads, the detail
section indicates the transaction as a “Bulkload”.
The system validates
the user’s access profile, the provided hierarchy information, and data
constraints for the bulk load transaction when updating the target models. The
parent bulk load transaction will show the error message if this validation
fails and no rows are loaded.
Where rows are
loaded, each row in the bulk load spreadsheet appears as a sub-transaction
within the bulk load transaction. The Message box shows the number of
successful and failed rows loaded.
For each loaded
spreadsheet, bulk load transactions are run in series for each row. Multiple
bulk load spreadsheets can be loaded and these transactions will load at the
Spreadsheet rows can
be processed at the same time and should not contain multiple, sequence
For each row of the bulk load sheet carrying out the default add action,
a Create action is shown on the list of transactions. Sheet rows that led to a
successful Create action have a Success status, while rows that failed show a
Fail status. If a row fails, the load process continues. For failed actions,
the transaction can be selected to show the error message.
If one or more rows
of the spreadsheet failed to load, the Bulk Load action displays a Fail status,
and the sub transactions status is Fail.
On the list of sub
transactions, choose the transaction Link hyper-link to inspect the details of
each sub transaction. For example, the submitted, start, and stop time for the
bulk load sub transaction corresponding with a row on the bulk load spreadsheet
is shown. In the case of a failed sub transaction, further information about
the failure - such as the error message and row data - is shown in the sub
A canceled bulk load
transaction means the processing spreadsheet sub transaction, and all sub
transactions within the spreadsheet transaction in a processing or queued
state, will fail.
transactions, multiple resource transactions may be in a Queued or Processing
state. By default, 14 rows are processed in parallel. Refer to the Refer to the
topic on Bulk Load Sheet Layout for more details. If a spreadsheet transaction
fails as a result of bulk load transaction cancellation, subsequent spreadsheet
tabs in the bulk load workbook will not be processed by the bulk loader.