topic Re: restored on sandbox but cannot access data connections in Alteryx Server Discussions

restored on sandbox but cannot access data connections

David-Carnes — Tue, 08 Oct 2024 20:34:12 GMT

Hello!
I restored a backup of my production server onto my sandbox server. Apparently the encryption key for gallery data connections wasn't brought over.

I monkeyed around in RuntimeSettings.xml file but to no avail. Is there a file or something in the MongoDB that I could change?

This is odd, because in the past, I have had the ability to use the data connectors that came over with the backup from production.

Many thanks!
David

Re: restored on sandbox but cannot access data connections

fmvizcaino — Wed, 09 Oct 2024 12:41:21 GMT

Hi @David-Carnes ,

I`m unaware of any specific files or guidelines for this process. Have you performed the complete host recovery process? That is what I usually do when I want to clone the environment.

https://help.alteryx.com/current/en/server/install/server-host-recovery-guide.html#idp403125

Best,

Fernando Vizcaino

Re: restored on sandbox but cannot access data connections

David-Carnes — Wed, 09 Oct 2024 14:07:34 GMT

@fmvizcaino !
Thank you; this was interesting reading.
I'll let you know how it goes.

Once again, thank you!

Re: restored on sandbox but cannot access data connections

David-Carnes — Fri, 11 Oct 2024 12:33:08 GMT

I now have a problem in production in that the Controller Token is 192 characters long. (64 x 3) But that is not in the scope of the problem I asked for help with.

Re: restored on sandbox but cannot access data connections

David-Carnes — Mon, 14 Oct 2024 12:26:44 GMT

I don't know how I ended up with a 192 character long controller token. I played around on our sandbox and deleting the content <ServerSecretEncrypted> in the RuntimeSettings.xml allowed me to get a bona fide controller token.

Re: restored on sandbox but cannot access data connections

fmvizcaino — Tue, 15 Oct 2024 20:55:43 GMT

Hey @David-Carnes ,

Sorry to keep you waiting. I know Alteryx changed the token structure in one of the versions but nothing like that.

Have you tried regenerating the token from the Alteryx system settings?

Best,

FErnando Vizcaino

Re: restored on sandbox but cannot access data connections

David-Carnes — Wed, 16 Oct 2024 12:34:52 GMT

Hi @fmvizcaino!
Like I mentioned in my post, I deleted the content in<ServerSecretEncrypted> and was able to regenerate a correct controller token.

Ciao for now....
David

Re: restored on sandbox but cannot access data connections

fmvizcaino — Wed, 16 Oct 2024 13:42:24 GMT

Oh nice!! I missed the last reply somehow.

Thanks for the update!

Re: restored on sandbox but cannot access data connections

TheCoffeeDude — Thu, 17 Oct 2024 02:38:29 GMT

Based on my experience, don't change the controller token on your sandbox or prod systems after you've performed the host recovery process. This will allow you to restore a prod backup without going through the host recovery process.

Re: restored on sandbox but cannot access data connections

fmvizcaino — Thu, 17 Oct 2024 13:46:38 GMT

Very good tip @TheCoffeeDude . I wasn`t aware of it!

Thanks for sharing.