Friday, December 9, 2011

Generating Queries issue BW

Due to an issue in one of the latest support packs (in our case SP08), many queries were being generated on each call of an enduser.

This causes major performance issues in reporting in our system. Mainly in generating the variable screen and the (non) usage of cache for these queries.

Wonder if this is happening in your system? Check on table RSRREPDIR and check if the timestamp in field GENTIME is not too recent for your active queries.

Also in the system you will see if you trace the call of the report that tables D010TAB and D010INC are accessed many times.

Implementing note 1528921 helped out on this (Queries regenerated each time during
execution). Please be aware!
Geplaatst door op
Labels:

14 comments:

  1. AnonymousMay 29, 2014 at 7:10 AM

    Hai,
    Greetings from Soaonlinetrainings.com,

    we do provide online training in testing tools like Selenium test,Load Runner,JMeter,
    ETL Testing,Pega testing, etc...........


    Thank you,

    soaonlinetrainings.com,
    9949023777

    ReplyDelete
  2. SharmaMarch 15, 2019 at 1:26 PM

    Hey, would you mind if I share your blog with my twitter group? There’s a lot of folks that I think would enjoy your content. Please let me know. Thank you.
    AWS Training in Chennai | Best AWS Training in Chennai | AWS Training Course in Chennai
    Data Science Training in Chennai | Best Data Science Training in Chennai | Data Science Course in Chennai
    No.1 Python Training in Chennai | Best Python Training in Chennai | Python Course in Chennai
    RPA Course Training in Chennai | Best RPA Training in Chennai

    ReplyDelete
  3. SharmaApril 25, 2019 at 2:57 PM

    And indeed, I’m just always astounded concerning the remarkable things served by you. Some four facts on this page are undeniably the most effective I’ve had.
    Java Training in Chennai |Best Java Training course in Chennai
    C C++ Training in Chennai |Best C C++ Training course in Chennai
    Data science Course Training in Chennai |Best Data Science Training course in Chennai
    RPA Course Training in Chennai |Best RPA Training course in Chennai
    AWS Course Training in Chennai |Best AWS Training course in Chennai
    Devops Course Training in Chennai |Best Devops Training course in Chennai
    Selenium Course Training in Chennai |Best Selenium Training course in Chennai
    Java Course Training in Chennai | Best Java Training course in Chennai
    Web Designing Training in Chennai | Best Web Designing Training course in Chennai
    MATLAB TRAINING IN CHENNAI | Best MATLAB TRAINING course IN CHENNAI

    ReplyDelete
  4. AparnaMay 2, 2019 at 7:55 AM




    I took more knowledge from your post and This is very valuable for all readers. I want more kinds of details in this topic and keep it up...!
    Excel Training in Chennai
    Advanced Excel Training in Chennai
    Pega Training in Chennai
    Unix Training in Chennai
    Oracle Training in Chennai
    Spark Training in Chennai
    Embedded System Course Chennai
    Linux Training in Chennai
    Excel Training in Chennai
    Advanced Excel Training in Chennai


    ReplyDelete
  5. jefrinMay 28, 2019 at 2:04 PM

    Hello, I read your blog occasionally, and I own a similar one, and I was just wondering if you get a lot of spam remarks? If so how do you stop it, any plugin or anything you can advise? I get so much lately it’s driving me insane, so any assistance is very much appreciated.

    Selenium Course Training in Chennai |Best Selenium Training Institute in Chennai
    Java Course Training in Chennai | Best Java Training Institute in Chennai

    ReplyDelete
  6. RajiJune 27, 2019 at 12:03 PM

    Hey Nice Blog !! Thanks For Sharing !!! Wonderful blog & good post.Its really helpful for me, waiting for a more new post. Keep Blogging :)
    Java Training in Chennai | Java Course in Chennai

    ReplyDelete
  7. jvimalaJuly 24, 2019 at 9:45 AM

    Thanks for sharing this great article. It made me understand few things about this concept which I never knew before. Keep posting such great articles so that I gain from it. IT Institute in KK Nagar| seo training institute in chennai | seo course in chennai

    ReplyDelete
  8. UnknownOctober 16, 2019 at 11:48 AM

    I have to voice my passion for your kindness giving support to those people that should have guidance on this important matter.

    Best PHP Training Institute in Chennai|PHP Course in chennai
    Best .Net Training Institute in Chennai
    Dotnet Training in Chennai
    Dotnet Training in Chennai

    ReplyDelete
  9. ramyaNovember 12, 2019 at 12:44 PM

    Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of....
    Aws training chennai | AWS course in chennai
    Rpa training in chennai | RPA training course chennai
    sas training in chennai | sas training class in chennai

    ReplyDelete
  10. Venu VemullaMarch 31, 2020 at 3:42 PM

    "I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
    sap bi/bw online training"

    ReplyDelete
  11. ArunaMay 17, 2020 at 4:31 PM

    Incredible Blogs!!!I utilize all your Articles...Thanks for it
    Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

    ReplyDelete
  12. subatharaOctober 31, 2020 at 12:17 PM

    I have read your blog its very attractive and impressive. I like your blog
    Digital Marketing Training in Velachery

    Digital Marketing Training in Tambaram

    Digital Marketing Training in Porur

    Digital Marketing Training in Omr

    Digital MarketingTraining in Annanagar

    ReplyDelete
  13. vanathiNovember 2, 2020 at 7:34 AM

    I finally found great post here.I will get back here. I just added your blog to my bookmark sites. thanks.Quality posts is the crucial to invite the visitors to visit the web page, that's what this web page is providing.
    Software Testing Training in Chennai

    Software Testing Training in Velachery

    Software Testing Training in Tambaram

    Software Testing Training in Porur

    Software Testing Training in Omr

    Software Testing Training in Annanagar

    ReplyDelete
  14. mahaDecember 29, 2020 at 4:21 PM

    Thanks for sharing this valuable information to our vision. You have posted a worthy blog keep sharing.

    Digital Marketing Training in Chennai

    Digital Marketing Course in Chennai

    ReplyDelete

Subscribe to: Post Comments (Atom)