Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Use of batchsize option

Hello,

I am loading/inserting 25K records to SBQQ__QuoteLIne__c object. When I used bulkops without batchsize, it took 4 hrs to load. But when I was told to use batchsize(90) for every 5K records, it took 2 minutes. So all in all, with batchsize option, it took only 10 minutes. Why? How do I determine the best setting for batch size? Is it by trial and error? I was told that if I increase the batchsize to greater than 90, it will not properly update records in SF. Is that correct?

And when I do update, only batchsize(1) works for the same object. And it takes a while to process.
1 person has
this question
+1
Reply
  • Do you have the output from the runs showing the messages and all the options used ?

    Without that I can only make a guess.

    1. Why the time difference ? There could be several reasons. For example, perhaps the object has a trigger on it that does not scale well to large batch sizes. Or perhaps the job queue on salesforce was running slow at the moment of the 4 hour load. Again, with the message output we could determine more.

    2. How do I determine the best batchsize ? Normally the best batchsize is the largest. However, triggers play a role in determining this.

    3. >90 get an error ? I have never heard this. Who was the source of the information ? If it was the vendor of the managed package, then they are merely reflecting their experience based on their APEX triggers and not the api itself.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Hi Bill,

    Is this the message output you are asking? I tried to saved it as excel but I didn't see an option to load an excel file.

    SPName Status Message LogTime Seen
    SF_BulkOps:E52D02D8-99F7-408C-B9D8-77EBA9F9653D Starting Parameters: Insert SALESFORCE SBQQ__QuoteLine__c_Load Version: V3.4.7 2018-03-02 14:00:10.963 0
    SF_BulkOps:E52D02D8-99F7-408C-B9D8-77EBA9F9653D Message Run the DBAmp.exe program. 2018-03-02 14:00:11.253 0
    SF_BulkOps:E52D02D8-99F7-408C-B9D8-77EBA9F9653D Message 14:00:11: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-02 14:00:11.970 0
    SF_BulkOps:E52D02D8-99F7-408C-B9D8-77EBA9F9653D Message 14:00:11: Inserting SBQQ__QuoteLine__c_Load (STL-SSRS / test_salesforce_backups). 2018-03-02 14:00:11.973 0
    SF_BulkOps:E52D02D8-99F7-408C-B9D8-77EBA9F9653D Message 14:00:11: DBAmp is using the SQL Native Client. 2018-03-02 14:00:11.973 0
    SF_BulkOps:E52D02D8-99F7-408C-B9D8-77EBA9F9653D Message 14:00:11: Error: SQL Table does not contain an Id column. 2018-03-02 14:00:11.973 0
    SF_BulkOps:E52D02D8-99F7-408C-B9D8-77EBA9F9653D Message Error: DBAmp.exe was unsuccessful. 2018-03-02 14:00:11.977 0
    SF_BulkOps:E52D02D8-99F7-408C-B9D8-77EBA9F9653D Message Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert SBQQ__QuoteLine__c_Load "STL-SSRS" "test_salesforce_backups" "SALESFORCE" " " 2018-03-02 14:00:11.977 0
    SF_BulkOps:E52D02D8-99F7-408C-B9D8-77EBA9F9653D Failed Ending - Operation Failed. 2018-03-02 14:00:11.977 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Starting Parameters: Insert SALESFORCE SBQQ__QuoteLine__c_Load Version: V3.4.7 2018-03-02 14:01:35.300 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message Run the DBAmp.exe program. 2018-03-02 14:01:35.570 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message 14:01:35: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-02 14:01:45.510 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message 14:01:35: Inserting SBQQ__QuoteLine__c_Load (STL-SSRS / test_salesforce_backups). 2018-03-02 14:01:45.510 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message 14:01:35: DBAmp is using the SQL Native Client. 2018-03-02 14:01:45.510 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message 14:01:36: SOAP Headers: 2018-03-02 14:01:45.510 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message 14:01:36: Warning: Column ''Internal_Notes__c'' ignored because it does not exist in the SBQQ__QuoteLine__c object. 2018-03-02 14:01:45.513 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message 14:01:45: 10678 rows read from SQL Table. 2018-03-02 14:01:45.513 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message 14:01:45: 10678 rows failed. See Error column of row for more information. 2018-03-02 14:01:45.513 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message 14:01:45: 0 rows successfully processed. 2018-03-02 14:01:45.513 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message 14:01:45: Errors occurred. See Error column of row for more information. 2018-03-02 14:01:45.517 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message Percent Failed = 100.000. 2018-03-02 14:01:45.550 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message Error: DBAmp.exe was unsuccessful. 2018-03-02 14:01:45.550 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Message Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert SBQQ__QuoteLine__c_Load "STL-SSRS" "test_salesforce_backups" "SALESFORCE" " " 2018-03-02 14:01:45.550 0
    SF_BulkOps:E7598399-94BC-4663-B2B8-EFF0C746A0CB Failed Ending - Operation Failed. 2018-03-02 14:01:45.550 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Starting Parameters: Insert SALESFORCE SBQQ__QuoteLine__c_Load Version: V3.4.7 2018-03-02 16:46:08.387 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message Run the DBAmp.exe program. 2018-03-02 16:46:08.580 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message 16:46:08: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-02 16:48:57.213 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message 16:46:08: Inserting SBQQ__QuoteLine__c_Load (STL-SSRS / test_salesforce_backups). 2018-03-02 16:48:57.213 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message 16:46:08: DBAmp is using the SQL Native Client. 2018-03-02 16:48:57.217 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message 16:46:09: SOAP Headers: 2018-03-02 16:48:57.217 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message 16:46:09: Warning: Column ''Internal_Notes__c'' ignored because it does not exist in the SBQQ__QuoteLine__c object. 2018-03-02 16:48:57.220 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message 16:48:57: 10678 rows read from SQL Table. 2018-03-02 16:48:57.223 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message 16:48:57: 10600 rows failed. See Error column of row for more information. 2018-03-02 16:48:57.223 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message 16:48:57: 78 rows successfully processed. 2018-03-02 16:48:57.223 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message 16:48:57: Errors occurred. See Error column of row for more information. 2018-03-02 16:48:57.223 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message Percent Failed = 99.300. 2018-03-02 16:48:57.293 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message Error: DBAmp.exe was unsuccessful. 2018-03-02 16:48:57.293 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Message Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert SBQQ__QuoteLine__c_Load "STL-SSRS" "test_salesforce_backups" "SALESFORCE" " " 2018-03-02 16:48:57.293 0
    SF_BulkOps:B2365688-4C64-4197-91A7-A56FFC7640A6 Failed Ending - Operation Failed. 2018-03-02 16:48:57.297 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load Version: V3.4.7 2018-03-05 14:49:25.350 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message Run the DBAmp.exe program. 2018-03-05 14:49:25.570 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message 14:49:25: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-05 15:53:18.480 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message 14:49:25: Inserting SBQQ__QuoteLine__c_Load (STL-SSRS / test_salesforce_backups). 2018-03-05 15:53:18.480 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message 14:49:25: DBAmp is using the SQL Native Client. 2018-03-05 15:53:18.480 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message 14:49:25: Batch size reset to 1 rows per batch. 2018-03-05 15:53:18.483 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message 14:49:26: SOAP Headers: 2018-03-05 15:53:18.483 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message 14:49:26: Warning: Column ''Internal_Notes__c'' ignored because it does not exist in the SBQQ__QuoteLine__c object. 2018-03-05 15:53:18.483 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message 15:53:18: 10678 rows read from SQL Table. 2018-03-05 15:53:18.483 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message 15:53:18: 30 rows failed. See Error column of row for more information. 2018-03-05 15:53:18.487 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message 15:53:18: 10648 rows successfully processed. 2018-03-05 15:53:18.487 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message 15:53:18: Errors occurred. See Error column of row for more information. 2018-03-05 15:53:18.487 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message Percent Failed = 0.300. 2018-03-05 15:53:18.513 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message Error: DBAmp.exe was unsuccessful. 2018-03-05 15:53:18.513 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Message Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert:batchsize(1) SBQQ__QuoteLine__c_Load "STL-SSRS" "test_salesforce_backups" "SALESFORCE" " " 2018-03-05 15:53:18.517 0
    SF_BulkOps:3803D1AE-1E0E-4ED3-8917-43B1312184FD Failed Ending - Operation Failed. 2018-03-05 15:53:18.517 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load1 Version: V3.4.7 2018-03-09 11:13:32.513 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Message Run the DBAmp.exe program. 2018-03-09 11:13:32.800 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Message 11:13:32: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-09 11:13:47.737 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Message 11:13:32: Inserting SBQQ__QuoteLine__c_Load1 (STL-SSRS / test_salesforce_backups). 2018-03-09 11:13:47.737 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Message 11:13:33: DBAmp is using the SQL Native Client. 2018-03-09 11:13:47.737 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Message 11:13:33: Batch size reset to 1 rows per batch. 2018-03-09 11:13:47.740 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Message 11:13:33: SOAP Headers: 2018-03-09 11:13:47.740 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Message 11:13:33: Warning: Column ''Internal_Notes__c'' ignored because it does not exist in the SBQQ__QuoteLine__c object. 2018-03-09 11:13:47.740 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Message 11:13:47: 22 rows read from SQL Table. 2018-03-09 11:13:47.740 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Message 11:13:47: 22 rows successfully processed. 2018-03-09 11:13:47.740 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Message Percent Failed = 0.000. 2018-03-09 11:13:47.747 0
    SF_BulkOps:2CBA7A0B-EE2A-4401-947A-8B3CEEE53A15 Successful Ending - Operation Successful. 2018-03-09 11:13:47.747 0
    SF_BulkOps:A913EB2B-282A-4809-B562-30079F8D3ECB Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load1 Version: V3.4.7 2018-03-09 13:19:28.677 0
    SF_BulkOps:A913EB2B-282A-4809-B562-30079F8D3ECB Message Run the DBAmp.exe program. 2018-03-09 13:19:28.680 0
    SF_BulkOps:A913EB2B-282A-4809-B562-30079F8D3ECB Message 13:19:28: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-09 13:19:42.747 0
    SF_BulkOps:A913EB2B-282A-4809-B562-30079F8D3ECB Message 13:19:28: Inserting SBQQ__QuoteLine__c_Load1 (STL-SSRS / test_salesforce_backups). 2018-03-09 13:19:42.747 0
    SF_BulkOps:A913EB2B-282A-4809-B562-30079F8D3ECB Message 13:19:28: DBAmp is using the SQL Native Client. 2018-03-09 13:19:42.750 0
    SF_BulkOps:A913EB2B-282A-4809-B562-30079F8D3ECB Message 13:19:28: Batch size reset to 1 rows per batch. 2018-03-09 13:19:42.750 0
    SF_BulkOps:A913EB2B-282A-4809-B562-30079F8D3ECB Message 13:19:29: SOAP Headers: 2018-03-09 13:19:42.750 0
    SF_BulkOps:A913EB2B-282A-4809-B562-30079F8D3ECB Message 13:19:42: 22 rows read from SQL Table. 2018-03-09 13:19:42.750 0
    SF_BulkOps:A913EB2B-282A-4809-B562-30079F8D3ECB Message 13:19:42: 22 rows successfully processed. 2018-03-09 13:19:42.753 0
    SF_BulkOps:A913EB2B-282A-4809-B562-30079F8D3ECB Message Percent Failed = 0.000. 2018-03-09 13:19:42.757 0
    SF_BulkOps:A913EB2B-282A-4809-B562-30079F8D3ECB Successful Ending - Operation Successful. 2018-03-09 13:19:42.760 0
    SF_BulkOps:9EC6715D-3935-4C2B-BE95-9298C7AC7BF9 Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load1 Version: V3.4.7 2018-03-09 13:51:40.953 0
    SF_BulkOps:9EC6715D-3935-4C2B-BE95-9298C7AC7BF9 Message Run the DBAmp.exe program. 2018-03-09 13:51:41.200 0
    SF_BulkOps:9EC6715D-3935-4C2B-BE95-9298C7AC7BF9 Message 13:51:41: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-09 13:51:57.817 0
    SF_BulkOps:9EC6715D-3935-4C2B-BE95-9298C7AC7BF9 Message 13:51:41: Inserting SBQQ__QuoteLine__c_Load1 (STL-SSRS / test_salesforce_backups). 2018-03-09 13:51:57.820 0
    SF_BulkOps:9EC6715D-3935-4C2B-BE95-9298C7AC7BF9 Message 13:51:41: DBAmp is using the SQL Native Client. 2018-03-09 13:51:57.820 0
    SF_BulkOps:9EC6715D-3935-4C2B-BE95-9298C7AC7BF9 Message 13:51:41: Batch size reset to 1 rows per batch. 2018-03-09 13:51:57.820 0
    SF_BulkOps:9EC6715D-3935-4C2B-BE95-9298C7AC7BF9 Message 13:51:41: SOAP Headers: 2018-03-09 13:51:57.820 0
    SF_BulkOps:9EC6715D-3935-4C2B-BE95-9298C7AC7BF9 Message 13:51:57: 22 rows read from SQL Table. 2018-03-09 13:51:57.820 0
    SF_BulkOps:9EC6715D-3935-4C2B-BE95-9298C7AC7BF9 Message 13:51:57: 22 rows successfully processed. 2018-03-09 13:51:57.823 0
    SF_BulkOps:9EC6715D-3935-4C2B-BE95-9298C7AC7BF9 Message Percent Failed = 0.000. 2018-03-09 13:51:57.827 0
    SF_BulkOps:9EC6715D-3935-4C2B-BE95-9298C7AC7BF9 Successful Ending - Operation Successful. 2018-03-09 13:51:57.827 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load Version: V3.4.7 2018-03-10 13:58:28.430 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message Run the DBAmp.exe program. 2018-03-10 13:58:29.247 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message 13:58:29: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-10 15:17:53.127 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message 13:58:29: Inserting SBQQ__QuoteLine__c_Load (STL-SSRS / test_salesforce_backups). 2018-03-10 15:17:53.130 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message 13:58:29: DBAmp is using the SQL Native Client. 2018-03-10 15:17:53.130 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message 13:58:29: Batch size reset to 1 rows per batch. 2018-03-10 15:17:53.130 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message 13:58:29: SOAP Headers: 2018-03-10 15:17:53.133 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message 15:17:53: 10678 rows read from SQL Table. 2018-03-10 15:17:53.133 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message 15:17:53: 1 rows failed. See Error column of row for more information. 2018-03-10 15:17:53.137 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message 15:17:53: 10677 rows successfully processed. 2018-03-10 15:17:53.137 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message 15:17:53: Errors occurred. See Error column of row for more information. 2018-03-10 15:17:53.137 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message Percent Failed = 0.000. 2018-03-10 15:17:53.163 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message Error: DBAmp.exe was unsuccessful. 2018-03-10 15:17:53.163 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Message Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert:batchsize(1) SBQQ__QuoteLine__c_Load "STL-SSRS" "test_salesforce_backups" "SALESFORCE" " " 2018-03-10 15:17:53.167 0
    SF_BulkOps:126567CA-B102-4239-A9EC-25746485E671 Failed Ending - Operation Failed. 2018-03-10 15:17:53.167 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load Version: V3.4.7 2018-03-15 17:29:10.650 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message Run the DBAmp.exe program. 2018-03-15 17:29:10.913 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message 17:29:10: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-15 18:56:10.393 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message 17:29:10: Inserting SBQQ__QuoteLine__c_Load (STL-SSRS / test_salesforce_backups). 2018-03-15 18:56:10.397 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message 17:29:11: DBAmp is using the SQL Native Client. 2018-03-15 18:56:10.397 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message 17:29:11: Batch size reset to 1 rows per batch. 2018-03-15 18:56:10.400 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message 17:29:11: SOAP Headers: 2018-03-15 18:56:10.400 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message 18:56:10: 10756 rows read from SQL Table. 2018-03-15 18:56:10.400 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message 18:56:10: 7 rows failed. See Error column of row for more information. 2018-03-15 18:56:10.400 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message 18:56:10: 10749 rows successfully processed. 2018-03-15 18:56:10.403 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message 18:56:10: Errors occurred. See Error column of row for more information. 2018-03-15 18:56:10.403 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message Percent Failed = 0.100. 2018-03-15 18:56:10.430 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message Error: DBAmp.exe was unsuccessful. 2018-03-15 18:56:10.430 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Message Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert:batchsize(1) SBQQ__QuoteLine__c_Load "STL-SSRS" "test_salesforce_backups" "SALESFORCE" " " 2018-03-15 18:56:10.433 0
    SF_BulkOps:5376296C-C1C2-4A77-8FED-2FE45155ED29 Failed Ending - Operation Failed. 2018-03-15 18:56:10.433 0
    SF_BulkOps:37C88E3D-01E9-4795-85E4-156A7EBD0671 Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load Version: V3.4.7 2018-03-16 10:03:28.160 0
    SF_BulkOps:37C88E3D-01E9-4795-85E4-156A7EBD0671 Message Run the DBAmp.exe program. 2018-03-16 10:03:28.390 0
    SF_BulkOps:37C88E3D-01E9-4795-85E4-156A7EBD0671 Message 10:03:28: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-16 11:38:18.403 0
    SF_BulkOps:37C88E3D-01E9-4795-85E4-156A7EBD0671 Message 10:03:28: Inserting SBQQ__QuoteLine__c_Load (STL-SSRS / test_salesforce_backups). 2018-03-16 11:38:18.403 0
    SF_BulkOps:37C88E3D-01E9-4795-85E4-156A7EBD0671 Message 10:03:28: DBAmp is using the SQL Native Client. 2018-03-16 11:38:18.407 0
    SF_BulkOps:37C88E3D-01E9-4795-85E4-156A7EBD0671 Message 10:03:28: Batch size reset to 1 rows per batch. 2018-03-16 11:38:18.407 0
    SF_BulkOps:37C88E3D-01E9-4795-85E4-156A7EBD0671 Message 10:03:29: SOAP Headers: 2018-03-16 11:38:18.407 0
    SF_BulkOps:37C88E3D-01E9-4795-85E4-156A7EBD0671 Message 11:38:18: 10780 rows read from SQL Table. 2018-03-16 11:38:18.410 0
    SF_BulkOps:37C88E3D-01E9-4795-85E4-156A7EBD0671 Message 11:38:18: 10780 rows successfully processed. 2018-03-16 11:38:18.410 0
    SF_BulkOps:37C88E3D-01E9-4795-85E4-156A7EBD0671 Message Percent Failed = 0.000. 2018-03-16 11:38:18.437 0
    SF_BulkOps:37C88E3D-01E9-4795-85E4-156A7EBD0671 Successful Ending - Operation Successful. 2018-03-16 11:38:18.440 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load Version: V3.4.7 2018-03-26 15:42:08.657 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message Run the DBAmp.exe program. 2018-03-26 15:42:08.833 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message 15:42:08: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-26 19:26:08.733 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message 15:42:08: Inserting SBQQ__QuoteLine__c_Load (STL-SSRS / test_salesforce_backups). 2018-03-26 19:26:08.733 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message 15:42:09: DBAmp is using the SQL Native Client. 2018-03-26 19:26:08.737 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message 15:42:09: Batch size reset to 1 rows per batch. 2018-03-26 19:26:08.737 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message 15:42:09: SOAP Headers: 2018-03-26 19:26:08.740 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message 19:26:08: 28120 rows read from SQL Table. 2018-03-26 19:26:08.740 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message 19:26:08: 1 rows failed. See Error column of row for more information. 2018-03-26 19:26:08.743 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message 19:26:08: 28119 rows successfully processed. 2018-03-26 19:26:08.743 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message 19:26:08: Errors occurred. See Error column of row for more information. 2018-03-26 19:26:08.747 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message Percent Failed = 0.000. 2018-03-26 19:26:08.807 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message Error: DBAmp.exe was unsuccessful. 2018-03-26 19:26:08.810 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Message Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert:batchsize(1) SBQQ__QuoteLine__c_Load "STL-SSRS" "test_salesforce_backups" "SALESFORCE" " " 2018-03-26 19:26:08.810 0
    SF_BulkOps:93C4C216-5609-45D6-8BF6-B48D9832C239 Failed Ending - Operation Failed. 2018-03-26 19:26:08.810 0
    SF_BulkOps:E09D0019-3F1A-48EE-85E8-5726F26C4B30 Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load3 Version: V3.4.7 2018-03-27 11:18:27.637 0
    SF_BulkOps:E09D0019-3F1A-48EE-85E8-5726F26C4B30 Message Run the DBAmp.exe program. 2018-03-27 11:18:27.897 0
    SF_BulkOps:E09D0019-3F1A-48EE-85E8-5726F26C4B30 Message 11:18:27: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-03-27 11:18:29.950 0
    SF_BulkOps:E09D0019-3F1A-48EE-85E8-5726F26C4B30 Message 11:18:27: Inserting SBQQ__QuoteLine__c_Load3 (STL-SSRS / test_salesforce_backups). 2018-03-27 11:18:29.950 0
    SF_BulkOps:E09D0019-3F1A-48EE-85E8-5726F26C4B30 Message 11:18:28: DBAmp is using the SQL Native Client. 2018-03-27 11:18:29.953 0
    SF_BulkOps:E09D0019-3F1A-48EE-85E8-5726F26C4B30 Message 11:18:28: Batch size reset to 1 rows per batch. 2018-03-27 11:18:29.957 0
    SF_BulkOps:E09D0019-3F1A-48EE-85E8-5726F26C4B30 Message 11:18:28: SOAP Headers: 2018-03-27 11:18:29.957 0
    SF_BulkOps:E09D0019-3F1A-48EE-85E8-5726F26C4B30 Message 11:18:29: 1 rows read from SQL Table. 2018-03-27 11:18:29.960 0
    SF_BulkOps:E09D0019-3F1A-48EE-85E8-5726F26C4B30 Message 11:18:29: 1 rows successfully processed. 2018-03-27 11:18:29.960 0
    SF_BulkOps:E09D0019-3F1A-48EE-85E8-5726F26C4B30 Message Percent Failed = 0.000. 2018-03-27 11:18:29.963 0
    SF_BulkOps:E09D0019-3F1A-48EE-85E8-5726F26C4B30 Successful Ending - Operation Successful. 2018-03-27 11:18:29.967 0
    SF_BulkOps:7221AD49-F0D3-47DE-859A-B9C21D53B27A Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load_180419 Version: V3.4.7 2018-04-19 15:58:39.597 0
    SF_BulkOps:7221AD49-F0D3-47DE-859A-B9C21D53B27A Message Run the DBAmp.exe program. 2018-04-19 15:58:39.877 0
    SF_BulkOps:7221AD49-F0D3-47DE-859A-B9C21D53B27A Message 15:58:39: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-04-19 15:58:55.703 0
    SF_BulkOps:7221AD49-F0D3-47DE-859A-B9C21D53B27A Message 15:58:39: Inserting SBQQ__QuoteLine__c_Load_180419 (STL-SSRS / test_salesforce_backups). 2018-04-19 15:58:55.707 0
    SF_BulkOps:7221AD49-F0D3-47DE-859A-B9C21D53B27A Message 15:58:40: DBAmp is using the SQL Native Client. 2018-04-19 15:58:55.710 0
    SF_BulkOps:7221AD49-F0D3-47DE-859A-B9C21D53B27A Message 15:58:40: Batch size reset to 1 rows per batch. 2018-04-19 15:58:55.710 0
    SF_BulkOps:7221AD49-F0D3-47DE-859A-B9C21D53B27A Message 15:58:40: SOAP Headers: 2018-04-19 15:58:55.713 0
    SF_BulkOps:7221AD49-F0D3-47DE-859A-B9C21D53B27A Message 15:58:55: 25 rows read from SQL Table. 2018-04-19 15:58:55.717 0
    SF_BulkOps:7221AD49-F0D3-47DE-859A-B9C21D53B27A Message 15:58:55: 25 rows successfully processed. 2018-04-19 15:58:55.720 0
    SF_BulkOps:7221AD49-F0D3-47DE-859A-B9C21D53B27A Message Percent Failed = 0.000. 2018-04-19 15:58:55.723 0
    SF_BulkOps:7221AD49-F0D3-47DE-859A-B9C21D53B27A Successful Ending - Operation Successful. 2018-04-19 15:58:55.727 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load18MR Version: V3.4.7 2018-04-20 09:06:10.677 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message Run the DBAmp.exe program. 2018-04-20 09:06:10.990 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message 09:06:11: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-04-20 12:56:11.830 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message 09:06:11: Inserting SBQQ__QuoteLine__c_Load18MR (STL-SSRS / test_salesforce_backups). 2018-04-20 12:56:11.833 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message 09:06:11: DBAmp is using the SQL Native Client. 2018-04-20 12:56:11.837 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message 09:06:11: Batch size reset to 1 rows per batch. 2018-04-20 12:56:11.840 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message 09:06:11: SOAP Headers: 2018-04-20 12:56:11.843 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message 12:56:11: 28120 rows read from SQL Table. 2018-04-20 12:56:11.843 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message 12:56:11: 1 rows failed. See Error column of row for more information. 2018-04-20 12:56:11.847 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message 12:56:11: 28119 rows successfully processed. 2018-04-20 12:56:11.850 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message 12:56:11: Errors occurred. See Error column of row for more information. 2018-04-20 12:56:11.853 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message Percent Failed = 0.000. 2018-04-20 12:56:11.917 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message Error: DBAmp.exe was unsuccessful. 2018-04-20 12:56:11.920 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Message Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert:batchsize(1) SBQQ__QuoteLine__c_Load18MR "STL-SSRS" "test_salesforce_backups" "SALESFORCE" " " 2018-04-20 12:56:11.920 0
    SF_BulkOps:F2C5C3E2-5C7C-4222-8110-30604813210B Failed Ending - Operation Failed. 2018-04-20 12:56:11.923 0
    SF_BulkOps:26B651C9-38CF-45F1-B0E4-6AE5D6D900E6 Starting Parameters: Insert:batchsize(90) SALESFORCE SBQQ__QuoteLine__c_Load23MR1 Version: V3.4.7 2018-04-20 15:05:55.327 0
    SF_BulkOps:26B651C9-38CF-45F1-B0E4-6AE5D6D900E6 Message Run the DBAmp.exe program. 2018-04-20 15:05:56.293 0
    SF_BulkOps:26B651C9-38CF-45F1-B0E4-6AE5D6D900E6 Message 15:05:56: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-04-20 15:07:45.910 0
    SF_BulkOps:26B651C9-38CF-45F1-B0E4-6AE5D6D900E6 Message 15:05:56: Inserting SBQQ__QuoteLine__c_Load23MR1 (STL-SSRS / test_salesforce_backups). 2018-04-20 15:07:45.913 0
    SF_BulkOps:26B651C9-38CF-45F1-B0E4-6AE5D6D900E6 Message 15:05:56: DBAmp is using the SQL Native Client. 2018-04-20 15:07:45.917 0
    SF_BulkOps:26B651C9-38CF-45F1-B0E4-6AE5D6D900E6 Message 15:05:56: Batch size reset to 90 rows per batch. 2018-04-20 15:07:45.920 0
    SF_BulkOps:26B651C9-38CF-45F1-B0E4-6AE5D6D900E6 Message 15:05:57: SOAP Headers: 2018-04-20 15:07:45.923 0
    SF_BulkOps:26B651C9-38CF-45F1-B0E4-6AE5D6D900E6 Message 15:07:45: 4917 rows read from SQL Table. 2018-04-20 15:07:45.927 0
    SF_BulkOps:26B651C9-38CF-45F1-B0E4-6AE5D6D900E6 Message 15:07:45: 4917 rows successfully processed. 2018-04-20 15:07:45.930 0
    SF_BulkOps:26B651C9-38CF-45F1-B0E4-6AE5D6D900E6 Message Percent Failed = 0.000. 2018-04-20 15:07:45.943 0
    SF_BulkOps:26B651C9-38CF-45F1-B0E4-6AE5D6D900E6 Successful Ending - Operation Successful. 2018-04-20 15:07:45.947 0
    SF_BulkOps:4A2A3AF0-64A8-4A26-8FD8-0C2B54AB0D5D Starting Parameters: Insert:batchsize(90) SALESFORCE SBQQ__QuoteLine__c_Load23MR2 Version: V3.4.7 2018-04-20 15:34:56.703 0
    SF_BulkOps:4A2A3AF0-64A8-4A26-8FD8-0C2B54AB0D5D Message Run the DBAmp.exe program. 2018-04-20 15:34:56.923 0
    SF_BulkOps:4A2A3AF0-64A8-4A26-8FD8-0C2B54AB0D5D Message 15:34:56: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-04-20 15:36:27.247 0
    SF_BulkOps:4A2A3AF0-64A8-4A26-8FD8-0C2B54AB0D5D Message 15:34:56: Inserting SBQQ__QuoteLine__c_Load23MR2 (STL-SSRS / test_salesforce_backups). 2018-04-20 15:36:27.250 0
    SF_BulkOps:4A2A3AF0-64A8-4A26-8FD8-0C2B54AB0D5D Message 15:34:57: DBAmp is using the SQL Native Client. 2018-04-20 15:36:27.253 0
    SF_BulkOps:4A2A3AF0-64A8-4A26-8FD8-0C2B54AB0D5D Message 15:34:57: Batch size reset to 90 rows per batch. 2018-04-20 15:36:27.257 0
    SF_BulkOps:4A2A3AF0-64A8-4A26-8FD8-0C2B54AB0D5D Message 15:34:57: SOAP Headers: 2018-04-20 15:36:27.260 0
    SF_BulkOps:4A2A3AF0-64A8-4A26-8FD8-0C2B54AB0D5D Message 15:36:27: 5000 rows read from SQL Table. 2018-04-20 15:36:27.260 0
    SF_BulkOps:4A2A3AF0-64A8-4A26-8FD8-0C2B54AB0D5D Message 15:36:27: 5000 rows successfully processed. 2018-04-20 15:36:27.263 0
    SF_BulkOps:4A2A3AF0-64A8-4A26-8FD8-0C2B54AB0D5D Message Percent Failed = 0.000. 2018-04-20 15:36:27.280 0
    SF_BulkOps:4A2A3AF0-64A8-4A26-8FD8-0C2B54AB0D5D Successful Ending - Operation Successful. 2018-04-20 15:36:27.283 0
    SF_BulkOps:E921A48E-986D-4F28-9E40-269A0D7E0B7B Starting Parameters: Insert:batchsize(90) SALESFORCE SBQQ__QuoteLine__c_Load23MR3 Version: V3.4.7 2018-04-20 15:40:57.410 0
    SF_BulkOps:E921A48E-986D-4F28-9E40-269A0D7E0B7B Message Run the DBAmp.exe program. 2018-04-20 15:40:57.653 0
    SF_BulkOps:E921A48E-986D-4F28-9E40-269A0D7E0B7B Message 15:40:57: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-04-20 15:42:18.710 0
    SF_BulkOps:E921A48E-986D-4F28-9E40-269A0D7E0B7B Message 15:40:57: Inserting SBQQ__QuoteLine__c_Load23MR3 (STL-SSRS / test_salesforce_backups). 2018-04-20 15:42:18.710 0
    SF_BulkOps:E921A48E-986D-4F28-9E40-269A0D7E0B7B Message 15:40:57: DBAmp is using the SQL Native Client. 2018-04-20 15:42:18.713 0
    SF_BulkOps:E921A48E-986D-4F28-9E40-269A0D7E0B7B Message 15:40:57: Batch size reset to 90 rows per batch. 2018-04-20 15:42:18.717 0
    SF_BulkOps:E921A48E-986D-4F28-9E40-269A0D7E0B7B Message 15:40:58: SOAP Headers: 2018-04-20 15:42:18.720 0
    SF_BulkOps:E921A48E-986D-4F28-9E40-269A0D7E0B7B Message 15:42:18: 5000 rows read from SQL Table. 2018-04-20 15:42:18.720 0
    SF_BulkOps:E921A48E-986D-4F28-9E40-269A0D7E0B7B Message 15:42:18: 5000 rows successfully processed. 2018-04-20 15:42:18.723 0
    SF_BulkOps:E921A48E-986D-4F28-9E40-269A0D7E0B7B Message Percent Failed = 0.000. 2018-04-20 15:42:18.740 0
    SF_BulkOps:E921A48E-986D-4F28-9E40-269A0D7E0B7B Successful Ending - Operation Successful. 2018-04-20 15:42:18.747 0
    SF_BulkOps:F42ED33E-E8BA-4933-A638-B44881D901BD Starting Parameters: Insert:batchsize(90) SALESFORCE SBQQ__QuoteLine__c_Load23MR4 Version: V3.4.7 2018-04-20 15:46:06.683 0
    SF_BulkOps:F42ED33E-E8BA-4933-A638-B44881D901BD Message Run the DBAmp.exe program. 2018-04-20 15:46:06.690 0
    SF_BulkOps:F42ED33E-E8BA-4933-A638-B44881D901BD Message 15:46:06: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-04-20 15:47:45.143 0
    SF_BulkOps:F42ED33E-E8BA-4933-A638-B44881D901BD Message 15:46:06: Inserting SBQQ__QuoteLine__c_Load23MR4 (STL-SSRS / test_salesforce_backups). 2018-04-20 15:47:45.143 0
    SF_BulkOps:F42ED33E-E8BA-4933-A638-B44881D901BD Message 15:46:06: DBAmp is using the SQL Native Client. 2018-04-20 15:47:45.147 0
    SF_BulkOps:F42ED33E-E8BA-4933-A638-B44881D901BD Message 15:46:06: Batch size reset to 90 rows per batch. 2018-04-20 15:47:45.150 0
    SF_BulkOps:F42ED33E-E8BA-4933-A638-B44881D901BD Message 15:46:07: SOAP Headers: 2018-04-20 15:47:45.153 0
    SF_BulkOps:F42ED33E-E8BA-4933-A638-B44881D901BD Message 15:47:45: 5000 rows read from SQL Table. 2018-04-20 15:47:45.157 0
    SF_BulkOps:F42ED33E-E8BA-4933-A638-B44881D901BD Message 15:47:45: 5000 rows successfully processed. 2018-04-20 15:47:45.160 0
    SF_BulkOps:F42ED33E-E8BA-4933-A638-B44881D901BD Message Percent Failed = 0.000. 2018-04-20 15:47:45.177 0
    SF_BulkOps:F42ED33E-E8BA-4933-A638-B44881D901BD Successful Ending - Operation Successful. 2018-04-20 15:47:45.180 0
    SF_BulkOps:F535D226-7E89-4802-A463-99668D38D10F Starting Parameters: Insert:batchsize(90) SALESFORCE SBQQ__QuoteLine__c_Load23MR5 Version: V3.4.7 2018-04-20 15:52:35.790 0
    SF_BulkOps:F535D226-7E89-4802-A463-99668D38D10F Message Run the DBAmp.exe program. 2018-04-20 15:52:35.800 0
    SF_BulkOps:F535D226-7E89-4802-A463-99668D38D10F Message 15:52:35: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-04-20 15:54:04.520 0
    SF_BulkOps:F535D226-7E89-4802-A463-99668D38D10F Message 15:52:35: Inserting SBQQ__QuoteLine__c_Load23MR5 (STL-SSRS / test_salesforce_backups). 2018-04-20 15:54:04.527 0
    SF_BulkOps:F535D226-7E89-4802-A463-99668D38D10F Message 15:52:36: DBAmp is using the SQL Native Client. 2018-04-20 15:54:04.530 0
    SF_BulkOps:F535D226-7E89-4802-A463-99668D38D10F Message 15:52:36: Batch size reset to 90 rows per batch. 2018-04-20 15:54:04.533 0
    SF_BulkOps:F535D226-7E89-4802-A463-99668D38D10F Message 15:52:36: SOAP Headers: 2018-04-20 15:54:04.537 0
    SF_BulkOps:F535D226-7E89-4802-A463-99668D38D10F Message 15:54:04: 4878 rows read from SQL Table. 2018-04-20 15:54:04.540 0
    SF_BulkOps:F535D226-7E89-4802-A463-99668D38D10F Message 15:54:04: 4878 rows successfully processed. 2018-04-20 15:54:04.540 0
    SF_BulkOps:F535D226-7E89-4802-A463-99668D38D10F Message Percent Failed = 0.000. 2018-04-20 15:54:04.557 0
    SF_BulkOps:F535D226-7E89-4802-A463-99668D38D10F Successful Ending - Operation Successful. 2018-04-20 15:54:04.560 0
    SF_BulkOps:FE9BC7F4-7E3B-45C8-BA5D-DE5C33EE796A Starting Parameters: Insert:batchsize(1) SALESFORCE SBQQ__QuoteLine__c_Load18MR1 Version: V3.4.7 2018-04-20 16:36:24.293 0
    SF_BulkOps:FE9BC7F4-7E3B-45C8-BA5D-DE5C33EE796A Message Run the DBAmp.exe program. 2018-04-20 16:36:24.770 0
    SF_BulkOps:FE9BC7F4-7E3B-45C8-BA5D-DE5C33EE796A Message 16:36:24: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-04-20 16:36:26.330 0
    SF_BulkOps:FE9BC7F4-7E3B-45C8-BA5D-DE5C33EE796A Message 16:36:24: Inserting SBQQ__QuoteLine__c_Load18MR1 (STL-SSRS / test_salesforce_backups). 2018-04-20 16:36:26.333 0
    SF_BulkOps:FE9BC7F4-7E3B-45C8-BA5D-DE5C33EE796A Message 16:36:24: DBAmp is using the SQL Native Client. 2018-04-20 16:36:26.337 0
    SF_BulkOps:FE9BC7F4-7E3B-45C8-BA5D-DE5C33EE796A Message 16:36:24: Batch size reset to 1 rows per batch. 2018-04-20 16:36:26.340 0
    SF_BulkOps:FE9BC7F4-7E3B-45C8-BA5D-DE5C33EE796A Message 16:36:25: SOAP Headers: 2018-04-20 16:36:26.340 0
    SF_BulkOps:FE9BC7F4-7E3B-45C8-BA5D-DE5C33EE796A Message 16:36:26: 1 rows read from SQL Table. 2018-04-20 16:36:26.343 0
    SF_BulkOps:FE9BC7F4-7E3B-45C8-BA5D-DE5C33EE796A Message 16:36:26: 1 rows successfully processed. 2018-04-20 16:36:26.347 0
    SF_BulkOps:FE9BC7F4-7E3B-45C8-BA5D-DE5C33EE796A Message Percent Failed = 0.000. 2018-04-20 16:36:26.353 0
    SF_BulkOps:FE9BC7F4-7E3B-45C8-BA5D-DE5C33EE796A Successful Ending - Operation Successful. 2018-04-20 16:36:26.353 0
    SF_BulkOps:B08683E9-C760-499B-B307-FFE4DFA1D8E6 Starting Parameters: Insert:batchsize(90) SALESFORCE SBQQ__QuoteLine__c_Load Version: V3.4.7 2018-04-26 14:21:31.437 0
    SF_BulkOps:B08683E9-C760-499B-B307-FFE4DFA1D8E6 Message Run the DBAmp.exe program. 2018-04-26 14:21:31.697 0
    SF_BulkOps:B08683E9-C760-499B-B307-FFE4DFA1D8E6 Message 14:21:31: DBAmp Bulk Operations. V3.4.7 (c) Copyright 2006-2017 forceAmp.com LLC 2018-04-26 14:22:38.127 0
    SF_BulkOps:B08683E9-C760-499B-B307-FFE4DFA1D8E6 Message 14:21:31: Inserting SBQQ__QuoteLine__c_Load (STL-SSRS / test_salesforce_backups). 2018-04-26 14:22:38.130 0
    SF_BulkOps:B08683E9-C760-499B-B307-FFE4DFA1D8E6 Message 14:21:31: DBAmp is using the SQL Native Client. 2018-04-26 14:22:38.133 0
    SF_BulkOps:B08683E9-C760-499B-B307-FFE4DFA1D8E6 Message 14:21:31: Batch size reset to 90 rows per batch. 2018-04-26 14:22:38.137 0
    SF_BulkOps:B08683E9-C760-499B-B307-FFE4DFA1D8E6 Message 14:21:32: SOAP Headers: 2018-04-26 14:22:38.140 0
    SF_BulkOps:B08683E9-C760-499B-B307-FFE4DFA1D8E6 Message 14:22:38: 1988 rows read from SQL Table. 2018-04-26 14:22:38.143 0
    SF_BulkOps:B08683E9-C760-499B-B307-FFE4DFA1D8E6 Message 14:22:38: 1988 rows successfully processed. 2018-04-26 14:22:38.147 0
    SF_BulkOps:B08683E9-C760-499B-B307-FFE4DFA1D8E6 Message Percent Failed = 0.000. 2018-04-26 14:22:38.167 0
    SF_BulkOps:B08683E9-C760-499B-B307-FFE4DFA1D8E6 Successful Ending - Operation Successful. 2018-04-26 14:22:38.170 0
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • I see that you are running on an older version of DBAmp. I would suggest upgrading to the latest release of DBAmp using the instructions at http://forceamp.com/upgrade.htm and then retrying the commands.

    Also, you never mentioned the source of the ">90 causes problems" comment. Was it the developer of the managed package ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Ok.

    Sorry about that. Yes, from the developer from Perficient.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Then they are sharing their experience based on the triggers they have written for that object and not generalizing to the salesforce API as a whole.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • OK thanks! So it is possible that the trigger is poorly written :(
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Possible and common that batch sizes need to be reduced to accommodate the work of a trigger.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned