Skip to content
This repository was archived by the owner on May 14, 2025. It is now read-only.
This repository was archived by the owner on May 14, 2025. It is now read-only.

Clean up all task/job executions -> more than 1000 results #6118

@qjoqueiroz

Description

@qjoqueiroz

Apologies if I'm opening this issue incorrectly—this is my first time. I have over 1,000 historical executions, and when attempting to run the cleanup process, it results in an error (see below). While I can perform cleanup multiple times using the days filter, it would be great if it were possible to remove more than 1,000 records at once.

Version: 2.11.5

Caused By: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

This when trying to run:

SELECT TASK_EXECUTION_ID, TASK_PARAM from AGGREGATE_TASK_EXECUTION_PARAMS where TASK_EXECUTION_ID IN (?, ?.......)

Using:
tasks/executions?action=CLEANUP,REMOVE_DATA&completed=true

Metadata

Metadata

Assignees

No one assigned

    Labels

    status/need-triageTeam needs to triage and take a first look

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions