Skip to main content
To homepage To homepage
Solved

Error while processing SSAS Tabular cube

M
Contributor

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

    M
    Contributor

    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

    S
    Contributor
    Forum|alt.badge.img+3
    • Syed Yousuf
    • 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.

    M
    Contributor

    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


    Most helpful members this week

    Terms and ConditionsCookie settings

    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