restored on sandbox but cannot access data connections

[David-Carnes]

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

[fmvizcaino · Accepted solution]

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.