Has anyone tried to use Reliersoft jdbc driver to pull data from Salesforce using ExecuteSQL processor? I've created an object Pricipal__c in Salesforce which contains three records. I can run "select * from Pricipal__c" in DbVisualizer and it works as expected. But I get neither data nor errors when I run the same SQL query from ExecuteSQL. The output from the nifi log shows that Reliersoft jdbc driver correctly connects and finds 3 records, but for some reason nothing is placed into flow files. Does anyone have any clues or recommendations? Thanks.
10:33:28,396 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.Driver Connect options: url: jdbc:sforce://login.salesforce.com 2018-07-10 10:33:28,758 INFO [Flow Service Tasks Thread-2] o.a.nifi.controller.StandardFlowService Saved flow controller org.apache.nifi.controller.FlowController@f5ebc9a // Another save pending = false 2018-07-10 10:33:30,361 INFO [Timer-Driven Process Thread-6] rc.Y [78 810458350 1768753242 true true true] Communicating with SF server took 870 ms 2018-07-10 10:33:30,376 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.f Partner server url: https://na53.salesforce.com/services/Soap/u/35.0/00Df2000001Ga7I 2018-07-10 10:33:30,376 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.f Partner session Id: 00Df2000001Ga7I!ASAAQDroAcrkJz3eYsqA4Vjzb..V2CoFwQaeMru8Xqg5mZcSdQHaN4kWSp1Czisn1ZSV0hvTQFEdPlwv04kznPOYn58V.E_y 2018-07-10 10:33:33,010 INFO [Timer-Driven Process Thread-6] rc.Y [78 1326156447 1016293809 true true true] Communicating with SF server took 399 ms 2018-07-10 10:33:33,073 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.util.a Metadata is up to date, having last been updated on Fri Jul 06 17:04:06 EDT 2018. 2018-07-10 10:33:33,081 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.f Disconnecting... 2018-07-10 10:33:33,238 INFO [Timer-Driven Process Thread-6] rc.Y [78 150728874 1016293809 true true true] Communicating with SF server took 126 ms 2018-07-10 10:33:33,238 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.f Disconnected. 2018-07-10 10:33:33,241 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.Driver Connect options: url: jdbc:sforce://login.salesforce.com 2018-07-10 10:33:34,952 INFO [Timer-Driven Process Thread-6] rc.Y [78 1795241438 -913733887 true true true] Communicating with SF server took 1432 ms 2018-07-10 10:33:34,953 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.f Partner server url: https://na53.salesforce.com/services/Soap/u/35.0/00Df2000001Ga7I 2018-07-10 10:33:34,953 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.f Partner session Id: 00Df2000001Ga7I!ASAAQM8pi_NGN4gPpJVZENNgLyy.jbYBza3vrAupKVVeFhBPxCw_VmDifRuHQ2zhUXS1Q5dUavbMyWkMQaItdXrIfAdg3owg 2018-07-10 10:33:37,037 INFO [Timer-Driven Process Thread-6] rc.Y [78 287958716 -1252905073 true true true] Communicating with SF server took 378 ms 2018-07-10 10:33:37,038 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.util.a Metadata is up to date, having last been updated on Fri Jul 06 17:04:06 EDT 2018. 2018-07-10 10:33:37,099 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.p Calling getColumns(null, null, PRICIPAL__C, null) method 2018-07-10 10:33:37,124 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.w No more records to fetch from back-end 2018-07-10 10:33:37,130 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.v PREPARED SELECT TO EXECUTE - select * from Pricipal__c 2018-07-10 10:33:37,132 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.p Calling getColumns(null, null, PRICIPAL__C, null) method 2018-07-10 10:33:37,136 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.w No more records to fetch from back-end 2018-07-10 10:33:37,139 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.v SELECT WITH SET PARAMETERS TO EXECUTE - SELECT Id, OwnerId, IsDeleted, Name, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, LastViewedDate, LastReferencedDate, First_Name__c, Last_Name__c, Email__c FROM Pricipal__c 2018-07-10 10:33:37,139 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.y EXECUTE QUERY FOR SQL - SELECT Id, OwnerId, IsDeleted, Name, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, LastViewedDate, LastReferencedDate, First_Name__c, Last_Name__c, Email__c FROM Pricipal__c USING 32 FETCH THREAD(S) 2018-07-10 10:33:37,167 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.p Calling getColumns(null, null, PRICIPAL__C, null) method 2018-07-10 10:33:37,171 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.w No more records to fetch from back-end 2018-07-10 10:33:37,173 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.f Elapsed time parse sql query: 7 ms 2018-07-10 10:33:37,174 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.y Elapsed time making query: 35 ms 2018-07-10 10:33:37,174 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.y Elapsed time getting columns for query: 0 ms 2018-07-10 10:33:37,174 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.y Elapsed time preparing metadata: 0 ms 2018-07-10 10:33:37,175 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.y Elapsed time creating final sql: 1 ms 2018-07-10 10:33:37,175 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.y SOQL TO EXECUTE - SELECT Id,OwnerId,IsDeleted,Name,CreatedDate,CreatedById,LastModifiedDate,LastModifiedById,SystemModstamp,LastViewedDate,LastReferencedDate,First_Name__c,Last_Name__c,Email__c FROM Pricipal__c 2018-07-10 10:33:37,705 INFO [pool-31-thread-1] rc.Y [110 1034277752 -1583682758 true true true] Communicating with SF server took 442 ms 2018-07-10 10:33:37,709 INFO [pool-31-thread-1] com.reliersoft.sforce.jdbc.o API REQUESTS: 41 of 15000 2018-07-10 10:33:37,709 INFO [pool-31-thread-1] com.reliersoft.sforce.jdbc.y SFDC reports 3 back-end records to fetch, with a first chunk of size 3 2018-07-10 10:33:37,714 INFO [pool-31-thread-1] com.reliersoft.sforce.jdbc.y Fetch completed. 2018-07-10 10:33:37,724 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.y getResultSet 2018-07-10 10:33:38,372 INFO [Timer-Driven Process Thread-6] com.reliersoft.sforce.jdbc.w No more records to fetch from back-end STATEMENT OF CONFIDENTIALITY The information contained in this email message and any attachments may be confidential and legally privileged and is intended for the use of the addressee(s) only. If you are not an intended recipient, please: (1) notify me immediately by replying to this message; (2) do not use, disseminate, distribute or reproduce any part of the message or any attachment; and (3) destroy all copies of this message and any attachments.
