Sign Up ›
  • Pannar
  • NEWBIE
  • 0 Points
  • Member since 2008
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 10
    Questions
  • 32
    Replies
0 replies

QUERY_TIMEOUT exception from weblogic java code

Hi,
 
I am querying contact object from salesforce thru java code. it might return 1lak records, so it is failing and shown the below exception and not fetched any records. it got stucked and doesn't return even a single record.
 

####<Dec 14, 2008 3:15:22 PM EST> <Warning> <WLW> <tfsny395sql> <cgServer> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <BEA1-2C4C0F3E04707E138162> <000000> <Id=sfdcCtrl; Method=com.tf.bsg.crm.sfdcCtrl.query(); Failure=com.bea.control.ServiceControlException: <xml-fragment xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sf="urn:fault.enterprise.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><faultcode>sf:QUERY_TIMEOUT</faultcode><faultstring>QUERY_TIMEOUT: Your query request was running for too long.</faultstring><detail><sf:fault xsi:type="sf:UnexpectedErrorFault" xmlns:sf="urn:fault.enterprise.soap.sforce.com"><sf:exceptionCode xmlns:sf="urn:fault.enterprise.soap.sforce.com">QUERY_TIMEOUT</sf:exceptionCode><sf:exceptionMessage xmlns:sf="urn:fault.enterprise.soap.sforce.com">Your query request was running for too long.</sf:exceptionMessage></sf:fault></detail></xml-fragment>>

 

Any thoughts how to resolve this issue.

 

thanks

pannar

  • December 16, 2008
  • Like
  • 0
2 replies

how to avoid SFDC Query time out exception

Hi,
 
I am querying contact object from salesforce thru java code. it might return 1lak records, so it is failing and shown the below exception and not fetched any records. it got stucked and doesn't return even a single record.
 

####<Dec 14, 2008 3:15:22 PM EST> <Warning> <WLW> <tfsny395sql> <cgServer> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <BEA1-2C4C0F3E04707E138162> <000000> <Id=sfdcCtrl; Method=com.tf.bsg.crm.sfdcCtrl.query(); Failure=com.bea.control.ServiceControlException: <xml-fragment xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sf="urn:fault.enterprise.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><faultcode>sf:QUERY_TIMEOUT</faultcode><faultstring>QUERY_TIMEOUT: Your query request was running for too long.</faultstring><detail><sf:fault xsi:type="sf:UnexpectedErrorFault" xmlns:sf="urn:fault.enterprise.soap.sforce.com"><sf:exceptionCode xmlns:sf="urn:fault.enterprise.soap.sforce.com">QUERY_TIMEOUT</sf:exceptionCode><sf:exceptionMessage xmlns:sf="urn:fault.enterprise.soap.sforce.com">Your query request was running for too long.</sf:exceptionMessage></sf:fault></detail></xml-fragment>>

 

Any thoughts how to resolve this issue.

 

thanks

pannar

  • December 16, 2008
  • Like
  • 0
16 replies

unique oppotunity name check thru apex?

Hi,

If an opportunity is created for Account 123, opportunity name is Opportunity–123.  If another opportunity is created for Account 123, the system will return an error if the name of the opportunity is the same as one already in SFDC.

Is it possible?

  • December 09, 2008
  • Like
  • 0
0 replies

UNIQUE OPPORTUNITY NAMES check thru Validation rule?

Hi,

If an opportunity is created for Account 123, opportunity name is Opportunity–123.  If another opportunity is created for Account 123, the system will return an error if the name of the opportunity is the same as one already in SFDC.

Is it possible?

 

  • December 08, 2008
  • Like
  • 0
9 replies

Validation Rule - to check western characters?

Dear all,
 
Is there way to create the validation rule on the particula custom field Name(Text(255) under Opportunity object.
There should be a restriction in that particular field that it should only allow western characters. Is it possible?
 
please respond.
regards
pannar
  • December 05, 2008
  • Like
  • 0
5 replies

Validation Rule - to check western characters?

Hi,
 
Is there way to create the validation rule on the particula custom field Name(Text(255) under Opportunity object.
There should be a restriction in that particular field that it should only allow western characters. Is it possible?
 
please respond.
regards
pannar 
  • December 05, 2008
  • Like
  • 0
0 replies

Problem with special character thru weblogic

Hi,

I am facing very serious issue while querying the record from oracle table. One of the fields contains the special character as part of email value. I need to handle that value.

My part of databaseControl.JCS file looks like below:-

Code:
static public class ContactData
{
public int ROWNUMBER;
public int BATCH_NUMBER;
public String EMAIL;
public String LOCAL_FIRST_NAME;
public String LOCAL_LAST_NAME; 


}
/**
* @jc:sql rowset-name="contactData" statement="SELECT EMAIL FROM CONTACT WHERE ROWNUM < 51"
*/
ContactData[] getContactData();


 

Code:
my part of JPD file from where i am calling db method which query the records.

--------------------------------------------------------------------------------

/**
* @jpd:process process::
* <process name="loadContacts">
* <clientRequest name="Subscription" method="subscription"/>
* <perform name="Perform" method="CacheRecordType"/>
* <block name="Group">
* <onException name="OnException">
* <perform name="Perform" method="perform1"/>
* </onException>
* <doWhile name="Do While" condition="exprFunction0($rowsProcessed)">
* <perform name="Perform" method="perform"/>
* </doWhile>
* </block>
* </process>::
* @jpd:xquery prologue::
* 
* 
* 
* 
* define function exprFunction0(xs:int $rowsProcessed) returns xs:boolean {
* ($rowsProcessed <= 50) and 
* ($rowsProcessed != 0)
* }
* 
* ::
*/
public void perform() throws Exception
{

LoginResult loginResult=null;
String sforceId="";
SvcControl.ContactData[] contactData = null;
log.debug("Started Load Contact process=");


try{
log.debug("Started Load Contact process="+ SvcControl.getContactData().toString());
contactData = SvcControl.getContactData();
log.debug("Started Load Contact process="+ contactData.toString());
}catch(Exception e){
log.error("Caught exception:"+e.getMessage());
return;
}
if(contactData!=null){


 


I am calling this method call on my JPD file and trying to assign it to ContactData array variable. It is updating the records by batch of 50. The problem is that if suppose any one of the records returned the email with special characters(junk value) , it breaks the whole process, it is unable to continue updating the rest of the records!! :-(

Web logic thrown the following exception while triggering the jpd process:

 

Code:
External Service Request 
Submitted at Thu Dec 04 22:19:11 IST 2008
<SOAP-ENV:Envelope xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOAP-ENV:Body>
<ns:getContactData xmlns:ns="http://www.openuri.org/"></ns:getContactData>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>


External Service Response 
Submitted at Thu Dec 04 15:20:51 IST 2008

<xml-fragment xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:fc="http://www.bea.com/2003/04/jwFaultCode/" xmlns:jwErr="http://www.bea.com/2002/04/jwErrorDetail/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> 

<faultcode xmlns:fc="http://www.bea.com/2003/04/jwFaultCode/">fc:JWSError</faultcode>

<faultstring>
com.bea.xml.marshal.XmlEncodingException: Error writing XML stream: com.bea.xml.pure.XMLStreamException: Unable to write XML string starting with m@debeauvaisfinance.com. It contains the illegal XML char 0x0013 at offset 23
</faultstring>

<detail> 

<jwErr:jwErrorDetail xmlns:jwErr="http://www.bea.com/2002/04/jwErrorDetail/">
com.bea.wlw.runtime.core.request.ResponseValidationException: com.bea.xml.marshal.XmlEncodingException: Error writing XML stream: com.bea.xml.pure.XMLStreamException: Unable to write XML string starting with m@debeauvaisfinance.com. It contains the illegal XML char 0x0013 at offset 23 ServiceException
at com.bea.wlw.runtime.jws.request.SoapResponse.processException(Ljava.lang.Exception;)Ljava.lang.Exception;(SoapResponse.java:194)
at com.bea.wlw.runtime.core.request.BaseResponse.setFault(Ljava.lang.Exception;)V(BaseResponse.java:23)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.runAsInvoke(Lcom.bea.wlw.runtime.core.request.Request;)Lcom.bea.wlw.runtime.core.request.Response;(BaseDispatcherBean.java:298)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.invoke(Lcom.bea.wlw.runtime.core.request.Request;)Lcom.bea.wlw.runtime.core.request.Response;(BaseDispatcherBean.java:54)
at com.bea.wlw.runtime.core.bean.SyncDispatcherBean.invoke(Lcom.bea.wlw.runtime.core.request.Request;)Lcom.bea.wlw.runtime.core.request.Response;(SyncDispatcherBean.java:168)
at com.bea.wlw.runtime.core.bean.SyncDispatcher_k1mrl8_EOImpl.invoke(Lcom.bea.wlw.runtime.core.request.Request;)Lcom.bea.wlw.runtime.core.request.Response;(SyncDispatcher_k1mrl8_EOImpl.java:100)
at com.bea.wlw.runtime.core.dispatcher.Dispatcher.remoteDispatch(Lcom.bea.wlw.runtime.core.dispatcher.DispFile;Lcom.bea.wlw.runtime.core.request.Request;)Lcom.bea.wlw.runtime.core.request.Response;(Dispatcher.java:161)
at com.bea.wlw.runtime.core.dispatcher.Dispatcher.dispatch(Lcom.bea.wlw.runtime.core.dispatcher.DispFile;Lcom.bea.wlw.runtime.core.request.Request;Ljavax.servlet.http.HttpServletResponse;Ljavax.servlet.ServletContext;)V(Dispatcher.java:49)
at com.bea.wlw.runtime.core.dispatcher.HttpServerHelper.executePostRequest(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Ljavax.servlet.ServletContext;Ljavax.servlet.ServletConfig;)V(HttpServerHelper.java:713)
at com.bea.wlw.runtime.core.dispatcher.HttpServer.doPost(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(HttpServer.java:49)
at javax.servlet.http.HttpServlet.service(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run()Ljava.lang.Object;(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Lweblogic.servlet.internal.FilterChainImpl;)V(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run()Ljava.lang.Object;(WebAppServletContext.java:6722)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Lweblogic.security.subject.AbstractSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Lweblogic.security.acl.internal.AuthenticatedSubject;Lweblogic.security.acl.internal.AuthenticatedSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(Lweblogic.servlet.internal.ServletRequestImpl;Lweblogic.servlet.internal.ServletResponseImpl;)V(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execute(Lweblogic.kernel.ExecuteThread;)V(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(Lweblogic.kernel.ExecuteRequest;)V(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run()V(ExecuteThread.java:178)
at java.lang.Thread.startThreadFromVM(Ljava.lang.Thread;)V(Unknown Source)
Caused by: com.bea.wlw.runtime.core.request.ResponseValidationException: com.bea.xml.marshal.XmlEncodingException: Error writing XML stream: com.bea.xml.pure.XMLStreamException: Unable to write XML string starting with m@debeauvaisfinance.com. It contains the illegal XML char 0x0013 at offset 23
at com.bea.wlw.runtime.jws.request.SoapResponse.setReturnValue(Ljava.lang.Object;)V(SoapResponse.java:112)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.runAsInvoke(Lcom.bea.wlw.runtime.core.request.Request;)Lcom.bea.wlw.runtime.core.request.Response;(BaseDispatcherBean.java:259)
... 20 more
Caused by: com.bea.xml.marshal.XmlEncodingException: Error writing XML stream: com.bea.xml.pure.XMLStreamException: Unable to write XML string starting with m@debeauvaisfinance.com. It contains the illegal XML char 0x0013 at offset 23
at com.bea.xml.marshal.MarshalContext.error(Ljava.lang.String;)Lcom.bea.xml.marshal.XmlEncodingException;(MarshalContext.java:148)
at com.bea.xml.marshal.MarshalContext.writeCharacterData(Ljava.lang.String;)V(MarshalContext.java:186)
at com.bea.xml.marshal.AtomicValueMPlan.marshal(Ljava.lang.Object;Lcom.bea.xml.marshal.MarshalContext;)V(AtomicValueMPlan.java:79)
at com.bea.xml.marshal.MarshalContext.writeElementObjectOrHref(Ljavax.xml.namespace.QName;Ljava.lang.Object;Lcom.bea.xml.marshal.MarshalPlan;ZZ)V(MarshalContext.java:436)
at com.bea.xml.marshal.BaseMPlan.writeValueUsingStrategy(Ljava.lang.Object;Lcom.bea.xml.marshal.BaseMPlan$ElementStrategy;Lcom.bea.xml.marshal.MarshalContext;)V(BaseMPlan.java:307)
at com.bea.xml.marshal.BaseMPlan.marshal(Ljava.lang.Object;Lcom.bea.xml.marshal.MarshalContext;)V(BaseMPlan.java:349)
at com.bea.xml.marshal.MarshalContext.writeElementObjectOrHref(Ljavax.xml.namespace.QName;Ljava.lang.Object;Lcom.bea.xml.marshal.MarshalPlan;ZZ)V(MarshalContext.java:436)
at com.bea.xml.marshal.ArrayMPlan.marshal(Ljava.lang.Object;Lcom.bea.xml.marshal.MarshalContext;)V(ArrayMPlan.java:122)
at com.bea.xml.marshal.MarshalContext.writeElementObjectOrHref(Ljavax.xml.namespace.QName;Ljava.lang.Object;Lcom.bea.xml.marshal.MarshalPlan;ZZ)V(MarshalContext.java:436)
at com.bea.xml.marshal.BaseMPlan.writeValueUsingStrategy(Ljava.lang.Object;Lcom.bea.xml.marshal.BaseMPlan$ElementStrategy;Lcom.bea.xml.marshal.MarshalContext;)V(BaseMPlan.java:307)
at com.bea.xml.marshal.BaseMPlan.marshal(Ljava.lang.Object;Lcom.bea.xml.marshal.MarshalContext;)V(BaseMPlan.java:349)
at com.bea.xml.marshal.MethodMPlan.marshal(Ljava.lang.Object;Lcom.bea.xml.marshal.MarshalContext;)V(MethodMPlan.java:261)
at com.bea.wlw.runtime.core.dispatcher.DispMessage.marshalXml([Ljava.lang.Object;Ljavax.xml.soap.SOAPMessage;Lcom.bea.jws.Protocol;Ljava.util.Map;)Ljava.lang.String;(DispMessage.java:377)
at com.bea.wlw.runtime.jws.request.SoapResponse.writePart(Lcom.bea.wlw.runtime.core.dispatcher.DispMessage;[Ljava.lang.Object;)V(SoapResponse.java:339)
at com.bea.wlw.runtime.jws.request.SoapResponse.setReturnValue(Ljava.lang.Object;)V(SoapResponse.java:107)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.runAsInvoke(Lcom.bea.wlw.runtime.core.request.Request;)Lcom.bea.wlw.runtime.core.request.Response;(BaseDispatcherBean.java:259)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.invoke(Lcom.bea.wlw.runtime.core.request.Request;)Lcom.bea.wlw.runtime.core.request.Response;(BaseDispatcherBean.java:54)
at com.bea.wlw.runtime.core.bean.SyncDispatcherBean.invoke(Lcom.bea.wlw.runtime.core.request.Request;)Lcom.bea.wlw.runtime.core.request.Response;(SyncDispatcherBean.java:168)
at com.bea.wlw.runtime.core.bean.SyncDispatcher_k1mrl8_EOImpl.invoke(Lcom.bea.wlw.runtime.core.request.Request;)Lcom.bea.wlw.runtime.core.request.Response;(SyncDispatcher_k1mrl8_EOImpl.java:100)
at com.bea.wlw.runtime.core.dispatcher.Dispatcher.remoteDispatch(Lcom.bea.wlw.runtime.core.dispatcher.DispFile;Lcom.bea.wlw.runtime.core.request.Request;)Lcom.bea.wlw.runtime.core.request.Response;(Dispatcher.java:161)
at com.bea.wlw.runtime.core.dispatcher.Dispatcher.dispatch(Lcom.bea.wlw.runtime.core.dispatcher.DispFile;Lcom.bea.wlw.runtime.core.request.Request;Ljavax.servlet.http.HttpServletResponse;Ljavax.servlet.ServletContext;)V(Dispatcher.java:49)
at com.bea.wlw.runtime.core.dispatcher.HttpServerHelper.executePostRequest(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Ljavax.servlet.ServletContext;Ljavax.servlet.ServletConfig;)V(HttpServerHelper.java:713)
at com.bea.wlw.runtime.core.dispatcher.HttpServer.doPost(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(HttpServer.java:49)
at javax.servlet.http.HttpServlet.service(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run()Ljava.lang.Object;(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Lweblogic.servlet.internal.FilterChainImpl;)V(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run()Ljava.lang.Object;(WebAppServletContext.java:6722)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Lweblogic.security.subject.AbstractSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Lweblogic.security.acl.internal.AuthenticatedSubject;Lweblogic.security.acl.internal.AuthenticatedSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(Lweblogic.servlet.internal.ServletRequestImpl;Lweblogic.servlet.internal.ServletResponseImpl;)V(WebAppServletContext.java:3764)

</jwErr:jwErrorDetail>

</detail>

</xml-fragment>


 

Anyone has any thoughts on this? I had set the charset as "iso-8859-1" in almost all the related weblogic script and xml files. but no progress! still getting the same exception. please guide me how to resolve this issue?

thanks

  • December 04, 2008
  • Like
  • 0
1 replies

Question on field updates! plz answer

Dear all,

I would like to know if it is possible to determine what fields were modified by a user when saving an object in Salesforce.  For example, a user accesses the Account object and updates the Description and Customer Group values.  When they click Save, can that action be captured and those 2 fields identified as modified for further processing in an easy fashion?

Thanks in advance
Pannar
  • November 27, 2008
  • Like
  • 0
0 replies

Question on Field updates? :-)

Dear all,

I would like to know if it is possible to determine what fields were modified by a user when saving an object in Salesforce.  For example, a user accesses the Account object and updates the Description and Customer Group values.  When they click Save, can that action be captured and those 2 fields identified as modified for further processing in an easy fashion?

Thanks in advance
Pannar
  • November 27, 2008
  • Like
  • 0
10 replies

Question on Field Level Updates

Dear all,

I would like to know if it is possible to determine what fields were modified by a user when saving an object in Salesforce.  For example, a user accesses the Account object and updates the Description and Customer Group values.  When they click Save, can that action be captured and those 2 fields identified as modified for further processing in an easy fashion?

Thanks in advance
Pannar


Message Edited by Pannar on 11-27-2008 03:21 AM
  • November 27, 2008
  • Like
  • 0
2 replies

how to avoid SFDC Query time out exception

Hi,
 
I am querying contact object from salesforce thru java code. it might return 1lak records, so it is failing and shown the below exception and not fetched any records. it got stucked and doesn't return even a single record.
 

####<Dec 14, 2008 3:15:22 PM EST> <Warning> <WLW> <tfsny395sql> <cgServer> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <BEA1-2C4C0F3E04707E138162> <000000> <Id=sfdcCtrl; Method=com.tf.bsg.crm.sfdcCtrl.query(); Failure=com.bea.control.ServiceControlException: <xml-fragment xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sf="urn:fault.enterprise.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><faultcode>sf:QUERY_TIMEOUT</faultcode><faultstring>QUERY_TIMEOUT: Your query request was running for too long.</faultstring><detail><sf:fault xsi:type="sf:UnexpectedErrorFault" xmlns:sf="urn:fault.enterprise.soap.sforce.com"><sf:exceptionCode xmlns:sf="urn:fault.enterprise.soap.sforce.com">QUERY_TIMEOUT</sf:exceptionCode><sf:exceptionMessage xmlns:sf="urn:fault.enterprise.soap.sforce.com">Your query request was running for too long.</sf:exceptionMessage></sf:fault></detail></xml-fragment>>

 

Any thoughts how to resolve this issue.

 

thanks

pannar

  • December 16, 2008
  • Like
  • 0
16 replies

unique oppotunity name check thru apex?

Hi,

If an opportunity is created for Account 123, opportunity name is Opportunity–123.  If another opportunity is created for Account 123, the system will return an error if the name of the opportunity is the same as one already in SFDC.

Is it possible?

  • December 09, 2008
  • Like
  • 0
9 replies

Validation Rule - to check western characters?

Dear all,
 
Is there way to create the validation rule on the particula custom field Name(Text(255) under Opportunity object.
There should be a restriction in that particular field that it should only allow western characters. Is it possible?
 
please respond.
regards
pannar
  • December 05, 2008
  • Like
  • 0
5 replies

Validation Rule - to check western characters?

Hi,
 
Is there way to create the validation rule on the particula custom field Name(Text(255) under Opportunity object.
There should be a restriction in that particular field that it should only allow western characters. Is it possible?
 
please respond.
regards
pannar 
  • December 05, 2008
  • Like
  • 0
6 replies

Intermittent Query_Timeout error

I've been reading through messages, and I haven't seen this question asked yet.
 
We've been running 2 S-Controls for a couple years now without issue. The control grabs the ID of the current account and then retrieves the related row from a custom object using that ID.  Lately, I have users complaining that the query is timing out. 
 
Strange thing is, I can't replicate the timeout on my machine.  I've seen it happen on their machines, but if I get a call about the timeout I immediately go in and try the same account without error. 
 
Am I just that lucky?    Any ideas as to what's going on?
  • July 10, 2008
  • Like
  • 0
45 replies

How to access APEX classes

I am new to APEX classes and have a few questions.  I posted once in the PHP forums to try and find a solution, but the answers were not clear

1)  If I create an APEX class can I access this from an external server/system or set of scripts that I write?  The script can be written in any language: PHP, Perl, etc....
2) Once I create the class and generate the WSDL from the class, do I download it and then use this like I do the Partner WSDL file


Any help or guidance would be appreciated.

I hope this is not too generic to answer my questions

Thanks,
Mike
11 replies

QUERY_TIMEOUT

Hi,

I keep get "QUERY_TIMEOUT: Your query request was running for too long." when do query. Can anybody help....

sq
14 replies

[PHP] The always popular "Invalid byte 1 of 1-byte UTF-8 sequence." problem

*** UPDATE 4 Feb 2005: It appears that one field was not having the utf8_encode function applied to it. Stupid error; you may now all point and laugh.



Greetings all; I recently had to code up a mechanism to insert/select cases into Salesforce via the SOAP API. Built everything up fine and began testing; eventually, some of the test cases included accented characters (umlauts, etc. e.g., ö). In these test cases, the insert call failed with the error message "java.io.UTFDataFormatException: Invalid byte 1 of 1-byte UTF-8 sequence."

Having encountered this problem before, I scoured my archives and reminded myself that the text should be passed through utf8_encode() before making the SOAP call. No problem then; I wrapped each text item with a utf8_encode() call.

However, the problem still persists even after using utf8_encode(); now, the accented characters are being passed as values that look like garbage (e.g., �?¼). The same error message is returned from the SOAP call; scoping the wire shows that the SOAP headers are set to UTF-8 encoding.

Pretty stumped at this point; any help would be appreciated. Server details follows:

* Fedora Core 2
* Apache 2.0.51-2.7
* PHP 4.3.8 (cgi)
* PEAR::SOAP 0.8RC3
* Latest Salesforce client from Sourceforge

Cheers.

Message Edited by sprak on 02-04-2005 10:04 AM

  • January 31, 2005
  • Like
  • 0
5 replies

Query Timeout vs. Network Timeout

I just ran a query (using sforce Explorer .NET version) for "select Id from AccountShare". This was for a large customer with nearly 2 million AccountShare records.

I did not receive a query timeout. I received a network timeout. I also tried the same thing with the API and confirmed that it is a network timeout by increasing the Timeout in the web service binding.

Is this the expected behavior? Under which circumstances should I expect a query timeout vs. a network timeout?