Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Worksheet not found error when running in server #15

Open
safvanplp opened this issue Oct 1, 2021 · 2 comments
Open

Worksheet not found error when running in server #15

safvanplp opened this issue Oct 1, 2021 · 2 comments

Comments

@safvanplp
Copy link

I am able to select the 'Worksheet Id' by using the browse button. But the worksheet name itself is coming in the bar. However I am able to retrieve the data in this way in Spoon, but when I am running the same in server, it is failing with the below error.

2021/10/01 14:20:30 - Target Mapping Spreadsheet Input.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Error: for worksheet : <<sheet_name>>  in spreadsheet :<<spread_sheet_key>>Resource not found:
2021/10/01 14:20:30 - Target Mapping Spreadsheet Input.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : java.io.FileNotFoundException: Resource not found:
2021/10/01 14:20:30 - Target Mapping Spreadsheet Input.0 - 	at org.pentaho.di.trans.steps.pentahogooglesheets.PentahoGoogleSheetsPluginCredentials.getCredentialsJson(PentahoGoogleSheetsPluginCredentials.java:87)
2021/10/01 14:20:30 - Target Mapping Spreadsheet Input.0 - 	at org.pentaho.di.trans.steps.pentahogooglesheets.PentahoGoogleSheetsPluginInput.init(PentahoGoogleSheetsPluginInput.java:109)
2021/10/01 14:20:30 - Target Mapping Spreadsheet Input.0 - 	at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
2021/10/01 14:20:30 - Target Mapping Spreadsheet Input.0 - 	at java.lang.Thread.run(Thread.java:748)
@jfmonteil
Copy link
Owner

Sorry, I have been out for a while, you need to move you JSON google credential file to somewhere where the server has access

@safvanplp
Copy link
Author

Thanks @jfmonteil . It was working after placing the credential file in the correct path.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants