SQL/BIDS 2008 R2 Error Processing Mining Structure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL/BIDS 2008 R2 Error Processing Mining...

SQL/BIDS 2008 R2 Error Processing Mining Structure

Rate Topic

Display Mode

Topic Options

Author

Message

bteague

Posted Wednesday, May 26, 2010 3:02 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 07, 2013 11:32 AM
Points: 13, Visits: 127

I receive the following errors when attempting to process a data mining model against Adventure Works DW ... when following the instructions in the 70-448 exam prep book by Veerman, Lachev and Sarka. Thoughts or known compatibility issues?

Error 4 Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element.
Error 5 An error occurred while parsing the 'StorageMode' element at line 1, column 11172 ('http://schemas.microsoft.com/analysisservices/2003/engine' namespace) under Load/ObjectDefinition/Dimension/StorageMode.
Error 6 Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\TK 448 Mining Models Project.0.db\TargetMailDim.2.dim.xml'.
Error 7 Error (Data mining): An error occurred while an internal object was being created.

Post #928637

nate.zimmerman

Posted Wednesday, August 18, 2010 8:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, August 30, 2011 8:45 AM
Points: 1, Visits: 1

Were you ever able to find a solution? I'm running into the same error and can't seem to find a fix.

Post #971157

bteague

Posted Wednesday, August 18, 2010 7:13 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 07, 2013 11:32 AM
Points: 13, Visits: 127

Honestly, I believe I reinstalled either the sample files or SSIS, but it was a while ago.

Post #971557

jonas 35896

Posted Tuesday, August 30, 2011 1:50 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 09, 2012 6:20 AM
Points: 1, Visits: 17

I've run into the same error. I deleted the project and started over from a previous chapter but no luck. Anyone got a solution? The advice on other sites has been to delete the .xml files that the error message is pointing at. When I did that I ended up with a corrupt cube.

Post #1167336

daniel aren

Posted Wednesday, June 27, 2012 6:38 AM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 8:16 AM
Points: 6, Visits: 61

Maybe this is helpful for some:
I deleted three files:
TK448 Ch09 Sequence.6.dms.xml
TK448 Ch09 Sequence ~MC.1.cub.xml
TK448 Ch09 Sequence ~MC-Order Number.1.dim.xml

after that i could deploy as usual.

Post #1321833

dixon.garry

Posted Sunday, August 05, 2012 12:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, September 10, 2012 2:20 AM
Points: 1, Visits: 15

Hi

Also working my way through the 70-448 exam book and got this error. I have no flippen clue what it is on about but I went into SSMS and deleted the SSAS database....it deployed fine after that. Here is a link I read that led me to do that, hope it helps.

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/303304b0-4cd8-4897-8f9d-1adef82f5ebb/

Cheers
G

Post #1340239

baudouintona

Posted Thursday, September 06, 2012 12:25 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 06, 2012 12:23 PM
Points: 1, Visits: 0

Hi,
Your solution worked for me too.
thank you very much

Post #1355554

« Prev Topic | Next Topic »

Permissions