Re: Update cube statement
From: Joe (morbidcamel_at_msn.com)
Date: 11/24/04
- Previous message: Joe: "Re: Update cube statement"
- In reply to: Akshai Mirchandani [MS]: "Re: Update cube statement"
- Next in thread: Joe: "Re: Update cube statement"
- Reply: Joe: "Re: Update cube statement"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Nov 2004 17:20:50 +0200
OK, the "method not allowed" was my fault, for some reason it wasn't allowed
to run executables.
I set digest information off, and set the anonomous account to my domain
account (OLAP Administrator etc). I also tried it with the local machine
Administrator account (IIS and OLAP on same machine)
When I do a update with the following connection
Data Source=http://JOE/xmla/msxisapi.dll;Initial
Catalog=<Catalog>;Provider=MSOLAP.2;Roles=joe
OR
Data Source=http://JOE/xmla/msxisapi.dll;Initial
Catalog=<Catalog>;Provider=MSOLAP.2;Roles=joe;ConnectTo=9.0
I get.. (and yes it is the inner most exception)
Error Code: -2147168234. Message: Connection to the server is lost. Source:
urn:schemas-microsoft-com:xml-analysis. Info:
The event log shows the following error: where <Domain>\<User> is my domain
account
User <Domain>\<User>, logged in from computer localhost, does not have
adequate permissions to open cube DemandPlanning in database JEDemoPlanning,
but tried to open it.
I truly believe there is a bug in xml/a somewhere. Cause this used to worked
with the old msolap.asp way of doing things...
"Akshai Mirchandani [MS]" <akshaim@online.microsoft.com> wrote in message
news:ePTUMqZ0EHA.1524@TK2MSFTNGP09.phx.gbl...
> If Anonymous access is turned on, then that is probably what it is using.
> Can you disable Digest authentication, and change the user for Anonymous
> access to be a valid domain user instead of IUSR_xxx? Then check the event
> log again to see what happens...
>
> 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:OKr%23SfH0EHA.3708@TK2MSFTNGP14.phx.gbl...
>> I thought using ConnectTo is a good practice and took it from the AdoMd
>> sample. Why should it matter?
>>
>> The Virtual directory is configured to allow anonymous access and it's
>> running under the IUSR_XXX account, which I also added to the OLAP
>> Administrators group to test with no avail.
>>
>> Under "Authenticated access" the Digest authentication for Windows domain
>> servers is checked. Realm is our internal domain name. nothing else is
>> checked or filled in.
>>
>>
>>
>>
>>
>> "Akshai Mirchandani [MS]" <akshaim@online.microsoft.com> wrote in message
>> news:%23JYpegnzEHA.2540@TK2MSFTNGP10.phx.gbl...
>> > Why are you saying ConnectTo=9.0? It shouldn't really matter as far as
>> > I
>> > know because when connecting using HTTP to an AS2k server you shouldn't
>> > need
>> > to specify ConnectTo.
>> >
>> > Can you post the details of the following -- how has your XMLA SDK
> virtual
>> > directory been configured? Do you have Anonymous access/Integrated?
>> > Anonymous running as which user? Etc.
>> >
>> > 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:OIlkLAjzEHA.3976@TK2MSFTNGP09.phx.gbl...
>> >> The connectionstring was infact incorrect. I used a role to connect to
>> >> the
>> >> cube and the connectionstring actually looks like:
>> >>
>> >> Data Source=http://
>> >> 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://
>> >> >> 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?
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>
- Previous message: Joe: "Re: Update cube statement"
- In reply to: Akshai Mirchandani [MS]: "Re: Update cube statement"
- Next in thread: Joe: "Re: Update cube statement"
- Reply: Joe: "Re: Update cube statement"
- Messages sorted by: [ date ] [ thread ]
