restored on sandbox but cannot access data connections

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

Database Connection

Accepted answers

fmvizcaino

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

All comments

fmvizcaino

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

David-Carnes

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

Once again, thank you!

David-Carnes

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.

David-Carnes

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.

fmvizcaino

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

David-Carnes

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

fmvizcaino

Oh nice!! I missed the last reply somehow.

Thanks for the update!

TheCoffeeDude

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.

fmvizcaino

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

Thanks for sharing.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703