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:
 |
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;