Discovery 6.0.2 is not able to create snapshot

Discussion

we are using discovery 6.0.2 version but when i am trying create a new snapshot it is not creating snapshop.below error log is generating

2023-08-27 00:00:53

DiscoveryProbe

Error executing query. Error in advanced query CreateModuleDefinitionsForExtensions2 in Modules_Reload in DiscoveryProbe (INSERT INTO {ModuleDef}(Name, Description, SS_Key, Kind, ApplicationDefId, ESpaceId, ExtensionId, Layer, IsSelected, IsDeleted) SELECT E.[Name], EV.[Description], E.[SS_Key], 'xif' as Kind, AD.[Id] as ApplicationDefId, NULL as ESpaceId, E.[Id] as ExtensionId, @LibModuleLayerId as Layer, 1 as IsSelected, 0 as IsDeleted FROM (((({Extension_Version} EV Inner JOIN {Extension} E ON (E.[VERSION_ID] = EV.[ID])) Inner JOIN ({Module} M Inner JOIN {App_Definition_Module} ADM ON (ADM.[MODULE_ID] = M.[ID])) ON (M.[EXTENSION_ID] = E.[ID])) Inner JOIN {ApplicationDef} AD ON (ADM.[APPLICATION_ID] = AD.[APPLICATIONID])) Left JOIN {ModuleDef} MD ON (MD.[EXTENSIONID] = E.[ID])) WHERE (E.[IS_ACTIVE] = 1) AND (AD.[ISDELETED] <> 1) AND (MD.[ID] IS NULL)): The INSERT statement conflicted with the FOREIGN KEY constraint "OSFRK_OSUSR_MRN_MODULEDEF2_OSUSR_MRN_MODULELAYER2_LAYER". The conflict occurred in database "dev-cib-platform-db", table "dbo.OSUSR_MRN_MODULELAYER2", column 'ID'.
The statement has been terminated.

AZUN-T-A-CIB-02

can anyone please help me to resolve this?already tried with old version but still i am getting same error.

28 Aug