Results 1 to 4 of 4
  1. #1
    Join Date
    May 2007
    Posts
    6

    Unhappy Unanswered: Regarding Querylog

    hi,

    I have a serious problem and would appreciate your early replies.
    I have MSAS 2000 installed in my production server.
    For the past two months no information has gone to my querylog file.
    Its size is 962,820 kb.
    So initially i thought size would be the problem and copied msmdqlog.mdb to my local system and there i was able to manually insert records and also whenever i fired a mdx query in my local cube there was an entry in the query log table.
    Even the logging tab is set to record once per query.
    So why does it not have any entries?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Have you restarted Analysis Services since the changes to logging were made?

  3. #3
    Join Date
    May 2007
    Posts
    6
    From the very first the logging has been set to once per query and we have not touched it since then.
    and ihave another doubt the msmdqlog.ldb file is missing in the server will this case any problem?
    Last edited by praba_smile; 05-26-07 at 02:27.

  4. #4
    Join Date
    May 2007
    Posts
    6

    Resolved

    I dint know what was the actual issue but once i migrated the query log to sql server everyting is fine

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •