UP20040 Could Not DROP Entity Used by a Job or Materialized View

You tried to DROP one of the following entities: CONNECTION, TABLE, or MATERIALIZED VIEW, and that entity is used by a job or a materialized view. For example, you tried to DROP a connection and that connection is being used in an ingestion job.

Possible Causes

• Upsolver does not allow dropping the connection because it will result in errors in the running job.

Possible Solutions

• First, drop the job or materialized views using the entity and then retry. You can obtain the list of jobs and/or materialized views using the entity from the error message.