Page 1 of 4

New Calendar Managing Resources Assignment Database Error

Posted: Sun Mar 06, 2011 5:51 pm
by niederhausern
I’m trying to set aside a Location for use by a specific Ward during a specified time block in the new calendar as described at https://tech.lds.org/ldshelp/index.php5/Local_Unit_Calendar:_Reserving_Locations_and_Resources/eng but I’m getting a “Database error, no resources included with this assignment” as shown below in the screen shot. I have selected resources but still get the error and the assignment does not block other wards from scheduling during this time as it should. Please advise.
ss.PNG
ss.PNG (15.49 KiB) Viewed 1198 times

Posted: Tue Mar 08, 2011 12:14 pm
by niederhausern
Anyone else having this issue?

Posted: Tue Mar 08, 2011 12:24 pm
by russellhltn
Out of curiosity, what country are you in?

As I understand it, the resources are tied into a database of church properties maintained by your FM group. I wonder if that's the source of the problem.

Posted: Tue Mar 08, 2011 12:34 pm
by aebrown
niederhausern wrote:I’m trying to set aside a Location for use by a specific Ward during a specified time block in the new calendar as described at [/SIZE]https://tech.lds.org/ldshelp/index.php5/Local_Unit_Calendar:_Reserving_Locations_and_Resources/eng[size=100] but I’m getting a “Database error, no resources included with this assignment” as shown below in the screen shot. I have selected resources but still get the error and the assignment does not block other wards from scheduling during this time as it should. Please advise.


I am able to duplicate this problem. Here's what I did:

  1. In Manage Locations and Resources, I created a new resource for one of our buildings called "test"
  2. In Manage Resource Assignments, I created an assignment for that resource for a series of dates.
  3. Back in Manage Locations and Resources, I deleted the resource "test"
  4. Back in Manage Resource Assignments, all the assignments for that resource now displayed a similar "Database error, no resources included with this assignment" message.
I don't know if you have the same root cause, but this may give you a lead. It certainly makes sense that if an assignment is linked to a resource that no longer exists, it could cause a database error (of course, the code should be cleaning up all database links to a resource when the resource is deleted, but the error is understandable).

Posted: Wed Mar 09, 2011 1:24 am
by niederhausern
RussellHltn wrote:Out of curiosity, what country are you in?

As I understand it, the resources are tied into a database of church properties maintained by your FM group. I wonder if that's the source of the problem.


Redmond, WA USA

Posted: Wed Mar 09, 2011 10:22 am
by niederhausern
aebrown wrote:I am able to duplicate this problem. Here's what I did:

  1. In Manage Locations and Resources, I created a new resource for one of our buildings called "test"
  2. In Manage Resource Assignments, I created an assignment for that resource for a series of dates.
  3. Back in Manage Locations and Resources, I deleted the resource "test"
  4. Back in Manage Resource Assignments, all the assignments for that resource now displayed a similar "Database error, no resources included with this assignment" message.
I don't know if you have the same root cause, but this may give you a lead. It certainly makes sense that if an assignment is linked to a resource that no longer exists, it could cause a database error (of course, the code should be cleaning up all database links to a resource when the resource is deleted, but the error is understandable).


What's interesting is I get the error without the resource being deleted.

Posted: Wed Mar 09, 2011 10:28 am
by russellhltn
niederhausern wrote:What's interesting is I get the error without the resource being deleted.


I wonder if the resource got deleted/recreated, renamed or otherwise changed.

Posted: Wed Mar 09, 2011 11:45 am
by jdlessley
RussellHltn wrote:I wonder if the resource got deleted/recreated, renamed or otherwise changed.
If the resource was deleted and then added in again it sounds logical that could cause the problem. The record key for the old resource would be different from the new resource even though they have the same name or character string. The event(s) created using the first resource record would be linked to that record. It doesn't exist. The new record, while having the same name, would have a different record key.

Posted: Tue Mar 15, 2011 1:48 pm
by mawhiteley
niederhausern wrote:What's interesting is I get the error without the resource being deleted.


Likewise. The resources haven't been changed (since I'm the one who created them) and I'm getting this "Database error" too, but only when I try to reserve resources for new events. The previously scheduled events still show their correct resources (i.e. Kitchen).

Ideas? Thanks.

Posted: Wed Mar 16, 2011 12:29 am
by niederhausern
mawhiteley wrote:Likewise. The resources haven't been changed (since I'm the one who created them) and I'm getting this "Database error" too, but only when I try to reserve resources for new events. The previously scheduled events still show their correct resources (i.e. Kitchen).

Ideas? Thanks.


Looks like that makes two of us getting the same error which leads me to belive it's not local to our site. Anyone else get this error? Anyone from lds.org know what's up?