Skip to main content

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).

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


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