2 OWC connected via HTTP: session reset!!!!

[Andrea K]

Help please, I have a aspx page with n Pivot Tables connected via http
to Analysis Service (sp3a)... the problem is that this page resets the
authentication in the web application (session and httpcontext).
I have patched AS with the hotfix 818963 but the problem it's the
same.

Help please, Andrea (from Italy)

 

[Alvin Bruney [MVP]]

post ur code

 

[Andrea K]

The Pivot Tables are created in client-side with vbs. I have stored in
sqlserver the xml for the Pivot Tables and in runtime I read this
value with aspx, put the value in a textbox that run at server and I
assign in the XMLData of the Pivot Tables the text in the textbox with
vbs. Stop.

Thanks, Andrea(from Italy).

post ur code

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Help please, I have a aspx page with n Pivot Tables connected via http
to Analysis Service (sp3a)... the problem is that this page resets the
authentication in the web application (session and httpcontext).
I have patched AS with the hotfix 818963 but the problem it's the
same.

Help please, Andrea (from Italy)

 

[Chris Magoun]

Are you using .NET Forms Authentication?

If so, the OWC seems to cause trouble if the authentication cookie does not
have an expiration date set.
Try making sure the FormsAuthenticationTicket you write has an expiration
date.

Chris Magoun

 

[Mark G]

This problem was introduced with SP3. Microsoft Support indicated that it
was an intended feature that closed a potential security hole with http
access to the cubes. The session gets reset with each pivot table in the
page. There is no fix and no workaround.