How can we help you today? How can we help you today?
MckMurray
Activity overview Badges (0) Posts (16) Comments (19)

Comments

Sort by recent activity
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
  1. Community
  2. DLM Automation
  3. Error trying to use .sqlgen file with Test step
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
Update: digging in a bit more, it looks like DLM Automation's SDG can't load the project file because the file was created in a newer version of SDG. Additionally, the version used by DLM doesn't seem to support copying IDENTITY column values when using an existing data source, which is what I'm trying to do. Is it possible to update the version of SDG being used by DLM Automation? / comments
  1. Community
  2. DLM Automation
  3. Error trying to use .sqlgen file with Test step
Update: digging in a bit more, it looks like DLM Automation's SDG can't load the project file because the file was created in a newer version of SDG. Additionally, the version used by DLM doesn't s...
0 votes
Thanks Eddie, I see now that is mostly working - although there is one case that isn't: One of the tables I want to import has an optional FK to another table that I do not want to import. In the source data there is only one row that has a value in this FK column. I chose the option to "skip the row" if invalid data is encountered, but it doesn't seem to be doing that. Instead, it fails the whole table insert (inserts 0 rows), and all subsequent tables can't be updated because it says "IDENTITY_INSERT is already on for table <failed table>. Cannot perform SET operation for table <subsequent table>". Any suggestions? Thanks / comments
  1. Community
  2. SQL Data Generator
  3. Existing Data Source and Foreign Keys
Thanks Eddie, I see now that is mostly working - although there is one case that isn't: One of the tables I want to import has an optional FK to another table that I do not want to import. In the s...
0 votes
Version 11.6.1.1686 Professional / comments
  1. Community
  2. SQL Compare 11
  3. SC not recognising &quot;release candidate&quot; migration scripts
Version 11.6.1.1686 Professional
0 votes
Ah, good to know. However the next challenge seems to be the following error when it tries to generate the deployment script: Cannot apply: HunkHeader[179,7->179,9] Any ideas? Thanks / comments
  1. Community
  2. SQL Compare 11
  3. SC not recognising &quot;release candidate&quot; migration scripts
Ah, good to know. However the next challenge seems to be the following error when it tries to generate the deployment script: Cannot apply: HunkHeader[179,7->179,9] Any ideas? Thanks
0 votes
OK, it's been duly added. If anyone wants to vote for this: http://sqltest.uservoice.com/forums/140716-sql-test-forum/suggestions/2428288-automatically-generate-unit-tests / comments
  1. Community
  2. SQL Test
  3. Ability to &quot;record&quot; unit tests?
OK, it's been duly added. If anyone wants to vote for this: http://sqltest.uservoice.com/forums/140716-sql-test-forum/suggestions/2428288-automatically-generate-unit-tests
0 votes
OK, accepting that it is necessary, I'm curious why the results of DBCC PAGE would need to be sent to the errorlog for a compare operation. DBCC TRACEON 3604 should route the results back to SQL Compare's connection, right? Would that mean that a DBCC PAGE is being issued with 3604 off? Thanks / comments
  1. Community
  2. SQL Compare 11
  3. Extreme server log growth with &quot;decrypt encrypted objects&quot;
OK, accepting that it is necessary, I'm curious why the results of DBCC PAGE would need to be sent to the errorlog for a compare operation. DBCC TRACEON 3604 should route the results back to SQL Co...
0 votes
Sure enough for some reason 3605 was set globally, though I can't think why... turned it off. I'll try it again with the option enabled and see if that fixes it. Thanks Edit: Sure enough, that was the culprit - a compare operation that previously logged > 787 MB just finished at < 3MB. Thanks for the pointer! / comments
  1. Community
  2. SQL Compare 11
  3. Extreme server log growth with &quot;decrypt encrypted objects&quot;
Sure enough for some reason 3605 was set globally, though I can't think why... turned it off. I'll try it again with the option enabled and see if that fixes it. Thanks Edit: Sure enough, that was ...
0 votes
Hi Mark, currently SQL Compare is set to "No Logging" so I have no SC-generated logs. To be clear, the logs I am talking about are the SQL Server error log files, the ones which can be found by going to Management > SQL Server Logs in SSMS. Elsewhere in the forums I came across this post from several years and many versions ago which may be related? I'm definitely seeing "DBCC 3604 ON" and "DBCC 3604 OFF" in the logs. https://forums.red-gate.com/viewtopic.php?t=10817 / comments
  1. Community
  2. SQL Compare 11
  3. Extreme server log growth with &quot;decrypt encrypted objects&quot;
Hi Mark, currently SQL Compare is set to "No Logging" so I have no SC-generated logs. To be clear, the logs I am talking about are the SQL Server error log files, the ones which can be found by goi...
0 votes
Any update on this request? We've been running into the same issue. In regards to the directions given above ("you would typically use SQL Data Compare to deploy the changes"), I have to disagree. The whole point of linking static data is to essentially elevate certain tables to the same importance as schema for the purpose of deployments. To then exclude these same tables from the main deployment channel (SQL Compare) is just broken. (Especially given that this has been recognised as an issue and addressed for command-line!) Can this be added as an option for UI? Thanks / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Deploy static table data best practice
Any update on this request? We've been running into the same issue. In regards to the directions given above ("you would typically use SQL Data Compare to deploy the changes"), I have to disagree. ...
0 votes
Total activity
48
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
13