x

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,

more ▼

asked Aug 26, 2011 at 01:58 AM in Default

pits gravatar image

pits
830 82 91 92

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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
more ▼

answered Aug 26, 2011 at 02:11 AM

Kev Riley gravatar image

Kev Riley ♦♦
53.2k 47 49 76

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x172
x57
x7

asked: Aug 26, 2011 at 01:58 AM

Seen: 2276 times

Last Updated: Aug 26, 2011 at 02:12 AM