topic Re: Dump in select in Application Development and Automation Discussions

Dump in select

rbharathi123 — Thu, 12 Oct 2023 11:29:57 GMT

Dear Experts,

I'm having issue that I'm getting dump after cursor crossing the select statement.

select is written for CDS VIEWS Which is having

If we use the select with up to rows its working properly.

Kindly Provide some suggestion or solution.

Regards,

Bharathi

image.png

Re: Dump in select

fedaros — Thu, 12 Oct 2023 12:24:56 GMT

Hi rbharathi123,

Check your modeling and selection, you seems to have a calculation attribute that with many rows, or a sum of it, are overflowing the 3,2 definition you did.

Regards, Fernando Da Rós

Re: Dump in select

rbharathi123 — Thu, 12 Oct 2023 14:20:09 GMT

Hi Fernando Da Ros,

Its working Properly in Pre Production But it getting dump only Quality.

Dumps Description Are varying from Every Client. But We are Not getting any dumps for same version in Pre Production which having lot of records compare to Quality.

Regards,

Bharathi

Re: Dump in select

fedaros — Thu, 12 Oct 2023 15:50:30 GMT

Hi rbharathi123,

This is a new error, you reached a system with more data and you are trying to select too much data without memory to process it.

Review your modeling if all filters are properly set, if all your joins are with correct set with proper keys and correlation to avoid double the data due to wrong joins.

It's all I can say without seeing your model, execution, planviz....

Regards, Fernando Da Rós

Re: Dump in select

Sandra_Rossi — Thu, 12 Oct 2023 16:37:12 GMT

You have embedded only one of the two images.

I do the other one for you.

Numeric overflow. Should be easy to understand. Other people have asked the question already.