Skip to Content

search table error: [2724] Olap temporary data size exceeded 31/32 bit limit"

Aug 02, 2017 at 12:00 PM


avatar image

I Have a calculation view which is based on other calculation views and joins to bring material Accounts data from different vendors(all joins have 1-1 maping with target). in the final view I have a calculated column as "Formatted_MATERIAL"(Material numbers without any leading zeros, used Ltrim() to remove leading zeros.) Now, when I m searching Formatted material equal to some specific number its showing read error(heading). if I m searching for some range of material its giving results. for EX: if I serach for material(500098). its present in following query results
select "Formatted_MATERIAL"
where "Formatted_MATERIAL" between 5000000 and 6000000
order by "Formatted_MATERIAL" but no results for

select "Formatted_MATERIAL"
where "Formatted_MATERIAL" = 5000098

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers