Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: executeUpdate method must not return a result set

  1. #1

    Default executeUpdate method must not return a result set

    I am writing a Insert/Update transformation in Kettle (3.0 GA) and I am receiving this error message: "executeUpdate method must not return a result set". I have tried to recreate the transformation with a currently working one using the same connections to no avail.

    This was noted in another post in the BI forum, but it might not apply here.
    http://forums.pentaho.org/showthread...749#post165749


    From what I have read on the jTDS site it is the number of rows about to be Insert/Updated being returned before the Insert is executed that causes the error.
    http://jtds.sourceforge.net/faq.html#expectingResultSet

    The odd part is I have other transformations working in the same structure without issue.

    Here is my transformation with the user/password's removed:
    <?xml version="1.0" encoding="UTF-8"?>
    <transformation>
    <info>
    <name>Inventory Items</name>
    <description/>
    <extended_description>Add Receiving to the location constraint and this should work.</extended_description>
    <trans_version/>
    <filename>C:\Work\Asset Management\Trans Old Magic Inventory Items.ktr</filename>
    <trans_status>0</trans_status>
    <directory>&#47;</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>
    </slaveservers>
    <clusterschemas>
    </clusterschemas>
    <modified_user>-</modified_user>
    <modified_date>2007&#47;10&#47;02 13:50:00.667</modified_date>
    </info>
    <notepads>
    </notepads>
    <connection>
    <name>New Environment</name>
    <server>DAS1105</server>
    <type>MSSQL</type>
    <access>Native</access>
    <database>AssetManSandbox</database>
    <port>1433</port>
    <username></username>
    <password>Encrypted </password>
    <servername/>
    <data_tablespace/>
    <index_tablespace/>
    <attributes>
    <attribute><code>EXTRA_OPTION_MSSQL.Domain</code><attribute>admin</attribute></attribute>
    <attribute><code>EXTRA_OPTION_MSSQL.instance</code><attribute>SDE</attribute></attribute>
    <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
    <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
    <attribute><code>INITIAL_POOL_SIZE</code><attribute>5</attribute></attribute>
    <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
    <attribute><code>MAXIMUM_POOL_SIZE</code><attribute>10</attribute></attribute>
    <attribute><code>MSSQL_DOUBLE_DECIMAL_SEPARATOR</code><attribute>N</attribute></attribute>
    <attribute><code>PORT_NUMBER</code><attribute>1433</attribute></attribute>
    <attribute><code>QUOTE_ALL_FIELDS</code><attribute>Y</attribute></attribute>
    <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
    <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
    </attributes>
    </connection>
    <connection>
    <name>Old Magic</name>
    <server>SQLCL01</server>
    <type>MSSQL</type>
    <access>Native</access>
    <database>magicdb</database>
    <port>1433</port>
    <username></username>
    <password>Encrypted </password>
    <servername/>
    <data_tablespace/>
    <index_tablespace/>
    <attributes>
    <attribute><code>EXTRA_OPTION_MSSQL.Domain</code><attribute>admin</attribute></attribute>
    <attribute><code>EXTRA_OPTION_MSSQL.instance</code><attribute>DBS01</attribute></attribute>
    <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
    <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
    <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
    <attribute><code>MAXIMUM_POOL_SIZE</code><attribute>10</attribute></attribute>
    <attribute><code>MSSQL_DOUBLE_DECIMAL_SEPARATOR</code><attribute>N</attribute></attribute>
    <attribute><code>PORT_NUMBER</code><attribute>1433</attribute></attribute>
    <attribute><code>QUOTE_ALL_FIELDS</code><attribute>Y</attribute></attribute>
    <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
    <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
    </attributes>
    </connection>
    <order>
    <hop> <from>Old Inventory Items</from><to>Insert &#47; Update Inventory Items</to><enabled>Y</enabled> </hop> </order>
    <step>
    <name>Old Inventory Items</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
    <partitioning>
    <method>none</method>
    <schema_name/>
    </partitioning>
    <connection>Old Magic</connection>
    <sql>select [SEQUENCE]
    ,[LASTMODIFIED]
    ,[LASTUSER]
    ,[_GROUP_]
    ,[PART #]
    ,[SERIAL]
    ,[ASSET#]
    ,[VENDOR]
    ,[INVOICE]
    ,[QTY]
    ,[CONFIG]
    ,[INSTALLED]
    ,[STATUS:]
    ,[_INACTIVE_:]
    ,0 AS ISCRITICAL

    FROM &quot;_SMDBA_&quot;.&quot;_INVENTOR_&quot;

    WHERE [LASTMODIFIED] &gt;= &apos;2007-01-01&apos;
    and [ASSET#] BETWEEN &apos;300000&apos; and &apos;400000&apos;
    and [VENDOR] = &apos;85&apos;

    </sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <cluster_schema/>
    <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
    <xloc>204</xloc>
    <yloc>157</yloc>
    <draw>Y</draw>
    </GUI>
    </step>

    <step>
    <name>Insert &#47; Update Inventory Items</name>
    <type>InsertUpdate</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
    <partitioning>
    <method>none</method>
    <schema_name/>
    </partitioning>
    <connection>New Environment</connection>
    <commit>100</commit>
    <update_bypassed>N</update_bypassed>
    <lookup>
    <schema/>
    <table>&quot;_SMDBA_&quot;.&quot;_INVENTOR_&quot;</table>
    <key>
    <name>SEQUENCE</name>
    <field>SEQUENCE</field>
    <condition>=</condition>
    <name2/>
    </key>
    <value>
    <name>SEQUENCE</name>
    <rename>SEQUENCE</rename>
    <update>Y</update>
    </value>
    <value>
    <name>LASTMODIFIED</name>
    <rename>LASTMODIFIED</rename>
    <update>Y</update>
    </value>
    <value>
    <name>LASTUSER</name>
    <rename>LASTUSER</rename>
    <update>Y</update>
    </value>
    <value>
    <name>_GROUP_</name>
    <rename>_GROUP_</rename>
    <update>Y</update>
    </value>
    <value>
    <name>PART #</name>
    <rename>PART #</rename>
    <update>Y</update>
    </value>
    <value>
    <name>SERIAL</name>
    <rename>SERIAL</rename>
    <update>Y</update>
    </value>
    <value>
    <name>ASSET#</name>
    <rename>ASSET#</rename>
    <update>Y</update>
    </value>
    <value>
    <name>VENDOR</name>
    <rename>VENDOR</rename>
    <update>Y</update>
    </value>
    <value>
    <name>INVOICE</name>
    <rename>INVOICE</rename>
    <update>Y</update>
    </value>
    <value>
    <name>QTY</name>
    <rename>QTY</rename>
    <update>Y</update>
    </value>
    <value>
    <name>CONFIG</name>
    <rename>CONFIG</rename>
    <update>Y</update>
    </value>
    <value>
    <name>INSTALLED</name>
    <rename>INSTALLED</rename>
    <update>Y</update>
    </value>
    <value>
    <name>STATUS:</name>
    <rename>STATUS:</rename>
    <update>Y</update>
    </value>
    <value>
    <name>_INACTIVE_:</name>
    <rename>_INACTIVE_:</rename>
    <update>Y</update>
    </value>
    <value>
    <name>ISCRITICAL</name>
    <rename>ISCRITICAL</rename>
    <update>Y</update>
    </value>
    </lookup>
    <cluster_schema/>
    <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
    <xloc>349</xloc>
    <yloc>157</yloc>
    <draw>Y</draw>
    </GUI>
    </step>

    <step_error_handling>
    </step_error_handling>
    <slave-step-copy-partition-distribution>
    </slave-step-copy-partition-distribution>
    <slave_transformation>N</slave_transformation>
    </transformation>

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Please attach the transformation, it's unreadable in clear-text because of some HTML op-codes.

    Thanks,
    Matt

  3. #3

    Default Sorry

    Hope this works
    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.