Messages

1

Bugs and Issues / Re: Encountering ORA-01795 when importing schema from large (1200+ tables) database

« on: May 16, 2017, 08:35:18 pm »

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:

Code: [Select]

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 


2

Bugs and Issues / Encountering ORA-01795 when importing schema from large (1200+ tables) database

« 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