Cognos Controller – can not save

Product:
Cognos Controller 10.4.2
Microsoft SQL database server

Issue:
After a restore of a production database to a test environment, the users can not save anything from inside Cognos Controller client, in the test enviroment.

Error Message:

FrangoClient.fm.UserAndInstallationRights.SaveUser.FrangoClient….

Server was unable to precess request –> System.Exception: xbo….

 

Possible solution:
Check with the Database Administrator (DBA) if any thing have been done during the restore.

If the controller database index are dropped, then the users can not save from inside Cognos Controller.

Do a new restore of the Controller database and try again.

More information on restore of database:

https://www.ibm.com/support/pages/how-migrate-upgrade-upsize-existing-database-new-later-version-controller