Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - ngong

Pages: [1] 2 3 ... 8
General Board / Re: History of lock/unlock
« on: September 06, 2018, 05:41:23 pm »
Thank you for that question, Peter.

Yes, we were used to PTC together with JET engine. But we noticed failures at the interface to PTC - especially 'Get All Latest'. I tried hard to find a solution and/or suitable help for that problem - without success. In order not to let the projects suffer, I gave up.

We switched to SQL Server. No longer using PTC on a per package base. However, in the course of ASpice and ISO26262 we need at least a history of the relationship of change requests and actual changes. Logging that information at lock time seems to me the easiest solution.

I would refuse to re-investigate the PTC per-package trial, as I do not have found the reason for that problems. For getting help, I would have to provide an example model exposing the problem. The one showing the failure is confidential. Trying to create one, I was not successful, yet.

Our experiences using SQL Server for EA in a multi-user environment are very positive. Our work is now more content focused, than on operating the tool. No more "memory overflow", "DAO failure" or "corrupted database" (at least until now). There is no way back for us. JET engine seems to be sufficient for single-user EA work with an ever growing model, not changed much in existing parts - as I did for more than decade.

General Board / Re: empty t_seclocks.EntityIF, what to do about it?
« on: August 23, 2018, 04:56:37 pm »
Hi, qwerty: I forgot, I ran consistency check and it led to "No Problem".

General Board / empty t_seclocks.EntityIF, what to do about it?
« on: August 23, 2018, 06:22:33 am »
Switched from .eap-files to SQL Server based storage of EA model.
Transfer to .eap-file worked fine till today.

I got the message: "An error has occurred: DAO.Recordset  [3314], The field 't_seclocks.EntityID' can't contain a Null value because the Required property for this field is set to True. Enter a value in this field. [Select * from t_seclocks], Field: locktype. Press OK to continue to next row (this record will be lost). Cancel to abort

Ok, I entered the SQL query and got 5 lines as a result. In one of them the field below the column heading EntiyID is empty. Guess that causes the problem. (I do not know how it got there, I was using EA heavily, but interactivily only.)

What shall I do about it? Transfer the result back, so that that record disappears from table t_seclocks? What will be the consequences?

General Board / EA14 and non-modal windows
« on: August 10, 2018, 12:14:20 am »
I love to work with non-modal windows, e.g. Features & Properties in EA14. There too many modal windows in earlier versions.

However, I ran in to a situation where the attributes of any data type or enumerations are not shown. Restarting, even rebooting Win10 did not solve the problem. The attributes are still there, I can see them in the project browser.

Do you got any idea what I missed?

Meanwhile I switched back to modal windwos and EA13.5 - there I can do with the attributes what I like to do.

General Board / Re: History of lock/unlock
« on: August 09, 2018, 11:43:24 pm »
Thank you Sunshine and Geert for your contribution.

All these are no good news to me.

Reviews and Discussions are techniques for manually enhancing quality and creativity - they would need high discipline in an ever changing team and hard to automate formal reviews in order to link change requests to actual changes.

Audits are too late for that purpose.

Baselines are also a bit late. I am thinking about proprietarily comparing baselines - based on project specific SW architecture profile - and group the list of differences by authors. Then ask the authors to apply CRs to their group. A bit late. Doing it just prior to a session creating a set of changes would be much better, that is at lock-time.

Geert, I got to thank you for that warning. However - does not make my problem smaler.

General Board / Re: Project Integrity Check
« on: August 09, 2018, 10:10:27 pm »
jepp - thank you all - worked fine

I did not understrand the problem - some LLEA... profile was in the way with an element called t_document - I never heard of before - but that is gone now and the entire model is ok (checked with LemmonTree against an older version).

Hence, seems not to be a bug to be reported to Sparx.

General Board / Project Integrity Check
« on: August 08, 2018, 03:28:20 am »
When I do a Project Integrity Check, I got one issue: The top-most package, the model itself, is flagged as "Orphaned object" and the check proposes the action "Delete Package Object". Obviously I do not follow that recommendation.

How to get a clean integrity check?

General Board / Re: History of lock/unlock
« on: August 08, 2018, 03:20:45 am »
Thank you Geert

why do you think programming those triggers would not be a good idea?

Such a trigger could ask the user about a Change Request ID - supporting reviews as well as quality and safety assessments.

I can close EA and get back in and still see whether a package or diagram is locked. That is why I think that information is stored somewhere in the database. If it is in the DB a trigger should be possible. Would be good using EA API for that. If API does not allow to register callbacks on lock/release-lock event, it should be possible on DB level (though I am completely blind in how to do triggers for SQL Server).

General Board / Re: unable to configure package
« on: August 06, 2018, 08:24:35 pm »
Ok, thank you Peter. Reading that it was so simple: I first have to get a lock, as I have put the whole model under "Require User Lock to Edit".

General Board / History of lock/unlock
« on: August 06, 2018, 08:19:54 pm »
For an SQL Server based EA model I enabled security with "Require User Lock to Edit".

Would it be possible to record all locks and lock releases together with the users issuing that function?

General Board / unable to configure package
« on: August 06, 2018, 07:55:04 pm »
I switched from .eap-file based model to SQL-Server based.
I enabled security and entered 2 groups: Administers and Designers.
As an Administer admin I got all securities.
However, when I right-click a package and select "Package Control/Configure" I get the information: "The current action cannot be completed as the necessary security is not available".

How can I configure a package in this case?

General Board / What about API support for Java 9+ and 64-bit systems?
« on: August 06, 2018, 12:59:49 am »
Oracle seems to be of no-compromise when it comes to switch to Java-11 and 64-Bit systems from 2019 on.
If SSJavaCOM.dll is as simple as stated, would that be a big issue?
Also having the Java_Sample ready would save a lot of learning time, nowadays using Eclipse Photon on Java-10

General Board / Re: Missing Cross References
« on: August 01, 2018, 05:23:50 pm »
This is still true for EA14.
If you ignore those messages it is likely that you violate your model - silently. You may notice only after printout or so.
One cause is that "Get All Latest" - for any reason - is not able to satisfy all inter-package references of controlled packages in all cases. I have not found out yet, in what cases external references get lost. It is seldom the case, but if I got it, I did not find a way to repair the situation. (Checking "For all packages, create placeholders for external references" is mandatory but does not hinder missing references.)
To be on the safe site in professional projects producing production software you may consider not using EA integration of Version Control at all. Define your own - tested - XMI based process.

General Board / automatic XMI export
« on: August 01, 2018, 05:05:53 pm »
Do you know a way to automatically export an EA model to its XMI representation?

I was able to identify only procedures which need manual interaction. What I am looking for is a command line in a Win batch file that I can start on a regular basis.

General Board / Re: SQL failure message after "Get All Latest"
« on: June 28, 2018, 09:32:11 pm »
Thank you, Geert.

I'll stay away from MariaDB in favor of SQL Server (or ... Express). For the same .eap file it worked without such messages.
Seems that EA is tested mainly for MS interfaces.

Pages: [1] 2 3 ... 8