SnapCenter upgrade fails if multiple versions of Custom Plugins are added in the NSM database

• SnapCenter upgrade from 5.0 to 6.0 or later version, fails if custom plug-ins with multiple versions are added in SnapCenter NSM database.
• SnapCenter upgrade fails with below error:

2024-11-21 13:37:38.846 Executing SQL script C:\Users\administrator\AppData\Local\Temp\<user>\6.0\6.0.0.0008_Call_CustomPlugin_Procedures.sql
2024-11-21 13:37:38.878 Error: executing SQL script C:\Users\administrator\AppData\Local\Temp\<user>\6.0\6.0.0.0008_Call_CustomPlugin_Procedures.sql
2024-11-21 13:37:38.878 Error: Result consisted of more than one row
SQL script 6.0.0.0008_Call_CustomPlugin_Procedures.sql calls below stored procedures:
CALL `nsm`.`Update_nsm_PluginType`();
CALL `nsm`.`Update_nsm_sc_CustomPluginInfo`();
CALL `nsm`.`Update_nsm_sc_CustomPluginOsInfo`();
CALL `nsm`.`Update_nsm_sc_customresourcetype`();
Failure is happening while calling stored procedure `nsm`.`Update_nsm_sc_CustomPluginInfo`(); because there are multiple entries are there in nsm_sc_customplugininfo table for same CustomPluginName
Below is stored procedure `nsm`.`Update_nsm_sc_CustomPluginInfo`()