Partition scheme

• 
  Hello, we have the same error and it is really blocking us. Please look into this.

  CaptainSensible June 07, 2018 12:21

  - 0 +
• 
  Hi @sergeydv & @CaptainSensible
  
  Thank you both for your post. 
  
  Please read through the documentation page below which should help you both to resolve your issues. 
  
  https://documentation.red-gate.com/soc6/troubleshooting/error-messages/failed-to-locate-the-object-name-for-the-object-name
  
  If not then please send us a ticket with your specifics if you have a support contract. 
  
  I hope this helps. 
  
  Richard Lynch.

  RichardL June 08, 2018 16:50

  - 0 +
• 
  Hi @RichardL
  
  This link was very helpful and resolved my issue.
  
  Thank you.

  sergeydv June 10, 2018 06:04

  - 0 +
• 

  We found out this solution as well:

  • Source Control -> Under the hood -> Open working base
  • In Windows Explorer, navigate to the folder for the missing object e.g. partition scheme
  • Right-click in folder, TortoiseSVN -> Update to Revision -> Choose items ..
  • Select the presumably unselected object and press OK.

  Do not ask me what causes this.
  
  

  CaptainSensible July 31, 2019 14:19

  - 0 +
• 
  This solutions here and in the linked article didn't work for us at all.  SQL Compare won't even open the folder. It crashes with the same error that SQL Source Control received in the beginning. 
  

  ben_medalogix January 28, 2020 02:25

  - 0 +
• 
  Hi,

  
  

  we are still getting this error (5 years after this post was opened). Is there a plan from RedGate to fix it at some point in the future?

  
  

  Partition scheme and partition function files are just not checked-in in the working base repository.

  Michaelbe April 20, 2023 08:46

  - 0 +
• 
  Hi @Michaelbe
  
  I'd advise looking at the article here: https://productsupport.red-gate.com/hc/en-us/articles/360007874773-The-partition-scheme-xxx-on-table-yyy-was-not-found

  DanC April 25, 2023 12:21

  - 0 +
• 
  Hi @DanC ,

  
  

  we found out that the Transient folder contained files which were not in the WorkingBase. So we wrote a PowerShell script which loops trough the LinkedDatabases, copies file from Transient to WorkingBase and commits them.

  
  

  Not sure if this is the best way to solve it but it worked and didn't cause any other issues.
  

  
  

  If we get the issue again in the future i will try your article, thanks.

  
  

  Best regards,
  Michael
  

  Michaelbe April 25, 2023 13:59

  - 0 +
• 
  Still struggling several years on with this one (whenever I have to re-setup an environment - long enough having passed since I fudged a solution the previous time.)
  
  https://productsupport.red-gate.com/hc/en-us/articles/360007874773-The-partition-scheme-xxx-on-table-yyy-was-not-found doesn't work (and has a 0/23 people found this useful rating)
  

  rhodrie June 26, 2023 07:26

  - 0 +
• 
  Still struggling several years on with this one (whenever I have to re-setup an environment - long enough having passed since I fudged a solution the previous time.)
  
  https://productsupport.red-gate.com/hc/en-us/articles/360007874773-The-partition-scheme-xxx-on-table-yyy-was-not-found doesn't work (and has a 0/23 people found this useful rating)
  

  rhodrie June 26, 2023 07:26

  - 0 +

Add comment

Please sign in to leave a comment.