Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: timezone setting in PDI-CE-5.3

  1. #1
    Join Date
    Aug 2015

    Default timezone setting in PDI-CE-6.0


    I am facing issue with timezone settings while retrieving data from Source. my target DB exist on my local machine, when i check timezone for both Source and Target using query : getting different result and i was mentioned "-Duser.timezone=UTC" (set OPT in spoon.bat (pdi-ce-6.0)) even though i am not able to retrieve data because of time mismatch.

    as per my observation there is change for spoon.bat in 5.3 and spoon.bat in 6.0 version. i can say 100% woked in 5.3 edition but not able to 6.0 version.

    Please suggest me how to set Source database timezone in my PDI-CE-6.0 spoon.bat file ??

    for Source(i.e. Amazon cloud):- Name:  mdc.png
Views: 168
Size:  2.0 KB for Target(i.e. Local machine):- Name:  idc.png
Views: 161
Size:  2.3 KB
    Last edited by santhi; 11-06-2015 at 10:10 AM.

  2. #2
    Join Date
    Mar 2015


    I have got same issue but issue is not from PDI side , There are so many reasons you need to check, few times JVM cache issues will create problem for your scenarios.

    Soultion as per my observation is : whenever you are using different PDI versions in your machine you need to restart your machine once you added "-Duser.timezone=UTC" in spoon.bat file.

    Please let me know if someone else know better suggestions.

    Thank you

  3. #3
    Join Date
    Aug 2015


    Thank you very much it worked for me when I restarted the machine.

    Not able to digest for this. seems to be we need to restart the machine daily twice or thrice. anyhow thank you for your quick update.

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.