Hi,
I am trying to get data from salesforce using salesforce connector by
writing a proxy. I get the following error when i run the sequence/proxy:
[2015-08-18 14:06:31,815] INFO {SERVICE_LOGGER} - Connection = Login to
Salesforce .....
[2015-08-18 14:06:38,933] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500
ERROR_MESSAGE : Error in Sender
I have attached a sequence i have written for the above task.
What could be the reason for this? Please help.
Thanks in advance.
Regards,
M.R.Aaquibah Nashry
*Intern, Engineering**| **WSO2, Inc.*
Mobile : +94 773946123
Tel : +94 112662541
Email : [email protected] <[email protected]>
<?xml version="1.0" encoding="UTF-8"?>
<sequence xmlns="http://ws.apache.org/ns/synapse"; name="AccManagersSeq">
<salesforce.getUserInfo configKey="sf_auth"/>
<log>
<property name="STATE" value="Authentication success!!!"/>
</log>
<salesforce.query>
<batchSize>2000</batchSize>
<queryString>SELECT Id,AccountId, Project__c, Name,Owner.Name,OwnerId, Products_in_use__c,Amount,FiscalQuarter,FiscalYear,IsClosed,IsWon,Opp_End_Date__c,Opp_Start_Date__c,LeadSource,Services_Amount__c,Opportunity_Term__c,Production_Support_Amount__c,Includes_Consulting__c,Includes_Dev_Support__c,Includes_Production_Support__c,Includes_QuickStart__c,Probability,Reason_Lost__c,ForecastCategory,Last_Account_Sale__c,CurrencyIsoCode, CloseDate FROM Opportunity</queryString>
</salesforce.query>
<class name="org.wso2.carbon.solutions.sf.DateStamper"/>
<log>
<property name="STATE" value="Query success!!!"/>
</log>
<iterate xmlns:ns1="urn:partner.soap.sforce.com"
xmlns:ns="http://org.apache.synapse/xsd";
continueParent="true"
expression="$body/ns1:queryResponse/ns1:result/ns1:records"
sequential="true">
<target>
<sequence>
<dbreport>
<connection>
<pool>
<password>root</password>
<user>root</user>
<url>jdbc:mysql://localhost:3306/sf</url>
<driver>com.mysql.jdbc.Driver</driver>
</pool>
</connection>
<statement>
<sql>
insert into AMpipeline(Id,AccountId, Project__c, Name,OwnerName,OwnerId, Products_in_use__c,Amount,FiscalQuarter,FiscalYear,IsClosed,IsWon,Opp_End_Date__c,Opp_Start_Date__c,LeadSource,Services_Amount__c,Opportunity_Term__c,Production_Support_Amount__c,Includes_Consulting__c,Includes_Dev_Support__c,Includes_Production_Support__c,Includes_QuickStart__c,Probability,Reason_Lost__c,ForecastCategory,Last_Account_Sale__c,Currency_code, CloseDate,RecordDate) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) </sql>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Id/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:AccountId/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Project__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Name/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:OwnerName/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:OwnerId/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Products_in_use__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Amount/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:FiscalQuarter/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:FiscalYear/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:IsClosed/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:IsWon/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Opp_End_Date__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Opp_Start_Date__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:LeadSource/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Services_Amount__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Opportunity_Term__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Production_Support_Amount__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Includes_Consulting__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Includes_Dev_Support__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Includes_Production_Support__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Includes_QuickStart__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Probability/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Reason_Lost__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:ForecastCategory/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:Last_Account_Sale__c/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:CurrencyIsoCode/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:CloseDate/text()"
type="VARCHAR"/>
<parameter xmlns:nsa="urn:sobject.partner.soap.sforce.com"
xmlns:nsb="urn:partner.soap.sforce.com"
expression="$body/nsb:records/nsa:RecordDate/text()"
type="VARCHAR"/>
</statement>
</dbreport>
<log>
<property name="STATE" value="db report success!!!"/>
</log>
</sequence>
</target>
</iterate>
<log>
<property name="STATE" value="finished 3rd query"/>
</log>
<sequence key="sf_response_seq"/>
<sequence key="fault"/>
</sequence>
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
