We have an issue where the incremental load job is failing with the below error.
MOD_COL_SQL - org.pentaho.di.core.exception.KettleStepException:
Error while running this step!
Couldn't execute SQL: ALTER TABLE DWH_ODF_XXX MODIFY COLUMN_NAME NUMBER(32)
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-01439: column to be modified must be empty to change datatype
This is caused when you don't remove the attributes from DWH before re-creating the attribute.
Release : 15.9.1
Note :- the Steps and error pertain to Oracle Database only.