Sparx Systems Forum

Discussion => Suggestions and Requests => Topic started by: Arquesoft on June 29, 2017, 01:02:18 am

Title: Be able to upload model images connected via Cloud
Post by: Arquesoft on June 29, 2017, 01:02:18 am
It is frustrating when you use the advantages of implementing Cloud Server in a company that has been using connections via ODBC to the EA Repository, but it is not possible to upload model images in order to be used as alternate images for elements.
Title: Re: Be able to upload model images connected via Cloud
Post by: Graham_Moir on July 03, 2017, 11:21:19 pm

Yes, but rumour has it that there is a fix coming in 13.5
Title: Re: Be able to upload model images connected via Cloud
Post by: Arquesoft on July 13, 2017, 11:50:14 pm
Not possible in 13.5 Build 1351.
Title: Re: Be able to upload model images connected via Cloud
Post by: Arquesoft on July 24, 2017, 11:39:30 pm
Not possible in 13.5 Build 1351.

When trying to upload the image via the Model Images window, it throws the following message in the System Output Window:
Cloud Services: Query in batch execute failed with message: FAIL: Microsoft OLE DB Provider for SQL Server [-2147217900] Cannot insert explicit value for identity column in table 't_image' when IDENTITY_INSERT is set to OFF.   
Title: Re: Be able to upload model images connected via Cloud
Post by: T Kouno on July 25, 2017, 09:32:16 am
Hello MMoya,

The help file says that you need ALTER permission, like below:

You have ALTER permission on the t_image table in Enterprise Architect, to be able to import model images
( http://www.sparxsystems.com/enterprise_architect_user_guide/13.5/model_repository/connecttosqlserver.html )

HTH,
Title: Re: Be able to upload model images connected via Cloud
Post by: Arquesoft on December 13, 2017, 05:52:23 am
As tested in a real environment (and confirmed via Sparx support), ALTER permission is not enough to make it works properly. Not found yet a solution.
Title: Re: Be able to upload model images connected via Cloud
Post by: Arquesoft on March 08, 2018, 03:38:33 am
Still not possible in version 14 Beta  :(
Title: Re: Be able to upload model images connected via Cloud
Post by: Geert Bellekens on March 08, 2018, 03:45:49 am
Still not possible in version 14 Beta  :(

Have you tried with the updated database schema?

Geert
Title: Re: Be able to upload model images connected via Cloud
Post by: Graham_Moir on April 06, 2018, 09:35:22 pm

We just hit this again, so it would be good if it was made more straightforward.
Geert - what do you mean by the updated schema?
Title: Re: Be able to upload model images connected via Cloud
Post by: Geert Bellekens on April 07, 2018, 04:04:28 am
Geert - what do you mean by the updated schema?

The updated the database schema a bit. Nothing major, just some tweaks here and there.

Geert
Title: Re: Be able to upload model images connected via Cloud
Post by: Arquesoft on April 13, 2018, 05:33:05 am
The schema we used had been created with 20-Jun-2016 version. EASchema_1220_SQLServer.sql
There is not a new version of the schema since our database creation.
Title: Re: Be able to upload model images connected via Cloud
Post by: Aaron B on April 13, 2018, 10:36:03 am
From the Readme.txt for EA 13.5 1351:

Quote
  Alternate Image handline on SQL Server Repositories improved, including restoring the ability to add images over a cloud connection:
    . Requires SQL Server user to have ALTER TABLE permission for the t_image table

Please confirm that you are running EA 1351 or higher, and that you have the required ALTER TABLE permission for the t_image table.
Title: Re: Be able to upload model images connected via Cloud
Post by: Aaron B on April 18, 2018, 05:07:00 pm
So I've just got some clarification that to fix this problem with SQL Server you need to apply an additional patch to the schema (EASchema_1220_SQLServer_Update1.sql). This update was just recently made available on our website (April 2018). In particular, please note that it requires all users to have EA 14 and is not backwards compatible. For more details, see:
http://www.sparxsystems.com/resources/corporate/index.html#sql_scripts