To homepage To homepage
Solved

Error when deploying tabular model - "This row has been removed"

  • 20 March 2021
  • 6 replies
  • 106 views
T
Rank

Hi all,

When deploying our tabular model/endpoint (Azure Analysis Services), we get a strange error: "This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row".

In the error message we don't see which table or row this relates to and we don't know if this error relates to a datawarehouse table or a repository table. All our datawarehouse tables in this tabular model contain data and 'look good'. In addition, this error occurs in one of our environments and not in the other environments. 

Has anyone experience with this error? Any thought on how we can debug this one?

Thanks.

icon

Best answer by Thomas Lind 19 August 2021, 14:48

View original

6 replies

tld
Rank
Userlevel 1
Badge +1

Hi Thomas,

Unfortunately, TimeXtender does not always return the complete error-message to you. However, if you try to do a Process Full on the Tabular model in SSMS, you will get the full error message. 

Best regards,

Thomas Duun, Atlytix

Thomas Duun, Atlytix - https://www.linkedin.com/in/thomasduun/
rogier.helmus
Rank
Badge +1

Hi Thomas,

I've run into the same error when trying to deploy a semantic model. Before that I was playing around with semantic model perspectives. I removed those and after that the deployment of the semantic model ran without an issue, so I assume the cause might be in the direction of the semantic model perspectives.

 

Thomas Lind
Rank
Userlevel 5
Badge +5

Hi Rogier
You are most likely correct in thinking that.

Last Thursday we released a new hot-fix with a fix of the perspectives. You would experience that exact error message if you deleted a field that was present in a perspective.

11029: Deleted semantic fields don't remove all related semantic perspective items
Fixed an issue where deleting a semantic field that is used in a perspective did not get remove from the perspective
https://legacysupport.timextender.com/hc/en-us/articles/360051186931 

anders.e.jonsson
Rank
Userlevel 1
Badge +1

Hi,

I get the same error when deploying a semantic model in version 6143.
I had one perspective which I don’t think affected this model, but I deleted it anyway. Still the same error.

Since I can’t deploy, there is nothing to process i SSAS.

Any other suggestions?

BR

Anders

Anders
Thomas Lind
Rank
Userlevel 5
Badge +5

Hi Anders

The error is also in the 6143 version. We have made a bug fix for it. It should be fixed in the next release.

The only way to delete a field from a table in a semantic model, when using perspectives, is to remove it from the perspective first.

anders.e.jonsson
Rank
Userlevel 1
Badge +1

Thanks Thomas,

I just rolled back to a previous version in the SSL and removed the perspective. Then it was just a matter of syncing the SSL.
Very convenient to be able to go back to a previous version in a single instance.

BR

Anders

Anders

Reply


Terms and ConditionsCookie settings