Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: Multiple user access on 10.4
Topic Summary:
Created On: 4-Oct-2006 20:26
Status: Read Only
Linear : Threading : Single : Branch
1 2 Next Last unread
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 4-Oct-2006 20:26
User is offline View Users Profile Print this message


Kevin Jones

Posts: 8
Joined: 28-Sep-2006

I am new to SA and we are have created a catalog and attached an enterprise encyclopedia that is available to everyone.  I have gotten into catalog manager and setup user access (admin priveledges to 1 person other than me).  When my co-worker opens SA, the encyclopedia that I created is not listed in the existing list for her.


Does anyone have any ideas?

Report this to a Moderator Report this to a Moderator
 5-Oct-2006 13:10
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

1. Check that the user is looking at the correct SQL server
2. Check that the user has the appropriate SQL Server permissions

I'm not quite sure what you mean about 'admin privileges' - 
  Do you mean the encyclopedia is associated with the 'Everyone' group and that has the Admin role?
or
  Have you only set the User's catalog access permissions.

Thanks
Ian



-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 9-Oct-2006 02:36
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

When your co-worker first opens System Architect, the catalog will not show up because she has not linked to it via the .UDL file. Existing can be defined as:

Encyclopedia names existing within a list in the computer's registry which you have previously linked to. The dialog box that opens does not go looking for a list of encyclopedias from the server. What you have to do is link to the encyclopedia as a New encycopedia through the New tab. It will either then created the .UDL file necessary or say "Oh it exists!" and link to it anyway.

Hope this helps.
Report this to a Moderator Report this to a Moderator
 9-Oct-2006 09:48
User is offline View Users Profile Print this message


SA Team

Posts: 4
Joined: 6-Oct-2006

Have you added a user to the catalog for your co-worker (the one trying to open the encyclopedia)? Once done you should find there name listed under the 'Everyone' groups 'Users & Groups' node. The encyclopedia should now be visible to them in the open encyclopedia dialog, assuming they have the appropriate priviliges on SQL Server or MSDE instance.

-------------------------


Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 9-Oct-2006 18:56
User is offline View Users Profile Print this message


Kevin Jones

Posts: 8
Joined: 28-Sep-2006

yes to 1 and 2

I set the user up with an admin role for that encyclopedia.

Report this to a Moderator Report this to a Moderator
 9-Oct-2006 19:05
User is offline View Users Profile Print this message


Kevin Jones

Posts: 8
Joined: 28-Sep-2006

Ok, we did the link to New encyclopedia and it said that one by that name already exists.  Thanks Duane! 

Now I have another problem.....

I get the following error message when trying to open the 10.4.18 encyclopedia from 10.4.18:

The selected encyclopedia could not be opened because inconsistencies were found in the structure of the database.  Please see the log report for details.

The log report shows errors like this:

<Entity> Table <Audit> Column <Identity> Property is invalid, value <T> should be <F>
<Entity> Table <Class> Column <Identity> Property is invalid, value <T> should be <F>
<Entity> Table <FromArrow> Column <Identity> Property is invalid, value <T> should be <F>

Report this to a Moderator Report this to a Moderator
 10-Oct-2006 10:24
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Which version of SQL Server are you using for your client and server?
We are aware that encyclopedias fail schema checks if SQL 2005 is used.

SA currently only supports SQL Server 2000.

If you have verified that you are using SQL Server 2000 for your catalog and encyclopedias, and are still having problems, I suggest you contact support, who will be able to assist further.

Thanks
Ian



-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 10-Oct-2006 16:21
User is offline View Users Profile Print this message


Kevin Jones

Posts: 8
Joined: 28-Sep-2006

We are using SQL Server 2000.  I will contact support.  Thanks
Report this to a Moderator Report this to a Moderator
 11-Oct-2006 11:06
User is offline View Users Profile Print this message


John Crouchley

Posts: 4
Joined: 6-Sep-2005

Here is a comment from one of our developers:

I've not seen schema checker errors like these before.  My first guess is that MDAC is not properly installed or the wrong version of MDAC is installed.
Report this to a Moderator Report this to a Moderator
 11-Oct-2006 19:58
User is offline View Users Profile Print this message


Kevin Jones

Posts: 8
Joined: 28-Sep-2006

What version of MDAC is recommended?
Report this to a Moderator Report this to a Moderator
 12-Oct-2006 12:26
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Developer comment :-
Best to install the latest which I believe is 2.8 SP1.

http://www.microsoft.com/downloads/details.aspx?familyid=78CAC895-EFC2-4F8E-A9E0-3A1AFBD5922E&displaylang=en

Note - you would need to create the encyclopedia again to ensure it was correctly created, as it may have been the create which was bad.



-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 12-Oct-2006 14:44
User is offline View Users Profile Print this message


Kevin Jones

Posts: 8
Joined: 28-Sep-2006

Will do, thanks!
Report this to a Moderator Report this to a Moderator
 13-Oct-2006 14:27
User is offline View Users Profile Print this message


Kevin Jones

Posts: 8
Joined: 28-Sep-2006

Ok, SQL Server is using MDAC 2.8 RTM, My machine has 2.8 RTM (can't go to 2.81 because we don't have XP SP2 installed).

Created a new encyclopedia, opened fine for me.  Closed System Architect and went home.  Opened it again today and I get the following error:

"The selected encyclopedia could not be opened because inconsistencies were found in the structure of the database.  Please see the log report for details."

I am the only person that opened this encyclopedia and I have not added anything to it (fortunately).

Report this to a Moderator Report this to a Moderator
 16-Oct-2006 10:26
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Hi

This is not an issue we have seen before, and to my knowledge not one which has been reported to support before. It may be some other installation issue?

I think the best way to proceed would be to log an incident with support, describing the issues you are seeing. They will need version numbers for Windows, SA, the MDAC controls etc.

If they are unable to find an issue with the install, it will be escalated promptly.

Thanks
Ian


-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 16-Oct-2006 15:17
User is offline View Users Profile Print this message


Kevin Jones

Posts: 8
Joined: 28-Sep-2006

I have logged it with support.
Report this to a Moderator Report this to a Moderator
 24-Oct-2006 19:40
User is offline View Users Profile Print this message


Doug Garbarino

Posts: 13
Joined: 30-Aug-2005

Kevin, I have also seen this problem pop up recently after upgrading to SA 10.4 and converting my encyclopedias. This error message has only appeared in a couple of our encyclopedias. I have not logged anything with support. When you receive an answer from support can you please post it. Thanks, Doug
Report this to a Moderator Report this to a Moderator
 9-Nov-2006 21:27
User is offline View Users Profile Print this message


Margot DeLapp

Posts: 4
Joined: 9-Nov-2005

We are also having this problem, intermittently and randomly.  It started with the upgrade to v10.4.  We each using MSDE on our workstations.  Given the same backup file (or mdf - it happens with detaching/attaching also), some users can open the encyclopedia, while others get the error message "The selected encyclopedia could not be opened because inconsistencies were found in the structure of the database.  Please see the log report for details."  We have worked around it by giving each other access to still-working encyclopedias in each other's MSDE SQL server, but we are worried that at any moment we will not be able to access our master encyclopedia.

Today I uninstalled 10.4.18 and then installed 10.4.23.  Of the five encyclopedias in my local MSDE server, I now can open only two of them.  I did nothing to the encyclopedias in between.  I tried restoring from my backups and I still get the error above.  I've been unable to locate a relevant "log report" on my or any other user's machine.  My sa2001.log file shows only e.g. "User logging in" and "Terminating System Architect."

Another user whom I upgraded to 10.4.23 today had been unable to open a particular encyclopedia in 10.4.18, now magically with 10.4.23 she can open that encyclopedia, but cannot open others instead.

This is Not Good.

Report this to a Moderator Report this to a Moderator
 10-Nov-2006 09:50
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Hi Kevin

Development has looked further into the issue you describe, and we have found a set of rights in SQL server which will cause the exact error message you have seen.

EXEC rights on all SA sprocs
S
ELECT rights on all SA tables (note the user doesn't have INSERT, UPDATE, or DELETE rights)

Errors produced when trying to open the encyclopedia:

'Entity' Table 'Audit' Column 'Identity' Property is invalid, value 'T' should be 'F'
'Entity' Table 'Class' Column 'Identity' Property is invalid, value 'T' should be 'F'
'Entity' Table 'FromArrow' Column 'Identity' Property is invalid, value 'T' should be 'F'
'Entity' Table 'FromAssc' Column 'Identity' Property is invalid, value 'T' should be 'F'

If we grant the user SELECT, INSERT, UPDATE, and DELETE rights then the encyclopedia can be opened without error.

Please can you check the rights you have assigned to the users on your database.


-------------------------

Senior Software Developer
Telelogic UK Ltd.

Edited: 10-Nov-2006 at 09:52 by SA Team
Report this to a Moderator Report this to a Moderator
 10-Nov-2006 09:54
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Margot> If you have not done so already, please could you log this issue with support - in order to enable us to contact you directly. If you have logged a support issue, please can you reply with the case ID so I can take a closer look.

Thanks
Ian

-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 10-Nov-2006 18:23
User is offline View Users Profile Print this message


Margot DeLapp

Posts: 4
Joined: 9-Nov-2005

Ian - Case ID is 7011875.  Thanks!
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.