.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Trying to Deploy Cube From XMLA

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
I'm trying to deploy a cube using the XMLA file generated from Microsoft.AnalysisService.Deployment. I've modified the connection string to contain the password needed to connect to the datasource, but as soon as I execute the XMLA it stripcs the passwords out and I get the error below.

<return xmlns="urn:schemas-microsoft-com:xml-analysis">
  <results xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults">
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" />
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty">
      <Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" />
      <Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception">
        <Error ErrorCode="3239182363" Description="Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Could not load file or assembly 'System.Transactions, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)." Source="Microsoft SQL Server 2008 Analysis Services" Help

View Complete Post

More Related Resource Links

Cannot deploy cube



I just downloaded the AdventureWorks DB so I could start testing some BI.
But now the db is installed correctly on the server on my workstation > WORKSTATION999\SQLEXPRESS
Now when i want to deploy the cubes I keep getting deployment failed!

The configuration properties of my projects are like this
Server : WORKSTATION999\SQLEXPRESS (default this was localhost, but I have no server called like that)
Database : Adventure Works DW Standart Edition

I even tried to deploy it on a development server but there also no luck...
Thanx in advance! (btw Working with MS Visual Studio 2005 SP2 on XP)

XMLA for Cube Processing fails when called from SQL Agent Job


I have some XMLA which runs fine in SSMS, but fails when called as a step in an agent job. Here is the XMLA:

  <Process xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

And here is the error from SQL Agent:

An exception (0xe0434f4d) occurred in the ANALYSISCOMMAND subsystem.  The step failed.

I am running this on SQL 2005 SP3 Developer Edition. I have even tried uninstalling and reinstalling the instance. The PC also has SQL 2008 instances installed (I'm not sure it that is relevant or not). I can get the SQL Agent job working fine on SQL 2008 and another SQL 2005 box.

Can anyone help?


SSAS 2K5 - Deploy XMLA with C# - User right



I have a C# installer that deploy a XMLA to a SQL Server SSAS 2005. My installer ask to provide a AD username and password to deploy the XMLA on the target serveur with SSAS. What are the permission needed to deploy a XMLA on a SSAS server ???.

The AD user have sysadmin,dbcreator and public access in the Server Role node on the SQL Server where SSAS is located and its still poping that the user don't have the right to "deploy" the XMLA. (Its working tho if the user is admin of the server PC)

Chunk of the code :

  imp = new Impersonation(session["DBMASTER"], session["DBMASTER_PWD"]);


  XmlaClient clnt = new XmlaClient();


  string xmla = File.ReadAllText(strXMLA);

  clnt.Send(xmla, null);


Thanks !
Richard Martin Web Developer / BI Developer

Cube, Build, Deploy, Process

Dear all,

I'd like to get simple and clear explanation of the cube in data mining, and 3 notions we encounter a lot : Build, Deploy, and Process.

(1) What is the cube that is created when we deploy a mining solution/project?
  I wonder what type of cubes they are because although the dialog on deploy/process
  show that cube, after successful deployment we still don't see the cube in Cubes folder
  of the project.

(2) Why the SQL Server created that cube? Even though we process only one table
  and only use case-table (without nested table)

(3) Can someone explain these 3 concepts with CLEAR differences between them?
  (A) Build
  (B) Deploy
  (C) Process

As far as I know, the stages are like that : build, then deploy, then process.  Also, it seems
to me that those operations do not create objects inside 'Relational' database, but create
objects (binary and text, with text files usually in XMLA programming language) in the
related project's folders and subfolders.  Any good explanation is appreciated.


How can deploy a cube from production server to local server?



How can deploy a cube from production server to local server?

I tried to do it from BIDS, I have opened production server database from BIDS but nothing happened when I click project file.

I couldnt change default deployment

Also I have tried Wizard but couldnt find product server asdatabase

Any help will be appreciated



SMTP not working if I use web deployment package to deploy my app.


Hi all

I use msdeploy to install my web app. deployment package. everything about web app works, but find out email was not working.

I checked telnet smtp is running.

I debug the project, and it was sending out email too.

So my solution was upload the whole project (not complied) to wwwroot, and email works too. Thats why I assume the deployment cause the problem.

at last, I also tried to copy the web deployment web.config to replace the project's web.config, and the email also work, so it wasn't the web.config problem.

Could anyone tell me whats going on?

My environment:

window 2003

iis 6

.net framework 4.0

Web Service Workflows: Deploy Distributed Business Processes With Windows Workflow And Web Services


Due to the distributed nature of a business process it makes sense for a workflow to be deployed as a distributed application. See how Windows Workflow and Web Services hold the key.

Israel Hilerio

MSDN Magazine October 2006

Are You Protected?: Design and Deploy Secure Web Apps with ASP.NET 2.0 and IIS 6.0


Ensuring the security of a Web application is critical and requires careful planning throughout the design, development, deployment, and operation phases. It is not something that can be slapped onto an existing application. In this article, Mike Volodarsky outlines best practices that allow you to take advantage of the security features of ASP.NET 2.0 and IIS 6.0 to build and deploy more secure Web applications.

Mike Volodarsky

MSDN Magazine November 2005

ClickOnce: Deploy and Update Your Smart Client Projects Using a Central Server


ClickOnce is a new deployment technology that allows users to download and execute Windows-based client applications over the Web, a network share, or from a local disk. Users get the rich interactive and stateful experience of Windows Forms, but still have the ease of deployment and updates available to Web applications. ClickOnce applications can be run offline and support a variety of automatic and manual update scenarios.Learn all about it here.

Brian Noyes

MSDN Magazine May 2004

Office 2003: Secure and Deploy Business Solutions with Microsoft Visual Studio Tools for Office


Microsoft Visual Studio Tools for the Microsoft Office System is a new technology that brings the advanced features of Visual Studio .NET and the .NET Framework to applications built for Microsoft Office Word 2003 and Microsoft Office Excel 2003. Deploying solutions built with this technology requires that you understand how runtime security is enforced in managed applications and how to configure users' systems to run your solutions without introducing security holes.To promote that understanding, this article will demonstrate how to establish trust, explain policy considerations and permissions, and explain what trusted code is all about. Secure assembly deployment is also covered in detail.

Brian A. Randell and Ken Getz

MSDN Magazine March 2004

VseWss is really the right tool to deploy with yet ?



I think VseWss has long way to go it is not ready to be used because it should first follow the architecture of SharePoint to be good deployment too for example :

you can create list definition using the template provided for that list definition you can create list instance in SharePoint when you create list this later reference its list template using feature ID the problem is that vsewss change the feature ID all the time what happens is that when you uninstall solution and deploy the wsp if you had list this later will complain that it could not found the list template feature actually this list is referring  to the old feature ID the same feature had been deployed with new feature ID.

Another drawback that I think is in the fixing phase is the impossibility of using feature properties such as ActivateOnDefault, scope, etc. Because the feature files is overwritten dynamically every time you deploy.

Deploy a .NET application on the ttarget machine

Hi all, I have a project, is written in C#, using .Net framework 3.5. When I build a setup installer, capacity of the setup is about 10MB. Suppose,  I put the setup files in a web , and users download it to install in their PC. But i think, Users must be download .NET framework to run my project. In this case, users ought to download a .rar file , which have more 200MB over the internet. It is very heavy :( So, I want to find out the best solution to deploy .NEt application to the client 's PC. Anybody help me,please ? Thanks so much!  

Getting Below error while accessing SQL server cube

Getting Below error while accessing SQL server cube   Error Generating Drop Down Values   Odbc driver returned an error (SQLExecDirectW).   Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. URL: http://SIMAPPWQS99/olap/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000) SQL Issued: SELECT "- AppReceivedTimeYQMDD"."Year" FROM "Medicare E2E Tracking" ORDER BY 1

Clustering on cube slices

Hi, I would like to use the clustering algorithm "seperately" on each cube slice.  The problem description: Having many employes and their arrival-to-work time I created a cube with a fact table and 3 dimensions: Employee, Time, Office and I would like to run the clustering algorithm seperately for each employee to receive his arrival-to-work clusters and to find his exceptions e.g., for the employee John who has the following arrival time records: 08:05, 07:55, 8:10, 8:07, 10:30, 10:31, 10:28, 15:00 I want to receive two clusters, the first one will include  08:05, 07:55, 8:10, 8:07 The second one will include 10:30, 10:31, 10:28 (and the exception will be 15:00) Having many employees I would like to create one data mining model and to use the cube slice and dice options    Searching the web and the MSDN I didn't find whether and how it can be done - I will very appreciate your help   Thanks in advance, Lora

Restore - Cube Analysis Services 2005

Hi, I'm from Brazil. Sorry for my English. I made a backup for my cube that has more than 2 GB, but de backup is created with only 50 mb. The backup don't showed erro message. I restored this backup without erro, but when I tryed query the cube, i receive this message: The query could not be processed: o File system error: The following file is corrupted: Physical file: \\?\C:\SQL Server\MSSQL.2\OLAP\Data\teste.59.db\"Nome_Servidor" - "Nome_Database".190.cub\Fato Inadimplencia Safra Contrato.190.det\Fato Inadimplencia Safra Contrato.167.prt\172.fact.data. Logical file . Someone can help? I realy need make this backup.Fabrício França Lima | MCP, MCTS, MCITP | Visite meu site: http://fabriciodba.spaces.live.com/ | Dicas de artigos SQL: Siga-me no twitter @fabriciodba.

Cube Processing Error

Hi All when i process the cube some times i get the error  "OLE DB or ODBC  Error: Operation Cancelled; HY008. Internal Error: The Operation Terminated unsuccessfully  " https://connect.microsoft.com/SQLServer/feedback/details/286505/error-in-processing-cube?wa=wsignin1.0 In above link Microsoft they said to increase Query time out, i made it 0 even it repros I am using SQL Server 2008.   Thanks

Instant Refreshment of Cube

HI All, Is that possible cube get refreshed as soon as data updated into the relation database?   Kindly Suggest Regards Amit
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend