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

Error: qbdialer__Call_Date_Time__c exists in the local table but does not exist in the delta table

I'm receiving the following error

Error: qbdialer__Call_Date_Time__c exists in the local table but does not exist in the delta table

I'm pretty new to this system, but from my research it looks like it may have something to do with sf_refresh? (which is apparently a sp) Any suggestions?
1 person has
this question
+1
Reply
  • What is the exact command you are running ?

    Can you provide the entire message output ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I should note that I am able to find the column in both my Task table as well as Task_Delta2017-02-03
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Date 2/15/2017 12:49:25 AM
    Log Job History (Get Salesforce data DBAmp (Replicate))

    Step ID 6
    Job Name Get Salesforce data DBAmp (Replicate)
    Step Name Delta Load Tasks
    Duration 00:12:48
    Sql Severity 16
    Sql Message ID 0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted 0

    Message
    Executed as user: FINSQLBI\SQLSERVERAGENT. --- Ending SF_Refresh. Operation FAILED. [SQLSTATE 42000] (Error 50000) --- Starting SF_Refresh for Task V3.1.9 [SQLSTATE 01000] (Error 0) 00:49:26: Using last run time of 2017-02-06 00:47:00 [SQLSTATE 01000] (Error 0) 01:02:13: Identified 145719 updated/inserted rows. [SQLSTATE 01000] (Error 0) 01:02:13: Error: qbdialer__Call_Date_Time__c exists in the local table but does not exist in the delta table or has a different definition. [SQLSTATE 01000] (Error 0) 01:02:13: Error: qbdialer__Call_Dial_Number__c exists in the local table but does not exist in the delta table or has a different definition. [SQLSTATE 01000] (Error 0) 01:02:13: Error: qbdialer__Call_Hour__c exists in the local table but does not exist in the delta table or has a different definition. [SQLSTATE 01000] (Error 0) 01:02:13: Error: qbdialer__Call_Lead_Status__c exists in the local table but does not exist in the delta table or has a different definition. [SQLSTATE 01000] (Error 0) 01:02:13: Error: qbdialer__Call_Ring_Time__c exists in the local table but does not exist in the delta table or has a different definition. [SQLSTATE 01000] (Error 0) 01:02:13: Error: qbdialer__Call_Time_Zone__c exists in the local table but does not exist in the delta table or has a different definition. [SQLSTATE 01000] (Error 0) 01:02:13: Error: qbdialer__Callback_Date_Time__c exists in the local table but does not exist in the delta table or has a different definition. [SQLSTATE 01000] (Error 0) 01:02:13: Error: qbdialer__CallRecordingURL__c exists in the local table but does not exist in the delta table or has a different definition. [SQLSTATE 01000] (Error 0) 01:02:13: Error: qbdialer__ImpressionId__c exists in the local table but does not exist in the delta table or has a different definition. [SQLSTATE 01000] (Error 0) 01:02:13: Error: qbdialer__SMSReminder__c exists in the local table but does not exist in the delta table or has a different definition. [SQLSTATE 01000] (Error 0) 01:02:13: Error: Table schema has changed and therefore the table cannot be refreshed. [SQLSTATE 01000] (Error 0) --- Ending SF_Refresh. Operation FAILED. [SQLSTATE 01000] (Error 0). The step failed.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

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

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

  • Are there Task tables in the database with schema other than dbo ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

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

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

  • So basically you need to tell sf_refresh what you want to do when some one changes the schema on salesforce. Your choices are:

    1. Fail. This is what is happening now
    2. Go run a sf_replicate of the table to pick up the changes
    exec sf_refresh 'Salesforce','account','yes'
    3. Keep going with the subset of columns that are still valid
    exec sf_refresh 'Salesforce','account','subset'

    For more details see SF_Refresh in the Stored Procedure Reference chapter of the DBAmp doc.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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