community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Error When Saving a Hyper File to a Shared Drive

Meteor

I keep getting the below error message whenever trying to save a hyper file to a shared drive:

 

 Output Data (6) PQresultStatus: 7 ERROR:  Unable to resolve database file path: Unable to obtain canonical path¶ [SQL State : 58P01] [Severity : ERROR] [Primary message : Unable to resolve database file path: Unable to obtain canonical path] ¶ ¶ ¶

 

I have tried saving a .tde to the shared drive and it worked fine.

I have tried saving the hyper locally and it works fine.

I have tried copying the hyper locally to the shared drive and it works fine.

 

The issue seems to just be saving hypers to a shared drive. However, I'm not exactly sure what the issue is. Any thoughts or suggestions would be much appreciated!

 

 

Thank you,

Gabriella

Alteryx
Alteryx

It looks like Tableau has had this issue as well: https://community.tableau.com/thread/274234 

 

https://kb.tableau.com/articles/issue/error-unable-to-obtain-canonical-path-when-attempting-to-save-...

 

What version of Alteryx Designer are you using?

 

One alternative for the time being would be to either write it locally and then move it to the network location or to use a batch file to move it to the network location at the end of the workflow. I just tested writing a hyper file to a shared network drive using my installation of Alteryx Designer 2019.3 and didn't have an issue.

Meteor

Hi @BrandonB ,

 

Thank you for the response! I will need to use the batch file option for the time being or save as .tde because I am using Designer 2019.2.

Hopefully there is another solution rather than just upgrading because we just upgraded to 2019.2 and upgrading again is not an option right now.

 

 

Thanks again,

Gabriella

Alteryx
Alteryx

Here is an article that shows how to move files using an Alteryx workflow. Hopefully this helps you for the time being!

 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Batch-Files-in-Alteryx-Part-2-Movin...

Meteor

This is very helpful! Thank you!

Labels