Be able to upload model images connected via Cloud

[Arquesoft]

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.

[Graham_Moir]

Yes, but rumour has it that there is a fix coming in 13.5

[Arquesoft]

Not possible in 13.5 Build 1351.

[Arquesoft]

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.   

[T Kouno]

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,

[Arquesoft]

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.

[Arquesoft]

Still not possible in version 14 Beta 

[Geert Bellekens]

Still not possible in version 14 Beta 

Have you tried with the updated database schema?

Geert

[Graham_Moir]

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?

[Geert Bellekens]

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

[Arquesoft]

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.

[Aaron B]

From the Readme.txt for EA 13.5 1351:

  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.

[Aaron B]

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