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 <[email protected]> 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 <[email protected]>
> Date: Fri, Jan 13, 2017 at 6:53 PM
> Subject: Salesforce connector supports for complex queries
> To: kesavany Yogarajah <[email protected]>, Keerthika Mahendralingam <
> [email protected]>
> Cc: Malaka Silva <[email protected]>, Shevan Goonetilleke <[email protected]>,
> Yasith Tharindu <[email protected]>, Suhan Dharmasuriya <[email protected]>,
> Nirodha Pramod <[email protected]>
>
>
> 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: [email protected]
>
>
>
> --
>
> 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: [email protected]
[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>[email protected]</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>[email protected]</userEmail><userFullName>Chanuka Dissanayake</userFullName><userId>005E0000007k1SgIAI</userId><userLanguage>en_US</userLanguage><userLocale>en_US</userLocale><userName>[email protected]</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
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
