• RaumilSforce
  • NEWBIE
  • 0 Points
  • Member since 2011

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies

I'm trying to use DataLoader to insert records into a custom object. This object is associated with apex triggers and workflows. When I kept the file size small (ex. 10 records), it loads fine but when I try to load anything bigger (ex. 100 records), I get this error:

 

Apex script unhandled trigger exception by user/organization: 00570000001eDYh/00D70000000IzMi

 

Primary_Revenue_Schedule_After_All: System.LimitException: Apex heap size too large: 3048542

 

I have over 50K records I have to insert... is there anyway to get around this? I have a feeling the code is faulty but I don't know how to fix it. I don't even see anything in the code that has 'heap size' in it.

Hi All,

 

i am trying to crate a formula based on the below criteria (user selection), but I am hiiting the limit of 5000 characters (size) limit.

  1. I have a 2 picklist fields, with one dependant. Business Unit, Product Type (dependant)
  2. If a user Selects Business unit (BET) and a Product Type with an acronym (e.g BGC), an enquiry number is generated based on the Product Type with a 5 character long number appended at the end (e.g BGC-00001).
  3. If no Product Type is selected for Business Unit BET, then the Enquirt Number Should be BET-00001
  4. Should the Business Unit NOT be BET, the Enqury Number is the business unit appended with a 4 character long number (e.g AUS-0001

I currently have the following code, but hit the limit when saving.  Please assist (reluctant on going to code for this):

 

IF (
AND(
ISPICKVAL(Business_Unit__c,"Bateman Engineered Technologies (BET)"),
OR(
ISPICKVAL(Product_Type__c,"Air Environmental (BPC)"),
ISPICKVAL(Product_Type__c,"Cement (BLC)"),
ISPICKVAL(Product_Type__c,"Comminution (BUC)"),
ISPICKVAL(Product_Type__c,"Conveyors (BCC)"),
ISPICKVAL(Product_Type__c,"Distribution (BGC)"),
ISPICKVAL(Product_Type__c,"Jetfloat (BQC)"),
ISPICKVAL(Product_Type__c,"Load Out Stations (BEC)"),
ISPICKVAL(Product_Type__c,"Pneumatics (BLC)"),
ISPICKVAL(Product_Type__c,"Process Equipment (BOC)"),
ISPICKVAL(Product_Type__c,"Specialised Handling (BAC)"),
ISPICKVAL(Product_Type__c,"Stackers & Reclaimers (BBC)"),
ISPICKVAL(Product_Type__c,"Water (BMC)")
)),
LEFT(SUBSTITUTE(TEXT(Product_Type__c ),LEFT(TEXT(Product_Type__c),FIND("(",TEXT(Product_Type__c))), ""),3)&"-"&
LPAD(Enquiry_Number2__c,5,'0'),



IF(

ISPICKVAL(Business_Unit__c,"Bateman Engineered Technologies (BET)"),

LEFT(SUBSTITUTE(TEXT(Business_Unit__c),LEFT(TEXT(Business_Unit__c),FIND("(",TEXT(Business_Unit__c))),""),3)&"-"&
LPAD(Enquiry_Number2__c,5,'0'),

LEFT(SUBSTITUTE(TEXT(Business_Unit__c),LEFT(TEXT(Business_Unit__c),FIND("(",TEXT(Business_Unit__c))),""),3)&"-"&
LPAD(Enquiry_Number2__c,4,'0')
))

 

Thanks in advance

 

  • July 29, 2011
  • Like
  • 0