Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Mysterious "tablename not defined" error in Ubuntu Linux but not Windows XP?

  1. #1

    Question Mysterious "tablename not defined" error in Ubuntu Linux but not Windows XP?

    hello,

    I have developed a rather simple CSV to Database transformation, using Table Output with statically defined (not from field) table name as the final output step.

    Transformation works fine in Windows XP (32-bit), but in Ubuntu 12.04 (64-bit), it fails and I am getting the following error. The same database server, destination table, and user credentials are used in both cases (this is all happening in my development environment). I checked all the obvious things like permissions, correct version of code, etc, but nothing seems out of place. What could cause something like this?

    Code:
    ERROR 02-09 15:24:12,414 - _etl_stage1 - org.pentaho.di.core.exception.KettleStepException:
    The tablename is not defined (empty)
    
    
            at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:259)
            at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128)
            at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
            at java.lang.Thread.run(Thread.java:722)
    Pentaho Version is CE 4.3.0-Stable.
    MySQL version is 5.6.6 (DEV version) running on XP.
    Database connections are "simple-jndi".

    A snippet of the transformation .ktr is copied below
    Code:
      <step>
        <name>_etl_stage1</name>
        <type>TableOutput</type>
        <description/>
        <distribute>Y</distribute>
        <copies>1</copies>
             <partitioning>
               <method>none</method>
               <schema_name/>
               </partitioning>
        <connection>CTC</connection>
        <schema/>
        <table>_etl_stage1</table>
        <commit>1000</commit>
        <truncate>N</truncate>
        <ignore_errors>N</ignore_errors>
        <use_batch>Y</use_batch>
        <specify_fields>Y</specify_fields>
        <partitioning_enabled>Y</partitioning_enabled>
        <partitioning_field/>
        <partitioning_daily>N</partitioning_daily>
        <partitioning_monthly>Y</partitioning_monthly>

  2. #2

    Default

    PROBLEM SOLVED. I guess I must have accidentally clicked the "Partition Table" right before I exported to the Linux box.

Tags for this Thread

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.