Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Kitchen problem after change pdi language

  1. #1
    Join Date
    Oct 2011
    Posts
    20

    Exclamation Kitchen problem after change pdi language

    Hi all,

    I've a problem with kitchen after using a different language in PDI.
    Let me explain my problem, I worked on pdi 4.0.1 in the english version.
    I made my jobs and transformations and everything works fine. After the last release of pdi, I decided to move to pdi 4.2.0. And for this version, the default language is the default language of windows (so french in my case). I didn't care about this but after save some jobs, I had errors from transformations which convert string into date. What was my suprise when I see that my log error was full french (except the mistake itself). I thought it was linked to 4.2.0 problem. So a use a dump of my pentaho_repository and I decided to continue with 4.0.1 in english version. No problem after that (all jobs worked fine) until the day after. The job was launched as usual but he failed with a french log and the same errors as the day before. But nobody works with a french version since the first mistake . So I decided to relaunch manually the job and .... it worked perfectly ! Since that, I didn't have the problem again. Did I miss something ? Does pentaho_repository store the language somewhere ?
    Moreover, I can't understand the mistake with date. Ok, the french date and english ones are differents on the format but I defined the format.
    Here the issue :
    Code:
    RC String : couldn't convert string [30 Sep 2008 - 30 Dec 2008] to a date using format [dd MMM yyyy]
    Unparseable date: "30 Sep 2008 - 30 Dec 2008"
    Have no foggiest idea why this issue appears.

    Thank you for your help !

    Alex


    Here the full trace :
    Code:
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : org.pentaho.di.core.exception.KettleValueException:
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : RC String : couldn't convert string [30 Sep 2008 - 30 Dec 2008] to a date using format [dd MMM yyyy]
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : Unparseable date: "30 Sep 2008 - 30 Dec 2008"
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : Erreur inattendue :
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : org.pentaho.di.core.exception.KettleException:
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : Impossible de lire depuis le fichier XML
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) :
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : org.pentaho.di.core.exception.KettleValueException:
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : RC String : couldn't convert string [30 Sep 2008 - 30 Dec 2008] to a date using format [dd MMM yyyy]
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : Unparseable date: "30 Sep 2008 - 30 Dec 2008"
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) :
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) :
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : org.pentaho.di.trans.steps.getxmldata.GetXMLData.getXMLRowPutRowWithErrorhandling(GetXMLData.java:644)
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : org.pentaho.di.trans.steps.getxmldata.GetXMLData.getXMLRow(GetXMLData.java:612)
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : org.pentaho.di.trans.steps.getxmldata.GetXMLData.processRow(GetXMLData.java:569)
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/10/26 18:11:40 - issuRWRQ.0 - ERROR (version 4.0.1-SNAPSHOT, build 13650 from 2010-07-22 11.12.39 by tomcat) : java.lang.Thread.run(Thread.java:662)
    Here my configuration :
    Code:
    pdi : 
     version : 4.2.0-stable 
     build : 2011-09-08
    
    kitchen :
     version : 4.0.1-SNAPSHOT
     build: 2010-07-22 11
    
    database pentaho_repository (mySQL 5.4)

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    It's an illegal date (more like a date range) and doesn't match the format you supplied so obviously it HAS TO fail.

Tags for this Thread

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.