Skip to main content

Celonis Product Documentation

DROP failed due to dependencies
Problem

The following errors might occur when executing your transformation scripts (even if they have worked before):

[Vertica][VJDBC](3128) ROLLBACK: DROP failed due to dependencies

Also here is an example how the error message looks like in the Celonis Platform UI:

50725982.png
Root Cause

With the latest release of one of the Celonis Platform services, we have introduced Vertica optimizations to improve Transformation run times for Data Jobs. Part of this optimization is the automated creation of projections in Vertica. Due to the projections, dropping a Table or View is only possible with a CASCADE statement, which will also drop all dependencies.

Solution

Add CASCADE to all affected DROP statements like in this example:

DROP TABLE IF EXISTS CDPOS_V CASCADE;