Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: hano08 on October 01, 2024, 10:11:08 pm

Title: Error message during Import - Native XML
Post by: hano08 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.

Title: Re: Error message during Import - Native XML
Post by: Geert Bellekens 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 (https://sparxsystems.com/downloads/corp/scripts/EASchema_1558_SQLServer.sql)

Geert

Title: Re: Error message during Import - Native XML
Post by: hano08 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

Title: Re: Error message during Import - Native XML
Post by: qwerty 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.

Title: Re: Error message during Import - Native XML
Post by: hano08 on October 02, 2024, 04:20:11 pm

Thanks qwerty,
I will try to contact Sparx.

Title: Re: Error message during Import - Native XML
Post by: Geert Bellekens on October 02, 2024, 04:35:16 pm

Quote from: hano08 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

That doesn't prove that you have done the optional t_diagram update.

Geert

Title: Re: Error message during Import - Native XML
Post by: Elpis on October 11, 2024, 10:43:34 pm

Quote from: Geert Bellekens on October 01, 2024, 10:49:42 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 (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).