PDA

View Full Version : Kettle - Could not setup row listener



begunrom
07-24-2006, 06:51 AM
When running a Kettle transformation i get a Kettle.ERROR_0012 - Could not setup row listener. Teh transformation seems to works. What does this message mean? How can i avoid this?

I also oploaded the Kettle transformation. You should rename it to .ktr (not allowed to upload)

2006-07-24 16:37:27,078 DEBUG [org.pentaho.plugin.kettle.KettleComponent] ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction execute validation=true
2006-07-24 16:37:27,078 DEBUG [org.pentaho.plugin.kettle.KettleComponent] ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction Start of execute
2006-07-24 16:37:27,078 INFO [zcwms921700] zcwms921700 - Transformation is pre-loaded from repository.
2006-07-24 16:37:27,078 DEBUG [org.pentaho.plugin.kettle.KettleComponent] ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction Preparing transformation
2006-07-24 16:37:27,078 INFO [zcwms921700] zcwms921700 - Dispatching started for transformation [zcwms921700]
2006-07-24 16:37:27,078 INFO [zcwms921700] zcwms921700 - This is not a replay transformation
2006-07-24 16:37:27,093 INFO [zcwms921700] zcwms921700 - This transformation can be replayed with replay date: 2006/07/24 16:37:27
2006-07-24 16:37:27,203 INFO [zcwms921700] zcwms921700 - Initialising 12 steps...
2006-07-24 16:37:27,515 INFO [Delete.0] Delete.0 - Connected to database...
2006-07-24 16:37:27,578 DEBUG [org.pentaho.plugin.kettle.KettleComponent] ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction Looking for step importer
2006-07-24 16:37:27,578 ERROR [org.pentaho.plugin.kettle.KettleComponent] ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction Kettle.ERROR_0012 - Could not set up row listener
2006-07-24 16:37:27,578 DEBUG [org.pentaho.plugin.kettle.KettleComponent] ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction Starting transformation
2006-07-24 16:37:27,578 INFO [Java Script Value zcwms921700.0] Java Script Value zcwms921700.0 - Starting to run...
2006-07-24 16:37:27,578 INFO [Select values.0] Select values.0 - Starting to run...
2006-07-24 16:37:27,578 INFO [Table input zcwms921700 AS400.0] Table input zcwms921700 AS400.0 - Starting to run...
2006-07-24 16:37:27,578 INFO [Merge Rows.0] Merge Rows.0 - Starting to run...
2006-07-24 16:37:27,578 INFO [IF DELETE.0] IF DELETE.0 - Starting to run...
2006-07-24 16:37:27,578 INFO [remove flag.0] remove flag.0 - Starting to run...
2006-07-24 16:37:27,578 INFO [Insert / Update.0] Insert / Update.0 - Starting to run...
2006-07-24 16:37:27,593 INFO [Delete.0] Delete.0 - Starting to run...
2006-07-24 16:37:27,593 INFO [Table input zcwms921700 mysql.0] Table input zcwms921700 mysql.0 - Starting to run...
2006-07-24 16:37:27,593 INFO [Select values 2.0] Select values 2.0 - Starting to run...
2006-07-24 16:37:27,593 INFO [Sort rows AS400.0] Sort rows AS400.0 - Starting to run...
2006-07-24 16:37:27,593 DEBUG [org.pentaho.plugin.kettle.KettleComponent] ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction Transformation running
2006-07-24 16:37:27,609 INFO [Sort rows mysql.0] Sort rows mysql.0 - Starting to run...
2006-07-24 16:37:27,609 INFO [Table input zcwms921700 mysql.0] Table input zcwms921700 mysql.0 - Finished reading query, closing connection.
2006-07-24 16:37:27,625 INFO [Select values 2.0] Select values 2.0 - Finished processing (I=0, O=0, R=43, W=43, U=0, E=0
2006-07-24 16:37:27,625 INFO [Sort rows mysql.0] Sort rows mysql.0 - Finished processing (I=0, O=0, R=43, W=43, U=0, E=0
2006-07-24 16:37:27,625 INFO [Table input zcwms921700 mysql.0] Table input zcwms921700 mysql.0 - Finished processing (I=43, O=0, R=0, W=43, U=0, E=0
2006-07-24 16:37:28,000 INFO [Table input zcwms921700 AS400.0] Table input zcwms921700 AS400.0 - Finished reading query, closing connection.
2006-07-24 16:37:28,015 INFO [Table input zcwms921700 AS400.0] Table input zcwms921700 AS400.0 - Finished processing (I=62, O=0, R=0, W=62, U=0, E=0
2006-07-24 16:37:28,015 INFO [Java Script Value zcwms921700.0] Java Script Value zcwms921700.0 - Finished processing (I=0, O=0, R=62, W=62, U=0, E=0
2006-07-24 16:37:28,015 INFO [Select values.0] Select values.0 - Finished processing (I=0, O=0, R=62, W=62, U=0, E=0
2006-07-24 16:37:28,015 INFO [Sort rows AS400.0] Sort rows AS400.0 - Finished processing (I=0, O=0, R=62, W=62, U=0, E=0
2006-07-24 16:37:28,015 INFO [Merge Rows.0] Merge Rows.0 - Finished processing (I=0, O=0, R=105, W=62, U=0, E=0
2006-07-24 16:37:28,015 INFO [IF DELETE.0] IF DELETE.0 - Finished processing (I=0, O=0, R=62, W=62, U=0, E=0
2006-07-24 16:37:28,015 INFO [remove flag.0] remove flag.0 - Finished processing (I=0, O=0, R=62, W=62, U=0, E=0
2006-07-24 16:37:28,031 INFO [Delete.0] Delete.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0
2006-07-24 16:37:28,750 INFO [Insert / Update.0] Insert / Update.0 - Finished processing (I=62, O=19, R=62, W=0, U=0, E=0
2006-07-24 16:37:28,890 INFO [zcwms921700] zcwms921700 - Transformation ended.
2006-07-24 16:37:28,890 INFO [org.pentaho.plugin.kettle.KettleComponent] ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction START
2006/07/24 16:37:27 - zcwms921700 - Dispatching started for transformation [zcwms921700]
2006/07/24 16:37:27 - zcwms921700 - This is not a replay transformation
2006/07/24 16:37:27 - zcwms921700 - This transformation can be replayed with replay date: 2006/07/24 16:37:27
2006/07/24 16:37:27 - zcwms921700 - Initialising 12 steps...
2006/07/24 16:37:27 - Delete.0 - Connected to database...
2006/07/24 16:37:27 - ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction Looking for step importer
2006/07/24 16:37:27 - ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction Kettle.ERROR_0012 - Could not set up row listener
2006/07/24 16:37:27 - ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction Starting transformation
2006/07/24 16:37:27 - Java Script Value zcwms921700.0 - Starting to run...
2006/07/24 16:37:27 - Select values.0 - Starting to run...
2006/07/24 16:37:27 - Table input zcwms921700 AS400.0 - Starting to run...
2006/07/24 16:37:27 - Merge Rows.0 - Starting to run...
2006/07/24 16:37:27 - IF DELETE.0 - Starting to run...
2006/07/24 16:37:27 - remove flag.0 - Starting to run...
2006/07/24 16:37:27 - Insert / Update.0 - Starting to run...
2006/07/24 16:37:27 - Delete.0 - Starting to run...
2006/07/24 16:37:27 - Table input zcwms921700 mysql.0 - Starting to run...
2006/07/24 16:37:27 - Select values 2.0 - Starting to run...
2006/07/24 16:37:27 - Sort rows AS400.0 - Starting to run...
2006/07/24 16:37:27 - ed8923cd-1b21-11db-b535-d14d49f9d346:COMPONENT:context-8696763-1153751847062:zcwms921.xaction Transformation running
2006/07/24 16:37:27 - Sort rows mysql.0 - Starting to run...
2006/07/24 16:37:27 - Table input zcwms921700 mysql.0 - Finished reading query, closing connection.
2006/07/24 16:37:27 - Select values 2.0 - Finished processing (I=0, O=0, R=43, W=43, U=0, E=0
2006/07/24 16:37:27 - Sort rows mysql.0 - Finished processing (I=0, O=0, R=43, W=43, U=0, E=0
2006/07/24 16:37:27 - Table input zcwms921700 mysql.0 - Finished processing (I=43, O=0, R=0, W=43, U=0, E=0
2006/07/24 16:37:28 - Table input zcwms921700 AS400.0 - Finished reading query, closing connection.
2006/07/24 16:37:28 - Table input zcwms921700 AS400.0 - Finished processing (I=62, O=0, R=0, W=62, U=0, E=0
2006/07/24 16:37:28 - Java Script Value zcwms921700.0 - Finished processing (I=0, O=0, R=62, W=62, U=0, E=0
2006/07/24 16:37:28 - Select values.0 - Finished processing (I=0, O=0, R=62, W=62, U=0, E=0
2006/07/24 16:37:28 - Sort rows AS400.0 - Finished processing (I=0, O=0, R=62, W=62, U=0, E=0
2006/07/24 16:37:28 - Merge Rows.0 - Finished processing (I=0, O=0, R=105, W=62, U=0, E=0
2006/07/24 16:37:28 - IF DELETE.0 - Finished processing (I=0, O=0, R=62, W=62, U=0, E=0
2006/07/24 16:37:28 - remove flag.0 - Finished processing (I=0, O=0, R=62, W=62, U=0, E=0
2006/07/24 16:37:28 - Delete.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0
2006/07/24 16:37:28 - Insert / Update.0 - Finished processing (I=62, O=19, R=62, W=0, U=0, E=0
2006/07/24 16:37:28 - zcwms921700 - Transformation ended.

2006-07-24 16:37:28,890 INFO [LocalVariables!!!!!!!] LocalVariables!!!!!!! - The variables you are trying to remove, do not exist for thread [zcwms921700]
2006-07-24 16:37:28,890 INFO [LocalVariables!!!!!!!] LocalVariables!!!!!!! - Please report this error to the Kettle developers. http://forums.pentaho.org/archived_att/files/zcwms921700.xml

Post edited by: begunrom, at: 07/24/2006 10:53

jdixon
07-25-2006, 05:23 PM
Hi,

The message means that your action sequence has an 'importstep' defined in the 'component-definition' for you Kettle component. The importstep is used to import data from the Kettle transformation into an action sequence to be used for content generation or in a business rule.



<action-definition>
<component-name>KettleComponent</component-name>
...
<component-definition>
<importstep>XML Output</importstep>
</component-definition>
</action-definition>


You have probably copied one of the sample Kettle action sequences that uses the import step.

Remove the 'importstep' node and this error will go away.



<action-definition>
<component-name>KettleComponent</component-name>
...
<component-definition>
</component-definition>
</action-definition>


James

begunrom
07-26-2006, 03:51 AM
Thank you,
It works.