Commit Time-out

Analysis Services Programming

Analysis Services Programming

Commit Time-out

If a commit is not successful because a client application's attempt to update a cube's writeback table times out (that is, the time spent attempting the commit reached the value of the DBPROP_MSMD_WRITEBACK_TIMEOUT property), the following error message is raised in the connection objects Errors collection:

Server unable to accept transaction at this time. Transaction pending on client.

In this case, the transaction's state is the same as it was immediately before the commit attempt. The client application can again attempt to commit, attempt to roll back, or allow more what-if changes.

The preceding message is produced as a result of the following return code from the ITransaction::Commit method: MSMD_E_TRANSACTION_COMMIT_TIMEOUT.

Increasing the value of the DBPROP_MSMD_WRITEBACK_TIMEOUT property can reduce the number of time-outs.

For more information, see Writeback Timeout Property.