LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Error "month value out of range" (DB Query)

    Employee
    Posted 08-01-2013 08:33

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: SambaDancer

    Dear all,
    I have been given a Firebird database + ODBC driver.
    I can connect to this database through the DB Query node and import some data.
    In some fields in some tables, however, I'm getting the error "month value out of range" (full error message below).
    Then, I just get the familiar red cross and no data is imported.
    Could someone please help me out, this is driving me nuts.
    Is there a way to simply import everything as text so at least I get to see the data?
    Is there a way to separate the good from the bad data?
    Thanks so much in advance!
    Best regards, Bart.

    ERROR processing data:
    month value out of range: 4294967295 [0,11]
    2013-08-01 17:20:36.000; WARN: month value out of range: 4294967295 [0,11]
    id: 0 chain: 0 group: 0
    cppDetail: context: JJulianCalendar::set() .\misc\JJulianCalendar.cpp@425

    2013-08-01 17:20:36.000; ERROR: ERROR processing data:
    month value out of range: 4294967295 [0,11]
    id: 0 chain: 0 group: 0
    cppDetail: context: Salmon::NED::NodeMain::errorMsg() .\NodeMain.cpp@28


  • 2.  RE: Error "month value out of range" (DB Query)

    Employee
    Posted 08-02-2013 05:03

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: SambaDancer

    Ok, I have solved this myself. If I make the select statement as follows, I get the time as a string:

    select CAST(MessedUpTimeField as char(13))
    from Table_Name