We're using the Office Web Components (vers. 11) pivot table inside Internet
Explorer as a client for our OLAP power users.
They are pretty much free to drill all dimensions, and sometimes they come
up with a combination that results in a long query.
When that happens, they get shown the hourglass for ever.

It looks to me like a timeout is happening somewhere along the chain between
Internet Explorer, OWC, Pivot Table Services, IIS, OLE DB 9.0, and SSAS 2005.

How can I find out what is happening ?

Is there way to force a timeout in IIS so that Internet Explorer will show
the hourglass for a maximum of 3 minutes (instead of for ever) and then come
back to the users ?

Thanks for any help, this is a big issue for us.

do you use the profiler to see the query executed?
you have to identify if the timeout come from the query himself or from the
connection between the client and the server.

what is your connection string?


"Pat" <pat (AT) online (DOT) nospam> wrote

Hello Pat,

Thank you for using Microsoft MSDN newsgroup.

I understand that you'd like to show pivottable to timeout when the query
take too much time. If I'm off-base, please let me know.

You may want to configure the timeout property of Pivottable to see if it
resolves the issue. You could use some script in the page hosting
pivottable.

<script language=VBScript>
Dim oPivot
Set oPivot = PivotTable1.Object
'Set the timeout to 60 seconds
oPivot.Connection.CommandTimeout = 60
</script>

Also, there is ServerTimeout property of AS 2005 that you could change for
the query timeout in AS server. However, it is not recommended to change
the value to too small because there shall be long queries.

As I know, there is <SessionTimeout> configuration in msmdump.ini if you
use HTTP Access to AS 2005:

http://www.microsoft.com/technet/pro.../httpssas.mspx

Since pivottable is a Activex control running on client side, I would think
IIS related configurations shall not affect its timeout behavior.

Please check if this helps. If you have further questions, please feel free
to post back.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.

Although this sounded like a good idea, OWC seems to ignore the timeout value.
I have set the timeout to 10 seconds, and I've tested a couple of dimension
combinations that did respond after about a minute.

Underneath is how I implemented your suggestion, do I have the right syntax?
What wonders me is that if I replace your code by:
Dim oPivot
Set oPivot = PivotTable1.ANYTHING
oPivot.ANYTHING.ANYTHING = 10
the whole thing still works without any error message.

<object classid="clsid:0002E55a-0000-0000-C000-000000000046" id="PivotTable1">
<param name="XMLData" value="<xml
xmlns:x="urn:schemas-microsoft-comffice:excel">
<x:PivotTable>
<x:OWCVersion>11.0.0.5531 </x:OWCVersion>
<xisplayScreenTips/>
<x:CubeProvider>msolap</x:CubeProvider>
<x:CacheDetails/>
<x:PivotView>
<x:IsNotFiltered/>
</x:PivotView>
</x:PivotTable>
</xml>">
<table width='100%' cellpadding='0' cellspacing='0' border='0'
height='8'><tr><td bgColor='#336699' height='25' width='10%'> </td><td
bgColor='#666666'width='85%'><font face='Tahoma' color='white' size='4'><b>
Missing: Microsoft Office Web Components</b></font></td></tr><tr><td
bgColor='#cccccc' width='15'> </td><td bgColor='#cccccc' width='500px'><br>
<font face='Tahoma' size='2'>This page requires the Microsoft Office Web
Components.<p align='center'> <a
href='http://www.microsoft.com/downloads/details.aspx?FamilyID=7287252c-402e-4f72-97a5-e0fd290d4b76&DisplayLang=en'>Click
here to install Microsoft Office Web Components.</a>.</p></font><p><font
face='Tahoma' size='2'>This page also requires Microsoft Internet Explorer
5.01 or higher.</p><p align='center'><a
href='http://www.microsoft.com/windows/ie/default.htm'> Click here to install
the latest Internet Explorer</a>.</font><br>&nbsp;</td></tr></table>
</object>
<br>
<br>
<input type="button" id="button1" value="click here">
<script language="vbscript">
sub button1_onclick()
PivotTable1.ConnectionString = "Provider=MSOLAP.3;" + _
"Data Source=SSAS2005instance;Initial Catalog=xxx"
PivotTable1.DataMember = "xxxxx"

Dim oPivot
Set oPivot = PivotTable1.Object
'Set the timeout to 10 seconds
oPivot.Connection.CommandTimeout = 10

end sub
</script>


""privatenews"" wrote:

Hello Pat,

Thank you for your update. I took sometime to build an enviroment to test
the issue on my side and I also found commandtimeout property does not take
effect.

Then I used the following connection string for pivottable and it does
still does not take effect:

Provider=MSOLAP.2;Data Source=myServerName;log file=c:\mymdx.txt;Initial
Catalog=FoodMart 2000; timeout=5;

I suspect there might be issues between OWC pivottable/AS 2005. To further
troubleshoot the issue, I need more information of your environment, will
you please get the following information?

a. Click Start, click Run, type msinfo32 and press Enter.

b. After the process of collection system information finish, select Save
from File menu and save this nfo file

c. Please email this nfo file to me at petery (AT) microsoft (DOT) com

I'm looking forward to your update. Thanks.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Peter,

Nice to see that you could reproduce the problem.
This way, you have all the info you need to troubleshoot the issue on your
own computer.
Once you get it working on your computer, please post the fix or workaround
so that we can get this issue solved.

Best regards.

""privatenews"" wrote:

Hello Pat,

Though we have reported this issue, there might not fix/workaround we could
provide very soon. In order to better work with you so that we may update
you on the status of the issue or if there is any fix, will you provide us
a valid email address. If you have concerns on this, you could send an
email to me at petery (AT) microsoft (DOT) com directly. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====