This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


~Chloe Cisresteroni
Sep 20, 2016, 12:38 PM
19 Posts
topic has been resolvedResolved

Resource not found in schedule database

  • Category: Domino Server
  • Platform: Windows
  • Release: 9.0.1
  • Role: End User
  • Tags:
  • Replies: 10

Dear All,

I have created a room resource but when I am trying to book the room, I am getting 'The following room/resource is either not available or restricted'.

The resource has a mail-in database.

I get the message 'Resource not found in schedule database' when I send the command 'tell rnrmgr show resource'.

I get the message 'Done validating resource' when I send the command tell 'sched validate resource'.

When I do 'Find Rooms' in Notes calendar, the resource is not listed while other resources are listed.

I have restarted rnrmgr and done a updall -R against the resource database but problem is same.

Any help would be greatly appreciated.

Thank you.

~James Preresaskioden
Sep 20, 2016, 4:44 PM
34 Posts
3 comments & 1 question
First off, Schedule Manager (sched) is no longer involved in anything R&R related.  So doing "tell sched validate resource" will not do anything.  You will get a "Done validating" message but since the name you gave it was not a user it did nothing.  You want to give that command to the Rooms & Resource Manager (rnrmgr): tell rnrmgr validate resource

If RnRMgr has a problem validating the room (e.g. its not in the NAB yet) then it will tell you what is wrong and you can go from there.

Next, due to the asynchronous design of the systems involved, a newly added room will not be bookable until the day after its added.  The system is designed to recheck everything at 2 AM and make previously unprocessed system changes available.  If that has not happened for you by now then we need to take a closer look why not.

If you absolutely must have the newly added room in use without waiting overnight then you can speed the process along by manually taking steps to speed up the asynchronous actions involved with AdminP and address book updates & replication.  Those steps to force the process have previously published by IBM so check the Technote database.

Simply restarting RnRMgr and running updall on the NAB (not the R&R dB) will not help if the NAB data is not yet there.  That work is done by AdminP.  Of course the AdminP request needs to be replicated from the R&R server to the NABs Administration Server.  So you need to make sure the AdminP request is there before you can force AdminP to process it.  All of this should have have happened overnight (you only posted this AM but did not say when you added your room).  Has it been overnight since you added the room?

Bruce
IBM
~Chloe Cisresteroni
Sep 20, 2016, 6:34 PM
19 Posts
Resource not found in Schedule Database

Dear Bruce,

Thank you for taking the time to reply.

I added the room last week, on Wednesday  Sep 14.

We have a clustered server to our main server but the resource db is not replicated to that server. The resource db is only on the main server. Maybe that could be the problem?

I'm allowed to book the room directly from the resource db. But users cannot do it from their calendar. Other rooms and resources work fine from the calendar.

tell rnrmgr validate resource gives 'Done validating resource.'

Thank you.

Best Regards,

Manjula

~James Preresaskioden
Sep 21, 2016, 11:20 PM
34 Posts
Quick followup
Did the tell rnrmgr validate command get your new room working?  

Do you get any info on the new room if you do a tell rnrmgr list ROOMNAME or a tell rnrmgr show ROOMNAME where ROOMNAME is the full hierarchical room name?

I did manage to find that we documented it in TechNote 1101535 which has the details (if you are interested) on why there is a delay when adding a new room.  It was published 8-9 years ago which was why it took a little while to find it.  
Bruce
IBM
~Chloe Cisresteroni
Sep 22, 2016, 5:28 AM
19 Posts
Resource not found in schedule database

Hello Bruce,

The validate did not get it to work. 

Tell rnrmgr list roomname gives 'room not found in schedule database'.

tell rnrmgr show room gives the same message.

I can book the room directly from the resource database. 

When I do 'Find Rooms' in my calendar to try to book the room, the room is not listed. 

Does the cluster thing make any difference?

At this point, I am interested in anything that will get it to work. I did not find the technote online. Kindly share it with me.

Thank you.

~James Preresaskioden
Sep 22, 2016, 4:55 PM
34 Posts
Try this
It sounds like the RnRMgr does not consider the new room to be a valid for monitoring & processing.  Try the following steps on the R&R server console:

set config DEBUG_SCHED_ALL=1
tell rnrmgr validate ROOMNAME (where ROOMNAME is the full hierarchical name of the room)
set config DEBUG_SCHED_ALL=0

The INI will cause the validate command to display any NAB related issues it has with checking the room before putting it into busytime.  Look for any messages that start with SchValidateUser:

SchValidateUser> NO matches for user ROOMNAME in N&A Book

or

SchValidateUser> Multiple matches for user ROOMNAME in N&A Book

or

SchValidateUser> User ROOMNAME's mail server is SERVER_B, not SERVER_A

Any message from SchValidateUser would indicate there is a NAB issue you need to resolve before RnRMgr can start processing requests for the room.  If there are none then the issue is not with verifying the room against the NAB and we will need to look at the R&R dB itself.  More on that later if necessary.

As for the question on clustering, it is only relevant if all your rooms are having an issue; not 1.  That does cause me to wonder if you moved the R&R dB after it was initially created and before you added the new room.  If you did, did you make sure you changed the Administration Server in the ACL to be the new home?  If not then the new room will have a different Home Server in the NAB (which would show up as that last SchValidateUser example).  All rooms in the same dB MUST have the same Home Server value in the NAB.  If not you will cause odd issues with request processing.

Bruce
IBM
~Chloe Cisresteroni
Sep 23, 2016, 9:58 AM
19 Posts
Resource not found in schedule database

Hello Bruce,

Configured the settings you advised.

I looked in Miscellaneous Events in Mail Log.

It says rnrmgr : Done validating room.

That's it.

I can't find the schvalidateuser. Where should I look for it?

Thank you.

~James Preresaskioden
Oct 3, 2016, 4:54 PM
34 Posts
Don't bother
  I only mentioned Sched because you had used it originally.  Sched will not say anything except Done but it will not warn you that the name you gave it was R&R, it simply says "Done".

Bruce
IBM
~Chloe Cisresteroni
Sep 27, 2016, 12:21 PM
19 Posts
Resource not found in schedule database

Hello Bruce,

I launched the command tell RnRMgr whoowns resourcedatabasename.NSF and found out the owner is mail3, our disaster recovery server.

I then replicated the db resource.nsf on mail1 (primary server) with that of mail3 (DR server) and everything started working.

I want mail1 to own resource.nsf so I will do as you advised in one of your post. I will shut down mail3 for 30 min so that mail1 takes control.

I would be grateful if you have any best practice for resource.nsf across clusters. WE have 3 clusters. Mail1 and mail2 are internal while mail3 is DR.

Thanks.

~James Preresaskioden
Oct 3, 2016, 4:57 PM
34 Posts
A quick followup
  The clustering failover design was added R7 to make R&R more robust in the event of a server failure.  Based on our several factors we limited the failover mechanism to happen on between the R&R dBs primary server and the next clustermate when the list of clustermates is sorted alphabetically.  That can sound a little confusing so let me demonstrate using a cluster of 3 server: Server A, Server B, and Server C.

  If the primary server is Server A then failover will happen between Server A and Server B, never Server C.  This is also the case if the primary server is Server B.  That is because when we sort the list of clustermates and remove the primary server Server B (or Server A in the 2nd example) come before Server C.  In order to have Server C be involved with failover it would need to be the primary server.  In that case failover would between Server C and Server A but never Server B.

  So if you set mail1 to be the primary server then failover should only happen to mail2.  It should never happen with mail3 unless mail3 is set as the primary server.  The only way I can see for mail3 to attempt failover and take control when mail1 died was if mail3 did not know about mail2.  

  You can see when the last time any server took control of an R&R database if you set DEBUG_RNRMGR=64 and then do a whoowns command.  The INI will cause RnRMgr to generate some extra output that tells you when each server in the cluster last attempted failover for the database you specify.  For example:

tell rnrmgr whoowns Rooms.nsf
CheckDBOwnership> NoteID NT00000C9E indicates replica 852563E3:007A46DF failedover on 09/26/2016 11:26:18 AM to server Server A/Kahn
CheckDBOwnership> NoteID NT00000A2A indicates replica 852563E3:007A46DF failedover on 08/08/2016 07:29:54 AM to server Server B/Kahn
Database IrisConf.nsf is currently under the control of server Server A/Kahn (0)

The CheckDBOwnership> tagged lines tell me that Server B had control for most of August and September and that Server A only recently took over processing of requests in my test dB.

  Once you have control back on mail1 I would check to see if failover happens with mail2 or mail3 in the future.  If you see it failover to mail3 then please contact Technical Support so we can investigate why and work on a solution to keep it off your DR server.

  In case you were not aware, the 'primary' server is specified in the R&R database ACL.  It is the Administration Server setting.  It is used to set the Home Server setting of each room doc in the NAB.
Bruce
IBM
~Chloe Cisresteroni
Oct 11, 2016, 10:54 AM
19 Posts
Resource not found in schedule database

Hello Bruce,

Thank you for taking the time to reply to my query.

The primary server in the resource database was always mail1. I did check.

But anyway, I will look into it and revert if there is anything.

Best Regards,

Manjula


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal