Hi,
I have some jobs scheduled on a
Pentaho Server 9.2 that read data from a
Mysql 5 and the authentication "
mysql_native_password".
Now the database has been migrated to
Mysql 8.0.29 with
caching_sha2_password authentication.
I've added the connector library
MySQL-connector-java-8.0.29.jar in the lib directory on the server, but the transformations that read data from Mysql fail.
This is the error:
17:23:26,973 ERROR [KettleComponent] Error Start: Pentaho pentaho-platform-core 9.2.0.0-290
17:23:26,975 ERROR [KettleComponent] 77eab14b-cd50-11ec-855d-0050569862a1:COMPONENT:context-152396886-1651850603485:j_load_titoli_sns_datamart.xactionKettle.ERROR_0008 - [it_383] An unexpected error occurred running the transformation org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - [it_249] Error occurred during transformation execution
org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - [it_249] Error occurred during transformation execution
at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeJob(KettleComponent.java:1030)
at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeAction(KettleComponent.java:606)
at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:467)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1116)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1081)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:995)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:949)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:838)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:752)
at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:354)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:284)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:181)
at org.pentaho.platform.plugin.action.builtin.ActionSequenceAction.execute(ActionSequenceAction.java:89)
at org.pentaho.platform.scheduler2.action.ActionRunner.callImpl(ActionRunner.java:176)
at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:80)
at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:56)
at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:177)
at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:166)
at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeActionImpl(DefaultActionInvoker.java:166)
at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeAction(DefaultActionInvoker.java:110)
at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:178)
at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:79)
at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:61)
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
Caused by: org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - [it_249] Error occurred during transformation execution
at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeJob(KettleComponent.java:1026)
... 24 more
17:23:26,979 ERROR [KettleComponent] Error end:
The same jobs and the transformations work well if executed from Spoon (PDI) 9.2 on my laptop.
On this laptop, I'm using the same connector: MySQL-connector-java-8.0.29.jar.
Why do these jobs fail on the server?
How can I debug this problem?
Thank you very much
Claudio
------------------------------
Claudio Battaglino
IT Support Manager
cbc
------------------------------