Error on Associative Rules Viewer

Hello,

I don't know if this is the correct forum or if it would perhaps be the server setup & upgrade, however, I'll ask here first. I am going through the SQL 2005 data mining tutorials and have encountered an error that states:

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

After looking around for a bit it appeared that this function is generally used in a stored procedure run from the server. Is this correct? What do I need to do to either correctly import the function into the project or to make sure that it is installed on the server?

We are running the Ent Ed. now, however, we just upgraded to this after I had already started on this project. Could that be a problem?

Any help on this would be greatly appreciated.

Thanks for your time.
Eric Wisdahl

Did you try another other viwer? If this happens to every viewer, you may find this post is helpful:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=928000&SiteID=1

Good luck,

|||

From your previous post in the other topic:

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,

I noticed that I do not, in fact, have the msmdspdm.dll in the appropriate spot. It states that the source should be in C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdspdm.dll. I did find a file with this name in the MSSQL.4\OLAP\bin folder and put it into the MSSQL.2 folder. I then had to restart the service and it appears that this has fixed the problem.

Thank you very much for your time...

Eric Wisdahl