Book a Demo

Author Topic: Import DDL Script (EA build 1721) - SQL Server (Azure SQL)  (Read 16 times)

robert.daniels-dwyer@hs2.

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
We are trying to import DDL into a SQL Server repository (running on Azure SQL on our own tenant).  We are getting an uncontrolled error with t_xref.  Sparx then creates the names of the first two tables in the .sql file, but no columns, and crashes out. 
We do not get this error when loading onto a local file-based repository.

Has anyone come across this?  Does anyone have any ideas?

------
Enterprise Architect (Build: 1721 - 64 bit)

Microsoft Cursor Engine [0x80040e21]

Field 'XrefID' - The value violated the data source schema constraint for the field.

Context:
select *
from t_xref
where Client in
    (
        select ea_guid
        from t_object
        where GenFile like 'C:\[Redacted]\Documents\Sparx Upload Test 30-07-26b\%'
    )
union
select *
from t_xref
where Client in
   (
    select ea_guid
    from t_connector
    where
        Start_Object_ID in
        (
            select Object_ID
            from t_object
            where GenFile like 'C:\[Redacted]\Documents\Sparx Upload Test 30-07-26b\%'
        )
    or
       End_Object_ID in
       (
            select Object_ID
            from t_object
            where GenFile like 'C:\[Redacted]\Documents\Sparx Upload Test 30-07-26b\%'
       )
    )