Hi All, I am trying to decrypt data in csv file and got error is "FATAL_ERROR|System.SecurityException: pad block corrupted". Can anybody send code to solve issue. I execute below code in annonymous block
I am getting Apex heap size is too large error message when i am uploading large file (10MB Size and data size is 65000records) in visualforce page using batch class. but if file size is 5MB(26000 records) data is inserted without any error.
Hi, Can any body help me that how to upload .XML file using batch class to insert account record? I have written code and excetute it in developer console and getting error that is "You've exceeded the limit of 100 jobs in the flex queue for org 00D2E000001G0Xe. Wait for some of your batch jobs to finish before adding more. To monitor and reorder jobs, use the Apex Flex Queue page in Setup."
Code in developer console : contact cnt =[select id,name from contact where name='Dummy']; attachment att =[select id,name,body,parentid from attachment where parentid=:cnt.id];
Product_XML_ParserDemo.makeAccount(att);
global class Product_XML_ParserDemo
{
public class wrap
{
public String accname{get; set;}
public String accnumb{get; set;}
public String accphone{get; set;}
public String accwebsite{get; set;}
public String accbstrt{get; set;}
public String accbcity{get; set;}
public String accbste{get; set;}
public String accbpcodde{get; set;}
public String accbcntry{get; set;}
}
webservice static void makeAccount(attachment att) {
DOM.Document doc = new DOM.Document();
blob myfile = att.body;
doc.load(String.valueOf(myfile.toString()));
Product_XML_ParserDemo pxmlprs = new Product_XML_ParserDemo();
pxmlprs.parseproducts(doc.getRootElement());
}
public List<wrap> wrplist{get;set;}
private void parseproducts(DOM.XMLNode node)
{
node=node.getChildElement('list',null);
for (Dom.XMLNode child : node.getChildElements())
{
if(child.getName() == 'Account')
{
System.debug('child'+child);
parseReport(child);
}
}
}
private void parseReport(DOM.XMLNode node )
{
wrap r = new wrap();
wrplist = new List<wrap>();
for (Dom.XMLNode child : node.getChildElements())
{
if (child.getName() == 'Name')
{
r.accname = child.getText().trim();
}
else if (child.getName() == 'AccountNumber')
{
r.accnumb= child.getText().trim();
}
else if (child.getName() == 'Phone')
{
r.accphone= child.getText().trim();
}
else if (child.getName() == 'Website')
{
r.accwebsite= child.getText().trim();
}
else if (child.getName() == 'Billingstreet')
{
r.accbstrt= child.getText().trim();
}
else if (child.getName() == 'BillingCity')
{
r.accbcity= child.getText().trim();
}
else if (child.getName() == 'BillingState')
{
r.accbste= child.getText().trim();
}
else if (child.getName() == 'BillingPostalCode')
{
r.accbpcodde= child.getText().trim();
}
else if (child.getName() == 'BillingCountry')
{
r.accbcntry= child.getText().trim();
}
}
wrplist.add(r);
list<account> prodlist=new list<account>();
for(wrap w: wrplist)
{
account acc=new account();
acc.Name = w.accname;
acc.AccountNumber = w.accnumb;
acc.Phone = w.accphone;
acc.Website = w.accwebsite;
acc.Billingstreet = w.accbstrt;
acc.BillingCity = w.accbcity;
acc.BillingState = w.accbste;
acc.BillingPostalCode = w.accbpcodde;
acc.BillingCountry = w.accbcntry;
prodlist.add(acc);
}
batchTestNew dbbbt = new batchTestNew(prodlist);
Id batchJobId= database.executeBatch(dbbbt,50);
}
____________________________________________
Batch Class
global class batchTestNew implements Database.Batchable<sObject>{
public List <account> accountsToParseSet = new List<account>();
global batchTestNew(List<account> accountsToParseGet){
accountsToParseSet = accountsToParseGet;
}
global List<SObject> start(Database.BatchableContext BC){
return accountsToParseSet;
}
global void execute(Database.BatchableContext BC,
List<sObject> scope){
for(sObject s : scope){
upsert accountsToParseSet;
}
INSERT scope;
}
global void finish(Database.BatchableContext BC){
}
}
Hi, I am getting chart as shown below but i need chart below for every question based on values in question. Can any body help me where i made mistake in my code using lightning component.Please Reply me as soon as possible.
Hi All, I am trying to decrypt data in csv file and got error is "FATAL_ERROR|System.SecurityException: pad block corrupted". Can anybody send code to solve issue. I execute below code in annonymous block
Hi, Can any body help me that how to upload .XML file using batch class to insert account record? I have written code and excetute it in developer console and getting error that is "You've exceeded the limit of 100 jobs in the flex queue for org 00D2E000001G0Xe. Wait for some of your batch jobs to finish before adding more. To monitor and reorder jobs, use the Apex Flex Queue page in Setup."
Code in developer console : contact cnt =[select id,name from contact where name='Dummy']; attachment att =[select id,name,body,parentid from attachment where parentid=:cnt.id];
Product_XML_ParserDemo.makeAccount(att);
global class Product_XML_ParserDemo
{
public class wrap
{
public String accname{get; set;}
public String accnumb{get; set;}
public String accphone{get; set;}
public String accwebsite{get; set;}
public String accbstrt{get; set;}
public String accbcity{get; set;}
public String accbste{get; set;}
public String accbpcodde{get; set;}
public String accbcntry{get; set;}
}
webservice static void makeAccount(attachment att) {
DOM.Document doc = new DOM.Document();
blob myfile = att.body;
doc.load(String.valueOf(myfile.toString()));
Product_XML_ParserDemo pxmlprs = new Product_XML_ParserDemo();
pxmlprs.parseproducts(doc.getRootElement());
}
public List<wrap> wrplist{get;set;}
private void parseproducts(DOM.XMLNode node)
{
node=node.getChildElement('list',null);
for (Dom.XMLNode child : node.getChildElements())
{
if(child.getName() == 'Account')
{
System.debug('child'+child);
parseReport(child);
}
}
}
private void parseReport(DOM.XMLNode node )
{
wrap r = new wrap();
wrplist = new List<wrap>();
for (Dom.XMLNode child : node.getChildElements())
{
if (child.getName() == 'Name')
{
r.accname = child.getText().trim();
}
else if (child.getName() == 'AccountNumber')
{
r.accnumb= child.getText().trim();
}
else if (child.getName() == 'Phone')
{
r.accphone= child.getText().trim();
}
else if (child.getName() == 'Website')
{
r.accwebsite= child.getText().trim();
}
else if (child.getName() == 'Billingstreet')
{
r.accbstrt= child.getText().trim();
}
else if (child.getName() == 'BillingCity')
{
r.accbcity= child.getText().trim();
}
else if (child.getName() == 'BillingState')
{
r.accbste= child.getText().trim();
}
else if (child.getName() == 'BillingPostalCode')
{
r.accbpcodde= child.getText().trim();
}
else if (child.getName() == 'BillingCountry')
{
r.accbcntry= child.getText().trim();
}
}
wrplist.add(r);
list<account> prodlist=new list<account>();
for(wrap w: wrplist)
{
account acc=new account();
acc.Name = w.accname;
acc.AccountNumber = w.accnumb;
acc.Phone = w.accphone;
acc.Website = w.accwebsite;
acc.Billingstreet = w.accbstrt;
acc.BillingCity = w.accbcity;
acc.BillingState = w.accbste;
acc.BillingPostalCode = w.accbpcodde;
acc.BillingCountry = w.accbcntry;
prodlist.add(acc);
}
batchTestNew dbbbt = new batchTestNew(prodlist);
Id batchJobId= database.executeBatch(dbbbt,50);
}
____________________________________________
Batch Class
global class batchTestNew implements Database.Batchable<sObject>{
public List <account> accountsToParseSet = new List<account>();
global batchTestNew(List<account> accountsToParseGet){
accountsToParseSet = accountsToParseGet;
}
global List<SObject> start(Database.BatchableContext BC){
return accountsToParseSet;
}
global void execute(Database.BatchableContext BC,
List<sObject> scope){
for(sObject s : scope){
upsert accountsToParseSet;
}
INSERT scope;
}
global void finish(Database.BatchableContext BC){
}
}
