Author Topic: EA crash after SQL connect (Read 4562 times)

Chaos · « **on:** November 08, 2005, 05:02:03 am »

My Enterprise Architect crash after a connect to a SQL Server Data Repository.

I am using the Enterprise Architect Corporate Trial Verion and I am testing it for our department. We want manage our Models over a SQL server and so I'm connecting to a server repository...

After selecting the server type and entering the needed details i test the connection. The test succeded an I press OK. Now I can give the connection a name and type. I use the name "EADB_sql" for testing. In the database server dialog is MS SQL Server shown. After pressing OK I am getting an error massage and EA crash.

The massage:
Enterprise Architect has experienced a network error and will close down

I hope that I can find here help. Maybee someone had the same problem and fix it. Thank's for reponses.

greetz Chaos

thomaskilian · « **Reply #1 on:** November 08, 2005, 05:28:37 am »

Have you setup the tables with the right scripts from Sparx?

Chaos · « **Reply #2 on:** November 08, 2005, 06:44:56 am »

Yes, I have setup the tables with the right script and I have also look in the database and the tables exist.

I have also restart the SQL server and nothing changed.

hd · « **Reply #3 on:** November 08, 2005, 01:08:04 pm »

Have you transferred an eap model to the SQL Server database?

Look up "Upsizing to SQL Server" in the EA Help Index for more details.

Chaos · « **Reply #4 on:** November 09, 2005, 01:07:02 am »

Bevore I can transfer an eap model to the SQL Server, there must exist a Server Repository or not?

Or is it possible that I can transfer first an eap model and than I can create a Repository?

thomaskilian · « **Reply #5 on:** November 09, 2005, 01:38:20 am »

- Create the repository using the scripts
- open EA
- Tools/Data Management/Transfer
- Copy the contents of an empty EAP (one of the samples) to the repository
- File/Open Project and connect to your SQL server

Chaos · « **Reply #6 on:** November 09, 2005, 02:32:23 am »

I have tryed it in your order thomaskilian, but nothing changed. I get the massage and EA crash.

I have no idea what it can be.

thomaskilian · « **Reply #7 on:** November 09, 2005, 04:09:01 am »

But the transfer worked?

Chaos · « **Reply #8 on:** November 09, 2005, 07:55:52 am »

How can i sea that the transfer worked?

Where can I find the entry in the database?

thomaskilian · « **Reply #9 on:** November 09, 2005, 12:58:36 pm »

There should have been some progress information. Also you can look inside the tables using the SQL Enterprise Manager. You should see around a hundred tables with lots of data (esp. t_object).

Chaos · « **Reply #10 on:** November 10, 2005, 02:30:17 am »

I don't know why, but it works now.

We have changed our network system yesterday and now EA don't crash after connect. Curious, but maybe the old network system was the reason. I can't explain it. I can now wonderfull create Repositorys and work with them. The transfer from .eap to DBMS work fluent without any crashes.

Thanks all that have tried to help me.

Chaos

thomaskilian · « **Reply #11 on:** November 10, 2005, 03:38:59 am »

I'm with you. Just spent the whole morning to kick my windows scripting under XP to accept my Add-In. In the end it looked to me as if I changed nothing - but it works now

Sparx Systems Forum

News: