Connect Cancel Button Cause Connect Error Going Forward
Closed this issue · 12 comments
terry-campbell-od commented
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
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
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.com<mailto: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 GitHub<#21 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHON4JJNPE6LAVARM5T43X3TEJUIBANCNFSM4ZNLXQGQ>.
terry-campbell-od commented
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.".
terry-campbell-od commented
Another user I am working with is having the same issue.
ssegal100 commented
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?
terry-campbell-od commented
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.com<mailto: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 GitHub<#21 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHON4JNB4R2726OK7IP74ZLTENUSNANCNFSM4ZNLXQGQ>.
terry-campbell-od commented
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.com<mailto: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.com<mailto: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 GitHub<#21 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHON4JNB4R2726OK7IP74ZLTENUSNANCNFSM4ZNLXQGQ>.
ssegal100 commented
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
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 Android<https://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 GitHub<#21 (comment)>, or unsubscribe<https://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
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.com<mailto: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 Android<https://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 GitHub<#21 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHON4JJLDY3N3QIUFSTZFS3TFABIFANCNFSM4ZNLXQGQ>.
ssegal100 commented
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
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.com<mailto: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 GitHub<#21 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHON4JLCA3UTTGPYMQPCA6DTFCVBHANCNFSM4ZNLXQGQ>.