Apex Code Development You need to sign in to do that
Don't have an account?
Michael M How to get around System.LimitException: Query of LOB fields caused heap usage to exceed limit. (in Apex)
Hello, I keep getting an ApexApplication email saying:
Failed to invoke future method 'public static void UploadDocument(String)' on class 'S3Controller' for job id '7073l0000FSMaBy'
caused by: System.LimitException: Query of LOB fields caused heap usage to exceed limit.
The line of code that is causing the error is this:
List<ContentVersion> versions=[SELECT VersionData,Title,ContentDocumentId,FileExtension FROM ContentVersion WHERE ContentDocumentId = :ids AND IsLatest = true];
How can I change my code so that if that error comes up, I still query the files but ONLY query the 1st file (as a way of avoiding the error)?
I TRIED this:
List<ContentVersion> versions = new list<contentversion>();
try{
versions=[SELECT VersionData,Title,ContentDocumentId,FileExtension FROM ContentVersion WHERE ContentDocumentId = :ids AND IsLatest = true];
}
catch (exception e){
versions=[SELECT VersionData,Title,ContentDocumentId,FileExtension FROM ContentVersion WHERE ContentDocumentId = :ids AND IsLatest = true limit 2];
}
BUT it didn't work. I am still getting the same ApexApplication error email.
Failed to invoke future method 'public static void UploadDocument(String)' on class 'S3Controller' for job id '7073l0000FSMaBy'
caused by: System.LimitException: Query of LOB fields caused heap usage to exceed limit.
The line of code that is causing the error is this:
List<ContentVersion> versions=[SELECT VersionData,Title,ContentDocumentId,FileExtension FROM ContentVersion WHERE ContentDocumentId = :ids AND IsLatest = true];
How can I change my code so that if that error comes up, I still query the files but ONLY query the 1st file (as a way of avoiding the error)?
I TRIED this:
List<ContentVersion> versions = new list<contentversion>();
try{
versions=[SELECT VersionData,Title,ContentDocumentId,FileExtension FROM ContentVersion WHERE ContentDocumentId = :ids AND IsLatest = true];
}
catch (exception e){
versions=[SELECT VersionData,Title,ContentDocumentId,FileExtension FROM ContentVersion WHERE ContentDocumentId = :ids AND IsLatest = true limit 2];
}
BUT it didn't work. I am still getting the same ApexApplication error email.
Hi,
I hope these links will help you.
https://developer.salesforce.com/forums/?id=906F00000008zoxIAA
https://salesforce.stackexchange.com/questions/239779/first-error-query-of-lob-fields-caused-heap-usage-to-exceed-limit
https://www.eigenx.com/blog/2017/1/23/solutions-to-fix-apex-heap-limits
Thank You
All Answers
Hi,
I hope these links will help you.
https://developer.salesforce.com/forums/?id=906F00000008zoxIAA
https://salesforce.stackexchange.com/questions/239779/first-error-query-of-lob-fields-caused-heap-usage-to-exceed-limit
https://www.eigenx.com/blog/2017/1/23/solutions-to-fix-apex-heap-limits
Thank You
Apply for a Moldova visa for Indians can find the necessary visa information they need to apply for a Moldova visa on this Site. If you would like to learn more about Moldova visa, please connect with us for the most up-to-date information.
Canada Tourist Visa from India, Canada Tourist and Business Visas can be applied for online, and we provide the best Canada visa agents in Chandigarh. Continental Immigration is India's premier provider.
US Visa Consultants in Hyderabad It is critical to discover a dependable and reliable travel agent or visa consultant in Hyderabad. One of the most outstanding visa agents in Hyderabad.
Visa Agents in Indore,Indore-based Continental Immigration offers Australia's top tourist visa consultant services, designed to meet your specific immigration needs.
Looking for the best UK tourist Visa Consultants in Indore to apply for visitor visas from India. We are a certified United kingdom visit visa consultant in Indore.
Our Canada Immigration Consultants in Indore will guide you the detailed paperwork required to fill the application form that includes all documents.
Chile Work Visa for Indians, All nationalities are welcome to utilise this product, enabling them to stay in Chile for a maximum of one year either working or studying. After the allotted time frame, an application for a permanent visa must be completed.
Germany Study Visa Consultants in delhi, University of Potsdam· The Johann Wolfgang Goethe University · Frankfurt ; Darmstadt University of Applied Sciences.
H1B Visa Consultant, Continental provides advice on global immigration opportunities and specialises in visa and immigration consulting.
Croatia Visa for Indians We provide the best Croatia tourist visa consultant in Delhi who will guide you with the detailed paperwork required to fill the application form including all documents.
Peru visa for Indians, When entering to Peru a traveller needs a passport valid at least half a year with 2 free pages in the visa section and you cannot extend your tourist visa once.
Brazil visa for Indians To qualify for a Brazil visa for Indians, our visa agents in Delhi will guide you through the detailed paperwork required to complete the application form that includes.
Chile Visa for Indians The Continental Immigration provides a Chile Visa for Indians Services in Delhi. We provide Chile's best Tourist visa consultant in Delhi to bring you immigration solution.
US Visa Consultants in Chandigarh, Continental Immigration is the fastest growing immigration consultants having expertise of providing quality solutions in immigration services to individuals.
German Visa Appointment Looking for a Germany Visa appointment booking? Continental Immigration i