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

Excelarator Add-in crashing when trying to use upload feature #28

Open
KattaRci opened this issue Nov 8, 2021 · 29 comments
Open

Excelarator Add-in crashing when trying to use upload feature #28

KattaRci opened this issue Nov 8, 2021 · 29 comments

Comments

@KattaRci
Copy link

KattaRci commented Nov 8, 2021

When I try to use Excelerator upload feature, it crashes my excel and reloads it. I have traced it back and it goes as far as creating a temporary stage and the put command in snowflake. but doesn't really put the file in the temporary stage or load the data to the snowflake table.

@ssegal100
Copy link
Collaborator

I believe you are using Excel 2013 correct? If so is there someone else that can try with a newer version?
When you like at the History in Snowflake, is the 'Put' command the last thing you see?
Steve

@KattaRci
Copy link
Author

KattaRci commented Nov 8, 2021

Most of us have Excel 2013 as a standard, but i can ask around and see if someone has a different version.
Yes, out command is the last successful command as it shows in History
Amar

@ssegal100
Copy link
Collaborator

Would you increase the log level for the ODBC driver and upload the log files. The details can be found here:
https://community.snowflake.com/s/article/How-to-generate-log-file-on-Snowflake-connectors#ODBC

@KattaRci
Copy link
Author

KattaRci commented Nov 9, 2021

I had one of my team member try the addin on excel 2016 and he was able to get little further than we were able to. He was getting all sorts of column and key issues while updating

@ssegal100
Copy link
Collaborator

Let me know if you want to review the errors your colleague is getting.
About your error, it looks like it will be a 2013 issue, but if there is anything in the odbc error logs, that might help also.

@KattaRci
Copy link
Author

Sure, for 2016, let us know when you are available and I can have Bijo from my team join a session to work out the issues

@KattaRci
Copy link
Author

I will send you the log details from 2013 as well in a little bit

@KattaRci
Copy link
Author

Here are the logs from excel 2013 32-bit run...

@KattaRci KattaRci reopened this Nov 12, 2021
@KattaRci
Copy link
Author

files

@KattaRci
Copy link
Author

Hi Steven, not sure if you received the log files as I do not see a upload button after attaching the files

@ssegal100
Copy link
Collaborator

No I didn't get it. Try again and if I don't get it I'll send you my email.

@KattaRci KattaRci reopened this Nov 12, 2021
@KattaRci
Copy link
Author

KattaRci commented Nov 12, 2021 via email

@KattaRci
Copy link
Author

no I am not able to upload. Tried it again. Please share your email

@ssegal100
Copy link
Collaborator

@KattaRci Thank you for sending the logs. I'm seeing 3 items:
1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible.
2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys.
3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps.
Steve

@KattaRci
Copy link
Author

KattaRci commented Nov 16, 2021 via email

@ssegal100
Copy link
Collaborator

@KattaRci From the documents you sent, it looks like #2 and #3 are from the 2016 version. Is that not the case?

@KattaRci
Copy link
Author

KattaRci commented Nov 17, 2021 via email

@KattaRci
Copy link
Author

KattaRci commented Nov 17, 2021 via email

@KattaRci
Copy link
Author

KattaRci commented Nov 17, 2021 via email

@KattaRci
Copy link
Author

KattaRci commented Nov 17, 2021 via email

@KattaRci
Copy link
Author

KattaRci commented Nov 17, 2021 via email

@KattaRci
Copy link
Author

KattaRci commented Nov 17, 2021 via email

@ssegal100
Copy link
Collaborator

You won't be able to insert or update any data from the ODBC driver until #2 is fixed. So looks like you solved the issue from #3 but #2 is preventing you from completing it.
A Snowflake support ticket will need to be opened to solve this one.

@KattaRci
Copy link
Author

KattaRci commented Nov 17, 2021 via email

@KattaRci
Copy link
Author

KattaRci commented Nov 17, 2021 via email

@KattaRci
Copy link
Author

KattaRci commented Nov 17, 2021 via email

@KattaRci
Copy link
Author

KattaRci commented Nov 17, 2021 via email

@KattaRci
Copy link
Author

KattaRci commented Nov 17, 2021 via email

@KattaRci
Copy link
Author

KattaRci commented Nov 30, 2021 via email

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