[HOP-4142] Bug when test Rhino script

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Not applicable
• Component/s: Pipelines
• Assignee: Bart Maertens
• Reporter: COCHIE Jeremie
• Created: 18/Aug/22 12:33
• Updated: 17/Feb/23 13:56
• Resolved: 17/Feb/23 13:56

Description

Hi

my format date is dd/MM/yyyy HH:mm:ss

When i test java script, i have a crash test with this error

org.apache.hop.core.exception.HopException: 
Impossible d'initialiser toutes les transformations.  L'exécution ne peut démarrer!
2022/08/18 14:24:31 - Hop - Projects enabled
2022/08/18 14:24:31 - Hop - Enabling project : 'Hop_Deco'
2022/08/18 14:27:29 - Exécution Scripts Java - PREVIEW - Executing this pipeline using the Local Pipeline Engine with run configuration 'local'
2022/08/18 14:27:29 - Exécution Scripts Java - PREVIEW - Distribution démarrée pour la tranformation [Exécution Scripts Java - PREVIEW]
2022/08/18 14:27:29 - ## TEST DATA ##.0 - ERROR: Impossible d'analyser le champ Date [whencreated] avec la valeur [18/08/2022 14:24:53] --> org.apache.hop.core.exception.HopValueException: 
2022/08/18 14:27:29 - ## TEST DATA ##.0 - whencreated String : couldn't convert string [18/08/2022 14:24:53] to a date using format [yyyy/MM/dd HH:mm:ss] on offset location 19
2022/08/18 14:27:29 - ## TEST DATA ##.0 - 18/08/2022 14:24:53
2022/08/18 14:27:29 - ## TEST DATA ##.0 - ERROR: Impossible d'analyser le champ Date [whenchanged] avec la valeur [18/08/2022 14:24:53] --> org.apache.hop.core.exception.HopValueException: 
2022/08/18 14:27:29 - ## TEST DATA ##.0 - whenchanged String : couldn't convert string [18/08/2022 14:24:53] to a date using format [yyyy/MM/dd HH:mm:ss] on offset location 19
2022/08/18 14:27:29 - ## TEST DATA ##.0 - 18/08/2022 14:24:53
2022/08/18 14:27:29 - ## TEST DATA ##.0 - ERROR: Impossible d'analyser le champ Date [lastlogontimestamp] avec la valeur [18/08/2022 14:24:53] --> org.apache.hop.core.exception.HopValueException: 
2022/08/18 14:27:29 - ## TEST DATA ##.0 - lastlogontimestamp String : couldn't convert string [18/08/2022 14:24:53] to a date using format [yyyy/MM/dd HH:mm:ss] on offset location 19
2022/08/18 14:27:29 - ## TEST DATA ##.0 - 18/08/2022 14:24:53
2022/08/18 14:27:29 - ## TEST DATA ##.0 - ERROR: Impossible d'analyser le champ Date [whencreatedexch] avec la valeur [18/08/2022 14:24:53] --> org.apache.hop.core.exception.HopValueException: 
2022/08/18 14:27:29 - ## TEST DATA ##.0 - whencreatedexch String : couldn't convert string [18/08/2022 14:24:53] to a date using format [yyyy/MM/dd HH:mm:ss] on offset location 19
2022/08/18 14:27:29 - ## TEST DATA ##.0 - 18/08/2022 14:24:53
2022/08/18 14:27:29 - ## TEST DATA ##.0 - ERROR: Erreur lors de l'initialisation de la transformation # TEST DATA ##
2022/08/18 14:27:29 - Exécution Scripts Java - PREVIEW - ERROR: L'initialisation de la transformation # TEST DATA ##.0 a échoué!

    at org.apache.hop.pipeline.Pipeline.prepareExecution(Pipeline.java:1021)
    at org.apache.hop.pipeline.engines.local.LocalPipelineEngine.prepareExecution(LocalPipelineEngine.java:206)
    at org.apache.hop.ui.pipeline.dialog.PipelinePreviewProgressDialog.doPreview(PipelinePreviewProgressDialog.java:149)
    at org.apache.hop.ui.pipeline.dialog.PipelinePreviewProgressDialog.lambda$open$0(PipelinePreviewProgressDialog.java:87)
    at org.apache.hop.ui.core.dialog.ProgressMonitorDialog.lambda$run$2(ProgressMonitorDialog.java:163)
    at java.base/java.lang.Thread.run(Thread.java:834)

 

The test wish  [yyyy/MM/dd HH:mm:ss]but my fieds are in this format dd/MM/yyyy HH:mm:ss

 

I try to overload format in hop property but not ok

HOP_DEFAULT_DATE_FORMAT an HOP_DEFAULT_TIMESTAMP_FORMAT

 

How keep french date format for the test

 

Thx