You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@nifi.apache.org by Vitaly Krivoy <Vi...@jhancock.com> on 2018/07/10 16:11:53 UTC
Reliersoft jdbc driver for nifi salesforce integration
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.
RE: Reliersoft jdbc driver for nifi salesforce integration
Posted by Vitaly Krivoy <Vi...@jhancock.com>.
Hi Pierre,
I appreciate you taking a look into the issue. I am attaching snapshots of relevant information. One particular aspect is that once the flow is started, I cannot stop ExecuteSQL its processor. I ended up restarting NiFi three times until the flow stopped and I could modify and save properties. That is unusual in my NiFi experience and might be connected to problems with Reliersoft JDBC driver.
From: Pierre Villard [mailto:pierre.villard.fr@gmail.com]
Sent: Wednesday, July 11, 2018 8:17 AM
To: users@nifi.apache.org
Subject: Re: Reliersoft jdbc driver for nifi salesforce integration
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 <Vi...@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<http://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<ma...@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<http://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.
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.
Re: Reliersoft jdbc driver for nifi salesforce integration
Posted by Pierre Villard <pi...@gmail.com>.
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 <Vi...@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.
>