Errors during project transfer

[ccastelein]

Hello,

we are planning to move our EA database and while performing dry-runs (both DBMS => DBMS and DBMS => file), we get a bunch of errors. These actually came down to 5 types of errors. 1 of these, we were able to fix the issue at the target.

We would like to have a clue on the impact of the error (can we safely ignore it?) and on potential fixes we should perform on the source or target project.

Below you find the errors:

* ERROR: *** t_stereotypes - record no: 47 Key: stereotype=MetaModel appliesto=class (1 occurence)
* ERROR: *** t_snapshot - record no: 550159 Key: snapshotid=L549598 (18.696 occurences)
* ERROR: *** t_taggedvalue - record no: 1 Key: propertyid={1AEB55C9-6D9A-4be5-8B77-4702645C4E79} (31 occurences)
* ERROR: *** t_template - record no: 1 Key: templateid={ABC41C05-B812-4e9d-9AC5-79F8AABC5089} (1 occurence)

The below errors were solved by enabling security at the target project (security was enabled at source but was disabled at target)
  ERROR: *** t_secpolicies - record no: 1 Key: property=WindowsAuthentication
  ERROR: *** t_secpolicies - record no: 2 Key: property=WindowsAuthenticationCheckSum
  ERROR: *** t_secpolicies - record no: 3 Key: property=ADLink{500F4DBA-33F1-435b-8566-4FA29F1C3CB9}
  ERROR: *** t_secpolicies - record no: 4 Key: property=ADLink{59604DD7-930E-4083-A59C-6C2F0E4A0D4F}
  ERROR: *** t_secpolicies - record no: 5 Key: property=UserSecurity
  ERROR: *** t_secpolicies - record no: 6 Key: property=ADLink{9DAB7737-DEE8-4433-9862-B77B1A965DCE}
  ERROR: *** t_secpolicies - record no: 7 Key: property=AutoCreateOrModifyUsers

Thanks for your feedback!

[Geert Bellekens]

First thing to try in these cases is the project integrity check.
That usually solves a lot of these type of issues.

Geert

[ccastelein]

@Geert, thanks for your feedback. I forgot to mention that we did run an integrity check, which results in a clean sheet...

Adding below also some version info if this might be helpfull..

Our current version is 15.2.1554 (build:1554).
Repository information: OLEDB - Oracle -- Database Version 7.0 -- Version date: Jan-31-2004

[qwerty]

Besides the fact that Oracle has proven to be the worst choice for EA use I'd recommend to mail Sparx support with that issue.

q.

[ccastelein]

@Q, thx for your suggestion. I have dropped them an email, hoping for swift feedback...

[ccastelein]

In the end we were able to found out the root cause of the problem, being the SQL database that was provisioned fixed size, without autogrow and of course, insufficient space for the amount of data in the soure repository.

Unfortunattaly, the GUI doesn't reveal this real root cause, I actually did discover it by accident while trying to connect and getting a message indicating "The database [] reached its size quota...". After fixing that, the migration went fine.

[Geert Bellekens]

I guess that info should be somewhere in the database error logs as well.

Geert

[ccastelein]

@Geert, probably, but I only had access to the migration log, which didn't reveal this info...

[Geert Bellekens]

I hope you are moving from Oracle to something else and not the other way around?

EA works really really bad (slow) on Oracle databases, even on the most high end servers tuned by highly paid specialists.

Geert

[ccastelein]

@Geert, definitely away from Oracle (to Azure), performance on Oracle was indeed horrible...  Only opening a diagram is multiple times faster...

[Geert Bellekens]

@Geert, definitely away from Oracle (to Azure), performance on Oracle was indeed horrible...  Only opening a diagram is multiple times faster...

Good to know . We have both the database (SQL server) as the client running on Azure (through WVD), and we are pretty happy with that setup.

Geert

[ccastelein]

@Geert, do you have any recommendation on the type of resource for SAL Azure? In a blogpost dating from 2016, the recommendation was S1 (https://community.sparxsystems.com/tutorials/938-define-a-shared-sparxsystems-enterprise-architect-project-in-microsoft-azure-sql-database-cloud.

[Geert Bellekens]

@Geert, do you have any recommendation on the type of resource for SAL Azure? In a blogpost dating from 2016, the recommendation was S1 (https://community.sparxsystems.com/tutorials/938-define-a-shared-sparxsystems-enterprise-architect-project-in-microsoft-azure-sql-database-cloud.

I'm not too much involved in those details. I know that we opted for two VM's. One to run the EA client over WVD, and another to run the SQL server.

Geert