search

Snowflake-Labs / Excelerator

This is an Excel Addin for Windows that reads and writes data to Snowflake
Apache License 2.0
78 stars 22 forks source link

Connect Cancel Button Cause Connect Error Going Forward #21

Closed terry-campbell-od closed 3 years ago

terry-campbell-od commented 3 years ago

When using the SnowflakeExcelAddin.xlam Add In, if I click Connect and then Cancel. Every time afterwards I receive an error "ERROR: Problem connecting: SQL compilation error: Object does not exist, or operation cannot be performed."

This did go away once after my computer went to sleep over night but I was able to recreate by clicking Cancel from the Connect Window.

ssegal100 commented 3 years ago

I'm not able to reproduce this one. Does the error happen after you click OK once you entered the user/password? Are you using SSO or username and password? Are you able to see what the last SQL executed was in Snowflake? If you look on the History tab in the Snowflake UI you should see a query executed with an error. Would you let me know what that is? Thanks.

terry-campbell-od commented 3 years ago

I am using SSO. Attached are screenshots. The history was from an hour ago. No new queries seem to be issued.

[cid:23401ae3-4ec4-473a-bf1d-2c2761e548db]

Thanks for the quick reply. The tool is awesome when working!!!

Terry Campbell Sr. Manager, IT - Enterprise Intelligence Systems 6600 N. Military Trail | Boca Raton, FL 33496 Tel: 561.438.6140 | Terry.Campbell@OfficeDepot.commailto:Terry.Campbell@OfficeDepot.com

[Office Depot | Max] CONFIDENTIALITY NOTICE: The information contained in this email and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this email in error, please immediately notify the sender and delete it from your system.

From: Steven Segal @.> Sent: Thursday, March 18, 2021 5:13 PM To: Snowflake-Labs/Excelerator @.> Cc: Terry Campbell @.>; Author @.> Subject: Re: [Snowflake-Labs/Excelerator] Connect Cancel Button Cause Connect Error Going Forward (#21)

[CAUTION: EXTERNAL SENDER]

I'm not able to reproduce this one. Does the error happen after you click OK once you entered the user/password? Are you using SSO or username and password? Are you able to see what the last SQL executed was in Snowflake? If you look on the History tab in the Snowflake UI you should see a query executed with an error. Would you let me know what that is? Thanks.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/21#issuecomment-802303633, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AHON4JJNPE6LAVARM5T43X3TEJUIBANCNFSM4ZNLXQGQ.

terry-campbell-od commented 3 years ago

Good morning, I tried using the addin this morning after waking my laptop from hibernation. I was able to connect the first time. I closed excel. I launched Excel again a little later and cannot connect to Snowflake. I receive the "ERROR: Problem connecting: SQL compilation error: Object does not exist, or operation cannot be performed.".

image

terry-campbell-od commented 3 years ago

Another user I am working with is having the same issue.

image

ssegal100 commented 3 years ago

Terry, Would you check your version of the Add-in? Click the Config button in the Ribbon. You should see the version number at the top. If you don't have the latest (1.1.15), would you download it? image

terry-campbell-od commented 3 years ago

I have 1.1.13. I will update to 1.1.15. Thanks.

Terry Campbell Sr. Manager, IT - Enterprise Intelligence Systems 6600 N. Military Trail | Boca Raton, FL 33496 Tel: 561.438.6140 | Terry.Campbell@OfficeDepot.commailto:Terry.Campbell@OfficeDepot.com

[Office Depot | Max] CONFIDENTIALITY NOTICE: The information contained in this email and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this email in error, please immediately notify the sender and delete it from your system.

From: Steven Segal @.> Sent: Friday, March 19, 2021 11:28 AM To: Snowflake-Labs/Excelerator @.> Cc: Terry Campbell @.>; Author @.> Subject: Re: [Snowflake-Labs/Excelerator] Connect Cancel Button Cause Connect Error Going Forward (#21)

[CAUTION: EXTERNAL SENDER]

Terry, Would you check your version of the Add-in? Click the Config button in the Ribbon. You should see the version number at the top. If you don't have the latest (1.1.15), would you download it? [image]https://user-images.githubusercontent.com/13276366/111804096-bef67d00-889d-11eb-851d-574648b7410a.png

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/21#issuecomment-802915817, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AHON4JNB4R2726OK7IP74ZLTENUSNANCNFSM4ZNLXQGQ.

terry-campbell-od commented 3 years ago

I installed 1.1.15 but extracting the new download over the existing files. I updated the file properties and checked the unblock check box. I was able to connect and run a query.

I closed Excel and reopened Excel. I can no longer run queries. I am receiving the same error.

[cid:01dab402-f40c-47ec-af12-6857a8de431b]

I am available for a debug session if you'd like.

Thanks.

Terry Campbell Sr. Manager, IT - Enterprise Intelligence Systems 6600 N. Military Trail | Boca Raton, FL 33496 Tel: 561.438.6140 | Terry.Campbell@OfficeDepot.commailto:Terry.Campbell@OfficeDepot.com

[Office Depot | Max] CONFIDENTIALITY NOTICE: The information contained in this email and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this email in error, please immediately notify the sender and delete it from your system.

From: Terry Campbell @.> Sent: Friday, March 19, 2021 11:35 AM To: Snowflake-Labs/Excelerator @.>; Snowflake-Labs/Excelerator @.> Cc: Author @.> Subject: Re: [Snowflake-Labs/Excelerator] Connect Cancel Button Cause Connect Error Going Forward (#21)

I have 1.1.13. I will update to 1.1.15. Thanks.

Terry Campbell Sr. Manager, IT - Enterprise Intelligence Systems 6600 N. Military Trail | Boca Raton, FL 33496 Tel: 561.438.6140 | Terry.Campbell@OfficeDepot.commailto:Terry.Campbell@OfficeDepot.com

[Office Depot | Max] CONFIDENTIALITY NOTICE: The information contained in this email and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this email in error, please immediately notify the sender and delete it from your system.

From: Steven Segal @.> Sent: Friday, March 19, 2021 11:28 AM To: Snowflake-Labs/Excelerator @.> Cc: Terry Campbell @.>; Author @.> Subject: Re: [Snowflake-Labs/Excelerator] Connect Cancel Button Cause Connect Error Going Forward (#21)

[CAUTION: EXTERNAL SENDER]

Terry, Would you check your version of the Add-in? Click the Config button in the Ribbon. You should see the version number at the top. If you don't have the latest (1.1.15), would you download it? [image]https://user-images.githubusercontent.com/13276366/111804096-bef67d00-889d-11eb-851d-574648b7410a.png

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/21#issuecomment-802915817, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AHON4JNB4R2726OK7IP74ZLTENUSNANCNFSM4ZNLXQGQ.

ssegal100 commented 3 years ago

Terry, as discussed this issue is due to the pseudo role ALL. The latest version of the Add-in 1.1.16, will set the role to an empty string if the previous Role used was ALL. This should prevent the error from occurring. Please download the latest version and let me know if it works for you. Thanks. Steve

terry-campbell-od commented 3 years ago

Thanks Steven, I will download today and test it out. Really appreciate the support.

Sent from my T-Mobile 4G LTE Device Get Outlook for Androidhttps://aka.ms/AAb9ysg

From: Steven Segal @.> Sent: Monday, March 22, 2021 11:12:02 PM To: Snowflake-Labs/Excelerator @.> Cc: Terry Campbell @.>; Author @.> Subject: Re: [Snowflake-Labs/Excelerator] Connect Cancel Button Cause Connect Error Going Forward (#21)

[CAUTION: EXTERNAL SENDER]

Terry, as discussed this issue is due to the pseudo role ALL. The latest version of the Add-in 1.1.16, will set the role to an empty string if the previous Role used was ALL. This should prevent the error from occurring. Please download the latest version and let me know if it works for you. Thanks. Steve

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/21#issuecomment-804549708, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AHON4JJLDY3N3QIUFSTZFS3TFABIFANCNFSM4ZNLXQGQ.

CONFIDENTIALITY NOTICE: The information contained in this email and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this email in error, please immediately notify the sender and delete it from your system.

terry-campbell-od commented 3 years ago

Steven,

1.1.16 is working great for me. Thank you for the quick turnaround and the great tool!

Regards, Terry

Terry Campbell Sr. Manager, IT - Enterprise Intelligence Systems 6600 N. Military Trail | Boca Raton, FL 33496 Tel: 561.438.6140 | Terry.Campbell@OfficeDepot.commailto:Terry.Campbell@OfficeDepot.com

[Office Depot | Max] CONFIDENTIALITY NOTICE: The information contained in this email and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this email in error, please immediately notify the sender and delete it from your system.

From: Terry Campbell @.> Sent: Tuesday, March 23, 2021 7:21 AM To: Snowflake-Labs/Excelerator @.>; Snowflake-Labs/Excelerator @.> Cc: Author @.> Subject: Re: [Snowflake-Labs/Excelerator] Connect Cancel Button Cause Connect Error Going Forward (#21)

Thanks Steven, I will download today and test it out. Really appreciate the support.

Sent from my T-Mobile 4G LTE Device Get Outlook for Androidhttps://aka.ms/AAb9ysg

From: Steven Segal @.> Sent: Monday, March 22, 2021 11:12:02 PM To: Snowflake-Labs/Excelerator @.> Cc: Terry Campbell @.>; Author @.> Subject: Re: [Snowflake-Labs/Excelerator] Connect Cancel Button Cause Connect Error Going Forward (#21)

[CAUTION: EXTERNAL SENDER]

Terry, as discussed this issue is due to the pseudo role ALL. The latest version of the Add-in 1.1.16, will set the role to an empty string if the previous Role used was ALL. This should prevent the error from occurring. Please download the latest version and let me know if it works for you. Thanks. Steve

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/21#issuecomment-804549708, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AHON4JJLDY3N3QIUFSTZFS3TFABIFANCNFSM4ZNLXQGQ.

ssegal100 commented 3 years ago

Great to hear Terry. It was great working with you on this. Are both issue now resolved? If so would you close them out? Thanks. Steve

terry-campbell-od commented 3 years ago

Yes sir, both issues are resolved. You can close issues #21 and #22. Thanks again!

Terry Campbell Sr. Manager, IT - Enterprise Intelligence Systems 6600 N. Military Trail | Boca Raton, FL 33496 Tel: 561.438.6140 | Terry.Campbell@OfficeDepot.commailto:Terry.Campbell@OfficeDepot.com

[Office Depot | Max] CONFIDENTIALITY NOTICE: The information contained in this email and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this email in error, please immediately notify the sender and delete it from your system.

From: Steven Segal @.> Sent: Tuesday, March 23, 2021 11:06 AM To: Snowflake-Labs/Excelerator @.> Cc: Terry Campbell @.>; Author @.> Subject: Re: [Snowflake-Labs/Excelerator] Connect Cancel Button Cause Connect Error Going Forward (#21)

[CAUTION: EXTERNAL SENDER]

Great to hear Terry. It was great working with you on this. Are both issue now resolved? If so would you close them out? Thanks. Steve

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/21#issuecomment-804980105, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AHON4JLCA3UTTGPYMQPCA6DTFCVBHANCNFSM4ZNLXQGQ.