Generated Kettle file error on foreign key constraint #140

2021/01/19 08:02:48 - Migration - Starting entry [Common_Aggregate]
2021/01/19 08:02:48 - Common_Aggregate - Running transformation using the Kettle execution engine
2021/01/19 08:02:48 - [Common].[Aggregate] - Dispatching started for transformation [[Common].[Aggregate]]
2021/01/19 08:02:48 - Table output.3 - Connected to database [__postgres_db__] (commit=100)
2021/01/19 08:02:48 - Table output.0 - Connected to database [__postgres_db__] (commit=100)
2021/01/19 08:02:48 - Table output.2 - Connected to database [__postgres_db__] (commit=100)
2021/01/19 08:02:48 - Table output.5 - Connected to database [__postgres_db__] (commit=100)
2021/01/19 08:02:48 - Table output.4 - Connected to database [__postgres_db__] (commit=100)
2021/01/19 08:02:48 - Table output.1 - Connected to database [__postgres_db__] (commit=100)
2021/01/19 08:02:48 - Table output.6 - Connected to database [__postgres_db__] (commit=100)
2021/01/19 08:02:48 - Table output.7 - Connected to database [__postgres_db__] (commit=100)
2021/01/19 08:02:48 - Execute SQL script.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : An error occurred, processing will be stopped: 
2021/01/19 08:02:48 - Execute SQL script.0 - Couldn't execute SQL: truncate table "common"."aggregate"
2021/01/19 08:02:48 - Execute SQL script.0 - 
2021/01/19 08:02:48 - Execute SQL script.0 - ERROR: cannot truncate a table referenced in a foreign key constraint
2021/01/19 08:02:48 - Execute SQL script.0 -   Detail: Table "deviceport" references "aggregate".
2021/01/19 08:02:48 - Execute SQL script.0 -   Hint: Truncate table "deviceport" at the same time, or use TRUNCATE ... CASCADE.
2021/01/19 08:02:48 - Execute SQL script.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Error initializing step [Execute SQL script]
2021/01/19 08:02:48 - [Common].[Aggregate] - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Step [Execute SQL script.0] failed to initialize!
2021/01/19 08:02:48 - Table input.0 - Finished reading query, closing connection.
2021/01/19 08:02:48 - Execute SQL script.0 - Finished reading query, closing connection.
2021/01/19 08:02:48 - Common_Aggregate - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Unable to prepare for execution of the transformation
2021/01/19 08:02:48 - Common_Aggregate - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : org.pentaho.di.core.exception.KettleException: 
2021/01/19 08:02:48 - Common_Aggregate - We failed to initialize at least one step.  Execution can not begin!
2021/01/19 08:02:48 - Common_Aggregate - 
2021/01/19 08:02:48 - Common_Aggregate - 
2021/01/19 08:02:48 - Common_Aggregate - 	at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1282)
2021/01/19 08:02:48 - Common_Aggregate - 	at org.pentaho.di.trans.Trans.execute(Trans.java:751)
2021/01/19 08:02:48 - Common_Aggregate - 	at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1188)
2021/01/19 08:02:48 - Common_Aggregate - 	at org.pentaho.di.job.Job.execute(Job.java:682)
2021/01/19 08:02:48 - Common_Aggregate - 	at org.pentaho.di.job.Job.execute(Job.java:823)
2021/01/19 08:02:48 - Common_Aggregate - 	at org.pentaho.di.job.Job.execute(Job.java:823)
2021/01/19 08:02:48 - Common_Aggregate - 	at org.pentaho.di.job.Job.execute(Job.java:823)
2021/01/19 08:02:48 - Common_Aggregate - 	at org.pentaho.di.job.Job.execute(Job.java:823)
2021/01/19 08:02:48 - Common_Aggregate - 	at org.pentaho.di.job.Job.execute(Job.java:823)
2021/01/19 08:02:48 - Common_Aggregate - 	at org.pentaho.di.job.Job.execute(Job.java:500)
2021/01/19 08:02:48 - Common_Aggregate - 	at org.pentaho.di.job.Job.run(Job.java:386)
2021/01/19 08:02:48 - Migration - Finished job entry [Common_Aggregate] (result=[false])
2021/01/19 08:02:48 - Migration - Finished job entry [BillComparison_CommunityDevicePortType] (result=[false])
2021/01/19 08:02:48 - Migration - Finished job entry [BillComparison_BillComparisonDetail] (result=[false])
2021/01/19 08:02:48 - Migration - Finished job entry [BillComparison_BillComparison] (result=[false])
2021/01/19 08:02:48 - Migration - Finished job entry [SQL SCRIPT START] (result=[false])
2021/01/19 08:02:48 - Migration - Job execution finished
2021/01/19 08:02:48 - Finished!
2021/01/19 08:02:48 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Finished with errors
08:02:48,416 ERROR [di] null Finished with errors
2021/01/19 08:02:48 - Start=2021/01/19 08:02:44.628, Stop=2021/01/19 08:02:48.416
2021/01/19 08:02:48 - Processing ended after 3 seconds.