How can we help you today? How can we help you today?
GSS
Activity overview Badges (0) Posts (2) Comments (6)

Activity overview

Latest activity by GSS

I have raised a support request. / comments
  1. Community
  2. SQL Compare
  3. unexpected token - where is it?
I have raised a support request.
0 votes
Hi Peter Sorry report that error is back.  It seems to be almost random.  Some days it does not occur, others it does.  And not related to any particular database.  The error itself is identical whenever it appears.  But once it does appear, nothing works for the remainder of the day. Where can I upload my log? Thanks. / comments
  1. Community
  2. SQL Compare
  3. unexpected token - where is it?
Hi PeterSorry report that error is back.  It seems to be almost random.  Some days it does not occur, others it does.  And not related to any particular database.  The error itself is identical whe...
0 votes
Thanks Peter.  The news is that this error has disappeared as mysteriously as it appeared.   I recently reinstalled Redgate (as part of updating to SSMS v20) so perhaps that fixed it.  Or maybe the version of Azure SQL Server changed to remove this unrecognised token. Sorry I can't provide a more satisfactory resolution. / comments
  1. Community
  2. SQL Compare
  3. unexpected token - where is it?
Thanks Peter.  The news is that this error has disappeared as mysteriously as it appeared.   I recently reinstalled Redgate (as part of updating to SSMS v20) so perhaps that fixed it.  Or maybe the...
0 votes
Thanks for the reply, Peter.  I'm happy to discuss here.  The answer is I do not know what "Window" is, and there is no db object I know called this.   This is why I was hoping to see the rest of the text for context.  Do you know how/where I can do this? There is a table column called "Window", but removing this table from the compare, and the database itself, makes no difference to the error. Otherwise "windows" appears in the Azure SQL server name.  (As is the case with most Azure servers.) This is an error that appears even after I narrow the comparison down to just one table, with the 'Ignore' option checked for everything.  It appears during the "comparing databases" part. / comments
  1. Community
  2. SQL Compare
  3. unexpected token - where is it?
Thanks for the reply, Peter.  I'm happy to discuss here.  The answer is I do not know what "Window" is, and there is no db object I know called this.   This is why I was hoping to see the rest of t...
0 votes
unexpected token - where is it?
  1. Community
  2. SQL Compare
I have an error when trying to perform a SQL Compare of two Azure SQL Server databases.  This is making it impossible to perform any compare of them.unexpected token: ["Window",<1392>,line=23,col=4...
2 followers 7 comments 0 votes
Thank for your reply.  I've just tried that.  The problem is that selecting a "remind me" option when a comparison is on screen does not dismiss the banner.  So it overlays the server names at each side of the comparison. It only dismisses it prior to you doing a comparison.   I suppose I could ensure I do that before running the comparison. / comments
  1. Community
  2. SQL Compare
  3. Update banner obscures stuff
Thank for your reply.  I've just tried that.  The problem is that selecting a "remind me" option when a comparison is on screen does not dismiss the banner.  So it overlays the server names at each...
0 votes
Update banner obscures stuff
  1. Community
  2. SQL Compare
The update banner is good at letting you know an update is available, but currently it is overlayed across the top of the window, directly beneath the menu bar and hiding the name of the servers yo...
2 followers 2 comments 0 votes
Thanks for your reply.  See below; [image] Clicking "More details" just shows the same error with no further details. In the log file the relevant section seems to be; 113:58:01.952|Info   |SQL Compare         |13 |Sending 1 event: [   {     "eventType": "database.comparison.failed",     "headers": {       "productId": "sql-compare",       "productVersion": "13.7.7.10021",       "eventUuid": "3dfc753d-2cb0-45b4-83c0-14dbbbf1d04c",       "usageUserId": "eec3d61d-b7af-4f3b-9566-662108fd3ab3",       "sessionUuid": "4894d79a-3b02-49fc-b17f-0bcdb5d23cbd",       "createdTimeUtc": "2019-05-20T12:58:01Z"     },     "payload": {       "exception": {         "type": "MismatchedTokenException",         "stackTrace": "   at RedGate.SQLCompare.ASTParser.StructureParser.RecoverToNextStatement(Exception e)   at RedGate.SQLCompare.ASTParser.StructureParser.statementFirstInBatch()   at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch()   at RedGate.SQLCompare.ASTParser.StructureParser.expr()   at RedGate.SQLCompare.Engine.Utils.GetAst(TextReader script, Boolean quotedIdentifiers)   at RedGate.SQLCompare.Engine.DatabaseMapper.FixTextObjectDefinition(ITextObject obj)   at RedGate.SQLCompare.Engine.DatabaseMapper.MapStoredProcedure(StoredProcedure sp, IDictionary`2 spMappingsToAdd)   at RedGate.SQLCompare.Engine.DatabaseMapper.MapDatabase(SqlCompareOwnerMappings origMappings)   at RedGate.SQLCompare.Engine.SqlCompareOwnerMappings.MapDatabase(Boolean first, StatusEventHandler status)   at RedGate.SQLCompare.Engine.SqlCompareOwnerMappings.MapDatabase(Boolean first)   at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineComparisonService.<>c__DisplayClass11_0.<GetMappings>b__2()   at System.Threading.Tasks.Task.Execute()--- End of stack trace from previous location where exception was thrown ---   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)   at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineComparisonService.<>c__DisplayClass11_0.<<GetMappings>b__1>d.MoveNext()--- End of stack trace from previous location where exception was thrown ---   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)   at RedGate.SqlServer.Comparison.Shared.UI.Dialogs.Mappings.ViewModel.StatusEventArgsHandler.<WrapShuCancellableOperation>d__4`1.MoveNext()--- End of stack trace from previous location where exception was thrown ---   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)   at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineComparisonService.<GetMappings>d__11.MoveNext()--- End of stack trace from previous location where exception was thrown ---   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)   at RedGate.SqlServer.Comparison.Shared.UI.Extensions.ProgressExtensions.<HandleErrorsIn>d__3`1.MoveNext()--- End of stack trace from previous location where exception was thrown ---   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)   at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineComparisonService.<CompareNowWithFur>d__10.MoveNext()--- End of stack trace from previous location where exception was thrown ---   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)   at FurHelper.FurUtils.<RunOperationWithFur>d__1`1.MoveNext()",         "errorNumber": 0       }     }   } ] 13:58:02.000|Info   |SQL Compare         |13 |Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents   Number of submitted usage events = 1   HTTP status code = 204 NoContent   Response body = 13:58:10.102|Error  |Engine Service      |1  |Comparison failed System.AggregateException: One or more errors occurred. ---> antlr.MismatchedTokenException: expecting "resource", found 'DATA'    at RedGate.SQLCompare.ASTParser.StructureParser.RecoverToNextStatement(Exception e)    at RedGate.SQLCompare.ASTParser.StructureParser.statementFirstInBatch()    at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch()    at RedGate.SQLCompare.ASTParser.StructureParser.expr()    at RedGate.SQLCompare.Engine.Utils.GetAst(TextReader script, Boolean quotedIdentifiers)    at RedGate.SQLCompare.Engine.DatabaseMapper.FixTextObjectDefinition(ITextObject obj)    at RedGate.SQLCompare.Engine.DatabaseMapper.MapStoredProcedure(StoredProcedure sp, IDictionary`2 spMappingsToAdd)    at RedGate.SQLCompare.Engine.DatabaseMapper.MapDatabase(SqlCompareOwnerMappings origMappings)    at RedGate.SQLCompare.Engine.SqlCompareOwnerMappings.MapDatabase(Boolean first, StatusEventHandler status)    at RedGate.SQLCompare.Engine.SqlCompareOwnerMappings.MapDatabase(Boolean first)    at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineComparisonService.<>c__DisplayClass11_0.<GetMappings>b__2()    at System.Threading.Tasks.Task.Execute() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineComparisonService.<>c__DisplayClass11_0.<<GetMappings>b__1>d.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at RedGate.SqlServer.Comparison.Shared.UI.Dialogs.Mappings.ViewModel.StatusEventArgsHandler.<WrapShuCancellableOperation>d__4`1.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineComparisonService.<GetMappings>d__11.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at RedGate.SqlServer.Comparison.Shared.UI.Extensions.ProgressExtensions.<HandleErrorsIn>d__3`1.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineComparisonService.<CompareNowWithFur>d__10.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at FurHelper.FurUtils.<RunOperationWithFur>d__1`1.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineService.<DoComparison>d__19.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at RedGate.SqlServer.Comparison.Shared.UI.Dialogs.Progress.ViewModel.ProgressDialogViewModel`1.<SetTask>d__40.MoveNext()    at RedGate.SqlServer.Comparison.Shared.UI.Dialogs.Progress.ViewModel.ProgressDialogViewModel`1.<SetTask>d__40.MoveNext()    --- End of inner exception stack trace ---    at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)    at RedGate.SqlServer.Comparison.Shared.UI.Services.Progress.ProgressDialogRunner.RunProgressDialog[TResult](Func`3 createTask, IntPtr hwndParent, ISetting`1 closeOnCompletion)    at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineService.RunPopulationAndComparison(IWin32Window parent, IProject project, Boolean forceReregistration, Boolean isDifferentProject) ---> (Inner Exception #0) line 39:21: expecting "resource", found 'DATA'<--- / comments
  1. Community
  2. SQL Compare
  3. Undocumented error message
Thanks for your reply.  See below;Clicking "More details" just shows the same error with no further details.In the log file the relevant section seems to be;113:58:01.952|Info   |SQL Compare       ...
0 votes
Total activity
11
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3