Getting Error While Deploying Cube

May 19, 2008

Hi,

I am getting following error while processing the cube.......

Error -1056899072 : The following system error occurred: Logon failure: unknown user name or bad password. .
Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'CDEV1', Name of 'CDEV1'.
Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CHARGE', Name of 'charge Type' was being processed.
Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'SURCHARGE DESC' attribute of the 'charge Type' dimension from the 'FSUM' database was being processed.
Error -1055129598 : Server: The operation has been cancelled.

I am able to deploy the cube and while processing am getting the following....
As I am using Oracle database, I selected Microsoft OLEDB Provider for Oracle.. and gave Oracle server name and credentials with which am accessing Oracle DB.

I have selected all the four Impersonation options.....

In Impersonation Information processing got started when I gave

Use Specific User name and Password: Under that whether I have to give Oracle DB credentials or SQL Server Credentials ??
OR
Is there anything missed ??

Pls....... Its really frustating me............ Plsssss help

Thnx
Nisanth

View 6 Replies

Error Deploying Cube

Mar 4, 2008

either the user, master-pcmaster, does not have access to the analysis services project1 database, or the database does not exist.

p.s. I have the sql server developer edition.

View 1 Replies View Related

Analysis :: Deploying SSAS Cube With Different Name On Same Server

Jun 21, 2013

How can i deploy an existing cube with a new name on the same server?

View 4 Replies View Related

Analysis :: Deploying In Order To Update The Cube?

Nov 2, 2015

Scenario: [**tableA**] plus [**tableDim1**] plus [**tableDim2**]. I create a DSW, a cube I deploy the [@@CUBE@@]..so connect the data using an excel file that show the data as [¬¬dashboard¬¬].

It works.

My question is: after three days the [**tableA**] is populated with new rows. In order to allow my colleagues to see the new rows I deploy the [@@CUBE@@] again. My colleagues can see the new rows in the [¬¬dashboard¬¬].

It works, ok. But do I really need to deploy the [@@CUBE@@] every time or it should be update automatically when you, for example, refresh the data in Excel. Do I miss something?

View 3 Replies View Related

Analysis :: Processing / Deploying Adventure Works Tabular Cube

Sep 14, 2015

I am trying to create a Adventure Works Tabular cube in my developing machine and im having problems deploying the tabular cube (the DW database was firstly attached without problems)

So I'm having problems processing Adventure Works Tabular Cube, the problems are somewhere between SSAS project configuration and running privileges, i think. I'll describe exactly where i am:

- in SSMS 2012, connections, tables and roles and roles are empty, i only have the full name of the database when I try to process i get an error "the table with id of "product category 92583829......", Name of Product Category refereced by the model Cube, does not exist. An error ocurred when loading the model cube, '?c:program filesmicrosoft
sql serverMSAS11.MSSQLSERVEROLAPDataAdventureWorks Tabular model SQL 2012.0.dbModel.21.cub.xml'. (Microsoft AnalysisServices.)"

- in SQL Server configuration Manager, I have
Sql Server (MSSQLSERVER) running with account NT ServiceMSSQLSERVER
Sql Server Analysis Services (MSSQLSERVER) running with account .L.ABCDE , which is my account, i've changed because i've read somewhere that i could have problems with privileges.

(Note: it's strange because SSAS is tabular, i can see a blue rectangle (sort of) in SSMS but in configurator manager seems to be a cube.)

- in SSAS Project i unzip a clean copy of the project and the first error is that BIM file can't be found, it try's to find server TOSHIBA_S50_BTAB, but as i have only tabular SSAS running, i replace for TOSHIBA_S50... And some time ago it worked, now it doesn't even found TOSHIBA_S50_B?!!!!

View 3 Replies View Related

Error On Deploying Changes

Feb 7, 2008

Hi I've not done much work on reporting services before.

I've made a change on my page and i can see the change on the preview its just a drop down list containing the week number.

But i can see to get to deploy these changes when i build my package it builds fine but when i go to deploy it am getting this error message

The item '/Data sources' already exist

View 3 Replies View Related

Error When Deploying A Report

Jun 4, 2007

I hope someone can help. I'm new to reporting services 2005, and I'm currently going through Microsoft's tutorial.

I can build a report no problem. But when it comes to deploying the report to a web page, the following message appears:

------ Build started: Project: Reporting Services Tutorial, Configuration: Production ------
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Reporting Services Tutorial, Configuration: Production ------
Deploying to http://localhost/reportserver
Error : Response is not well-formed XML.
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

This "reponse is not well-formed XML" error also occurs when I try to expand any of the folders from a "reporting services" server type in management studio.

Any ideas would be greatly appreciated!

Cheers

Richard Powell

View 3 Replies View Related

SQL Network Interfaces, Error: 26 (after Deploying)

Jan 17, 2006

Hello All,
We are migrating from ASP.Net 1.1 to 2.0 and have built a new site with the 2.0 membership controls (Login, etc). We're using VS2005/SQL Server 2005. All works well from the development site but once it is deployed from our local machine to our intranet development server, the following error is encountered after the user types in a valid username/password and clicks the Login button (on the Login control on the Login.aspx page):
Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Our web.config (for testing purposes only):
<?xml version="1.0"?>

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
<connectionStrings>
<add name="MyLocalSQLServer" connectionString="Initial Catalog=aspnetdb;data source=localhost;Integrated Security=SSPI;"/>
</connectionStrings>
<system.web>

<compilation debug="true"/>

<authentication mode="Forms">
<forms name="SqlAuthCookie" timeout="10"/>
</authentication>
<authorization>
<deny users="?"/>
</authorization>

<membership defaultProvider="MySqlMembershipProvider" >
<providers>
<clear/>
<add name="MySqlMembershipProvider"
connectionStringName="LocalSQLServer"
applicationName="FormsAuthSql"
type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
enablePasswordReset="true"
requiresQuestionAndAnswer="true"
requiresUniqueEmail="false"
passwordFormat="Clear"
minRequiredNonalphanumericCharacters="0"
minRequiredPasswordLength="3"
/>
</providers>
</membership>

<customErrors mode="Off"/>
</system.web>
</configuration>
Any suggestions will be greatly appreciated!
Troy

View 1 Replies View Related

Database Error After Deploying To Client

Apr 8, 2008

I have developed a VS2008 .net application using Sql Server express 2005. Running this on my development machine works fine but after i deploy to a client machine i get:

Cannot open user default database. Login Failed for user 'mycomputernameadministrator'

The client machine has sqlserver express 2005 installed using all instllation defaults

My connection string is:

Data Source=.SQLEXPRESS;AttachDbFilename=c:mydatamyfile.mdf;Integrated Security=True;User Instance=False"

I want to be able to deploy my app to any client PC without any database user login (i use my own built in to app) or errors obvoiusly

Could someone give me a step by step to resolve, much appreciated

Chris Anderson

View 4 Replies View Related

Deploying To Report Manager Error

Aug 22, 2006

I have created a report using SSRS 2005. It uses a stored procedure. It executes beautifully when I'm in reporting services. But, when I deploy it to Report Manager, this is the error I am getting.

An error has occurred during report processing.
Query execution failed for data set 'DataSource1'.
An MDX Statement was expected. An MDX expression was specified.

I have 3 parameters in this report. Start Date, End Date & Region. Region is a drop down that contains 2 options. This is a string field being passed into the procedure. Start and end dates are just basic date fields.

I am not using a cube to get my data.

I have deployed to the Report Manager before and have been successful.

Thanks!

View 4 Replies View Related

Error Deploying DataSource (rsAccessDeniedToSecureData)

Jun 10, 2005

Hi!

View 6 Replies View Related

Error While Deploying SSIS Package

Mar 12, 2008

Hi,
I am trying to deploy SSIS package through manifest file on a server. It gives the following message.

'Could not save the package "C:Package Pathpackagename.dtsx" to SQL Server "(local)"'.
Additional Information:
The SaveToSQLServer method has encountered OLE DB error code 0x8004E14 (invalid Target Directory. You must choose a project folder to store your package. If this is a permanent package, contact your DBA to create a project folder.

I have tried to create the package folder on the same path it is trying to save the package. But still i get the same error.
Is this a permission issue? I have all rights on sql server.
Thanks

View 9 Replies View Related

Error Deploying Managed Stored Proc

Jul 24, 2006

When I try to deploy this managed stored proc assembly on SQL Server 2005 I get this error:
Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x8007000e. You may fix the problem and try again later
I looked on the net but found no documentation about it. I know the CLR v2.0 is working as I have some ASP.NET apps running from this server that use it. Any ideas?

View 1 Replies View Related

Error While Deploying (sql2k5 Reporting Servic)

Sep 10, 2007

Hi, i created a report and i want to deploy it so i can view it in my browser, when i use deploy i get the following error:

Error1The permissions granted to user 'SRVDBTESTIUSR_SRVDBTEST' are insufficient for performing this operation.00

im logged in as administrator, i used mixed mode, where can i find that useraccount so i can give it more rights?

thx

View 1 Replies View Related

Error Deploying SSIS Package To SQL Server

Jun 14, 2005

I am getting strange error on deploying ssis package to SQL Server.

View 10 Replies View Related

Error Deploying Report With DataSource SSIS

Apr 11, 2008

Hello Everyone,

I make a report to consume a SSIS package, actually I use SSIS to load a datasheet on my Sql Server database, then i expose the aggregate values in a datareader destination. Every work fine in Visual Studio. But when i deploy my report and my Shared Data Source, and I try to run the report i get the next message:

An error has occurred during report processing.

No se puede crear una conexión al origen de datos 'ETLSource'.

The package failed to validate.
I dont Understand why, because when i work in BIDS the work perfect, Actually i'm using sql server authentication in my package connection to avoid the mistakes about report credentials.

That is the code of the ETLSource.
<?xml version="1.0" encoding="utf-8"?>
<RptDataSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Name>ETLSource</Name>
<DataSourceID>c238d65d-a0f3-48da-ae23-323d6ba13bb0</DataSourceID>
<ConnectionProperties>
<Extension>SSIS</Extension>
<ConnectString>-f "C:TempValidaCambioEfec.dtsx"</ConnectString>
</ConnectionProperties>
</RptDataSource>

Also I have SSIS and SSRS in the same machine. And I'm using the same domain Account to run SSIS, SSRS and Reports site.

Thank you for help me

Julian Castiblanco P
Bogotá, Colombia

View 5 Replies View Related

Error When Deploying Forms Authentication Sample

Feb 20, 2007

Hello

I'm trying to get the forms authentication sample working - I have followed the instructions given in the ReadMe that came with the samples. When I try to browse to localhost/reportserver (on the server), instead of seeing the logon page as expected, I get the following error message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I built the sample in VS 2005, and am using v2 of .net. Reporting services is installed on a windows server 2003 machine.

This has been driving me crazy for a while now. Any help would be greatly appreciated!

Thanks in advance

Dominic

View 4 Replies View Related

Error Deploying A CLR Stored Procedure That Uses A Web Service

Aug 14, 2007

Ok, first some background.

I am writing my first (complex) CLR Stored Procedure using Visual Studio 2005.

This SP worked fine until I added code to make a web service call. That web service is a wrapper web service I created because the actual web service I need to call uses System. Web.Extensions which was not available in my VS2005 Database Project.

At first I was getting the standard "External Access Assembly" errors, so I created a new user (was using SA) and assigned database ownership to the new user, then assigned permissions to that user. This worked to get it deployed, but I get the following error when its run:

<code>

System.InvalidOperationException: Cannot load dynamically generated serialization assembly. In some hosting environments assembly load functionality is restricted, consider using pre-generated serializer. Please see inner exception for more information. ---> System.IO.FileLoadException: LoadFrom(), LoadFile(), Load(byte[]) and LoadModule() have been disabled by the host.

System.IO.FileLoadException:

at System.Reflection.Assembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection)

at System.Reflection.Assembly.Load(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence securityEvidence)

at Microsoft.CSharp.CSharpCodeGenerator.FromFileBatch(CompilerParameters options, String[] fileNames)

at Microsoft.CSharp.CSharpCodeGenerator.FromSourceBatch(CompilerParameters options, String[] sources)

at Microsoft.CSharp.CSharpCodeGenerator.System.CodeDom.Compiler.ICodeCompiler.CompileAssemblyFromSourceBatch(CompilerParameters options, String[] sources)

at System.CodeDom.Compiler.CodeDomProvider.CompileAssemblyFromSource(CompilerParameters options, S
</code>

Anyone have any ideas?

Thanks!

Dave Borneman
Solution Architect,
anyWare Mobile Solutions.

View 1 Replies View Related

Error Deploying Reports That Previously Deployed

Oct 20, 2007

Hi All,
we are changing some reports from English to German...some of the reports that we have changed generate the message 'An internal error occurred on the report server. See the error log for more details.'

We go to

C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles

On the machine but we cannot find any more detailed error messages...

Does anyone have any idea as to whether the messages migh be written somewhere else?

Thanks and Best Regards

View 1 Replies View Related

Error Deploying Large Report Model

Oct 4, 2007

Hi ,

I am trying to deploy the report model which is more than 4 mb size. I am getting following error:

Error 2 There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded.

i changed the web.config on the server side:
as following:

<httpRuntime executionTimeout="600" maxRequestLength="102400" requestLengthDiskThreshold="80" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="5000" enableKernelOutputCache="true" enableVersionHeader="true" requireRootedSaveAsPath="true" enable="true" shutdownTimeout="90" delayNotificationTimeout="5" waitChangeNotification="0" maxWaitChangeNotification="0" enableHeaderChecking="true" sendCacheControlHeader="true" apartmentThreading="false" />

But still gets same error: what else i ahve to change.

Please help!!

Thanks

View 6 Replies View Related

Error When Deploying Report Builder Model

Nov 21, 2006

I get the following error when I try to deploy a report builder model. The SQL Server 2005 "Reporting Services" are installed and running on the local machine.

TITLE: Microsoft Semantic Model Designer
------------------------------

A connection could not be made to the report server http://localhost/ReportServer.

------------------------------
ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesReportServerRSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.SemanticQueryDesign)

------------------------------
BUTTONS:

OK
------------------------------

View 3 Replies View Related

Proxy Authentication Error While Deploying The Report On The Same Server

Jan 11, 2007

Hello Experts,

I have a Report Server when i try to deploy my report on the same server and if i use the Fully Qualified Domain Name in my report path i get the below Error

TargetServerURL : http://jptoclq901.corpusers.net/ReportServer

Error : The request failed with HTTP Status 407 : Proxy Authentication Required (Microsoft.ReportingServices.Designer)

but if i use the TargetServerURL as http://localhost/ReportServer, things do work fine. but company requirement is to use complete path.

Is this a limitation or some way out, any Idea???

Thanks in advance for the help

/Soni

View 1 Replies View Related

SSIS Deploying Error '/Data Sources' Already Exist

Feb 7, 2008

View 20 Replies View Related

Error While Loading Code Module When Deploying A Report

Jan 15, 2008

I have a custom assembly that I wrote. I placed it in the GAC and the report runs fine locally. I placed it on the server in the GAC and it kicks out the following error when deploying:

Error while loading code module: ��SSRSReporting, Version=1.0.1.0, Culture=neutral, PublicKeyToken=de4c010eaf2f2fe8��. Details: Could not load file or assembly 'SSRSReporting, Version=1.0.1.0, Culture=neutral, PublicKeyToken=de4c010eaf2f2fe8' or one of its dependencies. The system cannot find the file specified. ....

If I put the file in the /bin directory on the server there is no issues and it works fine. I need to to deploy to the GAC though. I restarted IIS and the RS services. I still have the same issue.

View 1 Replies View Related

Deploying Report Via Visual Studio To Sharepoint - Error

Sep 7, 2007

Hi guys

I seem to be having a bit of trouble deploying my reports from my Reporting Services Project in Visual Studio to my Sharpoint server.

Both the reporting server and sharepoint are installed on the same server.

The settings within my reporting server are as follows (where report is the site name):

TrargetDataSourceFolder - https://server/Report/Shared Documents/DataSources

TrargetReportFolder - https://server/Report/Shared Documents

TrargetServerURL - https://server/Report

I have not yet changed over all my reports to use fully qualified urls yet. As we have multiple domains in which the reports need to go through before they hit the production server and i haven't yet decided how i am going to handle the issues of the reports requiring fully qualified addresses (if someone has a way i would love to know).

I was getting the following error when i tried to deploy the projects but i delete all extensions from the blocked file types and that error went away. I can only guess that there was a file type it didn't like.

Error - "The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators."

When i deleted all the file extensions i now get the following error.

Error - "File Not Found."

Just wondering if anyone has had any success with visual studio and sharepoint deployment or run into this problem.

Thanks

Anthony

View 8 Replies View Related

Error That Has Nothing To Do With My Cube

Nov 5, 2005

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

View 31 Replies View Related

Power Pivot :: Aggregating Time Periods In Cube-member / Cube-value Formulas?

Aug 23, 2015

I am just starting out using CUBEMEMBER/CUBEVALUE formulas in excel linked into a sql olap db - using this method for some custom reports where pivot tables are not suitable.
The time dimension values include Months, Quarters and Years and the CUBEMEMBER formulas like

=CUBEMEMBER("OLAPCUBE","[Time].[Time].[Year].&[2015].&[1].&[1]") work fine - 1st quarter 1st month etc.

Is there a straightforward notation to aggregate months or do I need to use a plus sign to add a number of CUBEMEMBER formulas together.In other words - Is there an easier way of for say jan to july 2015 totals than

=CUBEMEMBER("OLAPCUBE","[Time].[Time].[Year].&[2015].&[1]") + (CUBEMEMBER("OLAPCUBE","[Time].[Time].[Year].&[2015].&[2]")) + (CUBEMEMBER("OLAPCUBE","[Time].[Time].[Year].&[2015].&[3].&[7]"))

I haven't tested this but have assumed it works but a bit long and clumsy.

View 5 Replies View Related

Processing Cube Error 211

Aug 14, 2000

When I process a new cube I recieve an error "Error (211): Unknown dimension member ' 8'; Time: 8/11/00 1:09:45 PM". Any ideas about what this error is about ?

View 2 Replies View Related

Error Browsing A Cube

Dec 29, 2005

Please help i have an error when i try to browse a cube.
= "Unable to browse the cube."
"Unable to locate the cube." or "Unspecified error."
thanx,
Lister104

View 1 Replies View Related

Cube Processing Error

Apr 14, 2004

Hi,
I am trying to Process a analysis server Cube and I am getting an error message saying

syntax error converting the varchar value A.H to column of type int.; 22018.

Can somebody tell me how to remove this error.

Thanks,
Praveen

View 2 Replies View Related

Error Processing A Cube

May 16, 2008

I just started getting a new error message to me:

Errors in the high-level relational engine. The data source view does not contain a definition for the 'WeightRecieved' column in the 'dbo_factPurchases' table or view.

The problem is WeightReceived IS defined in my DSV so I don't know what to do about this error.

Any suggestions?

View 4 Replies View Related

Analysis :: Creating Cube With AMO - Cube Has No Measure Groups?

May 19, 2015

I have problems creating a cube with AMO.

I can add the cube to the database object and fill it with dimensions and a measuregroup (see code below).

If I call cube.Update() it says something like "Error in meta data manager. Cube has no measuregroups." (getting the message in german language)

The error in Microsoft.AnalysisServices.OperationException.Results.Messages is -1055653629

I can't find any documentation about this (or any other) error code in Microsoft documentation.

Here's my Code:

Cube newCube = database.Cubes.Add("MyCube","MyCube");
newCube.Language = 1031;
newCube.Collation = "Latin1_General_CI_AS";
CubeDimension dim = newCube.Dimensions.Add("dim1","dim1","dim1");
CubeAttribute attrib = dim.Attributes.Find("dim1Attr1");

[code]....

View 2 Replies View Related

Cube Back Up Ends In Error

Aug 27, 2007

Hi all,

I have back up job that runs to back up Cube daily but lately it is failing and gives error bellow:

The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForError(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices.Xmla.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility) at Microsoft.AnalysisServices.Xmla.XmlaClient.SendMessageAndReturnResult(String& result, Boolean skipResult) at Microsoft.AnalysisServices.Xmla.XmlaClient.Execute(String command, String properties, String& result, Boolean skipResult, Boolean propertiesXmlIsComplete) at Microsoft.SqlServer.Management.Smo.Olap.SoapClient.ExecuteStatement(String stmt, StatementType stmtType, Boolean withResults, String properties, String parameters, Boolean restrictionListElement, String discoverType, String catalog) at Mi. The step failed.

But if i run that job manually it runs fine(successfully)

What could be the problem!!

thanks

View 1 Replies View Related