14 Replies Latest reply on Jun 9, 2010 11:36 AM by user4983473

    Planning application not registering following de registeration

    639623
      Hi,

      Essbase and planning 9.3.1

      A planning application was de registered to resolve an issue with applying security. The security issue turned out to be an incorrectly configured msad in HSS. However, the application is now not registering with HSS. The planning app is unassigned in HSS. If you move it to planning a message occurs saying 'applications with identical names cannot be assigned'.

      If I try and register the app from with eas a message appears saying it is already registered.

      Thanks,

      Nathan
        • 1. Re: Planning application not registering following de registeration
          JohnGoodwin
          You can check if it still exists in shared services.

          If you have microsoft office and it is on a machine that has http access to shared services go to
          Open >Enter as the file name > http://<hss servername>:58080/interop/content/files/Projects

          Enter admin account and password

          Does the planning app appear in the list as APPNAME.HP
          If so you can right click and delete.

          Cheers

          John
          http://john-goodwin.blogspot.com/
          1 person found this helpful
          • 2. Re: Planning application not registering following de registeration
            639623
            Hi John,

            The app is not present there.

            I deleted from HSS and went to register it in planning. However, when I try logging into planning user the admin user an error appears saying

            'Failed to sync with user provisioning'.

            Is this because the provisioning disappeared when the application was de registered?

            I am not sure what the next step is.

            Many thanks for your help,

            Nathan
            • 3. Re: Planning application not registering following de registeration
              JohnGoodwin
              Hi,

              It shouldn't matter if you are logging in as the application owner if it has been removed from HSS.
              The failed to sync is usually down to an issue with the planning app user table not being in sync with shared services.

              Cheers

              John
              http://john-goodwin.blogspot.com/
              • 4. Re: Planning application not registering following de registeration
                639623
                Hi John,

                I haven't seen that error before. What would have caused planning to fail out of sync? More importantly how can I get them in sync? refresh from EAS?

                Thanks,

                Nathan
                • 5. Re: Planning application not registering following de registeration
                  JohnGoodwin
                  I would first try and run the provisionusers utility in the bin directory, check the output log to see if there is an issue syncing.

                  Cheers

                  John
                  http://john-goodwin.blogspot.com/
                  • 6. Re: Planning application not registering following de registeration
                    639623
                    Hi John,

                    This is the output

                    [Fri Mar 12 12:13:54 GMT 2010] Starting synchronization.
                    Setting Arbor path to: C:\Hyperion\common\EssbaseRTC\9.3.1
                    Setting HBR Mode to: 2
                    HBR Logging Config File : HBRServer.properties
                    2010-03-12 12:14:00,078 WARN main com.hyperion.hbr.security.HbrSecurityAPI - Error retrieving user by identity
                    Embedded HBR initialized.
                    PLANTEST: Error occurred while synchronizing: java.lang.NullPointerException: name is null
                    Reaquired task list lease: Fri Mar 12 12:14:00 GMT 2010: 1268396040984
                    Setting HBR Mode to: 2
                    2010-03-12 12:14:01,969 WARN main com.hyperion.hbr.security.HbrSecurityAPI - Error retrieving user by identity
                    Embedded HBR initialized.
                    FCAST : Error occurred while synchronizing: java.lang.NullPointerException: name is null
                    Setting HBR Mode to: 2
                    2010-03-12 12:14:03,312 WARN main com.hyperion.hbr.security.HbrSecurityAPI - Error retrieving user by identity
                    Embedded HBR initialized.
                    FCASTDEV: Error occurred while synchronizing: java.lang.NullPointerException: name is null

                    Thanks,

                    Nathan
                    • 7. Re: Planning application not registering following de registeration
                      JohnGoodwin
                      You usually get that if you don't enter any parameters when running provisionusers

                      It should be

                      ProvisionUsers /ADMIN:adminName /PASS:password /A:appName

                      Once it has completed check the log.

                      I would also try running the

                      updateusers

                      utility as this will try and sync the users in the planning tables with shared services, it may be more beneficial to run this utility.

                      Cheers

                      John
                      http://john-goodwin.blogspot.com/
                      • 8. Re: Planning application not registering following de registeration
                        639623
                        Hi John,

                        I did both of these. The update users log produced no enteries. I did referennce to failed to sync on the cmd window.

                        Any other things to try? (restart any services?)

                        Many thanks,

                        Nathan
                        • 9. Re: Planning application not registering following de registeration
                          JohnGoodwin
                          Sounds like there is something wrong in the user tables for the planning application, I can't really expand much further without seeing.

                          Cheers

                          John
                          http://john-goodwin.blogspot.com/
                          • 10. Re: Planning application not registering following de registeration
                            639623
                            Thanks for your help John. It is really appreciated.
                            • 11. Re: Planning application not registering following de registeration
                              639623
                              Hi John,

                              This appeared in the cmd window (not log file) when the updateusers utility was run

                              Creating rebind thread to RMI
                              Setting Arbor path to: C:\Hyperion\common\EssbaseRTC\9.3.1
                              Setting HBR Mode to: 2
                              HBR Logging Config File : HBRServer.properties
                              2010-03-12 13:18:17,608 WARN main com.hyperion.hbr.security.HbrSecurityAPI - Err
                              or retrieving user by identity
                              Embedded HBR initialized.
                              com.hyperion.planning.HspRuntimeException: The following user already exists in
                              this application: admin.
                              at com.hyperion.planning.db.HspSecDBImpl.updateUser(Unknown Source)
                              at com.hyperion.planning.security.HspLogonSynchronizer.persistUserChange
                              s(Unknown Source)
                              at com.hyperion.planning.security.HspLogonSynchronizer.synchronizeUser(U
                              nknown Source)
                              at com.hyperion.planning.HspJSImpl.synchronizeUserWithProvisioning(Unkno
                              wn Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.utils.HspUpdateUsersUtility.main(Unknown Source
                              )
                              com.hyperion.planning.DuplicateUserException: Another user with the name admin a
                              lready exists.
                              at com.hyperion.planning.sql.actions.HspUserAction.update(Unknown Source
                              )
                              at com.hyperion.planning.sql.actions.HspAction.update(Unknown Source)
                              at com.hyperion.planning.sql.actions.HspActionSet.doActions(Unknown Sour
                              ce)
                              at com.hyperion.planning.sql.actions.HspActionSet.doActions(Unknown Sour
                              ce)
                              at com.hyperion.planning.db.HspSecDBImpl.updateUser(Unknown Source)
                              at com.hyperion.planning.security.HspLogonSynchronizer.persistUserChange
                              s(Unknown Source)
                              at com.hyperion.planning.security.HspLogonSynchronizer.synchronizeUser(U
                              nknown Source)
                              at com.hyperion.planning.HspJSImpl.synchronizeUserWithProvisioning(Unkno
                              wn Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.utils.HspUpdateUsersUtility.main(Unknown Source
                              )
                              com.hyperion.planning.DuplicateUserException: Another user with the name admin a
                              lready exists.
                              at com.hyperion.planning.sql.actions.HspUserAction.update(Unknown Source
                              )
                              at com.hyperion.planning.sql.actions.HspAction.update(Unknown Source)
                              at com.hyperion.planning.sql.actions.HspActionSet.doActions(Unknown Sour
                              ce)
                              at com.hyperion.planning.sql.actions.HspActionSet.doActions(Unknown Sour
                              ce)
                              at com.hyperion.planning.db.HspSecDBImpl.updateUser(Unknown Source)
                              at com.hyperion.planning.security.HspLogonSynchronizer.persistUserChange
                              s(Unknown Source)
                              at com.hyperion.planning.security.HspLogonSynchronizer.synchronizeUser(U
                              nknown Source)
                              at com.hyperion.planning.HspJSImpl.synchronizeUserWithProvisioning(Unkno
                              wn Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.utils.HspUpdateUsersUtility.main(Unknown Source
                              )
                              com.hyperion.planning.HspRuntimeException: The following user already exists in
                              this application: admin.
                              Cannot login to application: fcast
                              com.hyperion.planning.HspRuntimeException: Failed to sync with user provisioning
                              . Check Planning log for details
                              at com.hyperion.planning.HspJSImpl.synchronizeUserWithProvisioning(Unkno
                              wn Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.utils.HspUpdateUsersUtility.main(Unknown Source
                              )
                              java.lang.RuntimeException: Errors occured during syncrhonization: [com.hyperion
                              .planning.HspRuntimeException: The following user already exists in this applica
                              tion: admin.]
                              at com.hyperion.planning.HspJSImpl.synchronizeUserWithProvisioning(Unkno
                              wn Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.utils.HspUpdateUsersUtility.main(Unknown Source
                              )
                              java.lang.RuntimeException: Errors occured during syncrhonization: [com.hyperion
                              .planning.HspRuntimeException: The following user already exists in this applica
                              tion: admin.]
                              at com.hyperion.planning.HspJSImpl.synchronizeUserWithProvisioning(Unkno
                              wn Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HspJSImpl.login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                              at com.hyperion.planning.utils.HspUpdateUsersUtility.main(Unknown Source
                              )
                              Press any key to continue . . .

                              Thanks,

                              Nathan
                              • 12. Re: Planning application not registering following de registeration
                                JohnGoodwin
                                com.hyperion.planning.DuplicateUserException: Another user with the name admin already exists.

                                This can happen when an application has been migrated and the native sid for the application owner has not been updated correctly in the HSP_USERS

                                Cheers

                                John
                                http://john-goodwin.blogspot.com/
                                • 13. Re: Planning application not registering following de registeration
                                  639623
                                  Hi John,

                                  The issue is resolved now with help from Oracle.

                                  The application was registered with HSS by going directly to the appwizard. However, the admin user still couldn't log into the app. The provisioning against the planning app had to be removed for the admin user and the provisionusers.cmd run to sync up planning and HSS. The provisioning could then be put back in and everything was OK.

                                  Not straightforward. Thanks for your help.

                                  Thanks,

                                  Nathan
                                  • 14. Re: Planning application not registering following de registeration
                                    user4983473
                                    Is there any way to find out what it should be?