Error When Loading Grade Rate HDL — Date-Effective Row Conflict

Summary:

Hello Experts, I am trying to load a new Grade Rate Value record using HDL, but I am getting the following error: “You’ve provided a date-effective row that ends on 12/31/12 12:00 AM for an existing record that already exists with an end date of 10/14/23 12:00 AM.”
I want to understand why this error occurs and how to fix it.

Content (please ensure you mask any confidential information):

I am loading the following HDL to insert a new grade rate value:

METADATA|GradeRateValue|EffectiveStartDate|EffectiveEndDate|MinimumAmount|MidValueAmount|MaximumAmount|GradeRateName|GradeCode|LegislativeDataGroup|SetCode
MERGE|GradeRateValue|2026/08/01||400000|1000000|1600000|IN Specialty Salaried|I10|IND LDG|JOB_GRADE_IND_SET