Error in parsing

• 
  Is it always the same file that gives you the error message? Can you try unlinking and relinking the database, and see if it persists? If so, would it be possible for you to email us the affected file at support@red-gate.com, quoting the reference F0061365 in the subject line?

  Andy C S June 18, 2012 08:24

  - 0 +
• 
  I realize this post is old but was there a fix to this problem? I can't fix the problem committing via TortoiseSVN. My error was
  
  There was an error parsing the file "C:UsersharmstAppDataLocalRed GateSQL Source Control 3Transientsw20mz4vo.1z3Stored Procedures<SPNAME>.sql" at line 5, column 7, near the text .

  harmst May 14, 2015 14:51

  - 0 +
• 
  Got the same error. Any soluting to this? Also I can't send error reports. Gets stuck on Preparing the error report

  hannesdahlberg April 07, 2016 07:47

  - 0 +
• 
  Getting this a lot more often of late.
  
  Trashing and recreating the repository is no longer workable as I get this error within 3 or 4 commits.

  Errors occurred whilst parsing file C:UsersRadAppDataLocalRed GateSQL Source Control 4WorkingBasesfie1sg2a.rsnStored ProceduresProcessInterestRollover.sql
  
  '' at line 123, column 569
  
  

  
  Needless to say the query in question is 100% valid.
  
  SQL Server 2014
  Git source control
  SQL Source 4.4.0
  Windows 10
  
  The report error tool also seems to hang indefinitely preparing the report

  conradakunga May 13, 2016 04:57

  - 0 +
• 
  Errors occurred whilst parsing file C:\Users\{User}\AppData\Local\Red Gate\SQL Source Control 5\WorkingBases\coucolar.uwf\Stored Procedures\dbo.{Procedure Name}.sql
  
  '' at line 14, column 4
  
  '' at line 164, column 6
  
  '' at line 179, column 7
  
  '' at line 179, column 31
  
  '' at line 181, column 6
  
  This has started happening recently after upgrading to SQL Source Control Version 5.8.3.6733. I have a whole database which I can no longer use source control with. I checked the problem procedure was valid and it is. I then committed the procedure using Tortoise SVN, but it still doesn't work. I tried re-linking the database with source control as well, but nothing worked. I was going to attempt to downgrade to a slightly older version of SQL Source Control, but the newest version I could find online was Version 4.4!!! Can someone please tell me where I can find a later version (e.g. 5.8.3)? Or tell me how to fix this, but I assume it's a Red Gate bug.
  
  Cheers,
  Greg

  sgtwickoolOld August 30, 2017 15:42

  - 0 +
• 
  I just got the same problem. I've checked the code and it's all valid. In my case the code appears to be the copy fetched from the server for comparison:
  Errors occurred whilst parsing file C:\Users\{UserName}\AppData\Local\Red Gate\SQL Source Control 5\Transients\v454ksvg.4cb\Stored Procedures\dbo.sp_sys_HouseKeeping_CacheDB.sql
  
  '' at line 16, column 7
  
  This is line 16:
  CREATE PROCEDURE [dbo].[sp_sys_HouseKeeping_CacheDB]
  Column 7 would be the space between CREATE and PROCEDURE!!!

  NathanHobbs August 31, 2017 16:37

  - 0 +
• 
  +1 for this error on MS SQL 2014 + using Git as a repo - via a local folder.
  
  
  

  CPickett September 03, 2017 22:42

  - 0 +
• 
  Updated to SQL Source Control 5.7 and now getting this as an error popup rather than just a notification on the Commit page.
  
  Errors occurred whilst parsing file c:\[username redacted]\AppData\Local\Red Gate\SQL Source Control 5\Transients\2u11zjj5.elq\Stored Procedures\[filename redacted].sql

  CPickett September 03, 2017 22:44

  - 0 +
• 
  I am also facing this error, Please let me know if there is a solution for it. I am using SQL Server 2017, SQL Source Control 5.1. It gives this error when I am connecting to a Working Folder using SQL Server 2014 SSMS and connecting 2017's Server on my local. Please help.  

  Shreesh_Tiwari October 30, 2019 06:23

  - 0 +
• 
  Any resolution on this? I now am also facing this issue and its on the period between the dbo and procedure name!

  cpugeek January 21, 2021 17:55

  - 0 +
• 
  I'm getting this too. Source Control 7.1.9.  I've even tried deleting the table and recreating it from a previous commit, which clearly was valid at the time.  No love.

  Random Lengths August 30, 2022 08:50

  - 0 +
• 
  Hi,
  
  This isn't a bug to reassure you and is often down to incorrect syntax in the files. 
  
  The solution on this can depend on whether the issue is with WorkingBases or Transients files.
  
  To investigate this further, I would advise reaching out to support at: https://productsupport.red-gate.com/hc/en-us
  
  

  DanC September 07, 2022 12:34

  - 0 +
• 
  I'm sorry, but I will have to disagree with you DanC.  I tried deleting the table in question, committing and relinking, only to have every table throw this error, even though there were no recent changes in these tables that were failing.  The solution via productsupport was to unlink,  delete my local repo, re-clone from remote and re-attach.  All was good, and no commits were shown.  It was not syntax.

  Random Lengths September 07, 2022 12:53

  - 0 +

Add comment

Please sign in to leave a comment.