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 ========== |