Re: Update cube statement

From: Joe (johanotto_at_justenough.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 14:04:30 +0200

The connectionstring was infact incorrect. I used a role to connect to the
cube and the connectionstring actually looks like:

Data Source=http://>/xmla/msxisapi.dll;Initial Catalog=<AS
DB>;Provider=MSOLAP.2;Roles=joe;ConnectTo=9.0

If I don't use a role it works fine. But for the client in question this is
not a possibility because they have a novell network. The analysis database
and IIS server is the same server in a DMZ.

In the system log there is an error that gets logged when you try to update
a cube via AdoMd.NET from a remote machine.
User NT AUTHORITY\SYSTEM, logged in from computer localhost, does not have
adequate permissions to open cube <CubeName> in database <CubeName>, but
tried to open it.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

I checked that the NT AUTHORITY\SYSTEM user is an OLAP Administrator on the
Analysis Server (by default).

That was the inner exception, just incase... here is the entire extended
error information transformed through a xslt to generate html.

Error Information

      Message Error during attempt to commit changes to cube
'DemandPlanning'.
      Error Type ertError
      Exception Class Name
Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException
      Source Module urn:schemas-microsoft-com:xml-analysis
      Source Module Version 1.0.1.0

Stack Trace
      Method Location
      at InventoryOp.UI.BI.Utils.BIMdxUpdater.CommitTransaction()
      at InventoryOp.UI.BI.Utils.BIMdxUpdater.Update()
      at InventoryOp.UI.BI.BIPortalForm.OnModuleUpdates(Object sender,
BIUpdaterEventArgs e)
      at InventoryOp.UI.BI.Modules.BIModuleDXGrid.ApplyUpdates(Boolean
aRefreshView)
      at InventoryOp.UI.BI.Modules.BIModuleDXGrid.btnApply_Click(Object
sender, EventArgs e)
      at System.Windows.Forms.Control.OnClick(EventArgs e)
      at System.Windows.Forms.Button.OnClick(EventArgs e)
      at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
      at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)
      at System.Windows.Forms.Control.WndProc(Message& m)
      at System.Windows.Forms.ButtonBase.WndProc(Message& m)
      at System.Windows.Forms.Button.WndProc(Message& m)
      at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
      at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
      at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)

Context and Enviroment
      Machine Name JOE
      Operating System Win32NT ver 5.1.0.2600
      Application Name XXX
      Application Version 6.7.100.0
      .NET Framework Version 1.1.2032.4322
      User Name XXX
      Domain XXX
      Application Memory Usage (KB) 59632

Error Information

      Message Error during attempt to commit changes to cube
'DemandPlanning'.
      Error Type ertError
      Exception Class Name Microsoft.AnalysisServices.AdomdClient.AdomdError
      Source Module urn:schemas-microsoft-com:xml-analysis
      Source Module Version 1.0.1.0

Stack Trace
      Method Location
      Error Code: -2147168234. Message: Error during attempt to commit
changes to cube 'DemandPlanning'.. Source:
urn:schemas-microsoft-com:xml-analysis. Info:

Error Information

      Message Connection to the server is lost
      Error Type ertError
      Exception Class Name Microsoft.AnalysisServices.AdomdClient.AdomdError
      Source Module urn:schemas-microsoft-com:xml-analysis
      Source Module Version 1.0.1.0

Stack Trace
      Method Location
      Error Code: -2147168234. Message: Connection to the server is lost.
Source: urn:schemas-microsoft-com:xml-analysis. Info:

"Akshai Mirchandani [MS]" <akshaim@online.microsoft.com> wrote in message
news:ODI2irbzEHA.924@TK2MSFTNGP10.phx.gbl...
> Can you check the event logs on the Analysis Server machine and the IIS
> machine (if they are different)?
>
> Also, check the inner exception and details of the AdomdException -- they
> may have more information.
>
> Thanks,
> Akshai
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> Please do not send email directly to this alias. This alias is for
> newsgroup
> purposes only.
>
> "Joe" <johanotto@justenough.com> wrote in message
> news:%234fQzAVzEHA.2036@TK2MSFTNGP12.phx.gbl...
>> I'm connecting to xml/a via adomd .net
>>
>> I'm updating a cube using the following statement:
>>
>> UPDATE CUBE [Planning]
>> SET
>> ([Time].[All Time].[2005].[1st Half 2005].[Oct 2004]
>> ,[Product].[Group2].&[313].&[1447].&[439].&[321],[Site].[All Sites]
>> ,[Measures].[Input Sales @Aux Price]) = (3600 * 8.09014738166306)
>> USE_WEIGHTED_ALLOCATION BY
>> (([Measures].[Input Sales @Aux Price]) / ([Measures].[Input Sales @Aux
>> Price], [Product].[Group2].&[313].&[1447].&[439].&[321],[Site].[All
> Sites]))
>>
>> My connection string uses a remote xml/a provider:
>>
>> Data Source=http:// Server>/xmla/msxisapi.dll;Initial
>> Catalog=<Cube
>> Catalog>;Provider=MSOLAP.2;ConnectTo=9.0
>>
>> When executing under these conditions, select queries works fine.
>> However,
>> updates give me the following error condition.
>>
>> Connection to the server is lost
>> Source: urn:schemas-microsoft-com:xml-analysis
>>
>> What am I doing wrong?
>>
>>
>
>