Author Topic: Errors during project transfer  (Read 5224 times)

ccastelein

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Errors during project transfer
« on: May 17, 2021, 04:22:37 pm »
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

  • EA Guru
  • *****
  • Posts: 12250
  • Karma: +484/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Errors during project transfer
« Reply #1 on: May 17, 2021, 04:49:40 pm »
First thing to try in these cases is the project integrity check.
That usually solves a lot of these type of issues.

Geert

ccastelein

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Errors during project transfer
« Reply #2 on: May 17, 2021, 06:47:29 pm »
@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

  • EA Guru
  • *****
  • Posts: 13067
  • Karma: +376/-298
  • I'm no guru at all
    • View Profile
Re: Errors during project transfer
« Reply #3 on: May 17, 2021, 08:09:34 pm »
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

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Errors during project transfer
« Reply #4 on: May 17, 2021, 09:19:54 pm »
@Q, thx for your suggestion. I have dropped them an email, hoping for swift feedback...

ccastelein

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Errors during project transfer
« Reply #5 on: June 24, 2021, 09:29:21 pm »
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

  • EA Guru
  • *****
  • Posts: 12250
  • Karma: +484/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Errors during project transfer
« Reply #6 on: June 24, 2021, 09:58:38 pm »
I guess that info should be somewhere in the database error logs as well.

Geert

ccastelein

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Errors during project transfer
« Reply #7 on: June 24, 2021, 11:08:57 pm »
@Geert, probably, but I only had access to the migration log, which didn't reveal this info...

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 12250
  • Karma: +484/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Errors during project transfer
« Reply #8 on: June 24, 2021, 11:28:12 pm »
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

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Errors during project transfer
« Reply #9 on: June 24, 2021, 11:33:53 pm »
@Geert, definitely away from Oracle (to Azure), performance on Oracle was indeed horrible...  Only opening a diagram is multiple times faster...

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 12250
  • Karma: +484/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Errors during project transfer
« Reply #10 on: June 24, 2021, 11:59:45 pm »
@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

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Errors during project transfer
« Reply #11 on: June 29, 2021, 01:30:27 am »
@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

  • EA Guru
  • *****
  • Posts: 12250
  • Karma: +484/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Errors during project transfer
« Reply #12 on: June 29, 2021, 01:57:04 am »
@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