Hitachi Vantara Pentaho Community Forums
Page 1 of 3 123 LastLast
Results 1 to 10 of 30

Thread: Wrong timestamp Information

  1. #1
    Join Date
    Mar 2010
    Posts
    181

    Default Wrong timestamp Information

    Get File Names step displays wrong time stamp information when I pull the files from a remote server. It adds 6 hours to the actual time stamp. Any idea ?


    Name:  linuxTimeStamp.jpg
Views: 38
Size:  30.5 KBName:  SpoonTimeStamp.jpg
Views: 34
Size:  14.2 KB

  2. #2
    Join Date
    Mar 2010
    Posts
    181

    Default

    More information....

    If I map the network drive (source folder for the files) then it shows the correct time stamp with seconds and milli-seconds. Whereas, If I use ftp URI, it adds 6 hrs to the original time stamp...Interesting !!

  3. #3
    Join Date
    Apr 2008
    Posts
    4,689

    Default

    Do you have a timezone difference by chance?
    ie. Is FTP using GMT while your workstation is using a different timezone?

  4. #4
    Join Date
    Mar 2010
    Posts
    181

    Default

    No both are same time zone.

  5. #5
    Join Date
    Apr 2008
    Posts
    4,689

    Default

    What time zone?

  6. #6
    Join Date
    Mar 2010
    Posts
    181

    Default

    Mst

  7. #7
    Join Date
    Apr 2008
    Posts
    4,689

    Default

    If you said MDT, then the 6 hours would make sense... MDT is GMT-6
    I bet that if you did a full directory listing in a FTP client, you would see the other timezone in the FTP client as well.

  8. #8
    Join Date
    Mar 2010
    Posts
    181

    Default

    our sys admin verified that this is set to MDT. IS there a way this can be manipulated in Spoon and how ?

    Thanks for your quick responses. Appreciate your help.

  9. #9
    Join Date
    Apr 2008
    Posts
    4,689

    Default

    I'm willing to bet that the FTP service is giving you times in UTC, while your mapped folders are giving it to you in MDT.
    Depending on how you are using these timestamps, UTC may be more useful for you as it doesn't move around (there is not DT <-> ST switch in UTC)
    On the other hand, it may cause problems, since PDI takes time very seriously (look at time zone issues on the board - PDI will get very mad at you if you try to use a time that doesn't exist...)

    Can you try a listing using another FTP client (eg. Windows ftp.exe), to see if the FTP server is giving you UTC times?

  10. #10
    Join Date
    Mar 2010
    Posts
    181

    Default

    Yes I tried Filezila, WinScp and everything displays in MDT. I also remote logged in and got this

    $ date
    Thu Jun 9 14:06:44 MDT 2011

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.