5 Replies Latest reply: Oct 11, 2013 1:22 AM by Amit Porwal 007 RSS

    I am not able to login to HFR studio (11.1.2.2)

    Amit Porwal 007

      Dear All,

       

      Need your help on HFR front ASAP.

      After I installed the Essbase (Two instances, one on port 1423 and other on 1424) + Foundation + HFR on same VM machine (Windows 2008 R2, 64 bit),

       

      1) I am able to log in to Workspace using admin account, but I can't see anything releated to HFR there (HFR Menu items etc.)?

      2) I am not able to log in to HFR Studio using admin Account, It throws following error:

      *******>>>  "You are not authorized to use this functionality. contact your administrator."

       

      I have used the "admin" user id, and used both of the following server URL's to log in to HFR Studio:

      http://servername:19000

      http://servername:8200

       

      The diagnostioc report shows the following Messages:

       

      EPM System Registry
      FAILEDREG: RegistryNext issues are present:
      LOGICAL_WEB_APP (id: 725171b9c246198fa24da131419ca84df1S75a8):
         "webAppType" property missed
         "context" property missed
         "port" property missed
         "SSL_Port" property missed
         "isSSL" property missed
         "host" property missed
         "" child missed

       

      RA_FRAMEWORK (id: 725171b9c246198fa24da131419ca84df1S7868):
         "applicationId" property missed
         "RA_PRODUCT" parent missed

       

      RA_FRAMEWORK (id: 725171b9c246198fa24da131419ca84df1S7679):
         "applicationId" property missed
         "DATABASE_CONN" child missed
      Error: Checker execution failed.
      Recommended Action: Refer to the validation logs for exception details.
      Financial Reporting
      PASSEDCFG: ConfigurationValidating that configuration tasks have been completed0 seconds
      FAILEDREG: DatasourceChecking if datasource property exists in the registry
      Error: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'FR_SCHEDULER_DATA'.
      Recommended Action: Refer to the validation logs for exception details.
      0 seconds
      Reporting and Analysis
      FAILEDCFG: ConfigurationValidating that configuration tasks have been completed
      Error: EPMVLD-01004: The following configuration tasks have not been completed:
      FrameworkServicesConfiguration: Configuration Failed
      Recommended Action: Attempt to configure referenced tasks
      0 seconds
      PASSEDDB: Database ConnectivityChecking connection to database jdbc:weblogic:sqlserver://Servername\Servername;databaseName=ESSFondation;loadLibraryPath=D:\Oracle\Middleware\wlserver_10.3\server\lib0 seconds
      PASSEDSVR: Essbase Java APILaunch external checker with next command: D:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\launchEssbaseJavaAPI.bat EssbaseJAPIConnect ****** Servername:1424 Embedded6 seconds
      PASSEDEXT: External AuthenticationCheck Native Directory external authentication provider configuration0 seconds
      PASSEDREG: ConfigurationChecking if product has only one product node in registry.0 seconds
      FAILEDRA: Reporting and AnalysisCheck if the Reporting and Analysis Service (RA_SERVICE) components exist.
      Error: Components not found.
      Recommended Action: Ensure that you ran the config tool and configured the Reporting and Analysis Service component.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if the RAF Logical Web App (LOGICAL_WEB_APP) component exists.
      Found: 1.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if Event Server data folder exists.
      Data file locations are valid.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if the RAF Web App (RA_FRAMEWORK_WEB_APP) components exist.
      Found: 1. Hosts for the components: Servername
      0 seconds
      FAILEDRA: Reporting and AnalysisCheck if all required RAF properties exist under the RAF Logical Web App component.
      Error: Some required properties are not found in the RAF Logical Web App component: WebClient.SmartPages.DefaultSmartPage.PreconfiguredCategories, WebClient.SmartPages.ColorScheme.ColorScheme1.BackgroundColor, WebClient.Applications.DAServlet.OpenNewWindow, WebClient.UserInterface.Localization.localLanguageCode, WebClient.SmartPages.ColorScheme.ColorScheme2.HeaderColor, WebClient.Cache.Objects.HeadlinesPageTTL, WebClient.SmartPages.ColorScheme.ColorScheme0.FooterColor, WebClient.Internal.Cookies.EncryptCookies, WebClient.UserInterface.PortalColor.MainFrame.General.ColorMainWizard, WebClient.SmartPages.ColorScheme.ColorScheme0.HeadingColor, WebClient.UserInterface.Localization.localCountryCode, WebClient.Cache.Domain.DomainInfoTTL, WebClient.SmartPages.ColorScheme.ColorScheme3.BCMessagesColor, WebClient.SmartPages.ColorScheme.ColorScheme2.BackgroundColor, WebClient.SmartPages.ColorScheme.ColorScheme1.Name, RCPDirectoryURL2, WebClient.Cache.Objects.CategoryCacheSize, WebClient.UserInterface.JobOutput.MIMETypeToDisplayForSQRProgramOutput, WebClient.Cache.Objects.TaskListingTTL, WebClient.Cache.Objects.CategoryTTL, SmartViewContext, WebClient.Internal.Transfer.PassDCByStream, WebClient.SmartPages.ColorScheme.ColorScheme2.FooterColor, WebClient.SmartPages.ColorScheme.ColorScheme2.LinkColor, WebClient.SmartPages.ColorScheme.ColorScheme1.BCMessagesColor, WebClient.SmartPages.ColorScheme.ColorScheme0.HeaderColor, OfficeAddinSupport, WebClient.SmartPages.ColorScheme.ColorScheme0.BackgroundColor, WebClient.SmartPages.ColorScheme.ColorScheme1.HeaderColor, WebClient.Applications.iHTML.PollingTimeSec, WebClient.SmartPages.ColorScheme.ColorScheme3.LeftColor, WebClient.Cache.Objects.CacheModifyTTL, WebClient.SmartPages.ColorScheme.ColorScheme1.LeftColor, WebClient.Cache.Objects.CacheListTTL, WebClient.UserInterface.Subscription.ShowSubscriptions, WebClient.SmartPages.ColorScheme.ColorScheme2.LeftColor, WebClient.Diagnostics.Log.Configuration, WebClient.UserInterface.JobOutput.ShowHTMLOutputForSQRPrograms, WebClient.UserInterface.Localization.ShowTimeOrder, WebClient.Applications.DAServlet.DASResponseTimeout, WebClient.Applications.DAServlet.PollingTimeSec, WebClient.UserInterface.Localization.localVariant, WebClient.SmartPages.ColorScheme.ColorScheme0.LinkColor, WebClient.UserInterface.SmartCut.ShowAsLink, WebClient.SmartPages.ColorScheme.ColorScheme3.BackgroundColor, WebClient.UserInterface.JobOutput.ShowSPFOutputForSQRPrograms, WebClient.SmartPages.ColorScheme.ColorScheme3.FontColor, WebClient.SmartPages.ColorScheme.ColorScheme3.LinkColor, WebClient.SmartPages.General.MaxNumberOfInitializedFromPublished, WebClient.Internal.Upload.MaxFileSize, WebClient.SmartPages.ColorScheme.ColorScheme2.RightColor, WebClient.SmartPages.ColorScheme.ColorScheme3.HeadingColor, WebClient.SmartPages.ColorScheme.ColorScheme1.LinkColor, WebClient.SmartPages.ColorScheme.ColorScheme1.HeadingColor, WebClient.SmartPages.ColorScheme.ColorScheme2.HeadingColor, WebClient.UserInterface.Localization.ShowDateOrder, WebClient.Cache.Objects.BrowseQueryTTL, RelatedContentProtocol, WebClient.Cache.Objects.PublishedSmartPagesQueryTTL, WebClient.CorporateWorkspage.Folder, WebClient.UserInterface.PortalColor.MainFrame.General.ColorMainFrame, WebClient.SmartPages.Publish.Location, WebClient.SmartPages.General.MaxNumberOfSmartPages, WebClient.SmartPages.ColorScheme.ColorScheme2.Name, WebClient.SmartPages.ColorScheme.ColorScheme3.Name, WebClient.SmartPages.DefaultSmartPage.DefaultColorScheme, WebClient.Cache.Objects.CacheListSize, WebClient.UserInterface.Configuration.EnableMSReportsIntegration, WebClient.SmartPages.ColorScheme.ColorScheme2.FontColor, WebClient.SmartPages.ColorScheme.ColorScheme2.BCMessagesColor, WebClient.SmartPages.ColorScheme.ColorScheme0.RightColor, WebClient.Internal.Temp.Location, WebClient.SmartPages.ColorScheme.ColorScheme0.BCMessagesColor, WebClient.Applications.iHTML.BQServiceResponseTimeout, RAFVersion, customSmartcutUrl, WebClient.UserInterface.PortalColor.MainFrame.Title.ColorMainTitleUnderline, WebClient.SmartPages.ColorScheme.ColorScheme1.FontColor, WebClient.Applications.iHTML.DiskCachePollingPeriod, WebClient.UserInterface.PortalColor.MainFrame.General.ColorMainWizardBorder, WebClient.Cache.Objects.JobTTL, WebClient.SmartPages.General.ShowHeadings, WebClient.SmartPages.ColorScheme.ColorScheme3.FooterColor, WebClient.Applications.DAServlet.ZAC, Folder0, WebClient.SmartPages.ColorScheme.ColorScheme3.RightColor, WebClient.Cache.Notifications.NotificationQueryTTL, WebClient.Internal.Cookies.KeepCookiesBetweenBrowserSessions, WebClient.SmartPages.DefaultSmartPage.ShowBookmarks, WebClient.SmartPages.DefaultSmartPage.PreconfiguredEmbeddedObjects, WebClient.Cache.Browse.JobOutputSummaryListing, WebClient.SmartPages.DefaultSmartPage.ShowExceptionsDashboard, WebClient.SmartPages.ColorScheme.ColorScheme0.Name, WebClient.UserInterface.PortalColor.MainFrame.Text.ColorMainLinkFont, WebClient.SmartPages.ColorScheme.ColorScheme3.HeaderColor, WebClient.Internal.Redirect.RedirectPolicy, WebClient.SmartPages.ColorScheme.ColorScheme0.LeftColor, WebClient.SmartPages.ColorScheme.ColorScheme1.RightColor, WebClient.UserInterface.PortalColor.MainFrame.Text.ColorMainFont, WebClient.SmartPages.ColorScheme.ColorScheme1.FooterColor, WebClient.UserInterface.Localization.Show24HourTime, WebClient.SmartPages.ColorScheme.ColorScheme0.FontColor.
      Recommended Action: Ensure that you ran the config tool and configured the RAF Web App component.
      0 seconds
      WARNINGRA: Reporting and AnalysisChecker execution failed.
      Check if all required RAF properties exist under the Reporting and Analysis Setup component.
      The Reporting and Analysis Setup component is not found.
      0 seconds
      FAILEDRA: Reporting and AnalysisCheck if the Agent (AGENT) components exist.
      Error: Components not found.
      Recommended Action: Ensure that you ran the config tool and configured the Reporting and Analysis Service component.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if Service Broker data folder exists.
      Data file locations are valid.
      0 seconds
      FAILEDRA: Reporting and AnalysisCheck if the Reporting and Analysis Setup (RA_SETUP) component exists.
      Error: Components not found.
      Recommended Action: Ensure that you ran the config tool and configured the Reporting and Analysis component.
      0 seconds
      WARNINGRA: Reporting and AnalysisChecker execution failed.
      Check if RAF Services are available.
      No RAF Services (Agent Module) components found in Registry.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if Repository data folder exists.
      Data file locations are valid.
      0 seconds
      FAILEDRA: Reporting and AnalysisCheck if the Agent Module (AGENT_MODULE) components exist.
      Error: Components not found.
      Recommended Action: Ensure that you ran the config tool and configured the Reporting and Analysis Service component.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if Reporting and Analysis Services and corresponding Agent Modules belong to the same host.
      Reporting and Analysis Services and corresponding Agent Modules belong to the same host.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if every Agent Module is associated with some Agent.
      Every Agent Module is associated with some Agent.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if Agent Modules and corresponding Agents belong to the same host.
      Agent Modules and corresponding Agents belong to the same host.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if every Reporting and Analysis Service is associated with some Agent Module.
      Every Reporting and Analysis Service is associated with some Agent Module.
      0 seconds
      FAILEDRA: Reporting and AnalysisCheck consistency of the Service Agent sets between Registry and V8_SERVICEAGENT.
      Error: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
      Recommended Action: Ensure that you ran the config tool and configured the Reporting and Analysis Service component.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if every Agent is associated with some Agent Module(s).
      Every Agent is associated with some Agent Module(s).
      0 seconds
      FAILEDRA: Reporting and AnalysisCheck consistency of the Service Agent properties between Registry and database tables (V8_SERVICEAGENT, V8_SA_PROPS).
      Error: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
      Recommended Action: Ensure that you ran the config tool and configured the Reporting and Analysis Service component.
      0 seconds
      WARNINGRA: Reporting and AnalysisChecker execution failed.
      Check if Agents are available.
      No Agent components found in Registry.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if Job Factory data folder exists.
      Data file locations are valid.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if all required Workspace configuration files exist under the RAF Logical Web App component.
      All required files exist.
      0 seconds
      PASSEDRA: Reporting and AnalysisCheck if every Agent Module (except IR Log) is associated with some Reporting and Analysis Service(s).
      Every Agent Module (except IR Log) is associated with some Reporting and Analysis Service(s).
      0 seconds
      PASSEDWEB: LibrariesCheck if all shared libraries are targeted for application "WebAnalysis0".3 seconds
      FAILEDWA: Essbase connectivityCheck connectivity between Web Analysis Server and Essbase Server.
      Error: An error occurred while running the check.
      Recommended Action: Ensure that: 1) Essbase Server is configured properly and started; 2) Web Analysis Web Application is configured and started.
      0 seconds
      FAILEDWA: HFM connectivityCheck connectivity between Web Analysis Server and Financial Management Server.
      Error: An error occurred while running the check.
      Recommended Action: Ensure that: 1) Financial Management Server is configured properly and started; 2) Web Analysis Web Application is configured and started.
      0 seconds
      FAILEDWA: LoginCheck the possibility to login on Web Analysis Server.
      Error: An error occurred while running the check.
      Recommended Action: Ensure that Web Analysis Web Application is configured and started.
      2 seconds
      PASSEDWEB: Web ApplicationAvailability of Web application context http://Servername:16000/WebAnalysis0 seconds

       

      Message was edited by: AmitPorwal007

        • 1. Re: I am not able to login to HFR studio (11.1.2.2)
          Celvin Kattookaran

          Did you install Framework Components?

           

          Regards

           

          Celvin

          • 2. Re: I am not able to login to HFR studio (11.1.2.2)
            Amit Porwal 007

            Hello Celvin,

             

            Thanks for your reply, your help is really appreciated.

            I have installed the R&A framework, but this Framework was having some problem during Configuration and it failed.

            Here are the diagnostic report contents:

             

            Financial Reporting
            PASSEDCFG: ConfigurationValidating that configuration tasks have been completed0 seconds
            FAILEDREG: DatasourceChecking if datasource property exists in the registry
            Error: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'FR_SCHEDULER_DATA'.
            Recommended Action: Refer to the validation logs for exception details.
            0 seconds

             

             

            Reporting and Analysis
            FAILEDCFG: ConfigurationValidating that configuration tasks have been completed
            Error: EPMVLD-01004: The following configuration tasks have not been completed:
            FrameworkServicesConfiguration: Configuration Failed
            Recommended Action: Attempt to configure referenced tasks
            0 seconds
            PASSEDDB: Database ConnectivityChecking connection to database jdbc:weblogic:sqlserver://SRVPARERKD01\MSPARERKD03;databaseName=ESSFondation;loadLibraryPath=D:\Oracle\Middleware\wlserver_10.3\server\lib0 seconds
            PASSEDSVR: Essbase Java APILaunch external checker with next command: D:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\launchEssbaseJavaAPI.bat EssbaseJAPIConnect ****** SRVPARESSD03.fr.world.socgen:1424 Embedded6 seconds
            PASSEDEXT: External AuthenticationCheck Native Directory external authentication provider configuration0 seconds
            PASSEDREG: ConfigurationChecking if product has only one product node in registry.0 seconds
            FAILEDRA: Reporting and Analysis Check if the Reporting and Analysis Service (RA_SERVICE) components exist.
            Error: Components not found.
            Recommended Action: Ensure that you ran the config tool and configured the Reporting and Analysis Service component.
            0 seconds
            PASSEDRA: Reporting and Analysis Check if the RAF Logical Web App (LOGICAL_WEB_APP) component exists.
            Found: 1.
            0 seconds
            PASSEDRA: Reporting and Analysis Check if Event Server data folder exists.
            Data file locations are valid.
            0 seconds
            PASSEDRA: Reporting and Analysis Check if the RAF Web App (RA_FRAMEWORK_WEB_APP) components exist.
            Found: 1. Hosts for the components: SRVPARESSD03.fr.world.socgen.

             

            Warm Regards,

            Amit

            • 3. Re: I am not able to login to HFR studio (11.1.2.2)
              Celvin Kattookaran

              What is the error that you are getting while configuring it?

               

              Regards

               

              Celvin

              • 4. Re: I am not able to login to HFR studio (11.1.2.2)
                Amit Porwal 007


                Hello Celvin,

                 

                The FinancialReporting0.log shows fiollowing error message:

                 

                ####<Oct 9, 2013 2:28:14 PM CEST> <Error> <JDBC> <SRVPARESSD03> <FinancialReporting0> <[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1381321694884> <BEA-001112> <Test "select count(*) from V8_VERSION" set up for pool "raframework_datasource" failed with exception: "java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'V8_VERSION'.".>

                 

                Warm Regards,

                Amit Porwal

                • 5. Re: I am not able to login to HFR studio (11.1.2.2)
                  $anty

                  Looks like some issues during installation/configuration of RA Framework components. Did you really select all RAF components ? because I think configurator is not able to find them.

                  OR the issue could be related to the database user/schema which may not have sufficient rights as recommended in Oracle doc.

                   

                  Regards,

                  Santy