StrataFrame Forum / StrataFrame Database Deployment Toolkit / Database Deployment Toolkit (How do I?) / SampleDataInstallerClass -> cross-thread error... / Latest Posts

RE: SampleDataInstallerClass -> cross-thread error...

Ralph Rutschmann — Sun, 29 Jun 2008 01:35:17 GMT

Hi Trent!

[quote]That would probably be a good idea. Just to make sure that you are aware...[/quote]

Yes, Trent. I'm aware and that's really cool. :cool:

But it would be even cooler, not to have to do that.

Please don't get me wrong, SF is a great framework and I love it. I tried a few others and found SF seems to fit my needs best, especially the data deployment tool. This tool makes SF a real time saver when installing data for applications. Unfortunately this really important tool is not localized, which causes me to 'create my own deployment environment for an install'. It would be really great not to have to do that. I hope I can put my own development environment into a trash-can some time soon... ;)

Thank you very much and friendly greetings,

Ralph

RE: SampleDataInstallerClass -> cross-thread error...

Trent L. Taylor — Sat, 28 Jun 2008 12:32:10 GMT

[quote]But could you localization issues also take into account? It would save me (and other international customers too) tons of work...[/quote]

That would probably be a good idea. Just to make sure that you are aware...you can create your own deployment dialogs right now as we speak. In fact, the framework comes with a sample showing how to do this so you can create your own deployment environment for an install or whatever need you have there. This is what we do for our medical software as well as the SF installation. This is just a thought so you could move forward without having to wait on me :)

RE: SampleDataInstallerClass -> cross-thread error...

Ralph Rutschmann — Sat, 28 Jun 2008 03:36:44 GMT

Hello Trent,

[quote]I am unsure why your environment would act differently.[/quote]

sometimes it worked as expected, somtimes I got a cross-thread error.

[quote]I looked through the code to ensure that there was no cross-thread violations...and I did not see any.[/quote]

Accessing the combobox from inside the DoWork-Method is causing the error. The combobox is an element instantiated outside the DoWork thread of the BackgroundWorker and therefore lies at another thread, I guess. I don't know why it is working sometimes, but I don't know at all why Windows is working sometimes, or not... ;)

[quote]However, we are about to rework this dialog anyway, so I will be sure to take this into account![/quote]

Thank you very much, this will be great! :)

But could you localization issues also take into account? It would save me (and other international customers too) tons of work...

Thank you very much and friendly greetings,

Ralph

RE: SampleDataInstallerClass -> cross-thread error...

Trent L. Taylor — Fri, 27 Jun 2008 13:07:41 GMT

I am glad that you got it working. I am unsure why your environment would act differently. I looked through the code to ensure that there was no cross-thread violations...and I did not see any. However, we are about to rework this dialog anyway, so I will be sure to take this into account!

Thanks for your information and efforts!!!!

RE: SampleDataInstallerClass -> cross-thread error...

Ralph Rutschmann — Fri, 27 Jun 2008 12:11:19 GMT

Hello Trent! :)

Meanwhile I kicked off my old AMD equipment and own a brand new Intel machine now. :D

I installed all completly new from the scratch, Windows XP Professional, VS 2008 and the newest StrataFrame-Beta.

Unfortunately the problem persists, even with the new machine. It seems not to have something to do with AMD or Intel.

So I took a look what MicroSoft does with the Backgroundworker, which should have something to do with the error. I saw, that the examples from MS avoid any access to the GUI, from inside the doWork-Method. I tried to modify the source code, but found that not a good idea, because I do not want to modify the code again and again with any new release of SF.

I decided to translate the DeployDialogs-MDDDeployMain to C# and to modify it to my needs, using as much of the framework as I could.

And guess what? Right, the problem went away! :D

Here is, what I did (among others):

[codesnippet]

private void cboSQLServer_DropDown(object sender, EventArgs e)

{

if (!_ServersLoaded)

{

_ServersLoaded = true;

//-- Clear the combo

this.cboSQLServer.Items.Clear();

//-- Start the thread

this.sqlWorker.RunWorkerAsync();

}

private void sqlWorker_DoWork(object sender, DoWorkEventArgs e)

{

// Do not access the form's BackgroundWorker reference directly.

// Instead, use the reference provided by the sender parameter.

BackgroundWorker bw = sender as BackgroundWorker;

// Start the time-consuming operation.

// e.Result = TimeConsumingOperation(bw, arg);

this.LoadSQLServers(bw, e);

// If the operation was canceled by the user,

// set the DoWorkEventArgs.Cancel property to true.

if (bw.CancellationPending)

{

e.Cancel = true;

}

/// <summary>

/// Loads the available SQL servers into the combo box

/// </summary>

/// <remarks></remarks>

private void LoadSQLServers(BackgroundWorker bw, DoWorkEventArgs e)

{

//-- Show the wait window

bw.ReportProgress(1);

//-- Establish Locals

SQLServerSchema loSQL = new SQLServerSchema();

ArrayList list = new ArrayList();

//-- Cycle through all available servers

foreach (SQLServerInfo loSQLInfo in loSQL.LoadSQLServerList())

{

//-- Add the item

list.Add(loSQLInfo.Name);

}

e.Result = list;

}

private void sqlWorker_ProgressChanged(object sender, ProgressChangedEventArgs e)

{

if (e.ProgressPercentage == 1)

{

this.opgWindows.Enabled = false;

this.opgSQL.Enabled = false;

this.cmdBack.Enabled = false;

this.cmdNext.Enabled = false;

//-- this.cmdCancel.Enabled = false;

this.myWaitwindow.ShowWaitWindow(Localization.RetrieveTextValue("waitWindTxt030"), Localization.RetrieveTextValue("waitWindTxt040"));

}

private void sqlWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)

{

if (e.Cancelled)

{

this.myWaitwindow.HideWaitWindow();

// The user canceled the operation.

MessageBox.Show("Operation was canceled");

this._ServersLoaded = false;

this.opgWindows.Enabled = true;

this.opgSQL.Enabled = true;

this.cmdBack.Enabled = true;

this.cmdNext.Enabled = true;

this.cmdCancel.Enabled = true;

}

else if (e.Error != null)

{

// There was an error during the operation.

string msg = String.Format("An error occurred: {0}", e.Error.Message);

MessageBox.Show(msg);

}

else

{

// The operation completed normally.

ArrayList servers = (ArrayList)e.Result;

for (int i = 0; i < servers.Count; i++)

{

this.cboSQLServer.Items.Add(servers.ToArray().GetValue(i));

}

if (this.cboSQLServer.Items.Count > 0)

{

//-- Select the first item

this.cboSQLServer.SelectedIndex = 0;

}

this.myWaitwindow.HideWaitWindow();

this.opgWindows.Enabled = false;

this.opgSQL.Enabled = false;

this.cmdBack.Enabled = true;

this.cmdNext.Enabled = true;

//-- this.cmdCancel.Enabled = true;

}

private void cmdCancel_Click(object sender, EventArgs e)

{

if (this.sqlWorker.IsBusy)

{

// Cancel the asynchronous operation.

this.sqlWorker.CancelAsync();

this.cmdCancel.Enabled = false;

}

else

{

try

{

if (_Migrator != null)

{

_Migrator.CancelConversionThread();

_Migrator.Dispose();

}

catch (Exception)

{

throw;

}

finally

{

this.DialogResult = DialogResult.Abort;

this.Close();

}

[/codesnippet]

Maybe you can have a look at it and use it for the framework? OK, you will have to translate it to VB.NET, but this will surely not be a problem for you and this way you can shift my code to a much better one. :)

Friendly greetings,

Ralph

RE: SampleDataInstallerClass -> cross-thread error...

Trent L. Taylor — Tue, 05 Feb 2008 12:38:14 GMT

Actually I am using an AMD X2 Dual Core 6400+ ... I will still look into the issue to see if there is something that can be done. Thanks.

RE: SampleDataInstallerClass -> cross-thread error...

Ralph Rutschmann — Tue, 05 Feb 2008 12:26:18 GMT

Hi Trent,

my machine is equipped with an AMD Athlon 64X2 Dual Core Processor 4200+ / 2,21GHz, 1,00 GB Ram.

Unfortunately I can't run a test against a machine equipped with Intel chipset and processor because I do not have one near around. Are you using Intel without that problem? Then my next machine will surely have Intel on board.

Thank you very much and friendly greetings,

Ralph

RE: SampleDataInstallerClass -> cross-thread error...

Trent L. Taylor — Tue, 05 Feb 2008 10:29:16 GMT

[quote]Maybe there is something wrong with my machine?[/quote]

It is funny that you mentioned this....you are getting a cross-thread violation, which we have run into an issue recently where one machine would get the error and not another. The difference had to do with AMD dual cores and another machine with an Intel HyperThreading procesor. Strange, but true. I wonder if there is something along these lines going on here. I will look to see if there is some other precaution that we could take to aid in preventing this. Thanks for the info.

RE: SampleDataInstallerClass -> cross-thread error...

Ralph Rutschmann — Mon, 04 Feb 2008 01:49:45 GMT

Hello Trent,

> I ran the C# sample that gets installed with the framework (instead of the one from the forum) and did not have any issues. The one from the forum was ultimately added to the install. Click Start -> StrataFrame -> Samples -> C# -> Database Installer Sample. Run this sample to see if you have the same issue. <

Yes, I do. Unfortunately. I did exactly what you described:

I clicked on 'Pre-Build Dialogs', then 'Next' without touching anything else, after that I clicked on the little down arrow at the combobox for selecting an SQL Server.

At this point I get the following error message:

'System.InvalidOperationException was unhandled by user code
Message="Ungültiger threadübergreifender Vorgang: Der Zugriff auf das Steuerelement cboSQLServer erfolgte von einem anderen Thread als dem Thread, für den es erstellt wurde."
Source="System.Windows.Forms"
StackTrace:
bei System.Windows.Forms.Control.get_Handle()
bei System.Windows.Forms.Control.SendMessage(Int32 msg, Int32 wparam, Int32 lparam)
bei System.Windows.Forms.ComboBox.NativeClear()
bei System.Windows.Forms.ComboBox.ObjectCollection.ClearInternal()
bei System.Windows.Forms.ComboBox.ObjectCollection.Clear()
bei MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain.LoadSQLServers()
bei MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain.sqlWorker_DoWork(Object sender, DoWorkEventArgs e)
bei System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
bei System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

Maybe there is something wrong with my machine?

TIA and friendly greetings,

Ralph

RE: SampleDataInstallerClass -> cross-thread error...

Trent L. Taylor — Sun, 27 Jan 2008 11:29:39 GMT

Ralph,

I ran the C# sample that gets installed with the framework (instead of the one from the forum) and did not have any issues. The one from the forum was ultimately added to the install. Click Start -> StrataFrame -> Samples -> C# -> Database Installer Sample. Run this sample to see if you have the same issue. I am not having any issues with the sample. If you are running the installer class (not the standard part of the sample) through an installation, then you have to take this into account if you are executing the install on another thread by creating a delegate or a synchronization object (ISynchronizeInvoke). But if you are just running the WinForms sample, then I cannot reproduce. Any additional details would be helpful :)

RE: SampleDataInstallerClass -> cross-thread error...

Ralph Rutschmann — Thu, 24 Jan 2008 10:05:54 GMT

Hi Ben,

"I unpacked the examples to the projects directory and opened the solution with VS2005. Then I corrected the references to my new strataframe components on my machine and started debugging."

I used the CSharpDemos.exe examples from Microfour for StrataFrame - http://forum.strataframe.net/Topic5397-17-1.aspx without any changes other than to correct the references.

Can you reproduce the error with the example like it is?

TIA and friendly greetings, Ralph

RE: SampleDataInstallerClass -> cross-thread error...

Ben Chase — Thu, 24 Jan 2008 08:58:34 GMT

Could you show the code where you are creating and showing the MDDeployMain form?

Are you calling .Show() on the form or .ShowDialog() on the form?

SampleDataInstallerClass -> cross-thread error...

Ralph Rutschmann — Wed, 23 Jan 2008 10:56:32 GMT

Hi there,

maybe I'm doing something stupid, but I tried the SampleDataInstallerClass from the Example.zip for C#. I unpacked the examples to the projects directory and opened the solution with VS2005. Then I corrected the references to my new strataframe components on my machine and started debugging.

I tried the Pre-Build Dialogs, but as soon as I click on the combobox to choose the server, I get an exception in MDDeployMain.vb at

'-- Clear the combo

cboSQLServer.Items.Clear()

telling me, there is a cross-thread call exeption.

Therefore I can't choose any server and have to stop debugging.

Any hint?

TIA and friendly greetings, Ralph