Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Junk dimension problem

  1. #1

    Default Junk dimension problem

    Hi,

    i have the transormation described in PNG attached bellow.
    When i run the transformation Spoon crashes.
    When i try previewing it's running OK.

    Any thoughts ???

    Eric
    Attached Images Attached Images   

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

    Default

    No idea like that... what's the stacktrace? and maybe attach a sanitized version of your ktr.

    Regards,
    Sven

  3. #3

    Default

    Here is the .ktr file
    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <transformation>
      <info>
        <name>EXA_DIM_UO_KHEOPS</name>
        <description/>
        <extended_description/>
        <trans_version/>
        <trans_status>0</trans_status>
        <directory>/EXAMENS/BASE_PILOTAGE/ENTREPOT</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/12 18:40:06.796</modified_date>
      </info>
      <notepads>
      </notepads>
      
      <order>
      <hop> <from>Extraction depuis table</from><to>Combinaison recherche / Mise à jour</to><enabled>Y</enabled> </hop>  </order>
      <step>
        <name>Combinaison recherche / Mise à jour</name>
        <type>CombinationLookup</type>
        <description/>
        <distribute>Y</distribute>
        <copies>1</copies>
             <partitioning>
               <method>none</method>
               <field_name/>
               <schema_name/>
               </partitioning>
          <schema/>
          <table>EXA_UNITE_OP</table>
          <connection>DB2_PIAD_DWH45</connection>
          <commit>100</commit>
          <cache_size>9999</cache_size>
          <replace>N</replace>
          <crc>Y</crc>
          <crcfield>uop_hashcode</crcfield>
          <fields>
            <key>
              <name>uop_segeco</name>
              <lookup>uop_segeco</lookup>
            </key>
            <key>
              <name>uop_loc</name>
              <lookup>uop_loc</lookup>
            </key>
            <return>
              <name>uop_id</name>
              <creation_method>tablemax</creation_method>
              <use_autoinc>N</use_autoinc>
            </return>
          </fields>
          <sequence/>
         <cluster_schema/>
        <GUI>
          <xloc>305</xloc>
          <yloc>186</yloc>
          <draw>Y</draw>
          </GUI>
        </step>
    
      <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>STAGING sur vivianite</connection>
        <sql>SELECT distinct 
    segeco as uop_segeco
    ,loc as uop_loc
    FROM STG_KHEOPS_DEP
    </sql>
        <limit>0</limit>
        <lookup/>
        <execute_each_row>N</execute_each_row>
        <variables_active>N</variables_active>
         <cluster_schema/>
        <GUI>
          <xloc>89</xloc>
          <yloc>133</yloc>
          <draw>Y</draw>
          </GUI>
        </step>
    
      <step_error_handling>
      </step_error_handling>
    </transformation>
    Attached Files Attached Files

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.