User profile for MckMurray – Support

Activity overview Badges (0) Posts (16) Comments (19)

Comments

Is there either a fix for this or a way for me to start SSMS without sql prompt on so I can at least work? I got the same thing, and found that the error only occurs after you attempt to connect to a server in object explorer. SSMS 18.4. I'll try updating to latest SSMS next... Results: Updating to SSMS 18.7.1 resulted in a whole lot of other errors referencing other SQL Toolbelt tools that I had installed (SQL Source Control, SQL Test, etc.), so I updated all my SQL Toolbelt tools to latest, and now it seems to be working. / comments

Is there either a fix for this or a way for me to start SSMS without sql prompt on so I can at least work? I got the same thing, and found that the error only occurs after you attempt to conne...

0 votes

Thanks, yes, same issue here / comments

Thanks, yes, same issue here

0 votes

Yeah I know that's the real solution, but we're dealing with a few SQL 2008 instances until 2019 when extended support ends. I've added a suggestion: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/31754800-enable-extended-events-per-server / comments

Yeah I know that's the real solution, but we're dealing with a few SQL 2008 instances until 2019 when extended support ends. I've added a suggestion: https://sqlmonitor.uservoice.com/forums/91743-s...

0 votes

Thanks Russell, I just updated and 7.0.14 does resolve the issue. Thanks. / comments

Thanks Russell, I just updated and 7.0.14 does resolve the issue. Thanks.

0 votes

Too bad. Here's the suggestion if anyone would like to vote! https://redgate.uservoice.com/forums/267000-dlm-automation/suggestions/19295560-support-publishing-custom-schema-names-to-dlm-dash / comments

Too bad. Here's the suggestion if anyone would like to vote!https://redgate.uservoice.com/forums/267000-dlm-automation/suggestions/19295560-support-publishing-custom-schema-names-to-dlm-dash

0 votes

Thanks Mike, I'll test it out... Edit: ...and yes, that appears to resolve the issue. Thanks! / comments

Thanks Mike, I'll test it out... Edit: ...and yes, that appears to resolve the issue. Thanks!

0 votes

Anyone from Redgate here? Is this bug going to be fixed or is it just me? / comments

Anyone from Redgate here? Is this bug going to be fixed or is it just me?

0 votes

Thanks Rob, for the quick fix! / comments

Thanks Rob, for the quick fix!

0 votes

Hi Rob, I'm using VS Team Services build. / comments

Hi Rob, I'm using VS Team Services build.

0 votes

Thanks Rob, yep I can now use the data gen project file, although now I am getting another error which is somewhat unhelpful (see call stack below). If I run the equivalent SQLDataGenerator call in powershell on the Build machine, it runs successfully. Excerpt of logs: 2016-10-04T14:55:50.2029072Z ##[debug]Calling: C:Program Files (x86)Red GateDLM Automation 2SDGSQLDataGenerator.exe /server:XXXX /database:dlmautomation_a82480c2-ce1e-434b-a45f-b4e261b06426 "/project:C:BuildAgent_work1sData Generator FilesFinQA_Reference_Data_For_Test.sqlgen" /out:"C:UsersmurraymckernanAppDataLocalTempDLM Automation k45hpze.log" 2016-10-04T14:55:51.5850338Z ##[debug]C:Program Files (x86)Red GateDLM Automation 2SDGSQLDataGenerator.exe ended with exit code 1 2016-10-04T14:55:52.0650796Z ##[warning]Failed to send Smart Assembly error report. 2016-10-04T14:55:52.0660861Z ##[warning]System.InvalidOperationException: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application. 2016-10-04T14:55:52.0670801Z ##[warning] at System.Windows.Forms.MessageBox.ShowCore(IWin32Window owner, String text, String caption, MessageBoxButtons buttons, MessageBoxIcon icon, MessageBoxDefaultButton defaultButton, MessageBoxOptions options, Boolean showHelp) 2016-10-04T14:55:52.0670801Z ##[warning] at System.Windows.Forms.MessageBox.Show(String text, String caption) 2016-10-04T14:55:52.0680782Z ##[warning] at SmartAssembly.ReportException.ExceptionReporting.Report(Exception exception) 2016-10-04T14:55:52.0680782Z ##[warning] at RedGate.DLMAutomation.Shared.Errors.Reporting.SmartAssemblyErrorReporter.Report(Exception exception) 2016-10-04T14:55:52.0940848Z ##[error]System.Management.Automation.CmdletInvocationException: SQLDataGenerator.exe terminated with the exit code 1: General error. 2016-10-04T14:55:52.0950833Z ##[error]See the log information above for more details. ---> RedGate.DLMAutomation.Shared.Errors.TerminatingException: SQLDataGenerator.exe terminated with the exit code 1: General error. 2016-10-04T14:55:52.0950833Z ##[error]See the log information above for more details. 2016-10-04T14:55:52.0960813Z ##[error] at RedGate.DLMAutomation.Compare.RedgateTools.CompareResultExtensions.HandleDataGeneratorResult(RedgateToolResult redgateToolResult, ILog log, Object targetObject) 2016-10-04T14:55:52.0960813Z ##[error] at RedGate.DLMAutomation.Compare.SchemaTesting.TestDataGenerator.PopulateWithDataUsingProject(IDatabase database, String dataGeneratorProjectFile) 2016-10-04T14:55:52.0970817Z ##[error] at RedGate.DLMAutomation.Compare.SchemaTesting.SchemaSourceTester.SetupDatabase(String scriptsFolderPath, String compareOptions, String filterFilePath, Boolean includeTestData, String sqlDataGeneratorProjectFilePath, DatabaseServerConnection temporaryServerConnection, DatabaseConnection temporaryDatabaseConnection, Int32 commandTimeout) 2016-10-04T14:55:52.0970817Z ##[error] at RedGate.DLMAutomation.Compare.SchemaTesting.SchemaSourceTester.SetupDatabase(ScriptsFolder scriptsFolder, String compareOptions, Boolean includeTestData, String sqlDataGeneratorProjectFilePath, DatabaseServerConnection temporaryServerConnection, DatabaseConnection temporaryDatabaseConnection, Int32 commandTimeout, String filterFilePath) 2016-10-04T14:55:52.0980827Z ##[error] at RedGate.DLMAutomation.Compare.SchemaTesting.SchemaSourceTester.<>c__DisplayClass12_0.<RunTests>b__1(ScriptsFolder scriptsFolder) 2016-10-04T14:55:52.0980827Z ##[error] at RedGate.DLMAutomation.Compare.Packaging.DatabasePackage.AcceptToProxy[T](SchemaSourceVisitor`1 visitor) 2016-10-04T14:55:52.0990829Z ##[error] at RedGate.DLMAutomation.Compare.SchemaTesting.SchemaSourceTester.RunTests(ISchemaSource schemaToTest, DatabaseConnection tempDatabaseConnection, DatabaseServerConnection tempServerConnection, String testToRun, String compareOptions, String filterFilePath, Boolean includeTestData, String sqlDataGeneratorProjectFilePath, Int32 commandTimeout) 2016-10-04T14:55:52.0990829Z ##[error] at RedGate.DLMAutomation.PowerShell.Commands.InvokeDlmDatabaseTestsCommandImpl.Process() 2016-10-04T14:55:52.1000828Z ##[error] at RedGate.DLMAutomation.PowerShell.DlmAutomationCommandImpl`1.ProcessRecord() 2016-10-04T14:55:52.1000828Z ##[error] at RedGate.PowerShell.CommandBase`2.DelegateTo(Action doImplementation) 2016-10-04T14:55:52.1010829Z ##[error] --- End of inner exception stack trace --- 2016-10-04T14:55:52.1010829Z ##[error] at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input) 2016-10-04T14:55:52.1020820Z ##[error] at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke) 2016-10-04T14:55:52.1020820Z ##[error] at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync) 2016-10-04T14:55:52.1030837Z ##[error] at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings) 2016-10-04T14:55:52.1030837Z ##[error] at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings) 2016-10-04T14:55:52.1040822Z ##[error] at Microsoft.TeamFoundation.DistributedTask.Handlers.PowerShellHandler.Execute(ITaskContext context, CancellationToken cancellationToken, Int32 timeoutInMinutes) 2016-10-04T14:55:52.1040822Z ##[error] at Microsoft.TeamFoundation.DistributedTask.Worker.JobRunner.RunTask(ITaskContext context, TaskWrapper task, CancellationTokenSource tokenSource) / comments

Thanks Rob, yep I can now use the data gen project file, although now I am getting another error which is somewhat unhelpful (see call stack below). If I run the equivalent SQLDataGenerator call in...

0 votes

Total activity: 48
Last activity: February 06, 2025 10:52
Member since: February 04, 2025 16:52

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