PDA

View Full Version : Copying the rows of three tables into one table



kettle_anonymous
03-27-2006, 04:12 PM
I have 3 input tables and 1 output table. The three input tables are connected to the ( -->) output table. Each tables have the same set of fields. The output table is blank, and the input tables all contain 60 to 80 rows.

The problem is there is an error saying that ...

Table output.0 - ERROR : Because of an error, this step can't continue:
Error performing rollback on connection
Can't call rollback when autocommit=true

How do I go about this? Is my transformation model correct or do I have to use another model in kettle? Where is the setting "autocommit"?

Thanks!

-Cholo-

MattCasters
03-27-2006, 08:30 PM
I guess you hit an error while inserting and Kettle wants to rollback the connection.
However, you set a commit size of 0 in the TableOutput. This enables auto-commit.

Also, place a Dummy in the place of the Table Output and do a preview on that.
That way you're certain that all rows have indeed the same format etc.

Good luck!

Matt