Question & Answer

List of the most common questions and answers to them. Questions can relate technical, license, and methodology matters. You can find also tips & tricks here and anything else related to Enterprise Architect Information Portal.

Can I have more than one personal licence registered?

question_mark_1.png

Question

Can I have more than one personal licence registered?


Answer

Yes, if you follow the licensing rules, you can have any number of personal (or NP-EDU as well) licences registered.

 

Problem with license key

question_mark_1.png

Question

What should I do if there is a problem with my license key?


Answer

  1. You need to delete the appsettings.json configuration file in the infoport installation folder, restart the server and run the basic localhost and reconfigure the application 
  2. Or replace the license key in appsettings 

Search with Czech characters does not work

question_mark_1.png

Question

I don't see Czech characters in the full-text search. What is wrong?


Answer

You probably do not have the coalesce set correctly on the DB (database installation in which you have created EA repository).

 

Setting an Element Size in a Diagram

question_mark_1.png

Question

After adding an element to a diagram, the element has the wrong size. What to do?


Answer

In Enterprise Architect, click on Configure, then on Options. In the window that will open, click on Cloud and check the option Auto create Diagram Image and Image Map (each time a Diagram is saved).

Settings required for each project!

 

EA na ticket otázky a odpovědi_0.png

The diagram image is too small

question_mark_1.png

Question

The diagram image that I see is too small. Why?


Answer

The diagram value must be set to 400% and the Image Memory Limit to 256 (Optimal Zoom Setting).

 

Can I rename the EaInfoport.exe file?

question_mark_1.png

Question

Can I rename the EaInfoport.exe file?


Answer

No, InfoportLauncher would not be able to recognise the currently running version.

Inappropriate display of a detail

question_mark_1.png

Question

What to do when I have troubles with displaying a detail?


Answer

In a dynamic detail, the width of the field must be set.

Inappropriate display of the chart

question_mark_1.png

Question

What to do when I see the client’s chart displayed incorrectly, but it is correct in the portal?


Answer

If you see the client’s chart displayed incorrectly (distorted graphic), but it is correct in the server, it may be due to incorrectly installed MDG technology.

After editing, the change does not appear in the Enterprise Architect

question_mark_1.png

Question

What to do when the change does not appear in Enterprise Architect after editing in the portal?


Answer

You need to right-click on “package” in Enterprise Architect. We click on “contents” and then choose “reload current package”. Thus the package will be restored and the change will appear in Enterprise Architect.

If an EA repository cannot be connected due to an incorrect EAP password (EAP file path, Username or Password is not valid)

question_mark_1.png

Question

If, while connecting the EA repository, the system reports “Path to EAP file, Username or Password is not valid” in the configuration manager and you are sure that the name and path are correct, how to solve the problem?


Answer

  1. Check the username and password again – ideally copy the path to the clipboard and run it from the command line.
  2. Check if there is a space at the beginning or end of the password/username.
  3. Copy the EAP shortcut (or the entire EA Infoport directory) from the system folders to the root directory (e.g. to C:\EAInfoport). Note that the system folders to which Windows restricts access include, for example, Program Files and Program Files (x86)

Migration error

question_mark_1.png

Question

What to do if the following error occurs during migration?
(Column 'AspNetUsers.Id' is not of same collation as referencing column 'VisitedDetails.UserId' in foreign key 'FK_VisitedDetails_AspNetUsers_UserId'.
Could not create constraint or index. See previous errors.)


Answer

Make sure that the database table and the database itself have the same collation.

The “back” function is not supported by the browser

question_mark_1.png

Question

What should I do if I want to use the “back” function in the browser from the portal?


Answer

When switching between repositories or a portal, the “back” function is not supported by the browser.

User synchronisation against Enterprise Architect does not work

question_mark_1.png

Question

What should I do if my user does not synchronise against Enterprise Architect?


Answer

Make sure that the user has access to the repository. 
The portal administrator is not automatically taken as a repository user and has to be exactly assigned to the repository; otherwise, it will not be connected to Enterprise Architect.

 

 

How does an administrator log into Infoport for the first time?

question_mark_1.png

Question

How does an administrator log into Infoport for the first time?


Answer

 

The administrator logs in for the first time using the login credentials:

Username: admin
Password: P@ssw0rd

We recommend changing your password after the first login!


Unable to finish service due to mysql date in db

question_mark_1.png

Question

What to do in case of error Unable to convert MySQL date/time to System.DateTime, set AllowZeroDateTime=True or ConvertZeroDateTime=True in the connection string. See https://mysqlconnector.net/connection-options/ ?


Answer

If this error occurs, it should be enough to put at the end connection stringu ConvertZeroDateTime=True;.

Unable to view new models in Infoportal with basic permissions

question_mark_1.png

Question

I have connected the repository to the Infoportal. In Enterprise Architect I created a new root node (new model), but unfortunately in Infoportal the user with basic permissions cannot see it. How to solve this problem?


Answer

In version 7.x, the user is unfortunately forced to delete the repository and recreate it.
As of version 8.x, a button has been added to the repository edit for everyone, which will reset the permissions and thus create a default permission on the newly created model.

Users who own Medium Business Edition and above also have the option to manually set this default permission manually on behalf of the repository admin or model owner via the Permissions tab in the tree.

What happens if a user connects an EA repository to the infoportal and then migrates the database data?

question_mark_1.png

Question

What happens if a user connects an EA repository to the infoportal and then migrates the database data? 


Answer

The InfoPortal will not be able to properly evaluate its own permissions on packages.
A new button has been added to repository editing that will reset all permission settings on packages and resolve the repository migration issue.

Why can't LDAP login/logout?

question_mark_1.png

Question

Why can't LDAP login/logout?


Answer

Since version 8.0.1.x, we have normalized Windows Authentication to .Net 6 libraries.
Windows user who is not in LDAP will not be able to log in. Only users authenticated against LDAP and without the ability to log out will automatically log in.
For non-LDAP login, the administrator will need to set the AutomaticLogin entry in the LDAP section of appsettings.json to false and restart Infoport. This will remove the automatic login option, but the Login Page will be able to authenticate a user who is not in LDAP, but only in the database.

What should I do if I have collations inconsistency in my database (MySQL)?


question_mark_1.png

Question

What should I do if I have collations inconsistency in my database (MySQL)?


Answer

The following applies only to MySQL :
 
As of version 8.2, schema collation must be consistent with the collation of individual tables and columns or Infoport will not allow migration. The database admin must unify the collation on the schema. 

To display collation on columns, use query:

SELECT DISTINCT COLLATION_NAME 

FROM information_schema.columns 

 

WHERE TABLE_SCHEMA = 'schemaName'AND TABLE_NAME <>  '__EfMigrationsHistory' AND COLLATION_NAME IS NOT null 


To display collation on tables, use query:  

SELECT DISTINCT TABLE_COLLATION 

FROM information_schema.`TABLES` 

 

WHERE TABLE_SCHEMA = 'schemaName AND TABLE_NAME <>  '__EfMigrationsHistory'


To display the collation on the diagram, use query:

SELECT TABLE_NAME, COLUMN_NAME, COLLATION_NAME 

FROM information_schema.columns 

WHERE TABLE_SCHEMA = 'schemaName' 

  AND COLLATION_NAME IS NOT NULL 

  AND TABLE_NAME <>  '__EfMigrationsHistory' 

GROUP BY TABLE_NAME, COLUMN_NAME, COLLATION_NAME 

 

Please reunite the collation and restart Infoport.

 

You can use the following scripts for unification: 

For each table:

SELECT CONCAT('ALTER TABLE `', TABLE_NAME,  
'` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;')  
AS 'USE `DATABASE_NAME`;'  
FROM INFORMATION_SCHEMA.TABLES  
WHERE TABLE_SCHEMA = 'DATABASE_NAME'  
AND TABLE_TYPE LIKE 'BASE TABLE' 

For each column:

SELECT CONCAT('ALTER TABLE `', TABLE_NAME, '` MODIFY COLUMN `', COLUMN_NAME,'` ',  
DATA_TYPE, IF(CHARACTER_MAXIMUM_LENGTH IS NULL  
OR DATA_TYPE LIKE 'longtext', '', CONCAT('(', CHARACTER_MAXIMUM_LENGTH,  
')')  
), ' COLLATE utf8mb4_unicode_ci;') AS 'USE `DATABASE_NAME`;'  
FROM INFORMATION_SCHEMA.COLUMNS  
WHERE TABLE_SCHEMA = 'DATABASE_NAME'  
AND (SELECT INFORMATION_SCHEMA.TABLES.TABLE_TYPE  
FROM INFORMATION_SCHEMA.TABLES  
WHERE INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA =  
INFORMATION_SCHEMA.COLUMNS.TABLE_SCHEMA  
AND INFORMATION_SCHEMA.TABLES.TABLE_NAME =  
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME  
LIMIT 1) LIKE 'BASE TABLE'  
AND DATA_TYPE IN ( 'char', 'varchar' ) /* include other types if necessary */ 

 

Please contact the helpdesk for more information https://www.dphelpdesk.cz/

What is the required EA schema to connect EA repository?

image-1670942005795.png

Question:

What is the required EA schema to connect EA repository?

Answer:

MySQL database server with a schema of at least EASchema_1220_MySQL.sql, our recommendation EASchema_1558_MySQL.sql. (Note: EASchema_851_MySQL.sql does not work).

Version 8.4.0.12 - Access to views

In version 8.4.0.12, a new permission for views (Views) is added. For users/groups with permissions on the tree, you must also add permissions on views, otherwise the view will not be displayed.

Version 8.4.1.1 there is no need to add settings. A user authorized to the repositories tree also has access to views.

image-1678266807467.png

Admin does not have automatic access to repositories

Question

Since version 8.5.0.8563 admin can't get into the repositories?