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

Just upgraded DBAmp from 2.14.6 to 2.18.2 and getting an error while running a job

I Just upgraded DBAmp from 2.14.6 to 2.18.2 for MS SQL 2008R2 and I am trying to run a job. It looks like most of the commands are getting executed, but then the job ends with the error. Can you help me understand what this error means?

[SQLSTATE 01000] (Message 0) 05:15:12: Opening SQL Server rowset [SQLSTATE 01000] (Message 0) 05:15:15: 22 rows copied. [SQLSTATE 01000] (Message 0) 05:15:15: Drop Campaign if it exists. [SQLSTATE 01000] (Message 0) 05:15:15: Rename previous table from Campaign_Previous to Campaign [SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures. [SQLSTATE 01000] (Message 15477) 05:15:15: Create primary key on Campaign [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Replicate for Opportunity [SQLSTATE 01000] (Message 0) 05:15:15: Drop Opportunity_Previous if it exists. [SQLSTATE 01000] (Message 0) 05:15:15: Create Opportunity_Previous with new structure. [SQLSTATE 01000] (Message 0) 05:15:16: Run the DBAmp.... The step failed.
1 person has
this problem
+1
Reply
  • The job history always truncates the message output and we cannot see the actual message.

    Edit the job step, navigate to the Advanced tab and check the setting to Log to a table. Then start the job. When the job completes, come back to the advanced tab and view the table with the entire message output. Send it to me at support at forceamp.com so we can take a look.

    Alternatively, run the same command the step is using in a query window and send me the complete message output from the messages tab.

    Also, to confirm, did you run the Create DBAMP SPROCS.sql script to upgrade the stored procedures in this database as required by the upgrade instructions?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Yes, I ran the DBAMP SPROCS.sql script.
    I used the query window and ran the same command. These are the errors I got:

    11:27:27: Drop LeadHistory_Previous if it exists.
    11:27:27: Create LeadHistory_Previous with new structure.
    11:27:27: Run the DBAmp.exe program.
    11:27:27: DBAmp Bulk Operations. V2.18.2 (c) Copyright 2006-2014 forceAmp.com LLC
    11:27:27: Populating local table LeadHistory_Previous , server_name / master .
    11:27:28: DBAmp is using the SQL Native Client.
    11:27:28: Opening SQL Server rowset
    11:47:29: Error: RunQuery failed with com_error.
    11:47:29: FAHttp::Send::WinHttpReceiveResponse
    Win32Error::
    The operation timed out

    11:47:29: Error: DBAmp.exe was unsuccessful.
    11:47:29: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "LeadHistory_Previous" "server_name" "master" "linked_server_name"
    --- Ending SF_Replicate. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 244
    --- Ending SF_Replicate. Operation FAILED.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • This is a client-side timeout.

    Run the DBAmp configuration program, menu choice registry settings. Change the Receive timeout to 2900.

    Then retry replicating just that table.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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