Hi Vitaly, Can you share the configuration of your processor? Can you switch the log level to debug for this processor? Do you have input relationships on the processor (from other processor? failure?)?
Thanks Pierre 2018-07-10 18:11 GMT+02:00 Vitaly Krivoy <vitaly_kri...@jhancock.com>: > 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..V2CoFwQaeMru8Xqg5mZcSdQHaN4kWS > p1Czisn1ZSV0hvTQFEdPlwv04kznPOYn58V.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_VmDifRuHQ2zhUXS1Q5dUavbMyWkMQa > ItdXrIfAdg3owg > > 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. >