Users' private folders disappear after changing SharedServices Directory Provider
Posted by Priya Doyle, Last modified by Priya Doyle on 16 November 2010 01:32 PM
Applies to:Hyperion Financial Management - Version: 18.104.22.168.00 to 22.214.171.124.00 [Release: 9.2 to 9.3]
Hyperion Financial Management - Version: 126.96.36.199.00 to 188.8.131.52.00 [Release: 9.2 to 9.3]
z*OBSOLETE: Microsoft Windows Server 2003
Folders and documented created as "private" in HFM disappear after a change in the configuration of a Shared Services Directory Provider.The name of the Shared Services Directory Provider where the user is contained was changed.
Financial Management stores an internal pointer to users in the form username@provider_name. If the name of the provider is changed, that pointer will break
There are two ways of solving this issue.
This is the easiest option.
This solution is more complex. It involves updating the database table storing the documents, pointing records to the new provider name.
The table is your-application-name_RPTS, where "your-application-name" is the name of your HFM application. The column "CreatedUser" holds the pointers you need to update.
An example SQL command which would "restore" only one folder:
You can find all private folder affected by the issue by looking at the Private field in the same table; a value of -1 means the object is marked as private.
This command is only an example, you should consult with your DBA to build a better query and update all the affected records.