-
Post Install Script in Salesforce for deleting custom object data
I am deleting custom object data using Post Install Script. if data is huge, post install script error is coming.
I am writing below code in it.
List<UserMessage__c> m_loUserMessage;
m_loUserMessage = [select Title__c, MsgLine1__c, MsgLine2__c, MsgLine3__c, MsgLine4__c, MsgLine5__c, ReturnPage__c,
Increment__c from UserMessage__c order by Increment__c];
if(m_loUserMessage.size() > 10)
{
for(Integer i=0;i<(m_loUserMessage.size()-10);i++)
{
delete m_loUserMessage[i];
}
}Any one have suggestion for this for loop. Some of our customers has huge data. I think so that this error is coming.
Where should i put this for loop
-
2 Replies
-
Hi Bhavesh,
In the for loop, where you are deleting the record, you are performing DML operation inside the for loop and we can perform only limited DML operation in a thread.
Instead of deleting this in for loop, you can add the records to a list and then delete that list. But as you are querying the custom object data into a list, then there is also limit of querying into a list.
So, I would suggest using a batch class for this as it will handle really a huge amount of data. Please refer the below sample code for executing batch class from Post Install Script:
public without sharing class InstallationSystem implements Database.Batchable<SObject>, InstallHandler {
public void onInstall(InstallContext ic) {
// Initialize some data here
Database.executeBatch(this);
}
public Database.QueryLocator start(Database.BatchableContext bc) {
return Database.getQueryLocator([some query]);
}
public void execute(Database.BatchableContext bc, Sobject[] records) {
}
public void finish(Database.BatchableContext bc) {
}
}I hope this will help you.
Please let me know if you have any query.
Thanks
-
Hello Surabhi,
Thanks for quick reply.
I am doing another operation also in post install script. Please check below whole code of my post install script.
public class TaxNowPostInstall implements InstallHandler
{
public void onInstall(InstallContext context)
{
if(context.previousVersion() == null) // first install - create a new TaxNow Settings Record
{
//Insert some data when package install
TaxNowSetting__c tns = new TaxNowSetting__c(Name='AvaTax',Active_Setting__c=true,
Service_URL__c = 'https://avatax.avalara.net',TriggerLimit__c = 1);
insert(tns);
//Searching prodcut 'Tax Refund' from product catlog if it is not there, we are inserting it.
List<List<Product2 >>searchList = [FIND :'Tax Refund' RETURNING Product2 ];
Product2 pr = new Product2();
PriceBook2 customPriceBook = new PriceBook2();
if(searchList.size() == 0)
{pr.Name='Tax Refund';
pr.isActive=true;
pr.ProductCode = 'Tax Refund';
insert pr;// Insert Pricebook
customPriceBook.Name='Tax Refund';
customPriceBook.IsActive=true;
insert customPriceBook;
}
// Insert Product
List<EntityUse__c> initialCodes = new List<EntityUse__c>
{
new EntityUse__c(Description__c='Non-resident (Canada)', Name ='R'),
new EntityUse__c(Description__c='Commercial Fishery (Canada)', Name ='Q'),
new EntityUse__c(Description__c='Commercial aquaculture (Canada)', Name ='P'),
new EntityUse__c(Description__c='Other (requires Exempt Reason Desc) (both)', Name ='L'),
new EntityUse__c(Description__c='Direct mail (United States)', Name ='K'),
new EntityUse__c(Description__c='Direct pay permit (United States)', Name ='J'),
new EntityUse__c(Description__c='Industrial production / manufacturer (both)', Name ='I'),
new EntityUse__c(Description__c='Commercial agricultural production (both)', Name ='H'),
new EntityUse__c(Description__c='Resale (both)', Name ='G'),
new EntityUse__c(Description__c='Religious or educational org (both)', Name ='F'),
new EntityUse__c(Description__c='Charitable or benevolent org (both)', Name ='E'),
new EntityUse__c(Description__c='Foreign diplomat (both)', Name ='D'),
new EntityUse__c(Description__c='Tribe / Status Indian / Indian Band (both)', Name ='C'),
new EntityUse__c(Description__c='State government (United States)', Name ='B'),
new EntityUse__c(Description__c='Federal government (United States)',Name='A')
};
insert initialCodes;
List<Shipping_Codes__c> initialsCodes = new List<Shipping_Codes__c>
{
new Shipping_Codes__c(Description__c='Delivery by company vehicle before passage of title', Name ='FR010000'),
new Shipping_Codes__c(Description__c='After passage of title', Name ='FR010100'),
new Shipping_Codes__c(Description__c='Shipping Only (Not paid directly to common carrier)', Name ='FR010200'),
new Shipping_Codes__c(Description__c='Common carrier - FOB destination', Name ='FR020000'),
new Shipping_Codes__c(Description__c='Common carrier - FOB origin', Name ='FR020100'),
new Shipping_Codes__c(Description__c='Common carrier - FOB unknown', Name ='FR020200'),
new Shipping_Codes__c(Description__c='Non-common carrier - FOB destination', Name ='FR020300'),
new Shipping_Codes__c(Description__c='Non-common carrier - FOB origin', Name ='FR020400'),
new Shipping_Codes__c(Description__c='Non-common carrier - FOB unknown', Name ='FR020500'),
new Shipping_Codes__c(Description__c='Direct Mail-printed material for mass audience delivery', Name ='FR020600'),
new Shipping_Codes__c(Description__c='Charges that exceed the actual cost of delivery', Name ='FR020700'),
new Shipping_Codes__c(Description__c='Charges that exceed reasonable and prevailing rates', Name ='FR020800'),
new Shipping_Codes__c(Description__c='Shipping And Handling Combined', Name ='FR020900'),
new Shipping_Codes__c(Description__c='Common carrier - FOB destination', Name ='FR030000'),
new Shipping_Codes__c(Description__c='Common carrier - FOB origin',Name='FR030100'),
new Shipping_Codes__c(Description__c='Common carrier - FOB unknown', Name ='FR030200'),
new Shipping_Codes__c(Description__c='Non-common carrier - FOB destination', Name ='FR030300'),
new Shipping_Codes__c(Description__c='Non-common carrier - FOB origin', Name ='FR030400'),
new Shipping_Codes__c(Description__c='Non-common carrier - FOB unknown', Name ='FR030500'),
new Shipping_Codes__c(Description__c='Direct Mail-printed material for mass audience delivery', Name ='FR030600'),
new Shipping_Codes__c(Description__c='Charges that exceed the actual cost of delivery', Name ='FR030700'),
new Shipping_Codes__c(Description__c='Charges that exceed reasonable and prevailing rates', Name ='FR030800'),
new Shipping_Codes__c(Description__c='Electronically Delivered', Name ='FR030900'),
new Shipping_Codes__c(Description__c='Temporary Unmapped Freight SKU - taxable default', Name ='FR040000'),
new Shipping_Codes__c(Description__c='Miscellaneous', Name ='FR999999')
};
insert initialsCodes;
}
else // upgrade - make sure all TaxNowSettings have a value in TriggerLimit
{
for(TaxNowSetting__c tns : [select TriggerLimit__c from TaxNowSetting__c])
{
//once avalara package install, we insert TriggerLimit == 1 by default.
if(tns.TriggerLimit__c == null)
{
tns.TriggerLimit__c = 1;
update(tns);
}
}
}}
}Where should i wrote batch function in this script. Please suggest me. If possible please modify it and send me again.
Log In to reply.
Popular Salesforce Blogs
How To Optimize Automated Tests and Securely Log in to Salesforce Without Verification Code or MFA?
Like in any software testing, automation testing of Salesforce solutions is a reliable approach to verify the functionality and integrity of the platform. Automated tests…
Top 11 Extensions for Salesforce Developers
Extensions are computer programs that let users personalize their Chrome surfing experience. They are created using web technologies like HTML, CSS, and JavaScript. documentation for…
Salesforce: The Customer Success Platform To Grow Your Business Automation
If you’ve ever thought how great it would be to have a personal assistant, you should consider exploring Salesforce and its automation features. Imagine having…
Popular Salesforce Videos
Salesforce Admin Certification Questions and Explained Answers with References to Trailblazers
A Salesforce Admin Certification is the highest form of recognition a Salesforce Administrator can achieve; it demonstrates expertise in the field as well as a…
Survival Kit for Beginner Salesforce Developers - 1
Are you a developer just starting out with Salesforce? Are you an admin looking to get into development? Join us to learn a few easy,…
Apex Triggers in Salesforce | Concepts and Examples
Apex triggers enable you to perform custom actions before or after changes to Salesforce records, such as insertions, updates, or deletions. A trigger is Apex…
