Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Date error oracle -> pdi

  1. #1

    Exclamation Date error oracle -> pdi

    I have a base of sales per day in ORACLE, the field is dt_emis '10/10/2010'(dd/mm/yyyy) but when I run the transformation in SPOON, this field returns '09/10/2010 23:00:00,000 '(dd/mm/yyyy HH24:mi:SS.), I did some tests with the step "Table Input", ran a preview for this date only in select, put "where trunc(DT_EMIS)=to_date('10/10/2010','dd/mm/yyyy')" and "preview" returns the rows, but the result for the same column appears "09/10/2010 23:00:00.000". I've tested in both 4.1.0 Stable, 4.0.0 Stable and 3.2.0GA.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    The only thing I can think of is TimeZones.
    If your DB is in one TimeZone and your PDI is in another...
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  3. #3
    Join Date
    Feb 2012
    Posts
    1

    Default Oracle date problem in PDI

    I've the same problem. Someone have a solution?

  4. #4

    Default

    Not have the solution, but we identified the cause: the error occurs only on the day that daylight saving time starts when the microsoft windows comes in daylight saving time.
    In Brazil errors occurred: 14/10/2007, 19/10/2008, 18/10/2009, 17/10/2010, 16/10/2011 and earlier also.
    source:http://pt.wikipedia.org/wiki/Anexo:L...%A3o_no_Brasil

  5. #5
    Join Date
    Apr 2007
    Posts
    2,010

    Default

    is your jvm up to date? Oracle actually let you download patched java timezone info if it isnt ( tzupdater), or of course just update your jvm. I had a similar weirdy jvm / oracle timezone mismatch problem too.

  6. #6

    Default

    C:\Users\mmaekawa>java -version
    java version "1.6.0_26"
    Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
    Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode)

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.