New Calendar Managing Resources Assignment Database Error
-
- New Member
- Posts: 10
- Joined: Sun Mar 06, 2011 5:29 pm
New Calendar Managing Resources Assignment Database Error
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.
[attachment=0]ss.PNG[/attachment]
[attachment=0]ss.PNG[/attachment]
- Attachments
-
- ss.PNG (15.49 KiB) Viewed 1819 times
-
- New Member
- Posts: 10
- Joined: Sun Mar 06, 2011 5:29 pm
-
- Community Administrator
- Posts: 34499
- Joined: Sat Jan 20, 2007 2:53 pm
- Location: U.S.
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.
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.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.
So we can better help you, please edit your Profile to include your general location.
So we can better help you, please edit your Profile to include your general location.
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
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 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:
- In Manage Locations and Resources, I created a new resource for one of our buildings called "test"
- In Manage Resource Assignments, I created an assignment for that resource for a series of dates.
- Back in Manage Locations and Resources, I deleted the resource "test"
- Back in Manage Resource Assignments, all the assignments for that resource now displayed a similar "Database error, no resources included with this assignment" message.
Questions that can benefit the larger community should be asked in a public forum, not a private message.
-
- New Member
- Posts: 10
- Joined: Sun Mar 06, 2011 5:29 pm
-
- New Member
- Posts: 10
- Joined: Sun Mar 06, 2011 5:29 pm
aebrown wrote:I am able to duplicate this problem. Here's what I did:
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).
- In Manage Locations and Resources, I created a new resource for one of our buildings called "test"
- In Manage Resource Assignments, I created an assignment for that resource for a series of dates.
- Back in Manage Locations and Resources, I deleted the resource "test"
- Back in Manage Resource Assignments, all the assignments for that resource now displayed a similar "Database error, no resources included with this assignment" message.
What's interesting is I get the error without the resource being deleted.
-
- Community Administrator
- Posts: 34499
- Joined: Sat Jan 20, 2007 2:53 pm
- Location: U.S.
I wonder if the resource got deleted/recreated, renamed or otherwise changed.niederhausern wrote:What's interesting is I get the error without the resource being deleted.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.
So we can better help you, please edit your Profile to include your general location.
So we can better help you, please edit your Profile to include your general location.
-
- Community Moderators
- Posts: 9923
- Joined: Mon Mar 17, 2008 12:30 am
- Location: USA, TX
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.RussellHltn wrote:I wonder if the resource got deleted/recreated, renamed or otherwise changed.
JD Lessley
Have you tried finding your answer on the ChurchofJesusChrist.org Help Center or Tech Wiki?
Have you tried finding your answer on the ChurchofJesusChrist.org Help Center or Tech Wiki?
-
- New Member
- Posts: 36
- Joined: Tue Mar 15, 2011 2:46 pm
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.
-
- New Member
- Posts: 10
- Joined: Sun Mar 06, 2011 5:29 pm
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?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.