Monday, March 19, 2012

Error when creating DMX query

On screen states [Error loading mining model metadata: No Metadata found]

and on the functions states [Error loading functions: no functions found]

This also occures when trying to use the Data mining wizard, it will just not respond.

Have deleted and removed all references to SQL2005 Standard and reloaded and still get same errors

Could someone please advise, have sent errors to Microsoft with no responce back yet.

I assume you are using the DMX query in SQL Management Studio?

These results occur when you have a database selected that doesn't contain any mining models. If you select a database in the database selector on the toolbar that contains models, you will get the list of models in the database in that pane of the user interface.

Also you could just do

"CREATE MINING MODEL foo ( custid LONG KEY, MyColumn LONG CONTINUOUS) USING Microsoft_Clustering"

and that would create a model in the current database that should show up in the metadata browser.

Given that you have issues using the wizard as well, it sounds like there may be some other issues. Can you provide more details?

Thanks,

-Jamie

No comments:

Post a Comment