Known Issue - Delete Partial(Incomplete) records from the Online Enrollment Import list can produce an error - Fixed 7/31/2020
M
Minott Opdyke
started a topic
almost 3 years ago
Update - a fix for this error was shipped on 7/31/2020
When a Partial(Incomplete) Online Enrollment record is deleted from the Import list, the Registration End Date (STU.RED) is not being updated, leaving a NULL value. When the Deleted filter is chosen an error is produced because there is no Registration End Date. We are aware of the issue and working on a fix. In the meantime the following SQL query can be run to update STU.RED which will clear the error. We recommend not deleting Partial(Incomplete) records until the issue is fixed. Deleting Pending Imports does not produce an error.
USE AeriesRegistration <--your Registration Database name goes here.
--SELECT * FROM STU
UPDATE STU
SET RED = '2020-06-24 12:00:00.000' <--Enter the date of deletion
Minott Opdyke
Update - a fix for this error was shipped on 7/31/2020
When a Partial(Incomplete) Online Enrollment record is deleted from the Import list, the Registration End Date (STU.RED) is not being updated, leaving a NULL value. When the Deleted filter is chosen an error is produced because there is no Registration End Date. We are aware of the issue and working on a fix. In the meantime the following SQL query can be run to update STU.RED which will clear the error. We recommend not deleting Partial(Incomplete) records until the issue is fixed. Deleting Pending Imports does not produce an error.
USE AeriesRegistration <--your Registration Database name goes here.
--SELECT * FROM STU
UPDATE STU
SET RED = '2020-06-24 12:00:00.000' <--Enter the date of deletion
WHERE (RES = 'D') AND (RED IS NULL)
You may follow this Idea here: https://ideas.aeries.com/forums/926386/suggestions/40800535