Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: transform Error,help me

  1. #1
    Join Date
    Jun 2007
    Posts
    12

    Default transform Error,help me

    When I run my transform,I meet a error,pls help me.

    18:02:56,652 INFO [biserver] biserver - Setting preparedStatement to [SELECT `tournum ` FROM rpt_tour_panticipant_daily WHERE tourtime = ? AND userid = ? ]
    18:02:56,779 INFO [biserver] biserver - Setting update preparedStatement to [UPDATE rpt_tour_panticipant_daily
    SET `tournum ` = ?
    WHERE tourtime = ? AND userid = ? ]
    18:02:56,795 INFO [0] ??.0 - Checking row: [userid=19744, tournum =, othernum= 71, tourtime=2007-09-04]
    18:02:56,795 DEBUG [0] ??.0 - Field [tourtime] has nr. 3
    18:02:56,796 DEBUG [0] ??.0 - Field [userid] has nr. 0
    18:02:56,797 DEBUG [0] ??.0 - Field [tournum ] has nr. 1
    18:02:56,798 DEBUG [0] ??.0 - Values set for lookup: [tourtime=2007-09-04, userid=19744], input row: [userid=19744, tournum =, othernum= 71, tourtime=2007-09-04]
    18:02:56,799 ERROR [0] ??.0 - Error in step, asking everyone to stop because of:
    Error looking up row in database (pstmt.executeQuery())
    Unknown column 'tournum ' in 'field list'

    18:02:56,799 INFO [dbserver] dbserver - Statement canceled!
    18:02:56,799 INFO [dbserver] dbserver - Statement canceled!
    18:02:56,800 DEBUG [0] ??.0 - Signaling 'output done' to 0 output rowsets.
    Attached Files Attached Files

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

    Default

    A hunch ... the space after tournum is causing you problems.

    Regards,
    Sven

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.