Error while trying to load the mining model in the mining model viewer

Question

I get the following error when I try to load the mining model in the mining model viewer

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[NeuralNet].[GetAttributeValues]' function does not exist.

I get a similar error when I try to load the Load Mining Accuracy Chart

Failed to execute the query due to the following error:

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[AllOther].[GenerateLiftTableUsingDatasource]' function does not exist.

I have OWC 11 installed. What am I missing here?

Thanks

 

Answer 1

These are Analysis Services stored procedures that are suppposed to be installed with your server. Would you please start Management Studio and coonect to the Analysis Services instance you are using? After you connected, click the Assemblies in the object Explorer, you should be able to find System listed there. Right click system, and select properties. You will have a list of properties of this the system assembly.

At first, please verify your assemly exisits. The location of the assembly is list under general->Source. And it looks something like this:

    C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\bin\msmdspdm.dll

   Please verify this file is not deleted  by accident

Second, please check Security Settings. Usually, it should work fine for the following settings:

     Impersonation Info          ImpersonateServiceAccount

    Permission Set               Unrestricted.

Good luck,

Answer 2

I installed SQL Server and SSAS in D drive. For some reason, the System assembly source property still points to the C drive. I can't change it either from the property screen or rerun the XMLA script. I also copied the folder from D: to C:. It does not work either.

Do you know how to resolve it?

Thanks a lot.

Answer 3

On possible solution (if you don't have any sensitive data in Analysis Services): stop the service, rename your Data folder to something like Data.bak  (%ProgramFiles%\Microsoft SQL Server\MSSQL.2\OLAP\Data), then restart the service. This might fix the incorrect path issue.

 

Answer 4

I have a similar error:

 

Code Block

TITLE: Microsoft Visual Studio
------------------------------

Load cluster profile failed: Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[Clustering].[GetClusterProfiles]' function does not exist.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Viewers.SR&EvtID=LoadProfilesFailed&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[Clustering].[GetClusterProfiles]' function does not exist. (Microsoft OLE DB Provider for Analysis Services 2005)

------------------------------
BUTTONS:

OK
------------------------------

 

 

and was solved with the aid of the post by Yimin Wu

 

You only need to locate the files: "System.0.asm.xml" and "VBAMDX.0.asm.xml" and change the wrong path for the new one.

In my case this was inheritated for an old server that was two instances of sql server 2005 with AS and RS.

Thanks, Yimin

 

 

Answer 5

Hi,

 

I have also similar error. But Assemblies under my Analysis Server Database are empty.

 

To provide you with more context: I have a local instalation of Microsot SQL Server 2005, through which I connect

to the SQL Server on which I have restricted rights. My administrators has created for me Microsoft Analysis Server Database on which I have full admin rights. But maybe they did not created it properly, because the Assemblies on

database are empty.

 

---> Please what should I tell them to do to correct this ?

 

Thanks,

 

Vavrinec

 

Answer 6

This fixed my problem.  Just pointed "System.0.asm.xml" and "VBAMDX.0.asm.xml" to the directory that contained the .dll, restarted the AS service and we're back in business.  Thanks for the info.