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

Error while replicating Account

unclosed token at byte index 2072208 [SQLSTATE 01000] (Error 0) 04:52:52: Error: DBAmp.exe was unsuccessful.
1 person has
this question
+1
Reply
  • Couple of questions:

    1. What version of DBAmp are you currently running?
    2. What is the exact command you are running that causes this error?
    3. Can you post the complete message output from the command that is causing this error?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • DBAmp version : 3.1.1

    Command is inside error reprot below:
    Error:

    Ending SF_Replicate. Operation FAILED. [SQLSTATE 42000] (Error 50000) --- Starting SF_Replicate for Account V3.1.1 [SQLSTATE 01000] (Error 0) 02:00:01: Drop Account_Previous if it exists. [SQLSTATE 01000] (Error 0) 02:00:01: Create Account_Previous with new structure. [SQLSTATE 01000] (Error 0) 02:00:05: Run the DBAmp.exe program. [SQLSTATE 01000] (Error 0) 02:00:05: DBAmp Bulk Operations. V3.1.1 (c) Copyright 2006-2015 forceAmp.com LLC [SQLSTATE 01000] (Error 0) 02:00:05: Populating local table Account_Previous , [SQLSTATE 01000] (Error 0) 02:00:05: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Error 0) 02:00:05: Opening SQL Server rowset [SQLSTATE 01000] (Error 0) 04:48:29: Error: An error has occurred while fetching rows from salesforce.com. [SQLSTATE 01000] (Error 0) 04:48:29: Error: Replication failed. [SQLSTATE 01000] (Error 0) Source: ForceAmpAPI.SQueryResults4.1 [SQLSTATE 01000] (Error 0) Description: CQueryResultSet::Next [SQLSTATE 01000] (Error 0) unclosed token at byte index 2072208 [SQLSTATE 01000] (Error 0) 04:52:52: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000] (Error 0) 04:52:52: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "Account_Previous" [SQLSTATE 01000] (Error 0) --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000] (Error 0). The step failed.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Can you upgrade to the latest version of DBAmp and retry the command? To upgrade to the latest version of DBAmp, follow the instructions at the following link: http://forceamp.com/upgrade.htm
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Ok, let me try this...will take few hours..I will update you.
    Thanks
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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