dbTalk Databases Forums  

Stalled at first hurdle with deployment of AdventureWorks cube on SSAS 2005 ...

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Stalled at first hurdle with deployment of AdventureWorks cube on SSAS 2005 ... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andy
 
Posts: n/a

Default Stalled at first hurdle with deployment of AdventureWorks cube on SSAS 2005 ... - 10-30-2006 , 05:36 AM






I am trying to get the Adventure Works sample working with AS2005 and not having a lot of joy.
I opened the following solution file:

C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\Standard\Adventure Works.sln

Right clicked on the solution and selected "Deploy". Got the output shown below.
Does this mean that something has screwed up during my AS2005 installation?
Setup didn't report any errors.

I tried to "process" before doing deploy and did not get any errors. However when I browse the cube in "Management Studio" it just hangs.
Any pointers for trouble shooting would be much appreciated. I tried both "Standard" and "Enterprise" solution files and got the same problem.


------ Build started: Project: Adventure Works DW Standard Edition, Configuration: Development ------

Started Building Analysis Services project: Incremental ....

Build complete -- 0 errors, 0 warnings

------ Deploy started: Project: Adventure Works DW Standard Edition, Configuration: Development ------

Performing an incremental deployment of the 'Adventure Works DW Standard Edition' database to the 'localhost' server.

Generating deployment script...

Add Database Adventure Works DW Standard Edition

Process Database Adventure Works DW Standard Edition

Done

Sending deployment script to the server...

Error -1056571392 : OLE DB error: OLE DB or ODBC error.

Error -1054932978 : Errors in the OLAP storage engine: An error occurred while processing the '~CaseDetail ~MG' partition of the '~CaseDetail ~MG' measure group for the 'Customer Clusters ~MC' cube from the Adventure Works DW Standard Edition database.

Deploy complete -- 2 errors, 0 warnings

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.