Hi Malaka,
Also are you using latest ESB?
>
Yes it's, ESB 5.0 and tooling.
Maybe issue is related to TLS version?
Don't know, whether it have an effect, because it didn't work before they
have update to the new version.
I have attached the wire log, after invoking the query, it's basically not
responding.
Thanks,
Chanuka.
On Fri, Jan 13, 2017 at 8:16 PM, Malaka Silva <mal...@wso2.com> wrote:
> Hi Chanuka,
>
> Since we are simple invoking the api it should work.
>
> Can you share wire logs for further investigation.
>
> Also are you using latest ESB? Maybe issue is related to TLS version? [1]
>
> [1] https://help.salesforce.com/servlet/servlet.FileDownload?file=
> 0150M000003KgGkQAK
>
> +Dev List
> ---------- Forwarded message ----------
> From: Chanuka Dissanayake <chan...@wso2.com>
> Date: Fri, Jan 13, 2017 at 6:53 PM
> Subject: Salesforce connector supports for complex queries
> To: kesavany Yogarajah <kesav...@wso2.com>, Keerthika Mahendralingam <
> keerth...@wso2.com>
> Cc: Malaka Silva <mal...@wso2.com>, Shevan Goonetilleke <she...@wso2.com>,
> Yasith Tharindu <yas...@wso2.com>, Suhan Dharmasuriya <suh...@wso2.com>,
> Nirodha Pramod <niro...@wso2.com>
>
>
> Hi Kesavan,
>
> I have come across that, when querying data from Salesforce connector it
> does not retrieving the data, instead it kept waiting. Have you done
> anything related to $subject?. Following is the query which is not working
> through the connector.
>
> SELECT Id,Contact_Us_First_Submission_Date__c FROM Lead WHERE Status !=
> 'Disqualified' AND Participant_Type__c != 'Partner' AND Participant_Type__c
> != 'Other' AND Contact_Us_First_Submission_Date__c != Null
> Regards,
> Chanuka.
> --
> Chanuka Dissanayake
> *Software Engineer | **WSO2 Inc.*; http://wso2.com
>
> Mobile: +94 71 33 63 596
> Email: chan...@wso2.com
>
>
>
> --
>
> Best Regards,
>
> Malaka Silva
> Senior Technical Lead
> M: +94 777 219 791 <+94%2077%20721%209791>
> 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
> https://wso2.com/signature
> http://www.wso2.com/about/team/malaka-silva/
> <http://wso2.com/about/team/malaka-silva/>
> https://store.wso2.com/store/
>
> Don't make Trees rare, we should keep them with care
>
--
Chanuka Dissanayake
*Software Engineer | **WSO2 Inc.*; http://wso2.com
Mobile: +94 71 33 63 596
Email: chan...@wso2.com
[2017-01-14 10:09:19,187] DEBUG - content >> "92[\r][\n]"
[2017-01-14 10:09:19,189] DEBUG - content >> "<?xml version='1.0' encoding='UTF-8'?><soapenv:Envelope xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope";><soapenv:Body/></soapenv:Envelope>"
[2017-01-14 10:09:19,189] DEBUG - content >> "[\r][\n]"
[2017-01-14 10:09:19,189] DEBUG - content >> "0"
[2017-01-14 10:09:19,189] DEBUG - content >> "[\r][\n]"
[2017-01-14 10:09:19,190] DEBUG - content >> "[\r][\n]"
[2017-01-14 10:09:19,206] DEBUG - wire HTTP-Listener I/O dispatcher-1 >> "POST /services/SF_Lead_Proxy.SF_Lead_ProxyHttpSoap12Endpoint HTTP/1.1[\r][\n]"
[2017-01-14 10:09:19,206] DEBUG - wire HTTP-Listener I/O dispatcher-1 >> "Content-Type: application/soap+xml; charset=UTF-8; action="urn:mediate"[\r][\n]"
[2017-01-14 10:09:19,207] DEBUG - wire HTTP-Listener I/O dispatcher-1 >> "Cookie: menuPanel=visible; menuPanelType=main; region1_configure_menu=none; region3_registry_menu=none; region4_monitor_menu=none; region5_tools_menu=none; requestedURI=../../carbon/admin/index.jsp; JSESSIONID=70F5257D70D954AE9040F55DB9567251; current-breadcrumb=manage_menu%2Cservices_menu%2Cservices_list_menu%23[\r][\n]"
[2017-01-14 10:09:19,207] DEBUG - wire HTTP-Listener I/O dispatcher-1 >> "User-Agent: Axis2[\r][\n]"
[2017-01-14 10:09:19,207] DEBUG - wire HTTP-Listener I/O dispatcher-1 >> "Host: cio-dashboard-dev-nirodha2:8290[\r][\n]"
[2017-01-14 10:09:19,207] DEBUG - wire HTTP-Listener I/O dispatcher-1 >> "Transfer-Encoding: chunked[\r][\n]"
[2017-01-14 10:09:19,208] DEBUG - wire HTTP-Listener I/O dispatcher-1 >> "[\r][\n]"
[2017-01-14 10:09:19,208] DEBUG - wire HTTP-Listener I/O dispatcher-1 >> "92[\r][\n]"
[2017-01-14 10:09:19,208] DEBUG - wire HTTP-Listener I/O dispatcher-1 >> "<?xml version='1.0' encoding='UTF-8'?><soapenv:Envelope xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope";><soapenv:Body/></soapenv:Envelope>[\r][\n]"
[2017-01-14 10:09:19,208] DEBUG - wire HTTP-Listener I/O dispatcher-1 >> "0[\r][\n]"
[2017-01-14 10:09:19,209] DEBUG - wire HTTP-Listener I/O dispatcher-1 >> "[\r][\n]"
[2017-01-14 10:09:19,290] INFO - ModuleDeployer Deploying module: addressing-1.6.1-wso2v19 - file:/home/ubuntu/unifiedDashboards_ESB/wso2esb-5.0.0/./repository/deployment/client/modules/addressing-1.6.1-wso2v19.mar
[2017-01-14 10:09:19,295] INFO - ModuleDeployer Deploying module: rampart-1.6.1-wso2v18 - file:/home/ubuntu/unifiedDashboards_ESB/wso2esb-5.0.0/./repository/deployment/client/modules/rampart-1.6.1-wso2v18.mar
[2017-01-14 10:09:19,310] INFO - MailTransportSender MAILTO Sender started
[2017-01-14 10:09:19,323] INFO - JMSSender JMS Sender started
[2017-01-14 10:09:19,324] INFO - JMSSender JMS Transport Sender initialized...
[2017-01-14 10:09:19,346] INFO - ModuleDeployer Deploying module: addressing-1.6.1-wso2v19 - file:/home/ubuntu/unifiedDashboards_ESB/wso2esb-5.0.0/./repository/deployment/client/modules/addressing-1.6.1-wso2v19.mar
[2017-01-14 10:09:19,350] INFO - ModuleDeployer Deploying module: rampart-1.6.1-wso2v18 - file:/home/ubuntu/unifiedDashboards_ESB/wso2esb-5.0.0/./repository/deployment/client/modules/rampart-1.6.1-wso2v18.mar
[2017-01-14 10:09:19,360] INFO - MailTransportSender MAILTO Sender started
[2017-01-14 10:09:19,362] INFO - JMSSender JMS Sender started
[2017-01-14 10:09:19,362] INFO - JMSSender JMS Transport Sender initialized...
[2017-01-14 10:09:19,400] INFO - LogMediator Connection = Login to Salesforce .....
[2017-01-14 10:09:19,947] DEBUG - content >> "<?xml version='1.0' encoding='UTF-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:urn="urn:partner.soap.sforce.com"><soapenv:Body><urn:login><urn:username>integration-sfsha...@wso2.com</urn:username><urn:password>What3verqRtGa9ptSq684gjkiLjTSK32L</urn:password></urn:login></soapenv:Body></soapenv:Envelope>"
[2017-01-14 10:09:20,603] DEBUG - content << "<"
[2017-01-14 10:09:20,603] DEBUG - content << "?xm"
[2017-01-14 10:09:20,604] DEBUG - content << "l version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; xmlns="urn:partner.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><soapenv:Body><loginResponse><result><metadataServerUrl>https://wso2.my.salesforce.com/services/Soap/m/36.0/00DE0000000I8Cv</metadataServerUrl><passwordExpired>false</passwordExpired><sandbox>false</sandbox><serverUrl>https://wso2.my.salesforce.com/services/Soap/u/36.0/00DE0000000I8Cv</serverUrl><sessionId>00DE0000000I8Cv!ASAAQBJ2Nu5HtZFHeiADCogBLFwfa1Vfy0yFnujhGQEcOXvx8woN0V7bGuPpKdg3YkVOFkMgCL.b4kK84zbMsh7zgtxlwrzy</sessionId><userId>005E0000007k1SgIAI</userId><userInfo><accessibilityMode>false</accessibilityMode><currencySymbol xsi:nil="true"/><orgAttachmentFileSizeLimit>5242880</orgAttachmentFileSizeLimit><orgDefaultCurrencyIsoCode xsi:nil="true"/><orgDisallowHtmlAttachments>false</orgDisallowHtmlAttachments><orgHasPersonAccounts>false</orgHasPersonAccounts><organizationId>00DE0000000I8CvMAK</or"
[2017-01-14 10:09:20,606] DEBUG - content << "ganizationId><organizationMultiCurrency>true</organizationMultiCurrency><organizationName>WSO2</organizationName><profileId>00eE0000000h3wcIAA</profileId><roleId>00EE00000011qmIMAQ</roleId><sessionSecondsValid>28800</sessionSecondsValid><userDefaultCurrencyIsoCode>USD</userDefaultCurrencyIsoCode><userEmail>chan...@wso2.com</userEmail><userFullName>Chanuka Dissanayake</userFullName><userId>005E0000007k1SgIAI</userId><userLanguage>en_US</userLanguage><userLocale>en_US</userLocale><userName>integration-sfsha...@wso2.com</userName><userTimeZone>Asia/Colombo</userTimeZone><userType>Standard</userType><userUiSkin>Theme3</userUiSkin></userInfo></result></loginResponse></soapenv:Body></soapenv:Envelope>"
[2017-01-14 10:09:22,223] DEBUG - content >> "<?xml version='1.0' encoding='UTF-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:urn="urn:partner.soap.sforce.com"><soapenv:Header><urn:QueryOptions><urn:batchSize>10</urn:batchSize></urn:QueryOptions><urn:SessionHeader><urn:sessionId>00DE0000000I8Cv!ASAAQBJ2Nu5HtZFHeiADCogBLFwfa1Vfy0yFnujhGQEcOXvx8woN0V7bGuPpKdg3YkVOFkMgCL.b4kK84zbMsh7zgtxlwrzy</urn:sessionId></urn:SessionHeader></soapenv:Header><soapenv:Body><urn:query><urn:queryString>Id,SELECT Contact_Us_First_Submission_Date__c FROM Lead WHERE Status != 'Disqualified' AND Participant_Type__c != 'Partner' AND Participant_Type__c != 'Other' AND Contact_Us_First_Submission_Date__c != Null</urn:queryString></urn:query></soapenv:Body></soapenv:Envelope>"
[2017-01-14 10:09:22,511] DEBUG - content << "2"
[2017-01-14 10:09:22,512] DEBUG - content << "8"
[2017-01-14 10:09:22,512] DEBUG - content << "E"
[2017-01-14 10:09:22,512] DEBUG - content << "[\r]"
[2017-01-14 10:09:22,512] DEBUG - content << "[\n]"
[2017-01-14 10:09:22,512] DEBUG - content << "<"
[2017-01-14 10:09:22,513] DEBUG - content << "?xm"
[2017-01-14 10:09:22,513] DEBUG - content << "l version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:sf="urn:fault.partner.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><soapenv:Body><soapenv:Fault><faultcode>sf:MALFORMED_QUERY</faultcode><faultstring>MALFORMED_QUERY: unexpected token: Id</faultstring><detail><sf:MalformedQueryFault xsi:type="sf:MalformedQueryFault"><sf:exceptionCode>MALFORMED_QUERY</sf:exceptionCode><sf:exceptionMessage>unexpected token: Id</sf:exceptionMessage><sf:row>1</sf:row><sf:column>0</sf:column></sf:MalformedQueryFault></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>"
[2017-01-14 10:09:22,561] DEBUG - content << "0"
[2017-01-14 10:09:22,562] DEBUG - content << "[\r]"
[2017-01-14 10:09:22,562] DEBUG - content << "[\n]"
[2017-01-14 10:09:22,562] DEBUG - content << "[\r]"
[2017-01-14 10:09:22,561] DEBUG - wire HTTP-Listener I/O dispatcher-1 << "HTTP/1.1 202 Accepted[\r][\n]"
[2017-01-14 10:09:22,563] DEBUG - wire HTTP-Listener I/O dispatcher-1 << "Date: Sat, 14 Jan 2017 04:39:22 GMT[\r][\n]"
[2017-01-14 10:09:22,568] DEBUG - wire HTTP-Listener I/O dispatcher-1 << "Transfer-Encoding: chunked[\r][\n]"
[2017-01-14 10:09:22,562] DEBUG - content << "[\n]"
[2017-01-14 10:09:22,569] DEBUG - wire HTTP-Listener I/O dispatcher-1 << "[\r][\n]"
[2017-01-14 10:09:22,569] DEBUG - wire HTTP-Listener I/O dispatcher-1 << "0[\r][\n]"
[2017-01-14 10:09:22,570] DEBUG - wire HTTP-Listener I/O dispatcher-1 << "[\r][\n]"
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
