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

Replication Job Hanging

I have a SQL job that Refreshes/Replicates multiple tables.
This weekend it hung after starting 1 of the steps.
This is the 2nd time in the last month that this has happened.

I have multiple .csv files in the DBAmpWork folder on the machine for the table hung.
I have multiple .csv files in the DBAmpWork folder on the machine for the previous times the job hung.

I have multiple SQL tables with _Previous20181101T033623710 type extensions in my table list.

I am currently running 3.6.8 but since the job is currently hung, I didn't want to kill SQL and do an upgrade if there are trouble shooting steps better done while it is going.

I can see the DBAmpNet2.exe file active and the thread count keeps changing.

SQL shows the job in EXECUTE status but no CPU being utilized.
1 person has
this problem
+1
Reply
  • Kill the current job that is hung. Once you do this, can you forward the complete message output from that job that hung to support at forceamp.com so we can take a look? Also, what are the exact DBAmp commands being run in the step where the hanging occurs?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Current logging for that step is just this:

    Job 'SFDCProd_Replicate' : Step 55, 'Servicing_Store__c' : Began Executing 2018-12-27 19:57:40

    Each step logs to an individual text file.

    The step command is:
    EXEC [dbo].[SF_Replicate] 'SalesForce_Prod' , 'Servicing_Store__c' , 'pkchunk'

    This is NOT the same step the job hung on last time.

    Are there any other logs I can grab?
    Nothing is showing in the SQL logs or SQL error logs.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I will try to kill the job.
    Last time this happened we had to kill the SQL Agent and restart SQL.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Do you have individual text files laying around for each step? Can you send me the text file for the step where it hangs? I need to see the DBAmp message output from the step that is hanging for analysis.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I pasted the contents of the text file in my response above.
    No other logs are available.
    If there are options to get more logging, please let me know what they are and I will get them in place.

    I have killed the process but we are in a hung ROLLBACK situation.

    I will go about killing all processes, SQL Server Agent, and DBAmpNet2.exe to try to get it to clear.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Once everything is clear, can you try running the following in a new query window and send the complete message output to support at forceamp.com?

    EXEC SF_Replicate 'SalesForce_Prod' , 'Servicing_Store__c' , 'pkchunk'
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • After SQL killing the SPID and using Task Manager to kill the DBAmpNet2.exe, it stopped.

    This is what got logged into the text file.

    Job 'SFDCProd_Replicate' : Step 55, 'Servicing_Store__c' : Began Executing 2018-12-27 19:57:40

    Msg 0, Sev 0, State 1: Operation canceled [SQLSTATE HY008]

    Query cancelled.
    Msg 16389, Sev 16, State 1: The connection is no longer usable because the server failed to respond to a command cancellation for a previously executed statement in a timely manner. Possible causes include application deadlocks or the server being overloaded. Open a new connection and re-try the operation. [SQLSTATE 08S01]

    I am currently running the command you asked for and will paste that once it finishes.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Let's move this off the forum. Can you send it to support at forceamp.com?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • --- Starting SF_Replicate for Servicing_Store__c V3.6.8
    11:27:35: Parameters: SalesForce_Prod Servicing_Store__c pkchunk Version: V3.6.8
    11:27:35: Drop Servicing_Store__c_Previous20190102T112735313 if it exists.
    11:27:35: Create Servicing_Store__c_Previous20190102T112735313 with new structure.
    11:27:40: DBAmpNet2 3.6.8.0 (c) Copyright 2015-2017 forceAmp.com LLC
    11:27:40: Parameters: replicate Servicing_Store__c_Previous20190102T112735313 RWSSSIS2016 SFDCProd SalesForce_Prod pkchunk
    11:27:45: Job 7502A00000FfqtKQAR created on salesforce.
    11:27:45: Using the bulkapi with polling every 60 seconds
    11:27:45: Job still running.
    11:28:00: Job still running.
    11:29:00: Job still running.
    11:30:00: Job still running.
    11:31:01: Job still running.
    11:32:01: Job still running.
    11:33:01: Job Complete.
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhktQAD-7522A000007Y5N1.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhksQAD-7522A000007Y5Mr.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl6QAD-7522A000007Y5Mh.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl5QAD-7522A000007Y5NQ.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhkrQAD-7522A000007Y5Np.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl4QAD-7522A000007Y5Nu.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhkqQAD-7522A000007Y5NG.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlAQAT-7522A000007Y5N6.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl7QAD-7522A000007Y5NV.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl8QAD-7522A000007Y5Nz.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlBQAT-7522A000007Y5QU.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlEQAT-7522A000007Y5Mm.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl9QAD-7522A000007Y5Nk.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlFQAT-7522A000007Y5NB.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlCQAT-7522A000007Y5QK.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlGQAT-7522A000007Y5O9.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlKQAT-7522A000007Y5NL.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlDQAT-7522A000007Y5OT.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlJQAT-7522A000007Y5O4.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlOQAT-7522A000007Y5Nf.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlHQAT-7522A000007Y5Pq.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlPQAT-7522A000007Y5Ox.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlQQAT-7522A000007Y5Mw.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlLQAT-7522A000007Y5PH.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlTQAT-7522A000007Y5Na.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlSQAT-7522A000007Y5Oi.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlRQAT-7522A000007Y5Pv.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlUQAT-7522A000007Y5Pl.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlVQAT-7522A000007Y5OJ.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlMQAT-7522A000007Y5OY.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlWQAT-7522A000007Y5Od.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlZQAT-7522A000007Y5OO.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlYQAT-7522A000007Y5On.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlXQAT-7522A000007Y5Q0.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlnQAD-7522A000007Y5OE.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlaQAD-7522A000007Y5PR.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhldQAD-7522A000007Y5PC.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhliQAD-7522A000007Y5QZ.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhljQAD-7522A000007Y5QP.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlpQAD-7522A000007Y5P7.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhloQAD-7522A000007Y5Pb.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhltQAD-7522A000007Y5P2.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlsQAD-7522A000007Y5Os.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhluQAD-7522A000007Y5PW.csv
    11:33:27: File downloaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlqQAD-7522A000007Y5QF.csv
    11:33:27: Files downloaded complete.
    11:33:31: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhkqQAD-7522A000007Y5NG.csv
    11:33:31: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhkrQAD-7522A000007Y5Np.csv
    11:33:31: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhksQAD-7522A000007Y5Mr.csv
    11:33:31: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhktQAD-7522A000007Y5N1.csv
    11:33:31: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl4QAD-7522A000007Y5Nu.csv
    11:33:31: 4218 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhksQAD-7522A000007Y5Mr.csv
    11:33:31: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl5QAD-7522A000007Y5NQ.csv
    11:33:31: 4964 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhktQAD-7522A000007Y5N1.csv
    11:33:31: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl6QAD-7522A000007Y5Mh.csv
    11:33:32: 5378 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl6QAD-7522A000007Y5Mh.csv
    11:33:32: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl7QAD-7522A000007Y5NV.csv
    11:33:33: 32487 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl5QAD-7522A000007Y5NQ.csv
    11:33:33: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl8QAD-7522A000007Y5Nz.csv
    11:33:37: 100000 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhkqQAD-7522A000007Y5NG.csv
    11:33:37: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl9QAD-7522A000007Y5Nk.csv
    11:33:37: 85895 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhkrQAD-7522A000007Y5Np.csv
    11:33:37: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlaQAD-7522A000007Y5PR.csv
    11:33:38: 100000 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl4QAD-7522A000007Y5Nu.csv
    11:33:38: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlAQAT-7522A000007Y5N6.csv
    11:33:38: 54560 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl8QAD-7522A000007Y5Nz.csv
    11:33:38: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlBQAT-7522A000007Y5QU.csv
    11:33:38: 4681 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlAQAT-7522A000007Y5N6.csv
    11:33:38: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlCQAT-7522A000007Y5QK.csv
    11:33:39: 100000 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl7QAD-7522A000007Y5NV.csv
    11:33:39: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhldQAD-7522A000007Y5PC.csv
    11:33:41: 76525 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlaQAD-7522A000007Y5PR.csv
    11:33:41: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlDQAT-7522A000007Y5OT.csv
    11:33:42: 95067 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl9QAD-7522A000007Y5Nk.csv
    11:33:42: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlEQAT-7522A000007Y5Mm.csv
    11:33:42: 8316 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlEQAT-7522A000007Y5Mm.csv
    11:33:42: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlFQAT-7522A000007Y5NB.csv
    11:33:43: 4838 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlFQAT-7522A000007Y5NB.csv
    11:33:43: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlGQAT-7522A000007Y5O9.csv
    11:33:43: 66279 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlBQAT-7522A000007Y5QU.csv
    11:33:43: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlHQAT-7522A000007Y5Pq.csv
    11:33:44: 99838 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlCQAT-7522A000007Y5QK.csv
    11:33:44: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhliQAD-7522A000007Y5QZ.csv
    11:33:45: 43009 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlGQAT-7522A000007Y5O9.csv
    11:33:45: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhljQAD-7522A000007Y5QP.csv
    11:33:47: 95345 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhldQAD-7522A000007Y5PC.csv
    11:33:47: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlJQAT-7522A000007Y5O4.csv
    11:33:47: 94500 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlDQAT-7522A000007Y5OT.csv
    11:33:47: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlKQAT-7522A000007Y5NL.csv
    11:33:48: 9849 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlKQAT-7522A000007Y5NL.csv
    11:33:48: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlLQAT-7522A000007Y5PH.csv
    11:33:49: 81221 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlHQAT-7522A000007Y5Pq.csv
    11:33:49: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlMQAT-7522A000007Y5OY.csv
    11:33:50: 98908 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhliQAD-7522A000007Y5QZ.csv
    11:33:50: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlnQAD-7522A000007Y5OE.csv
    11:33:50: 43745 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlJQAT-7522A000007Y5O4.csv
    11:33:50: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhloQAD-7522A000007Y5Pb.csv
    11:33:50: 99725 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhljQAD-7522A000007Y5QP.csv
    11:33:50: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlOQAT-7522A000007Y5Nf.csv
    11:33:50: 9177 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlOQAT-7522A000007Y5Nf.csv
    11:33:50: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlpQAD-7522A000007Y5P7.csv
    11:33:53: 51523 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlnQAD-7522A000007Y5OE.csv
    11:33:53: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlPQAT-7522A000007Y5Ox.csv
    11:33:53: 5035 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlPQAT-7522A000007Y5Ox.csv
    11:33:53: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlqQAD-7522A000007Y5QF.csv
    11:33:53: 99691 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlLQAT-7522A000007Y5PH.csv
    11:33:53: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlQQAT-7522A000007Y5Mw.csv
    11:33:54: 3859 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlQQAT-7522A000007Y5Mw.csv
    11:33:54: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlRQAT-7522A000007Y5Pv.csv
    11:33:54: 78179 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlpQAD-7522A000007Y5P7.csv
    11:33:54: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlsQAD-7522A000007Y5Os.csv
    11:33:55: 81165 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhloQAD-7522A000007Y5Pb.csv
    11:33:55: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlSQAT-7522A000007Y5Oi.csv
    11:33:56: 95876 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlMQAT-7522A000007Y5OY.csv
    11:33:56: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhltQAD-7522A000007Y5P2.csv
    11:33:58: 75216 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlsQAD-7522A000007Y5Os.csv
    11:33:58: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlTQAT-7522A000007Y5Na.csv
    11:33:59: 99293 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlqQAD-7522A000007Y5QF.csv
    11:33:59: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhluQAD-7522A000007Y5PW.csv
    11:33:59: 97357 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlRQAT-7522A000007Y5Pv.csv
    11:33:59: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlUQAT-7522A000007Y5Pl.csv
    11:34:00: 41041 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlTQAT-7522A000007Y5Na.csv
    11:34:00: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlVQAT-7522A000007Y5OJ.csv
    11:34:00: 28574 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhluQAD-7522A000007Y5PW.csv
    11:34:00: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlWQAT-7522A000007Y5Od.csv
    11:34:02: 80960 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhltQAD-7522A000007Y5P2.csv
    11:34:02: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlXQAT-7522A000007Y5Q0.csv
    11:34:03: 99998 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlSQAT-7522A000007Y5Oi.csv
    11:34:03: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlYQAT-7522A000007Y5On.csv
    11:34:04: 69201 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlUQAT-7522A000007Y5Pl.csv
    11:34:04: Loading file into SQL Server: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlZQAT-7522A000007Y5OO.csv
    11:34:05: 91143 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlVQAT-7522A000007Y5OJ.csv
    11:34:06: 98056 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlWQAT-7522A000007Y5Od.csv
    11:34:06: 47830 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlYQAT-7522A000007Y5On.csv
    11:34:06: 57343 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlZQAT-7522A000007Y5OO.csv
    11:34:07: 98797 rows loaded. - D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlXQAT-7522A000007Y5Q0.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhksQAD-7522A000007Y5Mr.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhktQAD-7522A000007Y5N1.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl6QAD-7522A000007Y5Mh.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl5QAD-7522A000007Y5NQ.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhkqQAD-7522A000007Y5NG.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhkrQAD-7522A000007Y5Np.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl4QAD-7522A000007Y5Nu.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl8QAD-7522A000007Y5Nz.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlAQAT-7522A000007Y5N6.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl7QAD-7522A000007Y5NV.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlaQAD-7522A000007Y5PR.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl9QAD-7522A000007Y5Nk.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlEQAT-7522A000007Y5Mm.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlFQAT-7522A000007Y5NB.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlBQAT-7522A000007Y5QU.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlCQAT-7522A000007Y5QK.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlGQAT-7522A000007Y5O9.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhldQAD-7522A000007Y5PC.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlDQAT-7522A000007Y5OT.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlKQAT-7522A000007Y5NL.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlHQAT-7522A000007Y5Pq.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhliQAD-7522A000007Y5QZ.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlJQAT-7522A000007Y5O4.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhljQAD-7522A000007Y5QP.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlOQAT-7522A000007Y5Nf.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlnQAD-7522A000007Y5OE.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlPQAT-7522A000007Y5Ox.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlLQAT-7522A000007Y5PH.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlQQAT-7522A000007Y5Mw.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlpQAD-7522A000007Y5P7.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhloQAD-7522A000007Y5Pb.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlMQAT-7522A000007Y5OY.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlsQAD-7522A000007Y5Os.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlqQAD-7522A000007Y5QF.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlRQAT-7522A000007Y5Pv.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlTQAT-7522A000007Y5Na.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhluQAD-7522A000007Y5PW.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhltQAD-7522A000007Y5P2.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlSQAT-7522A000007Y5Oi.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlUQAT-7522A000007Y5Pl.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlVQAT-7522A000007Y5OJ.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlWQAT-7522A000007Y5Od.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlYQAT-7522A000007Y5On.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlZQAT-7522A000007Y5OO.csv
    11:34:07: File loaded successfully: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlXQAT-7522A000007Y5Q0.csv
    11:34:07: File load complete.
    11:34:07: 2818662 rows copied.
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhkqQAD-7522A000007Y5NG.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhkrQAD-7522A000007Y5Np.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhksQAD-7522A000007Y5Mr.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhktQAD-7522A000007Y5N1.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl4QAD-7522A000007Y5Nu.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl5QAD-7522A000007Y5NQ.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl6QAD-7522A000007Y5Mh.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl7QAD-7522A000007Y5NV.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl8QAD-7522A000007Y5Nz.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhl9QAD-7522A000007Y5Nk.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlaQAD-7522A000007Y5PR.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlAQAT-7522A000007Y5N6.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlBQAT-7522A000007Y5QU.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlCQAT-7522A000007Y5QK.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhldQAD-7522A000007Y5PC.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlDQAT-7522A000007Y5OT.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlEQAT-7522A000007Y5Mm.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlFQAT-7522A000007Y5NB.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlGQAT-7522A000007Y5O9.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlHQAT-7522A000007Y5Pq.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhliQAD-7522A000007Y5QZ.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhljQAD-7522A000007Y5QP.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlJQAT-7522A000007Y5O4.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlKQAT-7522A000007Y5NL.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlLQAT-7522A000007Y5PH.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlMQAT-7522A000007Y5OY.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlnQAD-7522A000007Y5OE.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhloQAD-7522A000007Y5Pb.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlOQAT-7522A000007Y5Nf.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlpQAD-7522A000007Y5P7.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlPQAT-7522A000007Y5Ox.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlqQAD-7522A000007Y5QF.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlQQAT-7522A000007Y5Mw.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlRQAT-7522A000007Y5Pv.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlsQAD-7522A000007Y5Os.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlSQAT-7522A000007Y5Oi.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhltQAD-7522A000007Y5P2.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlTQAT-7522A000007Y5Na.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhluQAD-7522A000007Y5PW.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlUQAT-7522A000007Y5Pl.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlVQAT-7522A000007Y5OJ.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlWQAT-7522A000007Y5Od.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlXQAT-7522A000007Y5Q0.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlYQAT-7522A000007Y5On.csv
    11:34:07: Deleted file: D:\DBAmpWork\7502A00000FfqtKQAR-7512A00000JEhlZQAT-7522A000007Y5OO.csv
    11:34:07: DBAmpNet2 Operation successful.
    11:34:09: Drop Servicing_Store__c if it exists.
    11:34:09: Rename previous table from Servicing_Store__c_Previous20190102T112735313 to Servicing_Store__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    11:34:09: Create primary key on Servicing_Store__c
    --- Ending SF_Replicate. Operation successful.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Looks like the command that is hanging in the job worked fine in a new query window. Can you go to the advanced tab of the job steps and check the option to save the job output to a table. Then when the job fails/hangs, return to the Advanced tab and hit VIEW. This will display the complete message output and send it to us.

    Also, do you have the DBAmp Performance Package turned on?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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