Setting LOGLEVEL from Answers

Standard

Normally, we check query in NQQuery.log file or from Answers also we can check the query directly.

 Difference is: NQQuery.log contains all the queries and need to identify them by time the report run.

If it’s directly from Answers (go to Settings > Administration > Manage Sessions), log available for every report runs until the query is changed.

 For every query of report there will be created one cursor, by accessing the cursor you can see the physical query generated by BI server.

 If we are unable to see the log file or if we find any error message saying that, No Log found while trying to watch the query in log the first step in the mind is to check the LOGLEVEL. When creating rpd by default, loglevel takes 0 values for Administrator user.

If it’s set to 0, we go for 2 or 3 accordingly, such that, the query will be appeared.

For suppose, if you are accessing presentation service of another system and unable to see the query. You need not to set the LOGLEVEL=2 in the rpd presented in another system.

I am assuming that all cursors are closed and LOGLEVEL is zero for particular user.

Log into answers with user who has LOGLEVEL =0, run any report then go to Settings > Administration > Manage Sessions. Click on View Log option.

You will have error message or you may open the view log but you can’t find the query run at this moment because of loglevel – “0″. (To test this error message, you better delete the content of NQQuery.log completely but before doing this you need to stop your BI Server service then clear the content and save file again start BI Server service)

error-message

Close the window as well as cursors

 Just go to advanced tab of particular report.

advanced-tab

Scroll down to see the option: Prefix

Here write SET VARIABLE LOGLEVEL=2; (semi-colon at the end is must)

 prefix

Now click on Results tab to re – run the report.

 Now you go Settings > Administration > Manage Sessions

Click on View Log to view the query. Now you are able to see the query and according to the LOGLEVEL – 2

 Go back to Advanced tab, observe the Logical query.

Before SQL, you find the text you written in Prefix field.

By mentioning the semi colon, BI Server executes these statements one after another.

This post explain you, how to set loglevel from answers it self, with out going to rpd,

This process overrides the loglevel set in the rpd.

About these ads

About Kishore & Naresh

Hi.. This is a blog operated by Kishore and Naresh. We are colleagues and working as BI Developers. Here we want to share our ideas and researches here. We were the active members of OTN Forums and inspired with Venkat and John's blog. We may not reach to that level, but we brings up all our ideas and research work we done. All the views expressed here are our own and does not reflect the views of our employers. We need all your blessings and support to grow. Thanks

25 responses »

  1. hi ,
    we learnt the easiest way to setup the log level.

    previously we are suppose to change in manage->security

    Thanks,
    Jaheer

  2. Hello I am so happy I found your weblog, I really found you by error, while
    I was searching on Yahoo for something else, Regardless I
    am here now and would just like to say many thanks for a tremendous post and a
    all round exciting blog (I also love the theme/design),
    I don’t have time to go through it all at the minute but I have book-marked it
    and also added your RSS feeds, so when I have time I will
    be back to read a lot more, Please do keep up the great work.

  3. Hey there! I’m at work surfing around your blog from my new iphone 3gs! Just wanted to say I love reading your blog and look forward to all your posts! Carry on the superb work!

  4. Please let me know if you’re looking for a article author for your site. You have some really good posts and I feel I would be a good asset. If you ever want to take some of the load off, I’d really like to write some material for your blog in exchange for a link
    back to mine. Please blast me an email if interested. Cheers!

  5. Its not my first time to pay a quick visit this website, i am visiting this web page dailly and obtain nice data
    from here all the time.

  6. Wow that was unusual. I just wrote an incredibly long comment but after I clicked
    submit my comment didn’t show up. Grrrr… well I’m not writing
    all that over again. Anyhow, just wanted to say excellent blog!

  7. You’re so cool! I do not think I have read something like this before. So nice to find another person with a few original thoughts on this issue. Seriously.. thank you for starting this up. This website is something that is needed on the internet, someone with a little originality!

  8. magnificent publish, very informative. I’m wondering why the opposite specialists of this sector don’t notice this.
    You must continue your writing. I am confident, you’ve a great readers’ base already!

  9. Hi there i am kavin, its my first occasion to commenting anyplace,
    when i read this article i thought i could also create comment due to
    this brilliant paragraph.

  10. Woah! I’m really loving the template/theme of this blog. It’s simple, yet effective.
    A lot of times it’s hard to get that “perfect balance” between superb usability and visual appearance. I must say that you’ve done a
    awesome job with this. In addition, the blog loads extremely quick
    for me on Firefox. Superb Blog!

  11. Pretty great post. I just stumbled upon your blog and wished
    to mention that I’ve truly enjoyed surfing around your weblog posts. After all I’ll be subscribing
    in your rss feed and I hope you write once more soon!

  12. I like the valuable info you supply to your articles. I will bookmark your blog and check again here regularly.
    I’m somewhat certain I’ll be told plenty of new stuff proper here!
    Best of luck for the following!

  13. Thanks for some other magnificent post. Where else may anyone get that kind of information
    in such a perfect manner of writing? I’ve a presentation next week, and
    I’m on the look for such info.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s