User profile for sgtwilko – Support

Activity overview Badges (0) Posts (4) Comments (5)

Comments

Hi @Sergio R, Thanks for the response, do you know if the required SQLCover DLLs are included in the existing Redgate plugin? Do you know how the existing plugin creates a local DB connection (as the documentation suggest we need to spin up an additional database to test a package)? I don't really want to move away from using the redgate plugin, but if I'm having to hand-roll the solution I won't be using it to run the tests and submit the test report. Thanks / comments

Hi @Sergio R,Thanks for the response, do you know if the required SQLCover DLLs are included in the existing Redgate plugin?Do you know how the existing plugin creates a local DB connection (as the...

0 votes

Hi @Sergio R Again thanks for the response. Do you know if the Redgate SQL Change Automation Build task will update and start using the new builds of tSQLt? If so would it be possible to add the code coverage at the same time? Thanks / comments

Hi @Sergio R Again thanks for the response.Do you know if the Redgate SQL Change Automation Build task will update and start using the new builds of tSQLt?If so would it be possible to add the code...

0 votes

Hi @DanC, Thanks for the response, but I think I probably needed to expand on my question. I have the pipeline running SQL Tests via the RedgateSqlChangeAutomationBuild task: [image] [image] I need to get the code coverage. Does this task output the code coverage, if so, where is the file? I'm happy to convert it to the correct format after I have the file, but so far I can't see how to get the coverage from this task. From what I've read, it would seem that I have to abort using Redgate to get the coverage information. Thanks. / comments

Hi @DanC,Thanks for the response, but I think I probably needed to expand on my question.I have the pipeline running SQL Tests via the RedgateSqlChangeAutomationBuild task:I need to get the code co...

0 votes

also missed the most of the log; here's the important bit. SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 72 ScriptModel: End position (from script provider) = Line: 0; Column: 72 ScriptModel: Last line length (from lines collection) = 72 ScriptModel: Caret position: Line: 0; Column: 68 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 41 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 72 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 72 ScriptModel: Caret position: Line: 0; Column: 68 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 41 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 41 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 42 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 46 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 46 ScriptModel: End position (from script provider) = Line: 0; Column: 46 ScriptModel: Last line length (from lines collection) = 46 ScriptModel: Caret position: Line: 0; Column: 42 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 42 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 46 ScriptModel: End position (from script provider) = Line: 0; Column: 46 ScriptModel: Last line length (from lines collection) = 46 ScriptModel: Caret position: Line: 0; Column: 42 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 46 ScriptModel: End position (from script provider) = Line: 0; Column: 46 ScriptModel: Last line length (from lines collection) = 46 ScriptModel: Caret position: Line: 0; Column: 42 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 43 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 46 ScriptModel: End position (from script provider) = Line: 0; Column: 47 ScriptModel: Last line length (from lines collection) = 46 ScriptModel: Caret position: Line: 0; Column: 42 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 47 ScriptModel: End position (from script provider) = Line: 0; Column: 47 ScriptModel: Last line length (from lines collection) = 47 ScriptModel: Caret position: Line: 0; Column: 43 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 43 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 47 ScriptModel: End position (from script provider) = Line: 0; Column: 47 ScriptModel: Last line length (from lines collection) = 47 ScriptModel: Caret position: Line: 0; Column: 43 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 47 ScriptModel: End position (from script provider) = Line: 0; Column: 47 ScriptModel: Last line length (from lines collection) = 47 ScriptModel: Caret position: Line: 0; Column: 43 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 44 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 47 ScriptModel: End position (from script provider) = Line: 0; Column: 48 ScriptModel: Last line length (from lines collection) = 47 ScriptModel: Caret position: Line: 0; Column: 43 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 48 ScriptModel: End position (from script provider) = Line: 0; Column: 48 ScriptModel: Last line length (from lines collection) = 48 ScriptModel: Caret position: Line: 0; Column: 44 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 44 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 48 ScriptModel: End position (from script provider) = Line: 0; Column: 48 ScriptModel: Last line length (from lines collection) = 48 ScriptModel: Caret position: Line: 0; Column: 44 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 48 ScriptModel: End position (from script provider) = Line: 0; Column: 48 ScriptModel: Last line length (from lines collection) = 48 ScriptModel: Caret position: Line: 0; Column: 44 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 45 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 48 ScriptModel: End position (from script provider) = Line: 0; Column: 49 ScriptModel: Last line length (from lines collection) = 48 ScriptModel: Caret position: Line: 0; Column: 44 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 49 ScriptModel: End position (from script provider) = Line: 0; Column: 49 ScriptModel: Last line length (from lines collection) = 49 ScriptModel: Caret position: Line: 0; Column: 45 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 45 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 49 ScriptModel: End position (from script provider) = Line: 0; Column: 49 ScriptModel: Last line length (from lines collection) = 49 ScriptModel: Caret position: Line: 0; Column: 45 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 I have the entire file still if you need it. / comments

also missed the most of the log; here's the important bit. SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines...

0 votes

it missed the error log off the bottom of the post: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity) at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength) at System.Text.StringBuilder.Append(Char value) at antlr.CharScanner.append(Char c) at antlr.CharScanner.consume() at antlr.CharScanner.matchNot(Int32 c) at antlr.CharScanner.matchNot(Char c) at _41._41(Boolean ) at _41.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at _42._270() at _42._36() at _42._4() at _42._2() at RedGate.SQLCompare.Engine.Database.GetDependencies(String sql, Boolean quotedIdentifiers, Boolean throwExceptions) at _16._1(SqlConnection , Boolean ) at _16._1() at RedGate.SQLCompare.Engine.Database.RegisterForSqlPrompt(ConnectionProperties connectionProperties, Options options, Boolean includeSystemObjects) at _18.Refresh(IAuthenticationTokenProvider provider) at _18._1(IAuthenticationTokenProvider ) at _18.GetMetaData(IAuthenticationTokenProvider provider) at RedGate.SqlPrompt.Engine.Cache.MetaDataCache._1(_18 , _4 , IAuthenticationTokenProvider , Boolean ) at RedGate.SqlPrompt.Engine.Cache.MetaDataCache.GetDatabase(ConnectionProperties conn, IAuthenticationTokenProvider provider, Boolean bleatIfBlacklisted) at RedGate.SqlPrompt.Engine.Cache.MetaDataCache.GetDatabase(ConnectionProperties conn, IAuthenticationTokenProvider provider) at RedGate.SQLPrompt.CommonUI.TaskExecuter.LoadDatabaseTask.DoTask() at RedGate.SQLPrompt.CommonUI.TaskExecuter.TaskExecuter.ExecuteTask() ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- RedGate.SQLPrompt.QueryAnalyzerUI Assembly Version: 3.0.0.300 Win32 Version: 3.0.0.300 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLPrompt.QueryAnalyzerUI.exe ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- RedGate.SqlPrompt.Engine Assembly Version: 3.0.0.300 Win32 Version: 3.0.0.300 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SqlPrompt.Engine.DLL ---------------------------------------- RedGate.SQLPrompt.CommonUI Assembly Version: 3.0.0.300 Win32 Version: 3.0.0.300 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLPrompt.CommonUI.DLL ---------------------------------------- RedGate.SQL.Shared Assembly Version: 5.3.0.1 Win32 Version: 5.3.0.1 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQL.Shared.DLL ---------------------------------------- RedGate.SqlPrompt.Engine.Gatekeeper Assembly Version: 3.0.0.300 Win32 Version: 3.0.0.300 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SqlPrompt.Engine.Gatekeeper.DLL ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- Accessibility Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- RedGate.Shared.Utils Assembly Version: 5.3.0.1 Win32 Version: 5.3.0.1 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.Shared.Utils.DLL ---------------------------------------- System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- RedGate.SQLCompare.ASTParser Assembly Version: 3.0.0.300 Win32 Version: 1.0.0.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLCompare.ASTParser.DLL ---------------------------------------- System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- RedGate.SQLCompare.Engine Assembly Version: 5.3.0.13 Win32 Version: 5.3.0.13 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLCompare.Engine.DLL ---------------------------------------- System.Transactions Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll ---------------------------------------- System.EnterpriseServices Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box. / comments

it missed the error log off the bottom of the post:See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Te...

0 votes

Total activity: 11
Last activity: February 06, 2025 11:42
Member since: February 05, 2025 10:00

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 2