Errors

By default, when an error occurs for an INSERT statement, changes made by the statement are undone. If the INSERT statement is called from within an existing transaction, the entire transaction is rolled back. ActiveSpaces does not impose a limit to the number of rows in a multi-row insertion. However, the number of rows must be processed within the time specified by the client request timeout property of the data grid (The default is 5 seconds).

If the insert values list does not match column list, a SQL command error is returned. Errors due to a conflict with the following constraints:
Constraints Error Description
PRIMARY KEY Values are not provided for all primary key columns