SSAS - Query time when processing - works with 2017 - timesout with 2019

• NicHopper

  SSCrazy Eights

  Points: 9090

  More actions

  May 15, 2020 at 2:42 pm

  #3752024

  Hi,

  I'm wondering if someone can help us out here as we are at a loss.

  We have at present a process which works like this;

  1. Server A (SQL 2016) kicks off an SSIS package which is locally stored as a .dstx file

  2. That package connects to Server B (SQL 2017) which has SSAS, SSIS and DB Engine on it, the package from Server A triggers a rebuild of the current partitions in a cube stored on Server B

  3. The cube on Server B has a database of a DB on server A, so it pulls all the data in and processes it.

  This all works fine.

  However when we upgrade server B from SQL 2017 to SQL 2019 the cube processing fails after about 10 minutes, the error being

  OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00.

  We can see the query running on server A as it collects the data, no blocking or anything, if we then rollback to SQL2017 on server A it all starts working.

  We've checked the defaults on the SSAS and they all look good and if we kick off the processing of the cube manually on server B it works fine.

  Has anyone come across this issue before?

  Any help would be appreciated.

  Thanks,

  Nic

  Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 16, 2020 at 3:10 pm

  #3752202

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• remigious

  Newbie

  Points: 1

  More actions

  October 21, 2021 at 9:20 pm

  #3943003

  Hi, We are facing the same issue. Were you able to find any resolution?