2023 Oct 12 12:29 PM
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
2023 Oct 12 1:24 PM
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
2023 Oct 12 3:20 PM
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
2023 Oct 12 4:50 PM
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
2023 Oct 12 5:37 PM
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.