Thursday, 23 January 2014

SSRS Troubleshooting: Specified method is not supported

Scenario:
I tried to create a model and in the last step of the creation wizard when I run I get the error message: specified method is not supported.

























Solution:
This could happen if you had mismatched model designer and semantic query DLLs installed.  Specifically you could check that the version numbers (Select the file-->Right Click-->Properties-->Details tab) on the following two DLLs match in:

(From BIDS help menu select-->About Microsoft Visual Studio. Check the version and if the version is 8 then)
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
Microsoft.ReportingServices.ModelDesigner.dll
Microsoft.ReportingServices.SemanticQueryEngine.dll

If they don't match you should repair your installation and/or reapply SP2.

Report models only support the .NET providers for SQL Server, Oracle, and Teradata. So, change it from the SQL Native Client OLE DB to the .NET SQL Client Data Provider and I got rid of the error and was able to build the report model.

Last step, One post has suggested to try to create the report manually.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home