StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » VS crashes when 1.6.1 opens solution

VS crashes when 1.6.1 opens solution

Ben Hayat — Sat, 07 Jul 2007 21:44:11 GMT

Firstly, congratulation to the release of 1.6.1

Just got done installing 1.6.1 on Win2K machine. Everything went through fine.
Now as soon as I try to open any solution (including C# samples), I get the message the VS has encounter error and if I click "Don't Send" it closes VS and re-opens VS.

I rebooted the machine but no luck!

I also tried opening VB samples, same thing!

Thanks!

RE: VS crashes when 1.6.1 opens solution

Trent L. Taylor — Sat, 07 Jul 2007 21:44:11 GMT

Robert:

[quote]C:\windows\assembly folder on my system [/quote]

You can manually install the assemblies with gacutil....or just download the new install that is posted in the My Account area and it will take care of it. To install with gacutil you will use the "-i" parameter. The easiest thing though if you are not familiar with the command line tools and have permission issues is to just download the latest build....which was corrected the same time the zip file was posted out here...and it will fix your problem as well.

[quote]C:\ProgramFiles/CommonFiles/MicroFour/StrataFrame and I copied them there but no joy[/quote]

Correct. The GAC always takes precedence. Anytime that an assembly tries to load it ALWAYS looks in the GAC first....even if you manually call Assembly.LoadFile() and give it the direct path of an assembly.

RE: VS crashes when 1.6.1 opens solution

Trent L. Taylor — Sat, 07 Jul 2007 21:40:26 GMT

Keith:

[quote]

Are the corrected assemblies packaged into the 1.6.1 DL currently available from the My Account area?

[/quote]

Yes. The install has been corrected and has the new assemblies.

RE: VS crashes when 1.6.1 opens solution

Ben Hayat — Sat, 07 Jul 2007 20:19:11 GMT

[quote][b]Pertti Karjalainen (07/07/2007)[/b][hr]Ivan,

if you set up your server as PC XT, make sure it is 8086 AND has a math coprocessor installed -- much speedier that way. Oh, and a 40MB drive would be nice, too, for enough storage for a lifetime (or so we thought back in 1985).

:P

Pertti[/quote]
I think the one that he has, is the 8088 with Seagate 20Meg full height. He is not so happy to give up his second 5 1/4 floppy drive, which he could store 320KB of data...:D

RE: VS crashes when 1.6.1 opens solution

Pertti Karjalainen — Sat, 07 Jul 2007 19:30:10 GMT

Ivan,

if you set up your server as PC XT, make sure it is 8086 AND has a math coprocessor installed -- much speedier that way. Oh, and a 40MB drive would be nice, too, for enough storage for a lifetime (or so we thought back in 1985).

Pertti

RE: VS crashes when 1.6.1 opens solution

Ben Hayat — Sat, 07 Jul 2007 18:17:18 GMT

[quote]Hope this makes sense.[/quote]
Greg, thank you very much for taking the time with your detail answer. The example that I brought up, was with a scenario that I had previously had to do in Delphi and SQL. And I had done it exactly as you said in the second strategy. I didn't use SProc, but I used SQL statement where I'd pass the old Salesrep and the new one to a method that would generate SQL on the fly and all the processing was done on DB Server. Now why did I ask this question, is another question, since I had done the solution before.

Ok, I was reading an article on LINQ that was explaining the actual statements of LINQ don't get executed (delayed execution) until you are iterating through the result sets (that's another subject of it's own), but to the naked eyes, the way you would update the 500 customers in LINQ, [b]is done in the first style that you mentioned, client side [/b]and then LINQ turns around and packages it and creates a parameter SQL and does the job on DB server.

Then I started to think of this new project, how I should approach a bunch of "batch" jobs, NOW that they can easily be converted to LINQ style for the future, without much change to the approach.

So, my question of wrapping the 500 updates within a transaction was prompted by that thought. I still want to think this through that I can easily swap all the SQL codes with LINQ codes for the future.

Do I make sense?:)

Thanks for your input!

RE: VS crashes when 1.6.1 opens solution

Greg McGuffey — Sat, 07 Jul 2007 17:59:57 GMT

Have you tried to unhide protected operating system files?

In XP:
- In windows explorer, Tools|Folder Options...
- click on the "View" tab
- expand the Files And Folders node if it isn't already
- Uncheck the "Hide protected operating system files (Recommended)" option
- Click OK

See if that works.

RE: VS crashes when 1.6.1 opens solution

Robert Carl Johnson — Sat, 07 Jul 2007 17:31:52 GMT

Trent, I downloaded the zip file and found the two dll's ok. However, the C:\windows\assembly folder on my system is protected and I am unable to drag the two files there. Looking at the folder there are no .dll files in it anyway. I did find microfour dll files in C:\ProgramFiles/CommonFiles/MicroFour/StrataFrame and I copied them there but no joy... SV still closes when I try to open a solution.

Robert

RE: VS crashes when 1.6.1 opens solution

Greg McGuffey — Sat, 07 Jul 2007 17:18:25 GMT

[quote]Hey Ivan, I connected to your server last night.[/quote]

Ivan has a server we can hack...er...mess with? ;)

RE: VS crashes when 1.6.1 opens solution

Greg McGuffey — Sat, 07 Jul 2007 17:16:17 GMT

[quote]Let's say I have to change the salesrep (foreign key) of 500 customer, and if I use transaction, will each customer "change" to remote server happen individually or do they get packaged up as on large transaction from client and then sent to the SE for processing?[/quote]

There are a couple of ways that you might do this. The first would be to loop through a BO and update each rep. I think the only transaction support you'd get would be for each individual update. However, this is almost always a bad idea.

The better way is to use a sql statement, which is usually infinitely faster and the entire change can be wrapped in a transaction. For this method to work, you'd need to be able to select the 500 customers that need changing some how, via sql. I.e. they all had another rep and now need a different one or maybe they are in certain zip codes and need to be assigned to a rep. The update is then trivial:

[codesnippet]-- T-SQL
-- customers is the customers table to be udpated
Update customers
Set repID = @repID
Where repID = @oldRepID -- in this case we are reassign the customers from one rep to another
[/codesnippet]

Now, where do you execute this sql. There are two main options: call a sproc that does this work, or execute the sql directly. In either case, I'd likely create a method on the customer BO and pass it the new repid and the old rep ID (or whatever data is needed to select the reps to update) and execute the sproc/sql using the ExecuteNonQuery() method. Then you could wrap this single statement into a transaction (still within the BO method). The transaction is thus the updating of ALL the customers (only a single sql statement). All the logic is encapsulated within the BO, the server does the work, life is good :D This works the same with or without SE.

This will be VERY fast (assuming appropriate indexes on the fields used in the where clause), compared to handling each customer on the client side individually (each update will be a call to the database...500 customers, 500 calls). If you are updating a gagillion customers, you can do it asynch, no problem...the work is actually being done on the server (assuming the server isn't on the same machine).

Hope this makes sense.

RE: VS crashes when 1.6.1 opens solution

Keith Chisarik — Sat, 07 Jul 2007 16:18:27 GMT

Are the corrected assemblies packaged into the 1.6.1 DL currently available from the My Account area? Or will I need to get the zip file posted here as well.

RE: VS crashes when 1.6.1 opens solution

Chan — Sat, 07 Jul 2007 14:56:22 GMT

It takes 8-14 secs to retrieve 500 records at Malaysia

RE: VS crashes when 1.6.1 opens solution

Ben Hayat — Sat, 07 Jul 2007 14:55:27 GMT

[quote][b]Trent L. Taylor (07/07/2007)[/b][hr]I haven't noticed any speed issues with the Brazilian database. It sucked down 500 records in less than 2 seconds from my crummy internet connection at my house....I was impressed! :w00t:[/quote]

I'm just busting his chops. I know, I did some edit/save and you can't tell it's not local.

Trent, let me ask you something. Let's say I have to change the salesrep (foreign key) of 500 customer, and if I use transaction, will each customer "change" to remote server happen individually or do they get packaged up as on large transaction from client and then sent to the SE for processing?

Thanks!

RE: VS crashes when 1.6.1 opens solution

Trent L. Taylor — Sat, 07 Jul 2007 14:37:58 GMT

I haven't noticed any speed issues with the Brazilian database. It sucked down 500 records in less than 2 seconds from my crummy internet connection at my house....I was impressed! :w00t:

RE: VS crashes when 1.6.1 opens solution

Ivan George Borges — Sat, 07 Jul 2007 14:05:48 GMT

[quote]You Work???[/quote]

Only on weekends... :cool:

[quote]Hey Ivan, I connected to your server last night. When are you going to change that 286 server to a 386. I have one 386 from 1985, if you want...;)[/quote]

Nah, no need for that. The software is so good that we thought of putting it on a PC XT, but then most of my games wouldn't run on an XT, so the 286 got in action... :P (you very funny)

RE: VS crashes when 1.6.1 opens solution

Ben Hayat — Sat, 07 Jul 2007 13:40:35 GMT

[quote][b]Trent L. Taylor (07/07/2007)[/b][hr]LOL...sorry :D[/quote]

Works great! Thanks...

RE: VS crashes when 1.6.1 opens solution

Ben Hayat — Sat, 07 Jul 2007 13:32:31 GMT

[quote][b]Ivan George Borges (07/07/2007)[/b][hr]... and I thought I would have a good excuse not to work this weekend!

:P[/quote]

You Work??? :D

Hey Ivan, I connected to your server last night. When are you going to change that 286 server to a 386. I have one 386 from 1985, if you want...;)

RE: VS crashes when 1.6.1 opens solution

Trent L. Taylor — Sat, 07 Jul 2007 11:37:35 GMT

LOL...sorry :D

RE: VS crashes when 1.6.1 opens solution

Ivan George Borges — Sat, 07 Jul 2007 11:16:05 GMT

... and I thought I would have a good excuse not to work this weekend!

RE: VS crashes when 1.6.1 opens solution

Trent L. Taylor — Sat, 07 Jul 2007 11:12:37 GMT

Simple fix....simple problem :blush: Attached is a ZIP file that contains two assemblies. Follow the steps below once the ZIP file has been extracted to your local machine.

Close Visual Studio
Drag the two MicroFour DLLs into c:\Windows\Assembly (GAC)
Re-open Visual Studio

That's it :hehe: Those darned last minute changes .... I knew better :D

RE: VS crashes when 1.6.1 opens solution

Ben Hayat — Sat, 07 Jul 2007 11:02:57 GMT

[quote][b]Trent L. Taylor (07/07/2007)[/b][hr]OK guys....sorry for thetrouble. I am working on thisight now. I think a last minute change is causing the prblem. :blush:[/quote]No sweat!

RE: VS crashes when 1.6.1 opens solution

Trent L. Taylor — Sat, 07 Jul 2007 10:34:44 GMT

OK guys....sorry for thetrouble. I am working on thisight now. I think a last minute change is causing the prblem. :blush:

RE: VS crashes when 1.6.1 opens solution

Ben Hayat — Sat, 07 Jul 2007 03:54:37 GMT

[quote]Open the DTEPreferences table and make sure that you have a field named pref_ShowFullBOName. [/quote]

Hi Trent;

I checked the table and the field does exist. Just wanted to let you know, if I try to run an existing compiled project, some forms work and some forms I get lots of errors.

As mentioned before, I can not even create NONE SF projects!

Thanks!

RE: VS crashes when 1.6.1 opens solution

Teddy Jensen — Sat, 07 Jul 2007 03:05:18 GMT

Hi,

I have the same problem after installing 1.6.1.

VS crashes if i try to open an existing or create a new SF project.

/Teddy

RE: VS crashes when 1.6.1 opens solution

Chan — Fri, 06 Jul 2007 23:17:52 GMT

Hi,
Attached result.log