We are trying to use for the first time the visualWorkflow to create a process, we need to avoid the user choose between many records and then update the owner of all of these but when the update actions runs we get the next error:
interaction.dal.exception.DALExecutionFault: ; nested exception is:
common.exception.ApiQueryException:
Info_Demandante_APC__c WHERE (Info_Demandante_APC__c.Id LIKE '%a1VM0000000D7PQMA0;
^
ERROR at Row:1:Column:69
invalid operator on id field
(There was a problem executing your command.) > UPDATE
i need to know if its posible to add the content delivery related list to the persona accounts records, i have it in opportunity but it i cant find the list in the person account format page.
I have a problem. I created an email template that uses a component to display a list of data. This component obtains data from an external web service through a soap service (in the apex controller). This template email I use it in a e-mail alert that is triggered by a workflow rule. My problem is that when you meet the rule and generates the email, I get the following message: An internal server error has occurred.
we area try to look a way to register automaticaly the incoming and outgoing emails from a emailbox to SF as a cases.
We are trying to do installing email to case as a agent and using mail rules for de outgoing mails but we are in a real headache with the email to case agent.
We ever receive the next error:
2011-02-13 13:22:17,942 1672 [main] INFO com.sforce.SalesforceAgent - Service https://echange2003imapserver:0:user:testInbox successfully registered 2011-02-13 13:22:17,942 1672 [main] INFO com.sforce.SalesforceAgent - com.sforce.mail.EmailService loaded as a timer service. 2011-02-13 13:22:18,020 1750 [Timer-0] ERROR com.sforce.mail.GenericClient - Unable to connect to mail service. Service: https://exchange2003serverUser: Username Message: https://exchange2003server nested exception is: java.net.UnknownHostException: https://exchange2003server
When we try to access by web to our imapserver th browser shows a certificated error:
"There is a problem with this website's security certificate."
we are trying to begin with apex in my org, we need to have a vf page with this objects:
- A datatable with the opportunitys (done)
-Checkbox for each register (done)
-Subject and body textboxes for a email sending(done)
-A button wich send an email to de selected opportunities(done)
the problem has come with the last requeriment, we need a listbox with EmailTemplates, its done but when i show this textbox the send mail button dont send the email.
Here is my controller:
public with sharing class EmailfromCheks {
//public EmailTemplate Template; String[] Templates = new String[]{}; public List<SelectOption> getItems() { // if (TemplateList == null) // { List<EmailTemplate> Template = [Select Id, Name From EmailTemplate Where IsActive = true order by FolderId limit 30]; List<SelectOption> TemplateList = new List<SelectOption>();
for (EmailTemplate c : Template) { TemplateList.add(new SelectOption( c.id, c.name )); } //} return TemplateList; } public String[] getTemplates() { return Templates; }
public void setTemplates(String[] Templates) { this.Templates = Templates; }
/* public EmailTemplate getEmailTemplate() { if(Template == null) Template = new EmailTemplate(); return Template; } public String[] selectedTemplate=new String[]{}; public String[] getSelectedTemplate() { return selectedTemplate; } public void setSelectedTemplate(String[] sel) { selectedTemplate=sel; } public List<SelectOption> TemplateList; public List<SelectOption> getTemplate () { if (TemplateList == null) { List<EmailTemplate> Template = [Select Id, Name From EmailTemplate Where IsActive = true order by FolderId limit 30]; TemplateList = new List<SelectOption>(); for (EmailTemplate c : Template) { TemplateList.add(new SelectOption( c.id, c.name )); } } return TemplateList; }*/ public String subject { get; set; } public String body { get; set; } public List<cOpportunity> OppLista; public List<cOpportunity> getOppLista() { if(OppLista == null) { System.debug('Empieza'); OppLista = new List<cOpportunity>(); for(Opportunity c : [select Id, Name, EmailContactoCurso__c from Opportunity where Opportunity.CodigoDeCurso__c = :ApexPages.currentPage().getParameters().get('id')]) { OppLista.add(new cOpportunity(c)); } } return OppLista; } public PageReference RefreshOpps() { List<Opportunity> selectedcOpp = new List<Opportunity>(); for(cOpportunity cOpp : OppLista) { if(cOpp.selected == true) { selectedcOpp.add(cOpp.Opp); } } return null; } public PageReference Send() { // System.debug('Declaro'); List<Opportunity> selectedcOpp = new List<Opportunity>();
} return null; } public class cOpportunity { public Opportunity Opp {get; set;} public Boolean selected {get; set;} public cOpportunity(Opportunity c) { Opp = c; ; } } }
and here my vf page:
<apex:page controller="EmailfromCheks"> <apex:form > <apex:selectList value="{!Templates}" size="1"> <apex:selectOptions value="{!Items}"/> if i comment this line the page send the email <apex:actionSupport event="onchange" rerender="features"/> </apex:selectList> <apex:pageBlock > <apex:pageBlockTable value="{!OppLista}" var="c" id="table"> <apex:column > <!-- This is our selected Boolean property in our wrapper class --> <apex:inputCheckbox value="{!c.selected}"/> </apex:column> <!-- This is how we access the contact values within our cContact container/wrapper --> <apex:column value="{!c.Opp.Name}" /> <apex:column value="{!c.Opp.EmailContactoCurso__c }" /> </apex:pageBlockTable> </apex:pageBlock> <br /><br /> <apex:outputLabel value="Subject" for="Subject"/>:<br /> <apex:inputText value="{!subject}" id="Subject" maxlength="80"/> <br /><br /> <apex:outputLabel value="Body" for="Body"/>:<br /> <apex:inputTextarea value="{!body}" id="Body" rows="10" cols="80"/> <br /><br /><br /> <apex:commandButton value="Send Email" action="{!Send}" /> </apex:form> </apex:page>
We are trying to use for the first time the visualWorkflow to create a process, we need to avoid the user choose between many records and then update the owner of all of these but when the update actions runs we get the next error:
interaction.dal.exception.DALExecutionFault: ; nested exception is:
common.exception.ApiQueryException:
Info_Demandante_APC__c WHERE (Info_Demandante_APC__c.Id LIKE '%a1VM0000000D7PQMA0;
^
ERROR at Row:1:Column:69
invalid operator on id field
(There was a problem executing your command.) > UPDATE
I have a problem. I created an email template that uses a component to display a list of data. This component obtains data from an external web service through a soap service (in the apex controller). This template email I use it in a e-mail alert that is triggered by a workflow rule. My problem is that when you meet the rule and generates the email, I get the following message: An internal server error has occurred.
we are trying to begin with apex in my org, we need to have a vf page with this objects:
- A datatable with the opportunitys (done)
-Checkbox for each register (done)
-Subject and body textboxes for a email sending(done)
-A button wich send an email to de selected opportunities(done)
the problem has come with the last requeriment, we need a listbox with EmailTemplates, its done but when i show this textbox the send mail button dont send the email.
Here is my controller:
public with sharing class EmailfromCheks {
//public EmailTemplate Template; String[] Templates = new String[]{}; public List<SelectOption> getItems() { // if (TemplateList == null) // { List<EmailTemplate> Template = [Select Id, Name From EmailTemplate Where IsActive = true order by FolderId limit 30]; List<SelectOption> TemplateList = new List<SelectOption>();
for (EmailTemplate c : Template) { TemplateList.add(new SelectOption( c.id, c.name )); } //} return TemplateList; } public String[] getTemplates() { return Templates; }
public void setTemplates(String[] Templates) { this.Templates = Templates; }
/* public EmailTemplate getEmailTemplate() { if(Template == null) Template = new EmailTemplate(); return Template; } public String[] selectedTemplate=new String[]{}; public String[] getSelectedTemplate() { return selectedTemplate; } public void setSelectedTemplate(String[] sel) { selectedTemplate=sel; } public List<SelectOption> TemplateList; public List<SelectOption> getTemplate () { if (TemplateList == null) { List<EmailTemplate> Template = [Select Id, Name From EmailTemplate Where IsActive = true order by FolderId limit 30]; TemplateList = new List<SelectOption>(); for (EmailTemplate c : Template) { TemplateList.add(new SelectOption( c.id, c.name )); } } return TemplateList; }*/ public String subject { get; set; } public String body { get; set; } public List<cOpportunity> OppLista; public List<cOpportunity> getOppLista() { if(OppLista == null) { System.debug('Empieza'); OppLista = new List<cOpportunity>(); for(Opportunity c : [select Id, Name, EmailContactoCurso__c from Opportunity where Opportunity.CodigoDeCurso__c = :ApexPages.currentPage().getParameters().get('id')]) { OppLista.add(new cOpportunity(c)); } } return OppLista; } public PageReference RefreshOpps() { List<Opportunity> selectedcOpp = new List<Opportunity>(); for(cOpportunity cOpp : OppLista) { if(cOpp.selected == true) { selectedcOpp.add(cOpp.Opp); } } return null; } public PageReference Send() { // System.debug('Declaro'); List<Opportunity> selectedcOpp = new List<Opportunity>();
} return null; } public class cOpportunity { public Opportunity Opp {get; set;} public Boolean selected {get; set;} public cOpportunity(Opportunity c) { Opp = c; ; } } }
and here my vf page:
<apex:page controller="EmailfromCheks"> <apex:form > <apex:selectList value="{!Templates}" size="1"> <apex:selectOptions value="{!Items}"/> if i comment this line the page send the email <apex:actionSupport event="onchange" rerender="features"/> </apex:selectList> <apex:pageBlock > <apex:pageBlockTable value="{!OppLista}" var="c" id="table"> <apex:column > <!-- This is our selected Boolean property in our wrapper class --> <apex:inputCheckbox value="{!c.selected}"/> </apex:column> <!-- This is how we access the contact values within our cContact container/wrapper --> <apex:column value="{!c.Opp.Name}" /> <apex:column value="{!c.Opp.EmailContactoCurso__c }" /> </apex:pageBlockTable> </apex:pageBlock> <br /><br /> <apex:outputLabel value="Subject" for="Subject"/>:<br /> <apex:inputText value="{!subject}" id="Subject" maxlength="80"/> <br /><br /> <apex:outputLabel value="Body" for="Body"/>:<br /> <apex:inputTextarea value="{!body}" id="Body" rows="10" cols="80"/> <br /><br /><br /> <apex:commandButton value="Send Email" action="{!Send}" /> </apex:form> </apex:page>
In our sandbox environment this morning, I started noticing this error when running tests: UNKNOWN_EXCEPTION, Chatter Feed SOQL Query limit exceeded for this user.
There is nothing in the log output regarding Chatter Feed SOQL query limits, or anything to indicate we are approaching our limitations. We do not even have Chatter enabled in the sandbox.
Number of SOQL queries: 0 out of 100 Number of query rows: 0 out of 500 Number of SOSL queries: 0 out of 20 Number of DML statements: 3 out of 100 Number of DML rows: 4 out of 500 Number of script statements: 50 out of 200000 Maximum heap size: 0 out of 1500000 Number of callouts: 0 out of 10 Number of Email Invocations: 0 out of 10 Number of fields describes: 0 out of 10 Number of record type describes: 0 out of 10 Number of child relationships describes: 0 out of 10 Number of picklist describes: 0 out of 10 Number of future calls: 0 out of 10 Number of find similar calls: 0 out of 10 Number of System.runAs() invocations: 0 out of 20
