question

EdPatino-8027 avatar image
3 Votes"
EdPatino-8027 asked ·

Method not found: 'Microsoft.AnalysisService.Database Microsoft.AnalysisSerices.JsonSerializer.DeserializeDatabese

I am working on Visual Studio 19 Pro and have been unable to open any of my Tabular model projects. I have checked that extensions are installed have rolled back the versions and uninstalled/reinstalled and I continue to get the following:

Error Cannot build obj\Development\Model.asdatabase. Reason: Method not found: 'Microsoft.AnalysisServices.Database Microsoft.AnalysisServices.JsonSerializer.DeserializeDatabase(System.String, Microsoft.AnalysisServices.Tabular.DeserializeOptions, Microsoft.AnalysisServices.CompatibilityMode)'.

And

Method not found: 'Microsoft.AnalysisServices.Tabular.Model
Microsoft.AnalysisServices.Database.get_Model()'

I am on VS19 Version 16.8.4
Microsoft Analysis Services Project V 2.9.14
I am able to open SSIS projects and SSRS project with no issue.

sql-server-analysis-services
· 4
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Same issue here. Visual Studio 2019 version 16.8.4

Opened tabular model 2 days ago, everything was fine. Now I'm getting 60663-image.png


0 Votes 0 ·
image.png (6.4 KiB)

I am getting this exact same problem. My version of Analysis Services Projects is 2.9.15 with the same 16.8.4 version of VS (Community).

0 Votes 0 ·

Also getting the same error message:

Microsoft.AnalysisServices.Tabular.Model Microsoft.AnalysisServices.Database.get_Model()

Visual Studio 2019 version 16.8.4 and Analysis Services Projects version 2.9.15.

Yesterday I closed the project, I try to open it today... got the error.

0 Votes 0 ·

I had the same issue. My notebook has a Windows 10 Home Single Language with Visual Studio 2019 version 16.8.4.

I downloaded the community version and got the message:

Method not found: 'Microsoft.AnalysisServices.Tabular.Model Microsoft.AnalysisServices.Database.get_Model()'

Only uninstalling the SSIS 3.12 wasn't enough. I had to uninstall the Visual Studio 2019 entirely and reinstall it. After thar I installed the SSIS 3.11.1 and the problem was solved.

0 Votes 0 ·
DorelAdam avatar image
10 Votes"
DorelAdam answered ·

OK guys,

The error seems to come from the SQL Server Integration Services Projects extension version 3.12 released on January 25. I uninstalled it and I was able to open the tabular project and build it.

I reverted back to version 3.11.1 from December 28 and everything is fine now.

https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

· 7 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Confirmed, thanks Adam!

Uninstalled SSIS 3.12 and the tabular model now loads. Installed SSIS 3.11 and it still works. SSIS Projects 3.12 seems to be the cause.

0 Votes 0 ·

I updated from 2.9.14 SSAS to 2.9.15 and then reverted back to SSIS 3.11 now I'm able to see my models.

Thank you Adam

0 Votes 0 ·

Great ! This is why I can't replicate the same issue with same environment , I had not installed SSIS project!
Thanks a lot for the sharing !!!

0 Votes 0 ·

Saved me a lot of troubleshooting!

Thanks Adam.

0 Votes 0 ·

Worked for me - thank you for saving me some hair!

0 Votes 0 ·

I just disable SSIS and it works fine. Thx Adam.

0 Votes 0 ·
Show more comments
LukasYu-msft avatar image
1 Vote"
LukasYu-msft answered ·

Hi,

Thanks you for your post here, @EdPatino-8027 @DorelAdam @MattBenham-1376 .


May I ask what is your operating system ? I just test with a new environment with :

VS - 16.8.4
AS Project - 2.9.15
OS - Window Server 2019

And I have not met such issue in Tabular model.

Did your VS work correctly at old version ? If your need is urgent , I suggest you to work with old build first and wait for the hot fix on this issue. You could download older version of VS at Download Visual Studio. As I used 16.8.2 for a long time and never met such issue.

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.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November


· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Lucas,

My OS is W10 1909 (18363.1316).

VS was working correctly with a previous version. I had to reinstall VS recently due to separate (resolved) issue and this issue appeared with the latest version that was installed.

Kind Regards,

Matt

0 Votes 0 ·

Hi Lucas,

My environment is:

Windows 10 Pro 20H2 (19042.746)
Visual Studio Enterprise 2019 (16.8.4)
AS Project 2.9.15

I was able to open tabular projects a few days ago. Now I'm getting the above error when I try to open a project. Also when building I'm getting:

Cannot build obj\Release\Model.asdatabase. Reason: Method not found: 'Microsoft.AnalysisServices.Database Microsoft.AnalysisServices.JsonSerializer.DeserializeDatabase(System.String, Microsoft.AnalysisServices.Tabular.DeserializeOptions, Microsoft.AnalysisServices.CompatibilityMode)'.




0 Votes 0 ·
NRond-9868 avatar image
0 Votes"
NRond-9868 answered ·

Hi all,

I ran into the same problem,
and as I knew I installed an update of SQL Server Integration Services Projects earlier, I tried uninstalling this version 3.12 and reinstalling version 3.11.1
The error no longer appears with this.
You can download the old version of SSIS projects here: SSIS Project


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RoschinMU avatar image
0 Votes"
RoschinMU answered ·

У меня установлены SSIS и SSAS, была ошибка и я просто отключил SSIS и модель стала открываться.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LasaterJohn-6006 avatar image
0 Votes"
LasaterJohn-6006 answered ·

It appears that disabling the SSIS extension also works. It's not as convenient but can be a quick workaround.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.