Hi there,
I need to know where my mistake is, or if its a real bug. The problem is reproducable.
My Setup: I set up an Oracle DB with 6 Useres and each one has its own tablespace, so I get 6 separate repositories.
I use ProCloud OLE DB, I can connect, I uesed the "project transfer" function of EA Client (V 15) to transfer a minimal Model (one Model incl. one view incl. one package incl. one diagram) that I created only for this use. Transfer successful, open repository with EA Client via ProCloud, also working, project integrity perfect, Oracle t_package shows 3 packages
Now the error: when I ADD another package "NewPackage", eg. to the "view"-Package, I get two errors:
- ORA-00001: Unique Contraint (username.PK_PACKAGE) violated
- ORA-00001: Unique Contraint (username.PK_OBJECT) violated
The Oracle DB t_package now STILL has only 3 entries, but the name of the last one (package) was now changed to "NewPackage", so an existing was changed instead of a new being added.
--> this only happens on the first occurrence, all I add later do not pose a problem.
Same thing with Diagrams, but with PK_DIAGRAM error
Can you understand? Can you help?
--> May the problem be, that using 6 Users with separate tabelspaces will NOT give them their own SEQUENCES? And this leads to the problems?
