SQL Error in Multiprovider Data Display

[Former Member]

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

[former_member183012]

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

[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

[michael_devine]

Hello,

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

until the issue is resolved.

Regards,

Michael

[RamanKorrapati]

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