🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Write database - Add generated primary keys

User: "miguelal"
New Altair Community Member
Updated by Jocelyn
Hi,

Since I upgraded to the latest release of RapidMiner (5.3.005) I seem to keep on getting the error below every time I try to use the option "add generated primary keys" of the Write Database operator. We are connecting to SQL Server 2008 R2, and using the JTDS driver.

Feb 13, 2013 9:20:30 PM SEVERE: Process failed: Database error occurred: A statement attempted to return a result set in executeBatch().

But as soon as we go back to the previous RapidMiner version (5.2), or I disable the "add generated primary keys" option, this problem goes away. This is the XML for the operator:

              <operator activated="true" class="write_database" compatibility="5.3.005" expanded="true" height="60" name="Write Database" width="90" x="45" y="210">
                <parameter key="connection" value="GOGLDB"/>
                <parameter key="table_name" value="BATCH"/>
                <parameter key="overwrite_mode" value="append"/>
                <parameter key="add_generated_primary_keys" value="true"/>
                <parameter key="db_key_attribute_name" value="BATCH_ID"/>
              </operator>
Has anybody come across this issue?

Thanks,
Miguel

Find more posts tagged with

Sort by:
1 - 4 of 41
    User: "Nils_Woehler"
    New Altair Community Member
    Hi Miguel,

    this indeed seem to be a bug. I've filed a internal issue for this.

    Best,
    Nils
    User: "miguelal"
    New Altair Community Member
    OP
    Thanks a lot for the prompt response!
    User: "miguelal"
    New Altair Community Member
    OP
    Any idea when this issue might get fixed?
    I tried the latest version, and I think it is still happening.
    Is there anything I can do to help?

    Thanks,
    Miguel
    User: "Nils_Woehler"
    New Altair Community Member
    Hi Miguel,

    the ticket is still open and hasn't been fixed yet. I will leave a message in this thread once this is done.

    Best,
    Nils