Author Topic: Error message during Import - Native XML  (Read 1426 times)

hano08

  • EA Novice
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
Error message during Import - Native XML
« on: October 01, 2024, 10:11:08 pm »
Hi,

When we do Full Project Transfer via Native XML > Import Complete Project, this error message appears:
 
Native Update FAILED with error:
Cannot insert explicit value for identity column in table 't_image' when IDENTITY_INSERT is set to OFF

It does not appear to affect the repository in any way, from what we can tell, but it would be good to know what this means and if it presents any risks?
Any help is appreciated.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13177
  • Karma: +549/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Error message during Import - Native XML
« Reply #1 on: October 01, 2024, 10:49:42 pm »
t_image is where your image library is stored.

I'm pretty sure that is because you are not on the latest version of the database schema.

For SQL Server there is an optional schema update scrip to be downloaded that should solve this. Not sure if it affects other DBMS as well, and how to deal with those. https://sparxsystems.com/downloads/corp/scripts/EASchema_1558_SQLServer.sql

Geert

hano08

  • EA Novice
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
Re: Error message during Import - Native XML
« Reply #2 on: October 02, 2024, 05:34:38 am »
Thanks Geert for your quick response.
However we have our repos updated to that schema.

(from the 'About' dialog:)
Connection / DBMS:  OLEDB - MS SQL Server
Database Schema Version: 1558

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +395/-301
  • I'm no guru at all
    • View Profile
Re: Error message during Import - Native XML
« Reply #3 on: October 02, 2024, 07:31:53 am »
The native XML transport is (compared to other features) relatively new. I would recommend to contact Sparx support. Meanwhile try one of the older options.

q.

hano08

  • EA Novice
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
Re: Error message during Import - Native XML
« Reply #4 on: October 02, 2024, 04:20:11 pm »
Thanks qwerty,
I will try to contact Sparx.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13177
  • Karma: +549/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Error message during Import - Native XML
« Reply #5 on: October 02, 2024, 04:35:16 pm »
Thanks Geert for your quick response.
However we have our repos updated to that schema.

(from the 'About' dialog:)
Connection / DBMS:  OLEDB - MS SQL Server
Database Schema Version: 1558
That doesn't prove that you have done the optional t_diagram update.

Geert

Elpis

  • EA User
  • **
  • Posts: 36
  • Karma: +6/-0
  • Make MDA/MBSE vital.
    • View Profile
Re: Error message during Import - Native XML
« Reply #6 on: October 11, 2024, 10:43:34 pm »
For SQL Server there is an optional schema update scrip to be downloaded that should solve this. [...] https://sparxsystems.com/downloads/corp/scripts/EASchema_1558_SQLServer.sql
This is the basic structure script URL, I guess. For optional schema update, it is https://sparxsystems.com/downloads/corp/scripts/EASchema_1558_SQLServer_Update1.sql (see https://sparxsystems.com/resources/repositories/ section "Microsoft SQL Server" for related info).