Solved

User showing up in a role - but not in that role

Posted on 2003-11-24
41
473 Views
Last Modified: 2013-12-18
I have in my ACL a group named Sales People - the group has the role Sales assigned to it.
In the Address Book there is a group Names Sales People.

John Smith was in the Sales People Group on the address book - so when he logged in uses the @ UserRoles function it stated -> Sales - That was correct.

He has been moved from Sales People to a differnt group.  His name does not show up in the Sales People group anywhere, but when he logs into the database it still says he has the role Sales - which is wrong now.

What could be wrong?  it seems like the group in the ACL is not seeing the changes in the address book?
0
Comment
Question by:Jaziar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 17
  • 14
  • 5
  • +1
41 Comments
 
LVL 24

Assisted Solution

by:HemanthaKumar
HemanthaKumar earned 160 total points
ID: 9810707
After you change the group members.. Either wait for all the Domino Directories to replicate or force replication on all servers. Then the changes will reflect on all the database ACL's

~Hemanth
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9810719
Is this DB on Server or Local ?
0
 
LVL 13

Expert Comment

by:CRAK
ID: 9810994
Are you sure that this role isn't assigned to any other groups? It's quite easy to start assigning roles to "default" user....
Also note that after changing a group, it might take some time for the server to realize what's happened: the viweindex on ($ServerAccess) needs a refresh!
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Jaziar
ID: 9811520
The database is on a server - the mail address book with the group is on the same server.  The replication should have taken place last week.  I waited all weekend just to see if that was the problem.  No other groups are assigned to the sales role.  This is strange.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9811580
Try compacting the db, it can re-sync your acl.

Also as Crak mentioned run updall on names.nsf to rebuild indexes
0
 

Author Comment

by:Jaziar
ID: 9812414
Can't touch the names.nsf file - I will try to compact the database when everyone gets off the database.  Is the viweindex on ($ServerAccess) on the names.nsf or can I do this on my database.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9812456
$serveraccess view is on names.nsf file.

0
 

Author Comment

by:Jaziar
ID: 9812500
Something else that is happening that is strange -

I have a action button thats composes the form which has fields with @dblookups

example of each

@Command([Compose];"ECR Form 2")

@Name([CN];@DbLookup("":"NoCache";""; "(HiddenNewComp)"; ECPrinterAffected; "Username"))


I have 5 views to select with the action button on top of each

Any view that has a document listed in it, when I compose the form none of the @dblookups work -> server error

but if the view has no documents listed in it - the @dblookups work fine.

Strange
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9812603
Probably the view's first col is not in ascending/descending order...

Actually what did you do so that you see this symptom ?
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9812609
Or your view index would be corrupted !!!

Open to a view in your db and  Hit Ctrl+Shift+F9 to build index of all views
0
 

Author Comment

by:Jaziar
ID: 9813503
No Luck on the rebuilding the index of all views - It is almost like it is pulling up differnt forms - one way the form is expanded the other is not expanded - but it is the same form.  What would tell the form to expand in one view and not the other?
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9813658
What expand  ? View in a form ? I am not following..

Which is pulling diff form ?  you mean documents ?
0
 
LVL 31

Assisted Solution

by:qwaletee
qwaletee earned 160 total points
ID: 9815195
Use the shift-control trick to open the ($ServerACcess) view in names.nsf.  Then, press Shift-F( (NOT shift-control-F9) to discard and rebuild this one index.

Are there any other ACL entries with that role?  Hemantha asked this earlier, I don't see a response from you.
0
 

Author Comment

by:Jaziar
ID: 9817497
No that is the only group with the role assigned.

I have a controlled access section on the form - I would say about half of the form is in the section.  

If there is a document in the view, when I compose the form the section is not expanded and the @dblookups fail
If there is not a document in the view, when I compose the form the section is expanded and the @dblookups work.  This is the way it should work and has been for over 2 months.
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9818062
Need more details....

What is the EXACT structure of the view? Give us the select formula, a list of columns, their fields/formulas, and sort properties.  Give us the values displaying in the view when one doc is present (make all columns visible when you do this).

What is the exact DbLookup formula?  What is the text of the error?

Note: previous comment should have said SHIFT-F9; it said Shift-F.  Sorry.
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9818143
Something just dawned on me.  You are NOT saying that whether the DbLookups succeed depends on whether the LOOKUP view has documents in it.  You are saying that whether the DbLookup succeeds depends on whether the view that the USER CURENT SEES has documents in it.

That could explain a lot.

You are using a key value taht is obtained from the "current document" in your lookup:
@DbLookup("":"NoCache";""; "(HiddenNewComp)"; ECPrinterAffected; "Username")

FOr the key value, you are using the value of the field ECPrinterAffected.

If that DbLookup is in a view action, it will take the field from the highlighted document.  If the Dbookup is in a form, then several things can happen:

1) If the field exists on the form, and teh DbLookup is further down the form tahn the field's position, then it will take whatever value the field calculated to at load time.

2) If the form does not inherit, AND the field does not exist on the form (or it exists on the form, but the DbLookup is positioned ABOVE that field -- or the DbLookup is used in the default or value formula for that very fiel, ECPrinetrAffected), then the lookup key will be blank.

3) If the form DOES inherit, and the DbLookup is being calculated ABOVE ECPrinterAffected / or there is no ECPrinterAffected field / or the DbLookup is in the default/value formula for ECPrinterAffected ... then the key value will be an INHERITED value.

I think #3 is what is occuring.  Teh form inherits values, and the DbLookup is occuring when the form either does not calculate its own ECPrinterAffected value, or has not done so yet at the time of the Dbookup.  Therefore, it is using an inherited value from the highlighted document in the view.  (The same would apply within the view action).

Now, if there is no highlighted document, then there is no value to inherit, and thelookup key is blank.  If there is a doc, then it uses teh value from the doc.  If the doc has a value that can't be found in the lookup view, then the lookup fails.

Check it out, let me know.  Any easy way to check is to place the following above the DbLookup

@Prompt([ok]; "DbLookup key"; @Text(ECPrinterAffected));

You can also test the value of the Dbookup itself by assigning it to a variable, and using an @Prompt of @Text of the value (@Text is to allow you to dsplay any error value returned).
0
 
LVL 13

Expert Comment

by:CRAK
ID: 9818621
I already wondered.... Shift F ???
For a minute I thought you had an interesting feature there: deleting the index, leaving it to others to trigger re-indexing. That would be a neat....
;-))
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9819550
To solve this issue, Convert the lookup views to flat and not categorized.. I have seen this problem earlier in some versions..To be on safer side always make the lookup views flat one !
0
 

Author Comment

by:Jaziar
ID: 9857896
Had the viweindex on ($ServerAccess) refreshed on the names.nsf.  Still assigning the wrong roles to users.  Makes me think there is something wrong in the database and not the names.nsf
0
 

Author Comment

by:Jaziar
ID: 9857915
The Views are not categorized. I am increasing the points on this one.  I really need this resolved as soon as possible
0
 

Author Comment

by:Jaziar
ID: 9857928
I am also going to split the problem since they are two seperate issues.  The question on this is

If there is a document in the view when I click a Compose Form action button - none of the @Dblookups work
If there is not a document in the view when I click the compose form action button - Everything works fine
0
 

Author Comment

by:Jaziar
ID: 9858358
I have figured out what the problem is!!!!!!!!!  Now I just need to know how to fix it.  When I hit the Compose Form Action button in a view that has documents
it is selecting and composing the form of the document in the view instead of creating a new form.  sometimes there are some fields still have infomation in them, even though it is suppose to be a new document.  Is there a way not the select the form of the view?
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9858566
I believe it is your view Form Formula which will cause this disable it and see if that fixes the problem.
0
 

Author Comment

by:Jaziar
ID: 9868927
No clue what you are refering to?
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9868984
Jaziar,

You are sure that the user is not in any other groups ?

I believe you removed and re-added the db icon on the workspace !

Don't user form in the formula for compose eg:

Form := "TEST"; @Command([Compose]; Form)

Open the view in design and look for form formula section in the program pane.. Remove any formula and save the view and retest the compose button
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9872479
Jaziar,
> I have figured out what the problem is!!!!!!!!!  Now I just need to know how
> to fix it.  When I hit the Compose Form Action button in a view that has
> documents it is selecting and composing the form of the document in the view
> instead of creating a new form.  sometimes there are some fields still have
> infomation in them, even though it is suppose to be a new document.  Is there
> a way not the select the form of the view?

Do you mean, it is composing a new document, but using form "A" instead of form "B" (form A is the form of the currently highlighted document, form B is the expected form)?

Open the view in designer.  On teh lower left, you will see a section for each column, plus, at the top, a Globals section and a section for the view itself -- "view name (view)"

Scroll to the top, and exand on the (view) entry.  the first subsection is VIEW SELECTION.  The second subsection is FORM FORMULA.

The FORM FORMULA is used to override the "standard form, and is usually used to display an existing document using a different form. It can cause problems on create though.  First, try recording the existing formula, so that you can put it back later, and then delete the form formula.  Retsart Notes, and see if he problem goes away.

If it does, we have to decide whether to leave it off (which afects the display of existing documents in the view), or to modify it to work for ne documents without swapping out the form for them.

The technique for the latter can be quite simple.  Add a new line on top of the ld form formula,  Te new line says:

@If(@IsNewDoc;@Return(@UnAvailable); CONTINUE...);
0
 

Author Comment

by:Jaziar
ID: 9874350
I am sorry for being so confussing.  Let me try once again to explain what is happening.  I only have one form, lets call it "form a"

Here is the action button code for "Create ECR"

@Command([Compose];"ECR Form 2")

This button is in every view.

OK - now when I am sitting in a view that has no documents and click the action button "Create ECR"

Form A comes up and it is like a new document and everything works great.

If there is a document in the view, when I click "Create ECR"

Form A comes up with half the fields empty and some fields filled in with values from the document in the view.  It seems like it opens the document in the view and removes the values from most of the fields and leaves some.  But it is still the document from the view.  Instead of creating a new Form A document, it seems to be trying to edit an existing document.  Almost like it is doing a auto select.  what I want is anytime the action is clicked it creates a new document, regardless of what is in the views.  It used to work this way, I am not sure what has changed.

Hope this clears things up better.
0
 
LVL 13

Accepted Solution

by:
CRAK earned 180 total points
ID: 9874474
Sounds like its inheriting values. Have you tried switching off that form property, or do you actually need it? Otherwise you may need to adjust some formulas to:
@If( @IsNewdocument; ...; ...)
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9874730
crak is right .If some fields are populating because the form inheritance and field refering to self would enable it to select values from selected docs. If this was your intention then it is working as you designed. If not just disable the property inherit values from selected docs
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9895230
Yeesh, you guys are parroting what I said over a week earlier, not in so many words:

If that DbLookup is in a view action, it will take the field from the highlighted document.

Same, of course, applies to value on the form itself.
0
 

Author Comment

by:Jaziar
ID: 9905132
Ok - the form that is coming up wrong does have some fields inheriting values from a differnt wrong.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9905560
wrong document ??

Did you disable inherit option in the form property ?
0
 

Author Comment

by:Jaziar
ID: 9920057
OK That is the problem!!  

On form "A" after the document reaches a certain state you can click a action button to create a new document from form "B"  - Form "B" inherits a few fields from Form "A" on create - (So I need the Inherit properties on create on form "B" checked.)  But the problem is - you can also create a document on Form "B" without being in Form "A" - (*There is the problem*)  

Any Suggestions?
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9920649
If that is the case then

1. Disable the inherit option in form B
2. In form A when you want to compose document B then use script to create doc B and populate the values from doc A (simulating Inheritance)
3. Or Create one more copy of Form B (with inherit option disabled) and use that in view and other one in Form
0
 
LVL 13

Expert Comment

by:CRAK
ID: 9920884
>  But the problem is - you can also create a document on Form "B" without being in Form "A" - (*There is the problem*)  

So you don't want A to be created if B is selected....
Have you disabled "Include in menu" (form properties) so you can only use a button to create a new document?
Use a formula like this in that button:
@If(
   Form="FormA";
   @Command([Compose]; "FormB");
   @Return(""))
0
 

Author Comment

by:Jaziar
ID: 9928134
The Include in menu is disabled.  I have included your code in a action button "Create SPR" eg:

@If(
   Form="Marketing Form";
   @Command([Compose]; "ECR Form 2");
   @Return(""))

but still if I click that "create SPR" button with a document in the view, it opens the document verses creating a new document.  But if there are no documents, it creates a new one (what I want)
0
 

Author Comment

by:Jaziar
ID: 9928170
Hemantha

The problem with creating a copy of the form (3. from above) it would mess up all my view selection formulas.
0
 
LVL 13

Expert Comment

by:CRAK
ID: 9928459
I don't understand Jaziar...
That formula should work from within a view: if you have a document "Marketing Form" selected it should create a ECR Form 2. If you have no document selected, it does nothing.

I understand it now opens the selected document? That's not what happens here...!?
0
 

Author Comment

by:Jaziar
ID: 9928679
My fault - the documents in the view are created from ECR Form 2 not Marketing Form.

my views are like this

By ECR
           >Color    action button top of view is "Create ECR"              - Composed ECR Form 2
           >Style    action button top of view is "Create ECR"                              ""
           >Etc       action button top of view is "Create ECR"                              ""

By Marketing
           >Mono    action button top of view is "Create Marketing"        - Compose Marketing Form
           >Users    action button top of view is "Create Marketing"                       ""
           >TLI       action button top of view is "Create Marketing"                       ""


In marketing form after the docuement gets to a approved stage -
it then gives the option to the use to create a ecr document using ECR Forn 2 from within the marketing form -
becuase some times the marketing info needs to be sent into ECR form.  
But once in a while a the info needs to go straight in to a ecr form  and bypass marketing forms.  That is where the problem is.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9929154
you can use either 2 or 3.

3 is much easier..

And it wouldn't mess up your view. The trick is you will incorporate a field called Form in this duplicate form and set it to what the view is set to.
0
 

Author Comment

by:Jaziar
ID: 10062091
This problem has gone away for now - so I am going to split the points.  Thanks for everyone's help
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Lotus Domino 9 web server 6 103
Get files more than 50 GB from F drive on list of servers 8 105
Lotus Script - Exporting Attachments and Folder Creation 2 124
DNS error assumed 8 107
This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question