Hi guys,
I'm working on hyperion planning 11.1.2.4. We are performing a migration from 11.1.2.3 to 11.1.2.4 realease. Once we migrated all the apps, we migrated users and groups, provisioning and security. We are doing some test an Now when ,we perform a retrieve from SmartView, with any user that isn't administor, we get this error from smartview "error 1020043 - you do not have sufficient access to perform a lock on this database".
After some reasearch we found that the write access we set on elements on hyperion planning didn't get trasformed them into Essbase filters. I only can see READ and NONE filters on essbase for any users, even if we set write access on some elements of the Scenario dimensions.
Actually, at the very start of the migration we had an issue with the user "admin" because we didn't change the import mode on Shared Services, that for default is set on "Create or Update", and admin wasn't on the original system.The result has been the delete of the user admin. We recreated it, launched updateusers.cmd and the problem seemed to be solved but we got the problem below (Doc ID 1532653.1):
Error: 1051675 [Admin@Native Directory] already exists in the security file. If this user/group was deleted from HSS, drop the user/group from ESSBASE by using the MAXL statement DROP [USER/GROUP] Admin@Native Directory FROM SECURITY_FILE
We ran the MaxL command, dropped the user admin from security_file and we are now able to make refresh of the datavase and of the security filters as well, but the security filters are not updated on Essbase, only READ and NONE are created when we perform refresh of the security filters.
I know maybe we haven't followed the correct steps to solve our initial issue but now it seems that we are not able to update the user filters on essbase.
I have read many posts but before to make any other step i would like to know what you think about this problem.
Do you have any idea?
Thank you in adavance guys for any advice you could give me
Bye
Maurizio