Messages

1

General Board / What's the best way to make this faster for remote working?

« on: April 10, 2020, 01:24:33 am »

Hi, I work at a company with 10 or so architects who use EA fairly heavily.  The speed has never been great but now we're all working remotely over a VPN it's terrible, we're seeing things like package checkouts taking from 5 to 30 minutes, several minutes just opening an entity, lots of SQL timeouts, and so on.

I'm not too familiar with the setup but I know we have:

• A single, relatively large model
• SQL Server back end (shared)
• TFS version control
• EA version 13.0

We've been investigating a bit, the main cause of the problems seems to be blocking in SQL.

There are a few options we're considering, namely

• Pro Cloud Server
• Running EA on VDIs
• Improving the SQL (e.g. faster box, isolated DB)

Pro Cloud Server seems like it should help by grouping queries together and reducing network traffic.  But before we dive in with that (which may take a little while anyway), I'd like to ask if anyone else has had similar issues and how you solved them.

2

Bugs and Issues / Re: 'User does not have permission to import model images' on Check Out

« on: March 19, 2019, 12:46:10 am »

Update: ALTER TABLE permissions got granted on t_image and that seems to have done the trick.  Why this only happened for my user I don't know (the SQL login is based on a shared AD group), and why granting me admin rights in EA also worked adds to the confusion - but it's working now and that's the main thing!

3

Bugs and Issues / Re: 'User does not have permission to import model images' on Check Out

« on: March 18, 2019, 04:35:47 am »

So still waiting on getting DB permissions changed, but in the meantime I was given admin permissions temporarily in EA and stopped getting the error.  I would think this means it's an EA permissions thing rather than a database thing, however the administrator says my permissions in EA are set the same as everyone else's.

Any idea what permission in EA I might be lacking which would result in this image error?

4

Bugs and Issues / Re: 'User does not have permission to import model images' on Check Out

« on: March 13, 2019, 09:29:39 pm »

Thanks Geert, unfortunately we're not on that version and I don't think an upgrade is going to happen anytime soon.

Do you know whether either of the suggested solutions is likely to work, before I start raising tickets?

5

Bugs and Issues / 'User does not have permission to import model images' on Check Out

« on: March 13, 2019, 07:43:44 pm »

Hi I'm using EA Corporate Edition v13.0.1306 with a SQL Server-based project and TFS for version control.

When I try and check out part of the model I usually get the message 'User does not have permission to import model images'.  Re-synching status with VC provider at this point shows the model is not checked out.  (In some areas of the model the checkout is successful but I get the error when checking back in).

Several other people here are using (I believe) the same setup successfully.

I found a couple of things online about this error regarding the t_image table.  One suggests giving my user ALTER permission on t_image - however I don't have a specific DB user set up, access is controlled with an AD group.  I could grant that user ALTER permissions, but as everyone uses the same group to log on I'd be surprised if that worked.

The other suggests creating an AD group called 'SQL Enterprise Architect Update' and doing this: GRANT ALTER ON [dbo].[t_image] TO [SQL Enterprise Architect Update].  Unfortunately getting an AD group created here isn't easy (and may not get approved at all), but I'm waiting on that in the meantime.

Any thoughts as to what the problem might be, or even how I can find more info to investigate?

Thanks