Migrating Sisense DB in 6.7
If you move Sisense 6.7 from one server to new machine then you need to move C:\Program Data\Sisense\PrismWeb\Repository folder in order to move whole Sisense database. There is one trick tied to that, in 6.7 mongo db has strict access policy. When you install Sisense it creates internally an user which will access mongo db for Sisense, but that user will be different on different machines. SO when you install clean Sisense on new machine, copy Repository it may not work and you will see an error that mongo db authentication has failed. You need to uninstall Sisense then(keep user data) and the install it again, that should align internal user in accordance to user used in Repository. There should be a way to do that with changing config, but I have found only two files for that which are :
C:\Program Data\Sisense\PrismWeb\Repository\usrs - there is AppUser key in there
C:\Program Files\Sisense\PrismWeb\App_data\Configurations\db - there is a mongo connection string at the end of this file which includes AppUser
I'm assuming that those two have to be exactly the same. There might be some additional files that require change, but I could not find them and found re-installation a quicker way to solve it. Maybe someone from Sisense could shed some light on this. Thanks in advance!
Sisense comes with the MongoDump and MongoRestore utilities. You can use them to output the contents of your MongoDB to .bson files, and then reimport those files. That will migrate your data without worrying about changes to the user administration/authentication for the MongoDB. If you need assistance or sample scripts, please contact Support.
Post is closed for comments.