You need to sign in to do that
Don't have an account?
dong
SOQL query error about this field "product_family__c"
Hi All,
I met a SOQL query error , Who could tell me why?
The case is , I can retrieve data from sforce explore by the following SOQL :
select case.owner.name, case.owner.userRole.name ,subject, status ,origin ,reason,
caseNumber,product_family__c,createdDate from case limit 20
caseNumber,product_family__c,createdDate from case limit 20
So , I use the following code to send my query.
QueryResult qr =
binding.query(
"select case.owner.name, case.owner.userRole.name ,subject, status ,origin ,reason, " +
"caseNumber,product_family__c,createdDate from case limit 20 ");
binding.query(
"select case.owner.name, case.owner.userRole.name ,subject, status ,origin ,reason, " +
"caseNumber,product_family__c,createdDate from case limit 20 ");
However, the error message is :
Exception:
org.xml.sax.SAXException: Invalid element in com.sforce.soap.enterprise.sobject._case - Product_Family__c
at org.apache.axis.encoding.ser.BeanDeserializer.onStartChild(BeanDeserializer.java:258)
at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)
at org.apache.axis.message.SAX2EventRecorder.replay(SAX2EventRecorder.java:165)
at org.apache.axis.message.MessageElement.publishToHandler(MessageElement.java:1141)
at org.apache.axis.message.RPCElement.deserialize(RPCElement.java:236)
at org.apache.axis.message.RPCElement.getParams(RPCElement.java:384)
at org.apache.axis.client.Call.invoke(Call.java:2467)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.sforce.soap.enterprise.SoapBindingStub.query(SoapBindingStub.java:3222)
at org.salesforce.quickstart.Samples.querySample(Samples.java:287)
at org.salesforce.quickstart.Samples.run(Samples.java:343)
at org.salesforce.quickstart.Samples.main(Samples.java:38)
Exception in thread "main" AxisFault
...................................................................................................................................................................
org.xml.sax.SAXException: Invalid element in com.sforce.soap.enterprise.sobject._case - Product_Family__c
at org.apache.axis.encoding.ser.BeanDeserializer.onStartChild(BeanDeserializer.java:258)
at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)
at org.apache.axis.message.SAX2EventRecorder.replay(SAX2EventRecorder.java:165)
at org.apache.axis.message.MessageElement.publishToHandler(MessageElement.java:1141)
at org.apache.axis.message.RPCElement.deserialize(RPCElement.java:236)
at org.apache.axis.message.RPCElement.getParams(RPCElement.java:384)
at org.apache.axis.client.Call.invoke(Call.java:2467)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.sforce.soap.enterprise.SoapBindingStub.query(SoapBindingStub.java:3222)
at org.salesforce.quickstart.Samples.querySample(Samples.java:287)
at org.salesforce.quickstart.Samples.run(Samples.java:343)
at org.salesforce.quickstart.Samples.main(Samples.java:38)
Exception in thread "main" AxisFault
...................................................................................................................................................................
If I delete Product_Family__c in my SOQL, the query is OK. So what shall I do if I still want to get Product_Family__c field's value back from salesforce?
1. The code web service API is not updated.
2. The profile executing the code does not have the permission to access "product_family__c".
http://wiki.apexdevnet.com/index.php/Web_Services_API#Java
I highly recommand you to spend quality time to grasp fundamental concept. As you progress to other technical stuff, these concept are essential to your own success.