Receiving an error: Errors occurred whilst parsing file ...

• 
  Hi tweber!
  
  I know the error message says that the issue is with the file in the WorkingBase folder, but when editing the SQL in step #2, you will actually need to make the change to the dbo.buxc_bJCCM_Weekly.sql file within the repository.
  
  Can you please give this a try if you haven't already?
  
  If the problem persists after updating the repository though, can you please close SSMS, unlink from SQL Source Control, delete the Caches folder %localappdata%\Red Gate\SQL Source Control 7, then relink?
  
  Hope that helps but let me know if not!

  Jessica R May 21, 2020 02:20

  - 0 +
• 
  I tried editing the file and deleted the extra lines. My local version, server version and the file that is in the working base folder all have the same code. Source Control still gives me the same error.
  So I am looking at the next step of unlinking source control. If I exit out of SSMS how do I unlink?
  The only place I see is in SSMS using the "Unlink form source control" button.
  Thanks,
  Todd

  tweber May 21, 2020 15:16

  - 0 +
• 
  Hi @tweber ,
  
  Thanks for confirming that and so sorry, I messed up the order of steps!
  
  While SSMS is still open, please unlink from source control, then close SSMS, delete the caches folder, and then relink, I believe that should get things working again but please let me know if not!
  
  Kind regards,
  
  Jessica Ramos
  
  
  

  Jessica R May 21, 2020 16:10

  - 0 +
• 
  I still am getting errors.
  I tried what you suggested and now I get the following error:
  
  

  tweber May 26, 2020 16:31

  - 0 +
• 
  Hi @tweber,
  
  It looks like the error is happening with a different file now, unfortunately.
  
  The Redgate file seems to have "hase_Name", is that correct (or should it be RD.Phase_Name)? If it is incorrect though, I'm not sure how it ended up like that in the Redgate file.
  
  Would it be possible for you to share your repository with us to test with? I can send you a private link to upload to.
  
  
  

  Jessica R May 28, 2020 02:42

  - 0 +
• 
  The lines in the Redgate file should not be there at all. 
  
  What folder would you want me to upload?

  tweber May 28, 2020 14:59

  - 0 +
• 
  Hm that is strange. If you can please send a copy of your repository, as well as both your working base and transient folders (Setup>Under the hood), we can take a look. You can send it to support@red-gate.com with subject "Files for ticket #162026".
  
  Thank you!

  Jessica R May 30, 2020 01:01

  - 0 +
• 
  Now I am getting the following error:
  
  
  My database is case sensitive.
  
  

  tweber June 03, 2020 14:10

  - 0 +
• 
  Here is more on the error:
  
  
  

  tweber June 03, 2020 14:25

  - 0 +
• 
  Hi @tweber!
  
  Just to confirm, are there two objects with the name uspxc_WAWP_10_Get_VPData_B but different casing?
  
  In either case, as the database is case sensitive, can you please go to Setup>Comparison Options>Use case-sensitive object definition? Hope that helps!
  
  (If not, that error normally suggests that there are two create statements for the object - can you please search the repository for uspxc_WAWP_10_Get_VPData_B to confirm? You can use Notepad++'s Search>Find in files feature.)

  Jessica R June 04, 2020 16:31

  - 0 +

Add comment

Please sign in to leave a comment.