Remnant of a deleted report

Unknown

Remnant of a deleted report

Unknown

[font=Roboto, Arial, Helvetica, sans-serif]Hello ! I have a problem with a report that i deleted (The FLOW run ERROR is past at the end of the ticket). What happend is that in my flow I use this Fetch SQL : select er.component_registration_id, er.entity_name from element_registration er inner join entity_folder ef on er.entity_folder_id = ef.folder_id where ef.full_path not like %System% and is_report = 1 But i keep having in ouput the ID of report that i have deleted so in the next step i have an error because it doesnt exist anymore. How can i fix this ? thank you for your time ! This is the error details : DecisionsFramework.Design.Flow.ErrorRunningFlowStep: Error running step Run Report[RunReportStep] in flow [[could be used as a Job] Save all Reports]: ElementRegistration d3d56d3d-eec6-11ea-8b7a-000d3a89d198 was not found ---> DecisionsFramework.LoggedException: ElementRegistration d3d56d3d-eec6-11ea-8b7a-000d3a89d198 was not found at DecisionsFramework.Design.Report.Service.Utils.ReportHelper.GetReportDefinitionInfo(AbstractUserContext user, String elementRegistrationtID) at DecisionsFramework.Design.Report.Service.Utils.ReportHelper.LoadReport(AbstractUserContext user, String elementRegistrationId, Boolean cached) at DecisionsFramework.Design.Flow.CoreSteps.RunReportStep.Run(StepStartData data) at DecisionsFramework.Design.Flow.FlowStep.RunStepInternal(String flowTrackingID, String stepTrackingID, KeyValuePairDataStructure[] stepRunDataValues, AbstractFlowTrackingData trackingData) at DecisionsFramework.Design.Flow.FlowStep.Start(String flowTrackingID, String stepTrackingID, FlowStateData data, AbstractFlowTrackingData trackingData, RunningStepData currentStepData) --- End of inner exception stack trace --- at DecisionsFramework.Design.Flow.FlowEngine.Error(String flowTrackingID, String stepTrackingID, Exception ex, String stepName, String flowName, String stepType, FlowStep step, RunningStepData stepData) at DecisionsFramework.Design.Flow.FlowStep.Start(String flowTrackingID, String stepTrackingID, FlowStateData data, AbstractFlowTrackingData trackingData, RunningStepData currentStepData) at DecisionsFramework.Design.Flow.FlowEngine.RunEngine() at DecisionsFramework.Design.Flow.FlowEngine.RunStepWithTrackingId(String flowTrackingID, FlowStep fs, FlowStateData data, String stepTrackingId, AbstractFlowTrackingData trackingData) at DecisionsFramework.Design.Flow.FlowEngine.Start(Flow flow, FlowStateData data, Boolean debug, String flowTrackingId, String workQueueName, Boolean startedViaRunFlowAction, DataPair[] initialGlobalExecutionData, PrimaryFlowTrackingData trackingData) at DecisionsFramework.Design.Flow.Service.Execution.FlowExecutionService.StartFlowAndGetPrimaryFlowTrackingData(String flowID, DataPair[] data, String flowTrackingId, Boolean startedViaRunFlowAction) at DecisionsFramework.Design.Flow.Service.Execution.FlowExecutionService.StartFlowWithData(String flowID, DataPair[] data, String flowTrackingId, Boolean startedViaRunFlowAction) at DecisionsFramework.Design.Flow.Service.Execution.FlowExecutionService.StartFlowWithData(AbstractUserContext context, String flowID, DataPair[] data, String flowTrackingId, Boolean startedViaRunFlowAction)[/font]

Unknown

[font=Roboto, Arial, Helvetica, sans-serif]Is your use case to create a report of reports and their parent folders? Adding and er.deleted = 0 to your where clause would prevent deleted items from being returned in the querys result set.[/font]
[font=Roboto, Arial, Helvetica, sans-serif]
[/font]
[font=Roboto, Arial, Helvetica, sans-serif]Whenever you delete an object, Decisions does not truly delete its data, instead, we flip a deleted flag in the corresponding table.[/font]
[i]edited by james.hartzell@decisions.com on 9/25/2020[/i]