ssas tabular unspecified error - Visual Studio 2017 SSDT

Vishwanatham, Gautam 1 Reputation point
2020-09-22T20:27:12.713+00:00

I have a tabular model, I just added a few measures and deployed it in Microsoft Sql server management studio,

when I am processing the partition, either in Visual studio or in sql server mgmt studio, I get below error, this is the partition where columns were added,
there are other partitions in the model for which I am not getting the error, please advise .

The following system error occurred: Unspecified error

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,260 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,821 Reputation points
    2020-09-23T03:36:10.697+00:00

    Hi,

    Since other partitions do not have error. From the error message , I assume there are
    unexpected data in the columns.

    I suggest you could check the data integrity in this partition in your data source. I guess it is not SQL Server datasource, so there is no specific error info ?

    Or you could make the partition smaller that has less rows or columns, to check where the corrupt data is .

    Regards,
    Lukas

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.