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

SQL Error in Multiprovider Data Display


Hi All,

Just come across a strange error while displaying Multiprovider data in RSA1.

If I do not pass any of the selection criterias I am able to see some data. It is showing data with certain selections as well but for few selection criterias it shows below SQL error. I am able to get the error with regular characterstic and nav attributes as well.

SQL0973N Not enough storage is available in the "PCKCACHESZ" heap or stack to process the statement. SQLSTATE=57011

What could be the possible issue and how to fix that.

Regards

Jitendra

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 24, 2014 at 02:41 PM

    Hi,

    Some selection combination getting huge data and unable to display.

    Even you can try to see the same selections thru LISTCUBE and see.

    Always try to see the limited combination data.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2014 at 03:35 PM

    Hello,

    Can you please check the APPLHEAPSZ and APP_CTL_HEAL_SZ parameters and increase them

    until the issue is resolved.

    Regards,

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2014 at 05:43 PM

    Hi Jitendra,

    I also think its because of huge data selection..try to provide specific selection.

    You might be aware about another ways to see data of info providers check one ie open muliprovider in Bex analyzer.

    Regards,

    Ganesh Bothe

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi All,

      Just to update that I am trying to see only 200 records and same error is coming at query level as well. However Basis team has increased some heap related parameters and now its working fine.

      @Micheal: I will pass on the parameters mentioned by you to basis team and check if they have worked on the same.

      Thansk to all for inputs.

      Regards

      Jitendra

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.