Messages

1

Bugs and Issues / Re: FK Issue in DDL Generation

« on: September 30, 2020, 08:02:40 pm »

Thanks for your reply Geert. I have run the integrity check and corrected all errors but this did not help.
I have found the spurious FK connector with no operation which was causing one of the issues.

However, most of the problems arise when there is more than one FK between the same 2 tables. In these case both the Connector and Property exist but the DDL generation is just not working for the FK constraint

2

Bugs and Issues / FK Issue in DDL Generation

« on: September 30, 2020, 02:12:12 am »

Hi, when generating DDL for SQL Server I am seeing issues with the FK generation. Specifically I am seeing FK constraints with empty reference data:

   CONSTRAINT [FK_Claim_ClaimType] FOREIGN KEY () REFERENCES  () ON DELETE No Action ON UPDATE No Action,
   CONSTRAINT [FK_Claim_ClaimType_02] FOREIGN KEY ([ClaimTypeSKey]) REFERENCES [dim].[ClaimType] ([ClaimTypeSKey]) ON DELETE No Action ON UPDATE No Action,

Note in this example 2 instances of FK for Claim_ClaimType. In the model I can only see one association between Claim and ClaimType tables.

I have tried deleting the association but the invalid constraint is still generated so I am guessing there is some sort of corruption here. I have a total of over 60 such errors, mostly arising when there are multiple FKs to the same table (based on different columns).

Any suggestions much appreciated.

3

Automation Interface, Add-Ins and Tools / Re: EA Excel VBA Importer not loading AttributeType

« on: January 30, 2020, 10:33:56 pm »

Import is working OK now. Thanks for your help Geert.

4

Automation Interface, Add-Ins and Tools / Re: EA Excel VBA Importer not loading AttributeType

« on: January 30, 2020, 04:04:25 am »

I have set up the import to create 3 columns on an existing table (Action Update table, create each column). It seems to run OK but nothing is updated in EA. It did finish very quickly, as soon as I pressed OK it returned with the Finished message.

5

Automation Interface, Add-Ins and Tools / Re: EA Excel VBA Importer not loading AttributeType

« on: January 29, 2020, 10:59:20 pm »

Thanks Geert! There are a lot of new columns in this version, do you have any documentation yet?

6

Automation Interface, Add-Ins and Tools / EA Excel VBA Importer not loading AttributeType

« on: January 29, 2020, 10:31:42 pm »

I am using the Bellekens Excel importer to load new columns into tables in a database model. The columns are added OK, but the datatype is empty after load. I have set the AttributeType and AttributeLength columns on the spreadsheet. Can anyone help? I have a lot of updates to make!

7

Bugs and Issues / Re: Pro Cloud Server Licence Issue

« on: January 13, 2020, 11:06:45 pm »

Thanks Eve, I will do that.

8

Bugs and Issues / Pro Cloud Server Licence Issue

« on: January 06, 2020, 11:51:16 pm »

Hi, I am running Pro Cloud Server with an enterprise licence valid until September 2020. This was running fine last year, but on returning from holidays I am confronted with the error - "The license file could not be verified". Has anyone seen this before and any ideas what it means? I have tried removing the licence then adding the original licence file again but same error.

9

Bugs and Issues / Re: Missing FK in SQL Server DDL Import

« on: November 30, 2019, 02:00:38 am »

I am running EA v15 and have reverse engineered SQL Server databases. The foreign key constraints imported OK in my case.

10

General Board / Re: Database Builder Import Overwrites Notes

« on: November 29, 2019, 08:33:55 pm »

Thanks for the suggestion Geert. As we are moving to automating the synchronisation process, maybe that could be incorporated in the code. I will make that suggestion.

David

11

General Board / Database Builder Import Overwrites Notes

« on: November 28, 2019, 08:59:00 pm »

Hi, I am running EA v15 using Pro Cloud Server. I have created a data model by reverse engineering a SQL Server database and enriched it. One of the enrichments is to load column descriptions using Geert Bellekens Excel import to bulk load. This worked very well, placing the new descriptions in the Notes window. However, when I update a column using Database Builder by importing from ODBC the Notes are deleted even though I have selected the option to ignore Remarks and no remarks show in the database compare window. I notice a bug was raised about this for v12 but does anyone know of a workaround as it seems Sparx does not see it as urgent!

12

General Board / Diagram background in WebEA

« on: November 08, 2019, 02:07:47 am »

Hi, WebEA displays diagrams with a white background, regardless of the background I have used in EA. If I add swimlanes with colour, these display OK in WebEA. Is there a way to set a general background colour? I don't want to add a swimlane in every diagram just to get the background as I want it!

David