The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hello,

We have a problem similar to this one.
We have a DB with ~400 tables and ~1300 foreign keys. All tables are empty. Generation of Entity Data Model succeeds only when foreign keys are deleted. When foreign keys are present, the process seems to never end (even when trying to map only one table with no relations to other tables). DB server CPU load is near 100% almost all the time (from beginning until killing the mapping process).

It works fine with a much lesser DB on the same server (only 40 foreign keys).

DB server - Win XP 64 bit (test server), SA 12.0.1.3436.
We tried the workaround mentioned in the link above (DB server on Win 7) but with no success.
We also have applied the latest EBF (3726) to the client side but that did not help too.

Is it a bug or are there some known restrictions?
Thanks.

asked 10 May '12, 03:52

Arthoor's gravatar image

Arthoor
1.1k264056
accept rate: 0%

edited 10 May '12, 03:57

Maybe you should give Sybase a sample db so that they can try to reproduce it.

(16 May '12, 02:55) Martin

Idem problem

(29 May '12, 03:48) Golem

I also have the same problem. I've even tried using Typed DataSet and DB server hangs with 100% CPU when I try to configure an existing TableAdapter. With Entity Framework I'm able to create a model based on views, but as soon as I try to add a table, the DB server hangs forever.

(07 Aug '12, 09:57) Eivind Gussi...
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×404
×64
×18

question asked: 10 May '12, 03:52

question was seen: 982 times

last updated: 07 Aug '12, 09:57