question

pits avatar image
pits asked

error message

Hello, Observed error message, An error occurred while data was being written to the query log. Although the table was created, query logging has stopped. Check the query log database or permissions for issues: OlapQueryLog All backups are running well, can yoy uplease advise what is meaning of this error,why this error occured and what is resolution for the same. Rgds,
ssaserrormessage
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Kev Riley avatar image
Kev Riley answered
The OlapQueryLog is a table used by the Usage-based Optimizer in Analysis Services (SSAS). Are you using the Usage-based Optimizer feature - if not, you could turn this off? Check with whoever has setup/configured the SSAS instance. Maybe look at this : [Configuring the Analysis Services Query Log (MSDN)][1] [1]: http://technet.microsoft.com/en-gb/library/cc917676.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.