Sparx Systems Forum
Enterprise Architect => Bugs and Issues => Topic started by: rubin on May 10, 2017, 09:00:38 pm
-
Hi Sparx,
I've recently started using Enterprise Architect v13 (build 1310) on Windows 10 Pro x64, using Oracle's latest ODBC drivers (12.02.00.01) to talk to a particularly large database (1203 tables, 3430 stored procedures, 3900 views, 3600 triggers).
I'm trying to use the Code->Data Models->DB Schema Import. I've succesfully set-up my ODBC connection to the database and can list the schema's available in the DB and start the import process, selecting tables, etc.
When I select all 1203 tables, Enterprise Architect imports all tables as entities on a diagram, however, all entities are empty (meaning: no columns, no links/relations/empty, only the name of the table is correctly imported). Consequently, there are no links/relations between the entities which means you simply get a square map with 1203 cubes.. not very insightful!
In the system output log of Enterprise Architect, I see the following error: "ORA-01795: maximum number of expressions in a list is 1000"
When I limit my selection to say 10 tables, I notice that the import takes considerably longer, and I get columns and relations. Unfortunately, shift-selecting does not work in the table list and so I would have to manually one-by-one select say 900 tables, and then on a second import the remaining 303 - you'll understand that that's not a real option :-).
There are known workarounds for avoiding ORA-01795 and I hope that Sparx can implement those in order to fix this bug: doing so would allow Enterprise Architect to actually interact with large scale "Enterprise" databases and would give me insight into how the database is structured visually.
Kind regards + hoping for a fix,
Rubin
-
I would report that selection issue as a bug. Use the from form the appropriate link in the Support area below in this page.
q.
-
Sparx support will ask you to send DBError.txt which you can find in %APPDATA%/Sparx Systems/EA
-
I filed a bug report + replayed the issue to give reproduce-steps. However, no DBError.txt to be found. In the system log I see:
Error retrieving table columns: => [S1000]: [Oracle][ODBC][Ora]ORA-01795: maximum number of expressions in a list is 1000
Error retrieving primary keys: => [S1000]: [Oracle][ODBC][Ora]ORA-01795: maximum number of expressions in a list is 1000
Error retrieving indexes: => [S1000]: [Oracle][ODBC][Ora]ORA-01795: maximum number of expressions in a list is 1000
Error retrieving foreign keys: => [S1000]: [Oracle][ODBC][Ora]ORA-01795: maximum number of expressions in a list is 1000
Error retrieving unique constraints: => [S1000]: [Oracle][ODBC][Ora]ORA-01795: maximum number of expressions in a list is 1000
Error retrieving check constraints: => [S1000]: [Oracle][ODBC][Ora]ORA-01795: maximum number of expressions in a list is 1000
Error retrieving object privileges: => [S1000]: [Oracle][ODBC][Ora]ORA-01795: maximum number of expressions in a list is 1000
Error fetching table synonyms: => [S1000]: [Oracle][ODBC][Ora]ORA-01795: maximum number of expressions in a list is 1000
Error fetching table properties: => [S1000]: [Oracle][ODBC][Ora]ORA-01795: maximum number of expressions in a list is 1000
Error retrieving table/view comments: => [S1000]: [Oracle][ODBC][Ora]ORA-01795: maximum number of expressions in a list is 1000