Book a Demo

Author Topic: "Model Image cannot be imported while connected to the SQL server repository"  (Read 9620 times)

roman104

  • EA User
  • **
  • Posts: 28
  • Karma: +0/-0
  • Right Information - In Right Time - for Right Role
    • View Profile
    • Right Information - In Right Time - for Right Role
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

Zvolensky

  • EA User
  • **
  • Posts: 62
  • Karma: +0/-0
  • Do... or do not. There is no try.
    • View Profile
Hello
This error is really confusing.
Here is the screenshot for those who cannot access the above link


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?

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
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.

Zvolensky

  • EA User
  • **
  • Posts: 62
  • Karma: +0/-0
  • Do... or do not. There is no try.
    • View Profile
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

Zvolensky

  • EA User
  • **
  • Posts: 62
  • Karma: +0/-0
  • Do... or do not. There is no try.
    • View Profile
Hello all
Nobody has the same issue as us? hmmm

Zvolensky

  • EA User
  • **
  • Posts: 62
  • Karma: +0/-0
  • Do... or do not. There is no try.
    • View Profile
Hello
Still nobody?
Are we the only guys experience this problem?

Graham_Moir

  • EA User
  • **
  • Posts: 749
  • Karma: +10/-15
    • View Profile
You might be the only guys trying this in this configuration...