OlapEvent = ObjIdUpdate(2)

• Igor Micev

  SSC-Dedicated

  Points: 33110

  More actions

  April 7, 2014 at 12:43 pm

  #285317

  Hi All

  When I execute sp_WhoIsActive to see who is active, I constantly see this running select

  SELECT @OlapEvent = ObjIdUpdate(2) with wait type (191ms)TRACEWRITE. Its status is suspended and it comes from Microsoft SQL Server Analysis Services.

  The cube processes without errors and is online.

  Parameter ExternalCommandTimeout for SSAS is set to 3600s and in the Windows application log I regularly see Errors "OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00" exactly on the time: e.g. 11:00, 12:00, then 14:00 and etc.

  Any advice or suggestion how to detect/resolve this error?

  Regards,

  Igor

  Igor Micev,My blog: www.igormicev.com

• Igor Micev

  SSC-Dedicated

  Points: 33110

  More actions

  April 8, 2014 at 2:15 am

  #1704059

  I've resolved the issue, simply, and want to share. I run

  exec sys.sp_configure 'default trace enabled',0

  reconfigure

  and the timeout-type error is not being reported in the app log anymore.

  Regards,

  Igor

  Igor Micev,My blog: www.igormicev.com