![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: Multiple user access on 10.4 Topic Summary: Created On: 4-Oct-2006 20:26 Status: Read Only |
Linear : Threading : Single : Branch |
|
![]() |
![]()
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
1. Check that the user is looking at the correct SQL server I'm not quite sure what you mean about 'admin privileges' - Thanks ------------------------- Senior Software Developer Telelogic UK Ltd. |
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
yes to 1 and 2 I set the user up with an admin role for that encyclopedia. |
|
![]() |
|
![]() |
|
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> |
|
![]() |
|
![]() |
|
Which version of SQL Server are you using for your client and server? ------------------------- Senior Software Developer Telelogic UK Ltd. |
|
![]() |
|
![]() |
|
We are using SQL Server 2000. I will contact support. Thanks
|
|
![]() |
|
![]() |
|
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.
|
|
![]() |
|
![]() |
|
What version of MDAC is recommended?
|
|
![]() |
|
![]() |
|
Developer comment :- 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. |
|
![]() |
|
![]() |
|
Will do, thanks!
|
|
![]() |
|
![]() |
|
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). |
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
I have logged it with support.
|
|
![]() |
|
![]() |
|
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
|
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
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 SELECT 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 |
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
Ian - Case ID is 7011875. Thanks!
|
|
![]() |
|
Telelogic System Architect
» System Architect - General Discussion
»
Multiple user access on 10.4
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.