April 11, 2016 at 8:42 am
Hi,
I have a new SQL 2014 SSAS install that I'm working with.
I've noticed the application log, logging Event ID 3, Category 289 repeatedly.
Google hasn't been much help as other posts on the internet are referencing issues with processing cubes, which I am NOT having a problem with.
The issue doesn't seem to be causing any end user negativity that I can tell. (This dev box was just stood up and is only being used by a couple of people currently).
The interesting thing is that it doesn't always happen, but when it does, it repeats for many hours based on the ExternalCommandTimeout setting. I have fiddled with this setting a bit. For example over the weekend the event pop-ed up at 1:04 PM, on Saturday, and then repeated (on the dot) every two hours (my timeout), until 11:04 PM, then nothing all day Sunday. There's nothing scheduled at 1:04 PM.
I do not see any other related events around this issue in the app log / sys log / default trace / or flight recorder.
Anyone seen anything like this?
April 11, 2016 at 11:45 am
Pulled this from a trace:
RowNumber3696
EventClass39
EventSubclass5
TextDataOLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00. Trace: The SQL Server notification read operation failed. SQL Trace status code: 0.
ConnectionIDNULL
NTUserNameNULL
ApplicationNameNULL
IntegerDataNULL
StartTime4/11/16 11:17
CurrentTime4/11/16 11:17
Duration0
DatabaseNameMy_DB
ObjectNameMy_SSAS_DataSourceName
ErrorNULL
ClientProcessIDNULL
SPIDNULL
CPUTimeNULL
NTDomainNameNULL
RequestParametersNULL
RequestPropertiesNULL
BinaryDataNULL
Corresponding line from the flight recorder:
(4/11/2016 11:17:55 AM) Message: OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00. (Source: ...\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003)
I also attempted to setup my msmdsrv.ini file to perform a minidump, but it didn't happen.
April 11, 2016 at 4:36 pm
Well, I figured out a bunch of this.
If anyone's interested: http://jonmorisissqlblog.blogspot.com/2016/04/ole-db-error-ole-db-or-odbc-error-query.html
April 12, 2016 at 11:17 am
....aaaand a MS Connect to vote up: https://connect.microsoft.com/SQLServer/feedback/details/2581127
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply