Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: roman104 on November 22, 2016, 05:54:11 pm

Title: "Model Image cannot be imported while connected to the SQL server repository"
Post by: roman104 on November 22, 2016, 05:54:11 pm

Hi EA Friends,
I am facing very strange Warning while working with MS SQL based Repository accessible via Sparx cloud services.
Screenshot is in attached pdf file.
I have never got this message with My SQL.
Do You have the same experience?
It seems to me, it is feature ...
Thank You
Have a nice modeling
Roman

https://agnicoli.mooo.com:9999/attachments/download/146/PCG_00176_20161122-Model%20Image%20cannot%20be%20imported%20while%20connected%20to%20the%20SQL%20server%20repository%20with%20Cloud%20Services.pdf (https://agnicoli.mooo.com:9999/attachments/download/146/PCG_00176_20161122-Model%20Image%20cannot%20be%20imported%20while%20connected%20to%20the%20SQL%20server%20repository%20with%20Cloud%20Services.pdf)

Title: Re: "Model Image cannot be imported while connected to the SQL server repository"
Post by: Zvolensky on November 22, 2016, 09:07:29 pm

Hello
This error is really confusing.
Here is the screenshot for those who cannot access the above link
(http://zvolensky.co.uk/sparx_error.png)

We are getting this error when we are trying to paste an image but also when we are using Model Wizard to create new packages.
We are using Sparx 13.0.1307 and Sparx Cloud 1.2.11

Any idea what might be the issue?

Title: Re: "Model Image cannot be imported while connected to the SQL server repository"
Post by: hd on November 23, 2016, 07:41:49 am

Grant users ALTER permission on the t_image table...

Code: [Select]

GRANT ALTER ON [dbo].[t_image] TO <eauser>;
Image IDs are unique, t_image.ImageID is an IDENTITY column, and inserting an image into the t_image table therefore requires execution of SET IDENTITY_INSERT t_image ON/OFF, which requires ALTER permission on the table.

Title: Re: "Model Image cannot be imported while connected to the SQL server repository"
Post by: Zvolensky on November 23, 2016, 03:00:01 pm

Hello
Thank you. Now the question is for which user as this is happening only when using Sparx Cloud connect, not with direct SQL connection
The cloud service is running under my domain account, which is also a db_owner of the Sparx repository on the SQL server

Title: Re: "Model Image cannot be imported while connected to the SQL server repository"
Post by: Zvolensky on November 28, 2016, 07:00:19 pm

Hello all
Nobody has the same issue as us? hmmm

Title: Re: "Model Image cannot be imported while connected to the SQL server repository"
Post by: Zvolensky on December 08, 2016, 03:33:06 pm

Hello
Still nobody?
Are we the only guys experience this problem?

Title: Re: "Model Image cannot be imported while connected to the SQL server repository"
Post by: Graham_Moir on December 08, 2016, 08:41:43 pm

You might be the only guys trying this in this configuration...