Hi, 1) I couldn't find the line to enable wire logs in my log4j file. Is it okay if i add the line to it? (log4j.logger.org.apache.synapse.transport.http.wire=DEBUG)
2) My init config is in the sequence *sf_auth* as below: <salesforce.init xmlns="http://ws.apache.org/ns/synapse";> <username>[email protected]</username> <password>p1ne@pplelrY5ZpMQVqPyPramkfIdKDYE6</password> <loginUrl>https://login.salesforce.com/services/Soap/u/27.0</loginUrl> </salesforce.init> 3) When i added the logs, i find that error occurs at <salesforce.getUserInfo configKey="*sf_auth*"></salesforce.getUserInfo> The error logs are as follows: [2015-08-18 14:42:22,950] INFO {SERVICE_LOGGER} - To: , MessageID: urn:uuid:4ca4be55-4b42-4b9f-89c3-3fc4b534a1a2, Direction: request, STATE = Before sf_auth sequence [2015-08-18 14:42:22,958] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce ..... [2015-08-18 14:42:26,100] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached the sequence. Thanks Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : [email protected] <[email protected]> On Tue, Aug 18, 2015 at 2:30 PM, Malaka Silva <[email protected]> wrote: > Seems like an error when sending the message out. > > Can you put some logs in your mediation flow and identify with point it's > failing? > > Also enabling wire logs will also help to find the failing point. Also > share the salesfore.init config. > > > > On Tue, Aug 18, 2015 at 2:19 PM, Aaquibah Nashry <[email protected]> wrote: > >> 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]> >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > > Best Regards, > > Malaka Silva > Senior Tech Lead > M: +94 777 219 791 > Tel : 94 11 214 5345 > Fax :94 11 2145300 > Skype : malaka.sampath.silva > LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 > Blog : http://mrmalakasilva.blogspot.com/ > > WSO2, Inc. > lean . enterprise . middleware > http://www.wso2.com/ > http://www.wso2.com/about/team/malaka-silva/ > <http://wso2.com/about/team/malaka-silva/> > > Save a tree -Conserve nature & Save the world for your future. Print this > email only if it is absolutely necessary. >
<?xml version="1.0" encoding="UTF-8"?> <sequence xmlns="http://ws.apache.org/ns/synapse"; name="AccManagersSeq"> <log> <property name="STATE" value="Before sf_auth sequence"/> </log> <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
