Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Kettle - Could not setup row listener

  1. #1
    Join Date
    Jan 2006
    Posts
    313

    Default Kettle - Could not setup row listener

    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_a...cwms921700.xml

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

  2. #2
    jdixon Guest

    Default Re:Kettle - Could not setup row listener

    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.

    Code:
        <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.

    Code:
        <action-definition>
          <component-name>KettleComponent</component-name>
    ...
          <component-definition>
          </component-definition> 
        </action-definition>
    James

  3. #3
    Join Date
    Jan 2006
    Posts
    313

    Default Re:Kettle - Could not setup row listener

    Thank you,
    It works.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.