Skip to main content
Solved

Error while processing SSAS Tabular cube


I am able to deploy the semantic model but when I execute it I get the following error message:

The current operation was cancelled because another operation in the transaction failed.

Details:

The current operation was cancelled because another operation in the transaction failed.
System.Exception

Not much do work with Im sorry to say but this is what I get. This is the TXDictionary project and it has worked before i moved it to a new server. The rest of the project executes fine (ODX, DSA and MDW).

Best answer by Syed Yousuf

Hi Martin,

To get additional details on this error:

1. Check software prerequisites ( SQL Server Management Objects (SMO), Analysis Management Objects (AMO) etc. ) on the new server, as described in this article:

https://legacysupport.timextender.com/hc/en-us/articles/213530403-TimeXtender-Prerequisites#Application

2. Try to process the Tabular model in SSMS - it may show additional error details.

View original
Did this topic help you find an answer to your question?

3 replies

This is what we get in the mail notification:

Finished executing project 'TXDictionary' Execution Package 'TXDictionary Full Project'

Execution failed

Start Time : 2021-04-26 16:46:23 End Time : 2021-04-26 16:46:35 on server: SRV12080 -Execute Execution Package TXDictionary Full Project 'Processing failed'

                             The current operation was cancelled because another operation in the transaction failed.

                            

                             Details:

                            

                             The current operation was cancelled because another operation in the transaction failed.

                             System.Exception

                            

Execute Project:Info:DoStep() has not been called!

  -Execute Project

Execute Business Units:Info:Initialized

Execute Data Warehouses:Info:Initialized Execute SSAS Multidimensional Servers:Info:DoStep() has not been called!

Execute Semantic Models:Info:Initialized

    -Execute Semantic Models

Execute TXDictionary(Tabular or Qlik):Info:Initialized

      -Execute TXDictionary(Tabular or Qlik) Execute Tabular endpoint Tabular:Error:Processing failed

        -Execute Tabular endpoint Tabular 'Processing failed'

                            The current operation was cancelled because another operation in the transaction failed.

                           

                            Details:

                           

                            The current operation was cancelled because another operation in the transaction failed.

                            System.Exception

No child steps


Forum|alt.badge.img+3
  • Contributor
  • 82 replies
  • Answer
  • April 26, 2021

Hi Martin,

To get additional details on this error:

1. Check software prerequisites ( SQL Server Management Objects (SMO), Analysis Management Objects (AMO) etc. ) on the new server, as described in this article:

https://legacysupport.timextender.com/hc/en-us/articles/213530403-TimeXtender-Prerequisites#Application

2. Try to process the Tabular model in SSMS - it may show additional error details.


Thanks! Processed the cube from SSMS and got a better error message:

Failed to save modifications to the server. Error returned: 'The size of a data value in table 'PackageExecutionTime' column 'ExecutionMessage' was too large to fit in that column.
The current operation was cancelled because another operation in the transaction failed.

That is easily fixed.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings