Messages

1

Bugs and Issues / Internal Error

« on: November 08, 2018, 02:59:50 am »

We have an Oracle data model, if you are familiar with the Oracle package structure you know that there is one package or folder named "tables" and inside this package resides the diagram that contains all the entities in the model.

Well, the thing is that EA takes too much time to open this diagram and at the end throws the "Internal application error" window. After clicking "OK" in the error window I'm able to work, but this is something new, it just started to happen yesterday.

I'm not sure if the diagram is broken or what, it's annoying to have to wait for the error window.

Is there a way to find why is this happening and fix it?

I ran the project Integrity check and everything looks fine.

I'm using EA 14.0.1418.

The repository details are:
Name:  [REPOSITORY_NAME]
Connection / DBMS:  OLEDB - Oracle
Database Version: 4.01
Version Date: Jan-31-2004

2

Bugs and Issues / Re: Model Search SQL - behaviour of the plus-character

« on: August 17, 2018, 02:08:46 am »

Consider sending a bug report.

q.

Thanks, I did it last week 

3

Bugs and Issues / Re: Model Search SQL - behaviour of the plus-character

« on: August 16, 2018, 11:31:22 pm »

 
I have setup the connection using ODBC (http://www.sparxsystems.com/enterprise_architect_user_guide/14.0/model_repository/connecttoaoracle9idatarep.html) and the behavior is the same, and yes, it's very slow opening the project (I'm not going to use it).

In the other hand, If I run the same query in the "Database Builder" in EA, this returns the expected result.

So, then:

• It's not the OLE DB driver because using ODBC I can replicate the error
• Neither the error is because the ODBC driver, because "Database Builder" returns the expected result.

I'm still thinking that the problem is in the "Search".

Thank you.

4

General Board / Re: Generating tables from a UML model attribute varchar default length

« on: August 13, 2018, 11:46:45 pm »

Try this:

• Modify the "DDL" Template (Design -> Tools -> Transform -> Transform Templates)
• Replace: type=%qt%%CONVERT_DB_TYPE(genOptDefaultDatabase, attType)%%qt%
  with:
      type = %qt%varchar%qt%
      length = %255%qt%

And see if works.

5

Bugs and Issues / Re: Model Search SQL - behaviour of the plus-character

« on: August 13, 2018, 11:10:14 pm »

What is strange is that if you use any other operator symbol, works perfect. I'm not sure if EA "translates" the query based on the defined database.

I also tried using #DB=ORACLE# macro with no success.

Simon, could you please review if EA is translating the query before sending it to the database?

if you are using the search, see in the result window, the header for the results displays something like "5||5", "double pipe" is used to concatenate strings in Oracle. (I don't know how to upload screen shots to illustrate my point).

Thank you!

6

Bugs and Issues / Re: Model Search SQL - behaviour of the plus-character

« on: August 10, 2018, 11:31:16 pm »

At the beginning I thought the same, but I ran the following query:

Code: [Select]

Select 5+5 from t_object  and it's returning 55. 


Thank you.

7

Bugs and Issues / Re: Model Search SQL - behaviour of the plus-character

« on: August 10, 2018, 12:47:23 am »

Hi Bert,

I'm facing the same issue with the plus character, instead of adding the values is concatenating them as strings.

Were you able to solve this issue? how?

We are using EA Version 14.0

Thank you!

8

General Board / Import DB Schema - Missing tables.

« on: July 27, 2018, 02:37:59 am »

Hello,

I'm looking for a different way to identify the tables in a DB that are not present in the data model with the intention of import them later.

What I tried was to use the DB Compare in Database Builder but if I select only the "Tables" folder, the tool only compare the tables in data model, does not show the tables in the DB that are not present in the model.

I found this link (https://www.sparxsystems.com/forums/smf/index.php/topic,39504.msg243756.html#msg243756) where it says:

"I found, that selecting ShowDifferences from subelements (ie Tables) doesn't report objects existing in database but not existing in the model. While using root element, EA reports new objects allowing to add them to the model."

I left EA running for more than an hour, probably if I leave EA running more time may show the "missing" tables, that's why I'm looking for an alternative that allows me to do this in less time.

Thank you.

9

Automation Interface, Add-Ins and Tools / Re: Using Counters in Names during DDL Transformation

« on: July 21, 2018, 02:05:02 am »

Hi,

Were you able to figure out how to do this?

I'll appreciate any feedback.

10

General Board / Re: Star Schema / Dimensional Database

« on: June 08, 2018, 11:23:47 pm »

Richard, you are right.

Although star schema is a methodology and can be implemented in any relational database, I've seen in other data modeling tools that you can define your data model as a dimensional model, this allows you to identify the tables as fact or dimension and also allows you to maintain the data lineage.

I believe that's why in the answer posted by lfgcasey says "Enterprise Architect supports physical data modeling for relational...", but at the end I see that EA does not support dimensional models.