Author Topic: Be able to upload model images connected via Cloud  (Read 4191 times)

Arquesoft

  • EA User
  • **
  • Posts: 123
  • Karma: +1/-0
  • EA Consulting and development in Spanish
    • View Profile
    • Arquesoft website
Be able to upload model images connected via Cloud
« 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.



Graham_Moir

  • EA User
  • **
  • Posts: 703
  • Karma: +5/-9
    • View Profile
Re: Be able to upload model images connected via Cloud
« Reply #1 on: July 03, 2017, 11:21:19 pm »

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

Arquesoft

  • EA User
  • **
  • Posts: 123
  • Karma: +1/-0
  • EA Consulting and development in Spanish
    • View Profile
    • Arquesoft website
Re: Be able to upload model images connected via Cloud
« Reply #2 on: July 13, 2017, 11:50:14 pm »
Not possible in 13.5 Build 1351.



Arquesoft

  • EA User
  • **
  • Posts: 123
  • Karma: +1/-0
  • EA Consulting and development in Spanish
    • View Profile
    • Arquesoft website
Re: Be able to upload model images connected via Cloud
« Reply #3 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.   



Takeshi K

  • EA User
  • **
  • Posts: 326
  • Karma: +5/-0
    • View Profile
Re: Be able to upload model images connected via Cloud
« Reply #4 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,
--
t-kouno

Arquesoft

  • EA User
  • **
  • Posts: 123
  • Karma: +1/-0
  • EA Consulting and development in Spanish
    • View Profile
    • Arquesoft website
Re: Be able to upload model images connected via Cloud
« Reply #5 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.



Arquesoft

  • EA User
  • **
  • Posts: 123
  • Karma: +1/-0
  • EA Consulting and development in Spanish
    • View Profile
    • Arquesoft website
Re: Be able to upload model images connected via Cloud
« Reply #6 on: March 08, 2018, 03:38:33 am »
Still not possible in version 14 Beta  :(



Geert Bellekens

  • EA Guru
  • *****
  • Posts: 8204
  • Karma: +193/-23
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Be able to upload model images connected via Cloud
« Reply #7 on: March 08, 2018, 03:45:49 am »
Still not possible in version 14 Beta  :(

Have you tried with the updated database schema?

Geert

Graham_Moir

  • EA User
  • **
  • Posts: 703
  • Karma: +5/-9
    • View Profile
Re: Be able to upload model images connected via Cloud
« Reply #8 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?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 8204
  • Karma: +193/-23
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Be able to upload model images connected via Cloud
« Reply #9 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

Arquesoft

  • EA User
  • **
  • Posts: 123
  • Karma: +1/-0
  • EA Consulting and development in Spanish
    • View Profile
    • Arquesoft website
Re: Be able to upload model images connected via Cloud
« Reply #10 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.



Aaron B

  • EA Administrator
  • EA User
  • *****
  • Posts: 896
  • Karma: +13/-0
    • View Profile
Re: Be able to upload model images connected via Cloud
« Reply #11 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.

Aaron B

  • EA Administrator
  • EA User
  • *****
  • Posts: 896
  • Karma: +13/-0
    • View Profile
Re: Be able to upload model images connected via Cloud
« Reply #12 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

Arquesoft

  • EA User
  • **
  • Posts: 123
  • Karma: +1/-0
  • EA Consulting and development in Spanish
    • View Profile
    • Arquesoft website
Re: Be able to upload model images connected via Cloud
« Reply #13 on: April 24, 2018, 09:12:27 am »
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

Excelent news!! I will test it when version 14 officialy available (cause it works in a production environment)



Arquesoft

  • EA User
  • **
  • Posts: 123
  • Karma: +1/-0
  • EA Consulting and development in Spanish
    • View Profile
    • Arquesoft website
Re: Be able to upload model images connected via Cloud
« Reply #14 on: May 03, 2018, 07:35:33 am »
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

What is the consecuence of executing the SQL patch and having some users using version 14 and others using previous versions? will this bother the use of image library? or just version-13 users would be unable to upload images? Will this scenary cause errors? (asuming I pretend to upload images only from version 14 users)