Can you try running with these changes

RankScore7:

LOAD Key_Qtr_ParamId_7,

SIM_ParamOrder,

SIM_Score_7,

AutoNumber(SIM_Score_7, Key_Qtr_ParamId_7&'AutoNumber1') as SIM_Rank_Score_7

Resident SIM_Data

Order By Key_Qtr_ParamId_7, SIM_Score_7 desc;

and

RankScore6_7:

LOAD Key_Qtr_ParamId_6_7,

SIM_ParamOrder,

SIM_Scores_6_7,

AutoNumber(SIM_Scores_6_7, Key_Qtr_ParamId_6_7&'AutoNumber2') as SIM_Rank_Score_6_7

Resident SIM_Data

Order By Key_Qtr_ParamId_6_7, SIM_Scores_6_7 desc;