Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.


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
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?

asked 10 May '12, 03:52

Arthoor's gravatar image

accept rate: 11%

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 10 May '12, 03:52

question was seen: 2,409 times

last updated: 07 Aug '12, 09:57