Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: transformation crsahing

  1. #1

    Default transformation crashing

    Hi,

    i have the following trans which is crashing spoon when launched and i have this in the log

    Code:
    2007-07-13 10:33:32,937 INFO  [Spoon] Spoon - Chargement transformation [crash]...
    2007-07-13 10:33:32,953 INFO  [Spoon] Spoon - Lexécution de la transformation démarrée.
    2007-07-13 10:33:33,000 INFO  [crash] crash - Distribution démarrée pour la tranformation [crash]
    2007-07-13 10:33:33,000 INFO  [crash] crash - Nombre d'arguments détectés:10 
    2007-07-13 10:33:33,343 ERROR [CNX_KHEOPS] CNX_KHEOPS - Can't turn auto commit off
    2007-07-13 10:33:33,984 ERROR [Spoon] Spoon - PDI a rencontré une erreur inattendue: veuillez svp fermer toutes le fenêtres avant d'arrêter PDI! 
    Failed to execute runnable (java.lang.IllegalArgumentException: Index out of bounds)
    2007-07-13 10:33:33,984 ERROR [Spoon] Spoon - org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.IllegalArgumentException: Index out of bounds)
        at org.eclipse.swt.SWT.error(SWT.java:3499)
        at org.eclipse.swt.SWT.error(SWT.java:3422)
        at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:126)
        at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3650)
        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3287)
        at be.ibridge.kettle.spoon.Spoon.readAndDispatch(Spoon.java:964)
        at be.ibridge.kettle.spoon.Spoon.main(Spoon.java:7325)
    Caused by: java.lang.IllegalArgumentException: Index out of bounds
        at org.eclipse.swt.SWT.error(SWT.java:3483)
        at org.eclipse.swt.SWT.error(SWT.java:3422)
        at org.eclipse.swt.SWT.error(SWT.java:3393)
        at org.eclipse.swt.widgets.Widget.error(Widget.java:432)
        at org.eclipse.swt.widgets.Table.getItem(Table.java:2056)
        at be.ibridge.kettle.spoon.SpoonLog.refreshView(SpoonLog.java:753)
        at be.ibridge.kettle.spoon.SpoonLog.access$600(SpoonLog.java:79)
        at be.ibridge.kettle.spoon.SpoonLog$4.run(SpoonLog.java:331)
        at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
        at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:123)
        ... 4 more
    Any idea about this ??

    Here is the simple trans reading from database and writing to staging table

    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <transformation>
      <info>
        <name>crash</name>
        <description/>
        <extended_description/>
        <trans_version/>
        <trans_status>0</trans_status>
        <directory>/</directory>
        <log>
          <read/>
          <write/>
          <input/>
          <output/>
          <update/>
          <rejected/>
          <connection/>
          <table/>
          <use_batchid>Y</use_batchid>
          <use_logfield>N</use_logfield>
        </log>
        <maxdate>
          <connection/>
          <table/>
          <field/>
          <offset>0.0</offset>
          <maxdiff>0.0</maxdiff>
        </maxdate>
        <size_rowset>1000</size_rowset>
        <sleep_time_empty>1</sleep_time_empty>
        <sleep_time_full>1</sleep_time_full>
        <unique_connections>N</unique_connections>
        <feedback_shown>Y</feedback_shown>
        <feedback_size>5000</feedback_size>
        <using_thread_priorities>N</using_thread_priorities>
        <shared_objects_file/>
        <dependencies>
        </dependencies>
        <partitionschemas>
        </partitionschemas>
        <slaveservers>
             <slaveserver><name>localhost</name><hostname>127.0.0.1</hostname><port>80</port><username>cluster</username><password>Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8</password><proxy_hostname/><proxy_port/><non_proxy_hosts/><master>Y</master></slaveserver>
        </slaveservers>
        <clusterschemas>
        </clusterschemas>
      <modified_user>admin</modified_user>
      <modified_date>2007/07/13 10:32:27.312</modified_date>
      </info>
      <notepads>
      </notepads>
      <order>
      <hop> <from>Extraction depuis table</from><to>Insertion dans table</to><enabled>Y</enabled> </hop>  </order>
      <step>
        <name>Extraction depuis table</name>
        <type>TableInput</type>
        <description/>
        <distribute>Y</distribute>
        <copies>1</copies>
             <partitioning>
               <method>none</method>
               <field_name/>
               <schema_name/>
               </partitioning>
        <connection>CNX_KHEOPS</connection>
        <sql>SELECT *
    FROM exa</sql>
        <limit>0</limit>
        <lookup/>
        <execute_each_row>N</execute_each_row>
        <variables_active>N</variables_active>
         <cluster_schema/>
        <GUI>
          <xloc>114</xloc>
          <yloc>121</yloc>
          <draw>Y</draw>
          </GUI>
        </step>
    
      <step>
        <name>Insertion dans table</name>
        <type>TableOutput</type>
        <description/>
        <distribute>Y</distribute>
        <copies>1</copies>
             <partitioning>
               <method>none</method>
               <field_name/>
               <schema_name/>
               </partitioning>
        <connection>STAGING sur vivianite</connection>
        <schema/>
        <table>STG_KHEOPS_EXA</table>
        <commit>100</commit>
        <truncate>Y</truncate>
        <ignore_errors>N</ignore_errors>
        <use_batch>Y</use_batch>
        <partitioning_enabled>N</partitioning_enabled>
        <partitioning_field/>
        <partitioning_daily>N</partitioning_daily>
        <partitioning_monthly>Y</partitioning_monthly>
        <tablename_in_field>N</tablename_in_field>
        <tablename_field/>
        <tablename_in_table>Y</tablename_in_table>
        <return_keys>N</return_keys>
        <return_field/>
         <cluster_schema/>
        <GUI>
          <xloc>324</xloc>
          <yloc>96</yloc>
          <draw>Y</draw>
          </GUI>
        </step>
    
      <step_error_handling>
      </step_error_handling>
    </transformation>
    Last edited by greatmaster1971; 07-13-2007 at 05:10 AM.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    - Which version of PDI?
    - Does it happen always, or only at random?

    At first sight it looks like one of the steps bomb out and the logviewer can't find the step anymore.

    Regards,
    Sven

  3. #3

    Default

    Quote Originally Posted by sboden View Post
    - Which version of PDI?
    1.5.0
    - Does it happen always, or only at random?
    it always happens
    Target database is mysql 4.0

    At first sight it looks like one of the steps bomb out and the logviewer can't find the step anymore.

    Regards,
    Sven
    can't figure out why ...

  4. #4

    Default

    When turning logs to Nothing then the transformation ran ok ...
    Why logviewer is crashing transfo ?

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.