The column '[blah]' referenced by index 'PK_blah' was not found in the database.

• 
  The latest way that I've worked around the issue was by following these steps:
  

  1. Read the error message to find the table name that is having problems.
  2. Find offending table in SSMS Object Explorer
  3. Right click on table to open the popup menu
  4. Click on Script Table As... > Drop and Create to... > New Query Editor Window
  5. Execute generated script
  6. This will throw an error...
  7. Give focus to the SQL Source Control tab (this will cause the RedGate error on another table).
  8. Repeat back at step 1 with the table referenced in the error dialog

  
  Once I follow the above steps all the way down to the deepest table (ie. no child record constraints), the error dialog went away and it showed my changed files.
  
  It wasn't pretty, but it worked. Would still like to hear back from RedGate with a ticket number so that I can track this issue over time.
  
  Thanks!
  Luc

  Luc December 11, 2017 22:13

  - 0 +
• 
  Hi Luc,
  
  Thanks for posting. We've created a support ticket for you and will be in touch shortly.

  Tianjiao_Li December 13, 2017 13:39

  - 0 +
• 
  Thank you for the response. Could you please provide me with the support ticket number for my records?
  
  Thanks,
  Luc

  Luc December 13, 2017 15:34

  - 0 +
• 
  Hi @Luc
  
  You will have received your ticket number in an automated mail from our ticketing system when it was created. My colleagues will be in touch via this ticket.

  RichardL December 15, 2017 14:13

  - 0 +
• 
  I am having the same issue. Does anyone know how to have this fixed?

  mzamora July 11, 2018 14:46

  - 0 +
• 
  The issue is back. I'm getting it every minute or so, over and over... 🤦‍♂️
  
  Luckily my work around steps above still apply. However, once the Drop and Create to... works successfully on the final faulty table, all of my data is wiped. Thus, it's not an ideal solution, but it does work.

  Luc July 12, 2019 14:09

  - 0 +
• 
  ATTN: RedGate Support
  
  Any update on this issue? It's still causing us problems from time to time and the work around is problematic as well. Thanks for any updates...

  Luc April 14, 2020 04:08

  - 0 +
• 
  Hi!!
  I've got the same problem... any help?

  Cristina April 22, 2020 06:55

  - 0 +
• 
  Colleague of mine is also having this issue, can't seem to correct it.

  tonywaddle April 22, 2020 14:43

  - 0 +
• 

  tonywaddle said:

  Colleague of mine is also having this issue, can't seem to correct it.

  Managed to fix it by disabling the index, then apply latest changes again from Source Control.

  tonywaddle April 22, 2020 15:06

  - 0 +
• 
  The only way I've been able to fix it is by following these steps. It is not ideal, but it does work every time.

  Luc April 24, 2020 08:05

  - 0 +
• 
  The only way I've been able to fix it is by following these steps. It is not ideal, but it does work every time.

  Luc April 24, 2020 08:05

  - 0 +
• 
  Still getting this error after rebuild db and  reinstalling redgate s/w. very very frustrating.   

  JLMCC March 24, 2022 07:30

  - 0 +
• 

  Luc said:

  The only way I've been able to fix it is by following these steps. It is not ideal, but it does work every time.

  Have tried this. It did not work any other tips?

  JLMCC March 25, 2022 09:15

  - 0 +

Add comment

Please sign in to leave a comment.