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

Error Message 8144 on Transaction Push Replication

Don,
have you changed the schema on the publisher and
subscriber - please can you check the table definitions.
Perhaps this was a nosync initialization and you created
the procedures by hand and they are now out of sync as
you've altered the columns on the publisher? Depending on
the problem it may be possible to run
sp_scriptpublicationcustomprocs to generate new
procedures and then recreate them on the subscriber if
this is the case. I'd only do this if the schemas are
identical.
HTH,
Paul Ibison
(The ONLY sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Paul,
Thank you so much. The developers were upgrading the publication and got the
error message that Dirc Khan-Evans just posted.
Trying to run ALTER TABLE ... get the error message:
Server: Msg 4929, Level 16, State 1, Line 1
Cannot alter the table 'blah' because it is being published for replication.
I had no choice but to delete the publication. I recreated it and pushed a
new subscription and it ran successfully. However, the schema changes did not
carry over to the subscriber. The subsriber table does not have the new
fields. That is why I am getting this error. Should I delete the table on
the subscriber and push a new subscription? Thanks.
Don
the "Paul Ibison" wrote:

> Don,
> have you changed the schema on the publisher and
> subscriber - please can you check the table definitions.
> Perhaps this was a nosync initialization and you created
> the procedures by hand and they are now out of sync as
> you've altered the columns on the publisher? Depending on
> the problem it may be possible to run
> sp_scriptpublicationcustomprocs to generate new
> procedures and then recreate them on the subscriber if
> this is the case. I'd only do this if the schemas are
> identical.
> HTH,
> Paul Ibison
> (The ONLY sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Don,
I'd reinitialize, but first double-check something in the
publication properties. On the article properties
elipsis, snapshot tab, for name conflicts check that it
says 'DROP the existing table'. When you subscribe, be
sure to leave the default which is to initialize. Then it
should all go fine.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

>
|||Paul,
Just to let you know how the story ended. I tried to reinitialize, but that
also did not work. I ended up droping the tables on the subscriber that had
schemas different from the publisher. I scripted the tables from the
publisher and recreated them on the subscriber. I then had to recreate the
publications and push the subscriptions. It now seems to be running fine.
Just one thought... the publisher is on SQL 2000 sp2 and the subsciber is on
2000 sp3. I don't know if this was a bug. Thanks for all your help.
Don Saluga
Vector Security Inc.
"Paul Ibison" wrote:

> Don,
> I'd reinitialize, but first double-check something in the
> publication properties. On the article properties
> elipsis, snapshot tab, for name conflicts check that it
> says 'DROP the existing table'. When you subscribe, be
> sure to leave the default which is to initialize. Then it
> should all go fine.
> HTH,
> Paul Ibison
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Thanks for the update Don - it's always helpful.
Regards,
Paul
"Don" <Don@.discussions.microsoft.com> wrote in message
news:A1286950-DC8C-4DB3-97CC-1C6E06E90565@.microsoft.com...
> Paul,
> Just to let you know how the story ended. I tried to reinitialize, but
that
> also did not work. I ended up droping the tables on the subscriber that
had
> schemas different from the publisher. I scripted the tables from the
> publisher and recreated them on the subscriber. I then had to recreate
the
> publications and push the subscriptions. It now seems to be running fine.
> Just one thought... the publisher is on SQL 2000 sp2 and the subsciber is
on[vbcol=seagreen]
> 2000 sp3. I don't know if this was a bug. Thanks for all your help.
> Don Saluga
> Vector Security Inc.
> "Paul Ibison" wrote: