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

Foreign key references invalid column

There were some changes made in my production Sales Force and now my Refresh job is failing on SF_CreateKeys. Foreign key references invalid column
How do I fix the issue?
1 person has
this question
+1
Reply
  • Run the stored procedure SF_Dropkeys. That will drop all existing keys.

    Then run the SF_CreatedKeys to recreate them.

    Note: We do not recommend running SF_CreateKeys for most customers. This is because the SF_Replicate stored procedure automatically creates keys on the primary Id. Therefore for most customers SF_CreateKeys is only needed if you are creating a database diagram.

    Send me an email at support at forceamp.com if you need help with removing SF_CreateKeys from your environment.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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