question

BrianY-6810 avatar image
0 Votes"
BrianY-6810 asked LukasYu-msft answered

SSAS - Where can I change the Table Properties Timeout period ?

Hello. What property controls the timeout when clicking Table Properties in SSAS Tabular? I've upped every one I could find including ConnectTimeout in the Data Source Properties and QuryTimeout. The table I'm trying to access the properties of is a view in the database and times out after 30 seconds no matter what property I change. Support info is below. Thank you.

Microsoft SQL Server Data Tools for Visual Studio 2017 (SSDT)
Version 15.9.16
VisualStudio.15.Release/15.9.16+28307.858
Microsoft .NET Framework
Version 4.8.03752

Installed Version: IDE Standard

Microsoft Visual Studio Tools for Applications 2017 00371-40000-00001-AA639
Microsoft Visual Studio Tools for Applications 2017

C# Tools 2.10.0-beta2-63501-03+b9fb1610c87cccc8ceb74a770dba261a58e39c4a
C# components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Common Azure Tools 1.10
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

NuGet Package Manager 4.6.0
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

Project 1.0
Information about my package

ProjectServicesPackage Extension 1.0
ProjectServicesPackage Visual Studio Extension Detailed Info

ResourcePackage Extension 1.0
ResourcePackage Visual Studio Extension Detailed Info

ResourcePackage Extension 1.0
ResourcePackage Visual Studio Extension Detailed Info

SQL Server Analysis Services 15.0.1395.0
Microsoft SQL Server Analysis Services Designer
Version 15.0.1395.0

SQL Server Data Tools 15.1.61906.03120
Microsoft SQL Server Data Tools

SQL Server Integration Services 15.0.1301.433
Microsoft SQL Server Integration Services Designer
Version 15.0.1301.433

SQL Server Reporting Services 15.0.1395.0
Microsoft SQL Server Reporting Services Designers
Version 15.0.1395.0

SsmsVsIntegration 1.0
Information about my package

Visual Basic Tools 2.10.0-beta2-63501-03+b9fb1610c87cccc8ceb74a770dba261a58e39c4a
Visual Basic components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Visual Studio Code Debug Adapter Host Package 1.0
Interop layer for hosting Visual Studio Code debug adapters in Visual Studio

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

Hi,

As 30 seconds looks very like the connection time out of SQL Server. I take a wild guess here.

So, you could check if you SQL Server datasouce is on, i.e., if the service is started? Could you make other query or connection to the server , see if it is working ?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BrianY-6810 avatar image
0 Votes"
BrianY-6810 answered BrianY-6810 commented

The database is definitely online. I can get the Table Properties from any other table except for one problematic one.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

It there any specialty about this table, currently I had no more clue for further investigating... Info about the view or query log/trace could be helpful

0 Votes 0 ·

Yes. When I run the query in SSMS, it takes about 45 seconds before it starts returning results. So the default 30 sec. timeout period in SSAS is inadequate.

0 Votes 0 ·
LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

Try to change the query timeout property in Datasource designer as :
81435-image.png



image.png (28.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.