Getting error in taking snapshot. I can see below in error log
Id: 8f604d69-9ed7-4a04-9939-c71d5aa08916
Time of Log: 2022-10-20 12:25:17
Request Key: 3e99ea54-7b26-4025-81bf-8e63ecb40be4
Module: DiscoveryProbe
Message: Error executing query. Error in advanced query UpdateModuleDefinitionsForEspacesOracle in Modules_Reload in DiscoveryProbe (UPDATE {ModuleDef} MD SET (MD.Description, MD.Name, MD.ApplicationDefId, MD.IsDeleted, MD.Kind, MD.SS_Key, MD.EspaceId) = ( Select EV.Description, E.Name, AD.Id, 0, 'oml', E.SS_Key, E.Id From {Espace_Version} EV Inner JOIN {Espace} E ON E.[VERSION_ID] = EV.[ID] Inner JOIN {Module} M ON M.[ESPACE_ID] = E.[ID] Inner JOIN {App_Definition_Module} ADM ON ADM.[MODULE_ID] = M.[ID] Inner JOIN {ApplicationDef} AD ON ADM.[APPLICATION_ID] = AD.[APPLICATIONID] Where MD.[ESPACEID] = E.[ID] and E.[IS_ACTIVE] = 1 AND AD.[ISDELETED] <> 1 ) Where MD.Kind = 'oml' ): ORA-01427: single-row subquery returns more than one row
Stack: [1] Error executing query. at ssDiscoveryProbe.Actions.FuncActionModules_Reload.QueryUpdateModuleDefinitionsForEspacesOracle(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount) at ssDiscoveryProbe.Actions.ActionModules_Reload(HeContext heContext, String inParamDatabaseProvider) at ssDiscoveryProbe.Actions.ActionApplications_Reload(HeContext heContext, String inParamDatabaseProvider) at ssDiscoveryProbe.Actions.ActionSnapShot_Create(HeContext heContext, Int32& outParamSnapShotId, String& outParamSnapShotName)
[2] Error in advanced query UpdateModuleDefinitionsForEspacesOracle in Modules_Reload in DiscoveryProbe (UPDATE {ModuleDef} MD SET (MD.Description, MD.Name, MD.ApplicationDefId, MD.IsDeleted, MD.Kind, MD.SS_Key, MD.EspaceId) = ( Select EV.Description, E.Name, AD.Id, 0, 'oml', E.SS_Key, E.Id From {Espace_Version} EV Inner JOIN {Espace} E ON E.[VERSION_ID] = EV.[ID] Inner JOIN {Module} M ON M.[ESPACE_ID] = E.[ID] Inner JOIN {App_Definition_Module} ADM ON ADM.[MODULE_ID] = M.[ID] Inner JOIN {ApplicationDef} AD ON ADM.[APPLICATION_ID] = AD.[APPLICATIONID] Where MD.[ESPACEID] = E.[ID] and E.[IS_ACTIVE] = 1 AND AD.[ISDELETED] <> 1 ) Where MD.Kind = 'oml' ): ORA-01427: single-row subquery returns more than one row
Regards,
Prasad
Hello Prasad,
Can you please validate if you are using the Discovery's latest stable version OS 11 (5.1.4)
Thank you!
Best regards,
ROM
Hi Ricardo,
I was using the latest version and issue started after we upgraded from 11.14 to 11.16.
I resolved the issue by deleting the component and reinstalling from forge.
Prasad Rao