AMO TOM Synchronize SynchronizeSecurity bug

Stefan 191 Reputation points
2021-01-14T09:24:02.063+00:00

Hi,
I have found a problem in AMO TOM dll when using the Synchronize method to synchronize a SSAS Tabular database from one server to another.

The problem is that the command is not synchronizing security memberships. It synchronize roles, but not the membership content of the roles.
When using the synchronize wizard in SSMS it works fine.

My code looks like this:

56553-synch-code-total-img.png

Using xEvents I managed to catch the command being sent to the server both using the TOM code and using the SSMS wizard.

Command when using TOM:
56545-tom-synch-img.png

Command when using SSMS:
56455-ssms-synch-img.png

So what we can see here is that even through I set the SynchronizeSecurity Enum to CopyAll in the code it doesn´t apply that property to the command. Just as a test a tested the other two enum values skipmembership and ignoresecurity. They both work as expected (property added to the command).

I read that skipmembership is the default syncronizesecurity value. Propably that is what is happening here. It ignores my CopyAll property and uses default skipmembership.

I´m using the latest available version (19.14.0) of the AMO dlls available here:
https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions

56547-dll-version-img.png

The servers are running SSAS 2019 version (15.0.34.21).

Any idesas?

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,249 questions
{count} vote

Accepted answer
  1. Stefan 191 Reputation points
    2021-03-17T17:15:17.723+00:00

    Test with new version 19.18.0.0 today and the issue seems to be fixed :)


3 additional answers

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-01-15T06:06:24.77+00:00

    Hi,

    Thanks for your posting. It looks like this is a by design issue, that we could not change much about the method command.

    I suggest you could post this issue at SQL Server Feedback site : https://feedback.azure.com/forums/908035-sql-server.

    Hope the product team could see this and offer some fixes or solution.

    Regards,
    Lukas


  2. Iggy Soputro 1 Reputation point
    2021-01-19T08:11:29.28+00:00

    Hi, I can also confirm I have the same issue with SSAS 2017, version 14.0.249.62. We have been synchronising using copyAll option in the past and have been working (i.e., role membership was synced) but the latest patch broke it (role membership not syncing anymore). I have up-vote your post.


  3. Stefan 191 Reputation points
    2021-01-27T13:47:30.623+00:00

    Just wanted to let you know that I raised a ticket with Microsoft and they confirmed that this a bug and it should be fixed in some upcoming release. Don´t know when though.