question

ShivaniKeluskar-5691 avatar image
0 Votes"
ShivaniKeluskar-5691 asked CarrinWu-MSFT commented

OLE DB or ODBC error:Query Timeout is the error returned by SSMS whenever the ssas cubes are refreshed through ssms sql server agent. The version of SSMS is v17 and SSAS (visual studio) is v17.

OLE DB or ODBC error: Query Timeout is the error returned by SSMS whenever the ssas cubes are refreshed through ssms sql server agent. The version of SSMS is v17 and SSAS (visual studio) is v17.

We have used the processing type as process full as well as process default but still same issues arises. There are no other parallel activities been performed on the server and server ram is 64GB. Also the system type is 64-Bit operation system.

134808-query-timeout.jpg


sql-server-generalsql-server-transact-sqlsql-server-analysis-services
query-timeout.jpg (192.9 KiB)
· 1
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.

Hi @ShivaniKeluskar-5691, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Query Timeout is the error returned by SSMS whenever the ssas cubes are refreshed

When you process a cube, the server is under stress and a query timeout (default 30 seconds) can occur.
Wait and try it again.
And it's better to run a cube processing outside working hours.

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.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @ShivaniKeluskar-5691,

Welcome to Microsoft Q&A!

Agree with @OlafHelper-2800. Though it is possible to query a cube while it is processing, but you may see some issues right around the processing commit if there are lots of long running and concurrent queries being run. There is an SSAS property called ForceCommitTimeout that specifies what happens to a query that is executing against the cube when the “pending commit” lock is placed, meaning these queries are blocking it from completing. ForceCommitTimeout is a signed 32-bit integer property that defines the timeout, in milliseconds, before a pending commit should cancel other commands that preceded the current command, including queries in process. The default value is 30 seconds (30000 milliseconds). For more information, please refer to Can you query a SSAS cube while it is processing?.


Best regards,
Carrin


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.

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.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

See:
https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/blog-analysis-services-stop-accept-new-connection?view=asallproducts-allversions


As the server enters phase 2 of the commit, it tries to obtain a server-level lock to update Master.vmp. If another transaction is in process at that point, the server waits for an interval that's equal to the ForceCommitTimeout setting. The default is 30 seconds. Then, it rolls back any uncommitted transactions and aborts executing queries. The server-wide lock remains in effect until the transaction is finished. It blocks any read lock request that's initiated. When a new sign-in or existing user tries to connect to the server, they start a read lock request and wait.

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.