Re: MDX Updates

On Mon, 13 Mar 2006 17:18:23 -0800, "T.K. Anand [MSFT]"
<tkanand@xxxxxxxxxxxxxxxxxxxx> wrote:

Try sending the SELECT statement from a different query window. If it
returns the wrong result, then your cube update transaction (in the first
query window) is not committed. Send a COMMIT TRANSACTION statement.

Thanx for Your answer. You were right : if I send a SELECT in a new
window, I obtan the wrong result... But, if I send a "COMMIT
TRANSACTION" in the Update's windows, I get an error :

Executing the query ...
The connection either timed out or was lost.
Execution complete

....And the service named "Analysis Service" crash (go in stopped
state), telling me, in Event Viewer (System) :

The SQL Server Analysis Services (MSSQLSERVER) service terminated
unexpectedly. It has done this 1 time(s).

Any idea ?
TIA
Fabio
.

Relevant Pages

  • Re: [RFC] JBD ordered mode rewrite
    ... data buffers that need syncing on transaction commit but a list of inodes ... that need writeout during commit. ... the file then that inode would be added to the journal list and the pages ...
    (Linux-Kernel)
  • Re: [RFC] JBD ordered mode rewrite
    ... data buffers that need syncing on transaction commit but a list of inodes ... that need writeout during commit. ... delayed allocation, starting a new transaction could to happen a lot to ...
    (Linux-Kernel)
  • Re: [PATCH 2/2] improve ext3 fsync batching
    ... array than it takes to complete the transaction. ... when commit times go up to seconds? ... Transactions on that busier drive would take longer, we would sleep ... longer which would allow us to batch up more into one transaction. ...
    (Linux-Kernel)
  • Re: Backups and Transaction Log file size
    ... It sounds like a classic case of a long running open transaction. ... Find the client and either commit or roll it back. ... If you know it is a garbage connection you can kill the SPID and it will roll back any changes that the SPID may have open and allow you to backup and truncate properly. ... Once the committed trans have been ...
    (microsoft.public.sqlserver.setup)
  • Re: [RFC] JBD ordered mode rewrite
    ... data buffers that need syncing on transaction commit but a list of inodes ... that need writeout during commit. ... the file then that inode would be added to the journal list and the pages ...
    (Linux-Kernel)