Alteryx Connect

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

Loading In - database connections to connect

Highlighted
8 - Asteroid

I'm trying to load my In-DB connections to Alteryx Connect, I've been following this: https://community.alteryx.com/t5/Alteryx-Connect-Knowledge-Base/Loading-Gallery-Metadata-to-Connect/... for the steps, but I keep getting this error see the image. Does anyone know how I can rectify this?

 

soha-elghany_0-1589994705301.png

 

Highlighted
Alteryx
Alteryx

Hi @soha-elghany ,

Thank you for sharing the issue,

you identified an unexpected situation in loader, and our team will implement the fix for future release.

However I would like to help you to fix also your current version, but I need to know what version you have installed.
I can send you updated macro for your version. I also attached here macro for version 2019.4 and later. So high chance that it will be good for you.

And quickly to explain what happenned:

I identified that in marco InDBConnectionFileParser.yxmcwho is responsible for InDB connection(xml file) parsing is expecting that there are configured 2 types of xml tags DbToAlteryx and AlteryxToDb. In your case the seccond is missing, which leads to error while parsing xml.

I created some text file inputs in order to ensure that expected field structure would be present in dataset and with union tool I put the real data and file structure together. I also fixed the oposit case. 

So if you copy the macro file to the Supporting_Macros subfolder (replace the old one) it should work.

this is the change: 

PetrH_0-1590134377407.png

 

 

Let me know if the hotfix helped.

 

Thank you again for your contribution for making the product better.

 

With best regards,


Petr Havel from Alteryx Connect team

 

Highlighted
8 - Asteroid

Thank you @PetrH for the help, I'm on version 2019.4, I'll give your macro a go, just to clarify do I just replace the old macro location with the new one? 

Highlighted
Alteryx
Alteryx

Hi @soha-elghany 

In order to execute the loader with updated macro you need to copy that macro to loader main folder. In my case the loader lives here: C:\ProgramData\Alteryx\AlteryxConnect\Alteryx_Loader so you need to copy the updated macro here: C:\ProgramData\Alteryx\AlteryxConnect\Alteryx_Loader\Supporting_Macros\ the old one should be there already.

I suggest to do not touch the loader, just copy the macro on filesystem.

My colleague was also looking to your issue, and he suspects that you pointed to completely wrong indb file, which dont contain indatabase connections. If possible you can share with us yours..

Best regards,


Petr

Highlighted
8 - Asteroid

I've attached my xml file, this XML file got generate once I managed my In-DB connections. How else am I supposed to create that XML?

Highlighted
Alteryx
Alteryx

Thank you for indb file @soha-elghany we will check again whats the issue. Will let you know.

Petr

Highlighted
8 - Asteroid

Thank you @PetrH appreciate the help!

I tried to run the app with the in-DB connections again with the new macro you sent over in this thread and I'm now getting a new error:

soha-elghany_0-1590758247528.png

 

Highlighted
Alteryx
Alteryx

Hi @soha-elghany ,

 

Thank you for providing example file.

Here is updated macro, please put it again to loaders file.

Its almost original one, the trick was that in your case the connectins file contained only one entry, which was incorrectly parsed.

PetrH_0-1591030418632.png

 

 

Now its focused on the correct xml element and it works in all cases.

So thank you again for help and letting us know.

With best regards,

Petr

Highlighted
8 - Asteroid

Hi @PetrH thank you for the new macro, I tried again and I'm getting the same error. 

Highlighted
Alteryx
Alteryx

Hi @soha-elghany , 

I checked again, with your provided UserConnections.xml and it wotks on my pc.

There must be I guess some problem while puting the macro on right place, or its beuing overwritten.

I think that the best would be to quickly jump on call with you and check, while on call.

 

If you dont mind, I can send you MS Team meeting invite, or you can do the same.

Lets just find some convenient time slot. (I am based in Europe, Czech republic, so we are in UTC+2)

feel free to send me invite.

With best regards,

Petr