function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
EamonODEamonOD 

Big Insert that spans a Maintenance Window

Hi,

 

Over the weekend I'm planning to carry out a large insert using DBAmp butt see that there is Salesforce Maintenance planned. Will the session get killed off or rolled back if the two overlap?

 

Is there anyone out there with any experience of this I would appreciate some advice.

 

Any help welcome.

 

Thanks in advance,

EamonOD

forceAMPforceAMP

 

The answer to your question depends on whether you are using the bulkapi switch with sf_bulkops. If you are then the large insert exists as a set of jobs on salesforce and will survive the maintenance window.

 

If you are not using the bulkapi switch, then the records sent up until DBAmp loses the connection will not be rollbacked. You can identify which records "made it" by looking for "Operation Successful" in the load table.