39
Views
2
Comments
[Discovery] Error executing query in discoveryprobe
discovery
Web icon
Forge component by Francisco Menezes
Application Type
Traditional Web

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.


Regards,

Prasad Rao

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.