Error: for worksheet xxx in spreadsheet: xxxx Connection Reset

[ffneri]

Hi guys,

I'm trying to use some transformations, using this plugin. So far work flawsly on Kettle Spoon (windows desktop).

However, after installing the plugin on Server (CentOS), we're facing some issues and I couldn't find a workaround to this.

I think the JSON file with credentials its okay, since I'm using in my local computer to execute the transformations. When I change the path (on purpose), the logs show the issue "Resource not found:"

But, when I fill the correct path to the JSON file and try to run in the server I got this error "Connection Reset"

Could anyone have a guess, what is the issue? thanks a lot!

2024-10-08 16:10:01,551 DEBUG [org.pentaho.di.repository.utils.IRepositoryFactory$CachingRepositoryFactory] Repository was cached for user: __________
2024-10-08 16:10:01,551 DEBUG [org.pentaho.di.repository.utils.IRepositoryFactory$CachingRepositoryFactory] Repository was cached for user: __________
2024-10-08 16:10:11,795 DEBUG [org.pentaho.di.repository.RepositoryConnectionUtils] Creating Meta-repository
2024-10-08 16:10:11,795 DEBUG [org.pentaho.di.repository.RepositoryConnectionUtils]  Populating Meta repository
2024-10-08 16:10:11,795 DEBUG [org.pentaho.di.repository.RepositoryConnectionUtils] singleDiServerInstance=true, loading default repository
2024-10-08 16:10:11,796 INFO  [org.pentaho.di] 2024/10/08 16:10:11 - RepositoriesMeta - Reading repositories XML file: FromInputStream
2024-10-08 16:10:11,844 DEBUG [org.pentaho.di.repository.RepositoryConnectionUtils]  Finding repository metadata
2024-10-08 16:10:11,844 DEBUG [org.pentaho.di.repository.RepositoryConnectionUtils]  Getting repository instance
2024-10-08 16:10:11,844 DEBUG [org.pentaho.di.repository.RepositoryConnectionUtils] Connecting to repository
2024-10-08 16:10:11,846 DEBUG [org.pentaho.di.repository.RepositoryConnectionUtils]  Connected to repository
2024-10-08 16:10:11,981 INFO  [org.pentaho.di] 2024/10/08 16:10:11 - _____xxxx_____ - Dispatching started for transformation [_____xxxx_____]
2024-10-08 16:10:12,150 ERROR [org.pentaho.di] 2024/10/08 16:10:12 - _____xxxx_____ - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Error: for worksheet : _____xxxx_____ in spreadsheet :_____yyyyyy_____  Connection reset
2024-10-08 16:10:12,151 ERROR [org.pentaho.di] 2024/10/08 16:10:12 - _____xxxx_____ - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : java.net.SocketException: Connection reset
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/java.net.SocketInputStream.read(SocketInputStream.java:186)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/java.net.SocketInputStream.read(SocketInputStream.java:140)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:478)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:472)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.security.ssl.SSLSocketInputRecord.decode(SSLSocketInputRecord.java:160)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:111)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1506)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1416)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:456)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:427)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.net.www.protocol.https.HttpsClient.afterConnect(HttpsClient.java:572)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:201)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.net.www.protocol.http.HttpURLConnection.getOutputStream0(HttpURLConnection.java:1367)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1342)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(HttpsURLConnectionImpl.java:246)
2024/10/08 16:10:12 - _____xxxx_____ -      at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:77)
2024/10/08 16:10:12 - _____xxxx_____ -      at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:981)
2024/10/08 16:10:12 - _____xxxx_____ -      at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:283)
2024/10/08 16:10:12 - _____xxxx_____ -      at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307)
2024/10/08 16:10:12 - _____xxxx_____ -      at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:394)
2024/10/08 16:10:12 - _____xxxx_____ -      at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489)
2024/10/08 16:10:12 - _____xxxx_____ -      at com.google.api.client.auth.oauth2.Credential.intercept(Credential.java:217)
2024/10/08 16:10:12 - _____xxxx_____ -      at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:868)
2024/10/08 16:10:12 - _____xxxx_____ -      at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:419)
2024/10/08 16:10:12 - _____xxxx_____ -      at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:352)
2024/10/08 16:10:12 - _____xxxx_____ -      at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:469)
2024/10/08 16:10:12 - _____xxxx_____ -      at org.pentaho.di.trans.steps.pentahogooglesheets.PentahoGoogleSheetsPluginInput.init(PentahoGoogleSheetsPluginInput.java:111)
2024/10/08 16:10:12 - _____xxxx_____ -      at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
2024/10/08 16:10:12 - _____xxxx_____ -      at java.base/java.lang.Thread.run(Thread.java:829)
2024-10-08 16:10:12,151 ERROR [org.pentaho.di] 2024/10/08 16:10:12 - _____xxxx_____ - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Error initializing step [XXXXXXXXXXXX]
2024-10-08 16:10:12,298 INFO  [org.pentaho.di] 2024/10/08 16:10:12 - Table output.0 - Connected to database [_____xxxx_____] (commit=1000)
2024-10-08 16:10:12,299 ERROR [org.pentaho.di] 2024/10/08 16:10:12 - _____xxxx_____- ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Step [_____xxxx_____] failed to initialize!
2024-10-08 16:10:12,302 ERROR [org.pentaho.platform.plugin.kettle.PdiAction] Kettle.ERROR_0011 - [pt_335] Could not prepare transformation for execution
org.pentaho.di.core.exception.KettleException:
We failed to initialize at least one step.  Execution can not begin!


        at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1301) ~[kettle-engine-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.plugin.kettle.PdiAction.executeTransformation(PdiAction.java:512) [DIS-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.plugin.kettle.PdiAction.execute(PdiAction.java:263) [DIS-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.scheduler2.action.ActionRunner.callImpl(ActionRunner.java:176) [pentaho-platform-scheduler-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:80) [pentaho-platform-scheduler-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.scheduler2.action.ActionRunner.call(ActionRunner.java:56) [pentaho-platform-scheduler-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:177) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:166) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeActionImpl(DefaultActionInvoker.java:166) [pentaho-platform-scheduler-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.scheduler2.action.DefaultActionInvoker.invokeAction(DefaultActionInvoker.java:110) [pentaho-platform-scheduler-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:178) [pentaho-platform-scheduler-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:79) [pentaho-platform-scheduler-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:61) [pentaho-platform-scheduler-9.4.0.0-343.jar:9.4.0.0-343]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:199) [quartz-1.7.2.jar:?]
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546) [quartz-1.7.2.jar:?]
2024-10-08 16:10:12,311 ERROR [org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob] ActionAdapterQuartzJob.ERROR_0004 - Action "ktr.backgroundExecution" failed to run as a quartz job
org.quartz.JobExecutionException: ActionInvoker.ERROR_0004 - Action "org.pentaho.platform.plugin.kettle.PdiAction" failed to execute
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:195) ~[pentaho-platform-scheduler-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:79) [pentaho-platform-scheduler-9.4.0.0-343.jar:9.4.0.0-343]
        at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:61) [pentaho-platform-scheduler-9.4.0.0-343.jar:9.4.0.0-343]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:199) [quartz-1.7.2.jar:?]
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546) [quartz-1.7.2.jar:?]