Event Helpmate 2004
Technical Support Article
TSA#: 3110  
TSA Title: EH2004 Upgrade Utility produces "3021 : You cannot add or change the record because a related record is required in tblROOM."  
Builds Affected: Build 1.1  
Status: Resolved in SR1A
Category: Upgrade Utility  
  
Problem/Issue Description
When running the EH2004 Upgrade Utility to bring in your existing Helpmate Scheduler 2002 (previous version) data, the following 3 error messages are received:

"Stage 0" - click OK

"3021 : You cannot add or change the record because a related record is required in tblROOM." - click OK

"Error making room assignment. Upgrade process failed." - click OK
 
Cause
There is at least one Room resource record in your Helpmate Scheduler 2002 database that has a blank "Managed By" field. This creates the problem described above. 
Resolution
NOTE:  Resolved in EH2004 SR1A

(1) Open your Helpmate Scheduler 2002 version product.

(2) Select "Resources | Room Detail" from the top menubar. This will open the Room Detail form and show you the 1st room record in your HS2002 database.

(3) Determine if the currently displayed room record has a value for the "Managed By" field. If this value is blank, click the Room Detail form's unlock button (yellow key in the upper left-hand corner), assign a value to this field, and then click the Save button to save the changes.

(4) Click the button at the top of the Room Detail form which is a single arrow pointing to the right - this will take you to the next Room record.

(5) Repeat steps 3 & 4 until all Room records have been checked. Once this is completed, all of your HS2002 Room records should have a value for the "Managed By" field.

(6) Re-run the EH2004 Upgrade Utility.

NOTE: If in the Room Detail form there are no values in the "Managed By" pull-down control to select from, select "Setup & Preferences | Resources Setup" and add an item to the list.

This problem will be resolved in the EH2004 "Service Release 1". 

TSA Creation Date:  2-July-2004
TSA Modified Date:  17-Jan-2005 

 

Return to EH2004 TSA Index