What does the command ExternalCommandTimeout do?

Question

I have a cube that crashes about 45 minutes in the processing and I got the tips to set the ExternalCommandTimeout default 3600 seconds to a much higher value, and it worked, the cube does now process completly.

But what does it really do, what kind om preventing timeout is it? Is is that the executing of the actual query does not run more than 3600 seconds (1 hour), or is it a connection timeout, or what is it?

Answer 1

Hi,

For the definition of ExternalCommandTimeout:

An integer property that defines the timeout, in seconds, for commands issued to external servers, including relational data sources and external Analysis Services servers

It is not a connection timeout. For connection timeout , there is a property of SSAS that is ExternalConnectionTimeout

For more detail info see : SSAS General properties

Regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 2

So this means that my query takes to long to execute in the processing?

Is this the proper way to solve this, increasing the timeout? Or should I try to rewrite anything in the code, edit the partitions, adding indexes in used tables, or what do I do?