Admin rights lost after 7.0 was installed

[Robert_K.]

Hello,

I work with Oracle 9i repository, EA corporate edition, user security enabled (required lock to edit mode).
I have the login as admin, with all privileges enabled. Using version 6.5 I'm able to manage users, groups etc. but after I had installed version 7.0.813 - all the privileges disappeared (I haven't enabled the auditing functionality yet). I can login using the same login/pass, but all the privileges I had - do not work any more. Even locking/unlocking model elements became disabled for me. What happened What I did wrong? Please help...

Best Regards, Robert.

[«Midnight»]

No ideas Robert,

This is a potentially dangerous problem, depending on how your organization handles distributed projects.

Please report this to Sparx directly, as it needs attention.

You can do this by clicking Support at the top of any forum page, then following the Bug Report link in the left side margin. You can also do this from the EA main menu via Help | On-line Resources | Bug Report Page.

Please post back to this thread with any response you get from Sparx.

David

[Robert_K.]

Thanks for the fast answer Midnight, but before I'll submit a bug I would like to clarify one thing which may be the reason of this problem - what exactly means database version in the window "About EA"?
I have there database version 4.1 dated to JAN-31-2004, but in the help file for EA ver. 7.0 I found screenshot with database version 7.0. Maybe my database structure is obsolete?
I looked into resources on Sparx web page, and the DDL for Oracle database provided there (http://www.sparxsystems.com/securedownloads/corp/Oracle_BaseModel.sql) is without any version inside, but it contains a date "12/03/2003"). So I'm completely confused.

[«Midnight»]

You're in good shape Robert,

The database version you quote (4.1) seems to be the first EA version to use the current schema. There have only been minor changes since, and data types etc. have remained compatible. If you installed EA 7.0 you should be fine. If the projects you are having trouble with date from any 6.x version of EA (and probably from any 5.x as well) this still holds true.

AFAIK the only 'breaking' change in 7.0 was the audit trail, and that only applies when auditing is enabled - at least that was the most recent I've heard from Sparx (dating back to build 810).

As to the Oracle schema, my guess is that the date you see is likely the original release date of the schema. There doesn't seem to be a detailed change history, so the date has not evolved to reflect recent changes.

Download the most recent version from the Resources page on the Sparx site just to be sure. It is most likely the same as the one you have.

The Oracle schema is designed to work with version 9i and 10g. There was a tweak some time back to handle a rare problem with one Oracle 10 data type, but I don't think this affected EA models themselves.

I have not yet heard from anyone (Sparx or others) about whether the EA schema works with just-released Oracle 11g engine. Nor have I yet had a chance to try it out.

David

[Robert_K.]

In the meantime build 814 was released. I checked it and it still doesn't work.
So the bug is already submitted and I'm waiting now for the answer.

[«Midnight»]

I think this build (814) was already being packaged when we had the discussion. We'll hope that: Sparx can return to their old 2-week build interval, and that the correction appears in 815.

Thanks for sticking with this to verify things.

David

[Robert_K.]

Well... Sparx hasn't answered yet...

[Eve]

I believe this issue should be fixed in build 815.  Robert, I'm not sure if your email has been lost somewhere or if it just hasn't been answered for some reason.

I would recommend sending in another email requesting a confirmation.  If you're in the situation I believe your regional settings will have a comma (,) for the decimal point.  (In addition to using oracle with security enabled as you specified.)

If this isn't the case, then you definately need to chase the issue up further because it is unlikely that we know about it.

[Robert_K.]

Thanks simonm.

I changed my regional settings to some with dot as a decimal separator - and it helped! (yes, I had a comma there)
It is a strange bug, for the first sight decimal separator has no connection to user privileges - at least for me. I would never guess that the reason may be numbers representation

Concerning lack of the answer from Sparx - I submitted this bug once again, with detailed description and ever screenshots, hoping Sparx will notice that...

Thanks once again!

[Geert Bellekens]

I had a similar problem with the Oracle (10g) repository.
Whenever deleting something from an activity diagram I got an error: "missing expression: SQL = Delete t_connection where ConnectorID in (153,,654)"
That was also related to the local settings. After changing the decimal sign to point (.) it was fine.
I just installed build 815 and it is fixed there. I know can delete anything with my usual local setting. (decimal sign: comma (,))