Topics
Prev Next

Repository

This topic provides answers for questions that often arise when installing and maintaining Enterprise Architect's model repositories.

Question

Answer

See also

How do I correct the error when opening MySQL repository - "Row cannot be located for updating. Some values may have been changed since it was last read"?

This error can occur due to incorrect configuration of the MySQL ODBC Driver. Please confirm that your MySQL Driver is configured as described in the Set up a MySQL ODBC Driver Help topic. In particular, ensure you have set the options as described in step 7.

Set up a MySQL ODBC Driver

Are there limits to the Project Size of Enterprise Architect .eap and .eapx files?

The file format for .eap files is MS Jet 3.5, and for .eapx files is MS Jet 4.0. This format, although very efficient for small repositories and a small group of users, can create problems for larger repositories above 40 megabytes or user groups above 5 simultaneous users.

For more details see page 4 of the Deployment of Enterprise Architect white paper.

Deployment of Enterprise Architect

Are there limits to the project size of an Enterprise Architect DBMS repository?

The maximum size of an Enterprise Architect DBMS repository has yet to be reached by any of our users. The repository size is only limited by the general specification for each of the DBMS vendors.

What DBMS can I use for a repository?

Enterprise Architect projects are stored in a database. Enterprise Architect supports a range of DBMS products for storing model repositories.

The range of supported DBMSs is listed on the System Requirements web page.

Note: working with a DBMS repository requires the Enterprise Architect Corporate Edition or higher.

Enterprise Architect System Requirements webpage

"Unrecognized database format" - How do I correct a corrupted .EAP file?

On rare occasions usually caused by network or PC outages, a .EAP file can become corrupted and cannot be opened, typically returning the error 'Unrecognized database format'. You usually fix this by running the 'Repair a Project' command on the file. For further details, see the Repair a Project Help topic.

If the 'repair' does not help, compacting the database can sometimes resolve corruption. For details see the Compact a Project Help topic.

Repair a Project Compact a Project

Can I view more information regarding items in the Project Integrity Check?

It is not possible to view more information regarding the integrity check items. The Integrity Check finds corrupted records in the project's underlying database. Generally these types of issue should always be 'Cleaned', regardless of which elements, Packages or database tables they are related to.

We recommend making a backup of your project, then using the 'Recover/Clean' option to clean all issues. As mentioned in the Check Project Data Integrity Help topic, when Enterprise Architect 'cleans' the model, it attempts to recover lost Packages and elements and generates a new Package at the model root level called '_recovered_'. Check through any elements that are found and, if required, drag them into the model proper. If they are not required, delete them.

Check Project Data Integrity

What are the hardware specifications for DBMS's?

Each scenario can have vastly different usage of Enterprise Architect features, which means there can be different emphasis on the use of tables in the repository. As such we can only provide a broad setup procedure for your preferred DBMS. For hardware specifications you will need to check with the vendor of the DBMS that you intend to use.

Server Based Repositories

Where can I find the repository table names for a SQL Model Search?

When using SQL Model Searches you need access to the details on the table structures and table names used in the repository,  there is broad documentation of the Database in the 'Automation' Help pages, with reference to the table names associated with each of the Classes.  See the Automation Help topic.

Also see the general pages (... Package) for diagrams and (...Class) pages for functions and attributes under the Automation Reference Help topic.

The (...Class) pages contain the table names - see 'Associated table in .EAP file' at the head of each page.

For example, see the diagram under the Element Package Help topic and 'Associated table in .EAP file' details in the Element Class Help topic.

In a repository the t_snapshot is becoming quite large. Is this normal and should it be purged ?

The t_snapshot table is used for storing Auditing data. We recommend you regularly save your audit logs to an external file, and then clear the logs from the repository. If you are using a .eap file, we recommend that you also perform a compact operation after clearing the logs.

For instructions on how to Save Logs and Clear Logs, refer to the Auditing Settings Help topic.

Auditing Performance Issues Auditing Settings