Book a Demo

Author Topic: Copying Packages, another users are locked  (Read 5053 times)

Luis Gustavo

  • EA Novice
  • *
  • Posts: 16
  • Karma: +0/-0
    • View Profile
Copying Packages, another users are locked
« on: May 07, 2013, 11:39:40 pm »
Hello "
I'm using EA 9.3 with 4 users connected in SQL Database.
For example, if user "A" copy/paste one package, during this procedure another users ("B", "C" and "D")can't use EA.
It's look likes locking during this copy/paste.

Is this normal?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Copying Packages, another users are locked
« Reply #1 on: May 07, 2013, 11:57:07 pm »
I'd say yes, if you want a model with a little bit of consistency. What should be the outcome if user A copies something he's seeing and (while he can't see) another user B is changing it. Does it take too long so you're worried?

q.
« Last Edit: May 07, 2013, 11:58:20 pm by qwerty »

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Copying Packages, another users are locked
« Reply #2 on: May 08, 2013, 12:14:36 am »
There has been a locking issue for EA v9 with SQL Server. It should be fixed in the latest version (10.0.1007).

Geert

Luis Gustavo

  • EA Novice
  • *
  • Posts: 16
  • Karma: +0/-0
    • View Profile
Re: Copying Packages, another users are locked
« Reply #3 on: May 08, 2013, 02:27:22 am »
Qwerty,

User "B" is connected in same database. But not working in the same package, While the user "A" makes a copy, B is locked.

This is a problem or security(consistency)?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Copying Packages, another users are locked
« Reply #4 on: May 08, 2013, 02:42:50 am »
See Geerts answer. If that isn't the issue, can you detail how long the lock is held?

q.

Luis Gustavo

  • EA Novice
  • *
  • Posts: 16
  • Karma: +0/-0
    • View Profile
Re: Copying Packages, another users are locked
« Reply #5 on: May 08, 2013, 05:21:40 am »
EA from computer "B", "C" and "D" Styed locked during all time while is pasted.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Copying Packages, another users are locked
« Reply #6 on: May 08, 2013, 07:38:44 am »
Sure. But how long does the paste take? One second or two?

q.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Copying Packages, another users are locked
« Reply #7 on: May 08, 2013, 09:16:38 am »
Copy and paste of a package uses and XMI export/import. By default this uses a database transaction to ensure consistency. It's the transaction that is locking out other users. You can disable that behaviour on the XML import dialog or in the XML Specifications options page.