Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Error with delete step

  1. #1

    Default Error with delete step

    My column name from the database has a space in it (Id Datum). Could this be the reason for the following error? This is 2.5.1.

    2007/09/18 09:07:08 - datawarehouse - Setting update preparedStatement to [DELETE FROM F_kosten
    2007/09/18 09:07:08 - datawarehouse - WHERE Id Datum >= ? ]
    2007/09/18 09:07:08 - Delete.0 - Checking row: [startdatum=2007/09/01 00:00:00.000, enddatum=2007/09/30 23:59:59.999, Id Monatsanfang=244]
    2007/09/18 09:07:08 - Delete.0 - Field [Id Monatsanfang] has nr. 2
    2007/09/18 09:07:08 - Delete.0 - Values set for delete: [Id Monatsanfang=244], input row: [startdatum=2007/09/01 00:00:00.000, enddatum=2007/09/30 23:59:59.999, Id Monatsanfang=244]
    2007/09/18 09:07:08 - Delete.0 - ERROR (version 2.5.1, build 1 from 2007/09/18 09:01:09) : Error in step, asking everyone to stop because of:
    2007/09/18 09:07:08 - Delete.0 - ERROR (version 2.5.1, build 1 from 2007/09/18 09:01:09) : Error inserting row
    2007/09/18 09:07:08 - Delete.0 - ERROR (version 2.5.1, build 1 from 2007/09/18 09:01:09) : Line 2: Incorrect syntax near 'Datum'.

    Thanks,
    Tobias

  2. #2

    Default Buuug :-)

    oohh, and yes, this is a bug. if I add quotes around my column name, as seen in the picture, everything works.

    By the way, I already reported this way back, here:

    http://www.javaforge.com/proj/tracke...e&task_id=4577

    Thanks,
    Tobias
    Attached Images Attached Images  

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

    Default

    It is automatically fixed in v3

    Regards,
    Sven

  4. #4

    Default

    Cool, I can live with adding quotes until then.

    Thanks!

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.