Skip to Content
author's profile photo Former Member
Former Member

Reporting Agent report runs for ever

Hello,

Inorder To "worm the cache" of a report i've made a web template to it, changed its properties (via RSRT) to cache mode 4-persistent cache across each application server, persistent mode 3-tranparent table(BLOB) and generate the report. when i run it with the report agent it runs for ever...

Please Advice.

David

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2006 at 10:17 AM

    Hey David.

    I read something about this somewhere... I tried to look for the oss note, but couldn't find it, however, I remember that the issue was with customer exits that looped forever because some values could not be determined. Thus, if you are using exit variables in the query you are trying to pre-calc, maybe this is the reason for the long run-time.

    Maybe note 745641 can be a starting point for you.

    Good luck!

    Jacob

    P.S: you can warm up the cache by using the "print" function and "Fill OLAP cache if possible" so you dont have to build a webtemplate for the query. This option is only available after some SP... I think it's SP 26 for BW 3.0B

    I found the note: it's 879061 😊

    Message was edited by: Jacob Jansen

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi JAcob,

      looks like you have already prime the cache by reporting agent for precalculating webtemplate.

      did u ? if so i am trying that ..and facing some problems. I think i am making some mistakes in process. can you please write me back step by step procedure ?

      I will definately come back and give to points to the answer.

      Thank You

      KSmith

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

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