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

Error in BW Report

Experts,

I am executing BW report in Bex ,When i execute After entering in the parameters ,it is giving Application error messages .

Error an exception with typeCX_SY_DYN_CALL_ILLEGAL_TYPE Occured ,

The attempt to call the subroutine HIERATTRIVL_GET in the program failed

due to a type error involving parameter number 6

Message no. RS_EXCEPTION000

Any advice greatly appreciated .

-Mano

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2006 at 07:59 AM

    Hi Mano,

    go in Tcode RSRT and select first Environment --> Repair read mode.

    Then, always in Tcode RSRT, click on "Generate Report" buttom.

    Ciao.

    Riccardo.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2006 at 10:14 AM

    Riccardo,A.H.P ,Pradit,

    Thanks for u r reply.

    This error occuring from yesterday for few reports only .

    NOT all reports .

    Riccardo,

    Through RSRT -Did nt work .

    A.H.P,Pradit,

    This report was working before.This error occured yesterday onwards .

    Any other ideas greatly appreciated .

    Thanks

    Mano

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2006 at 08:04 AM

    hi Mano,

    check if helps oss note 656060

    also 965857, 846036 (what's your bw version and support package level ? may need to apply support package)

    656060

    Symptom

    Although one of the following two cache modes

    Main Memory Cache Without Swapping (mode 1)

    Main Memory Cache With Swapping (mode 2)

    is set for a query, long runtimes occur when you execute the query. The statistics (table RSDDSTAT) display the database times.

    If there is a heavy system load, the following message can also appear: RS_EXCEPTION000: No left space in shared memory.

    Other terms

    Cache, performance, displacement, shared buffer

    Reason and Prerequisites

    This problem occurs because the shared memory is insufficiently dimensioned.

    Solution

    Increase the amount of shared memory. The size of the shared memory should be at least 200 MB. You can refer to transaction RSRCACHE for the amount of memory reserved by the main memory cache (RSRCACHE -> Main Memory: Shared Memory/Buffer Reserved).

    The corresponding settings are (at least):

    rsdb/esm/buffersize_kb = 200000

    and, as a precaution, also

    rsdb/esm/max_objects = 10000.

    Alternatively, for queries with large resulting quantities, you can convert the Cache Mode in transaction RSRT1 to

    Cluster/Flat File Cache for Each Application Server (mode 3)

    Cluster/Flat File Cache Across Each Application Server (mode 4)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2006 at 08:22 AM

    Hi Manohar

    Take a look at following OSS Notes when searched on -

    HIERATTRIVL_GET :- 855444,838566,947104

    RS_EXCEPTION000 :- 846036,965857,656060

    Check which is relevant for your version and also use any program name given in error message. Check doe short dump in ST22 there you will get more information on this error message

    Regards

    Pradip

    Add a comment
    10|10000 characters needed characters exceeded

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.