Have you ever received error “Demogr.refresh Line 13 Unhandled Structured exception error 2071 Procedure: Refresh Error 2029” and wonder what it was?

Why this error happened?

• A termination date was removed by error from an employee terminated records without changing the employee status from Terminated back to Active.
• The employee was terminated in error and needed to be rehired or have the status changed, and the error occurred when attempting to open the employee record or when using Task, Rehire Employee.
• Other reasons may be the employee status was updated to p_active =T in HRPERSNL table and the Termination date is Null or blank on our table

There are a few reasons:

When an employee is terminated in Sage HRMS, the employee status is changed from Active to Terminated in our database and a valid date field must be entered for Sage HRMS to validate the terminated record. If the Termination date field is blank, Sage HRMS cannot confirm a valid termination and generates a process error. Therefore, Sage recommends using the Add New Hire, Rehire Employee or Terminated Employee function wizard within Sage HRMS as best practice. From the Navigation Pane, under Tasks you will see these functions.

You will also find more information by accessing Sage HRMS Help, select Search Help, and type the keyword (i.e Add New Hire, Rehire Employee or Terminate Employee) in the Documentation and Resources.

There are two ways to resolve this issue:

1. You can perform a mass update to change terminated employees that need to be active within Sage HRMS. This will allow you to restore the affected employee record back to active status, allowing access to make the necessary changes. Whether you want to update the Termination Date with a valid date field or make other changes to this record. This resolution does not require access to the SQL database if you familiar with performing mass update on the Sage HRMS UI.

Note: It is recommended to make a backup of your SageHRMS_Live and other applicable databases prior to performing a mass update.

From the Navigation Pane, select Employees, Processes and Mass Update

Update File: Employee Personnel
Update Field: Employee Status Code (A/T/L/D/N)
Records to Update: Pe.p_empno="####" and Pe.p_active="T" (for "####" enter the specific employee's ID number)
New Value: "A"

Click ‘OK’

A popup message will appear indicating how many records will be updated.

You can go to View/Edit employee and correct the employee record. 

2. This option requires access to the SQL server.

Note: It is recommended to make a backup of your SageHRMS_Live and other applicable databases prior to performing any changes to SQL server.

This is a more advanced option and should only be used by a Database Administrator or someone with advanced SQL knowledge if option 1 cannot be used.

Login to the SQL, select SageHRMS_Live dbo.Hrpersnl for the specific employee using the employee id. Review the values in fields, for example, look for NULL values in Terminated Date fields and update to a valid date.