4 Replies Latest reply on Dec 22, 2010 8:18 PM by David Debish

    HFM and IIS

    foksh
      what are the steps required to enable HFM with IIS.

      when I browse the URL "http://servername:19000/hfm" I get that The website is under maintenance. or The website has a programming error.

      maybe IIS is not the reason for that error but i was guessing it might be.

      Thanks,
      foksh
        • 1. Re: HFM and IIS
          foksh
          I checked the Windows Event viewer and i get this error:

          Error 11; Hyperion; 12/20/2010 17:07:41; CHsxServer.cpp; Line 851; <?xml version="1.0"?>
          <EStr><Ref>{1642EA18-1C37-45D9-9CC4-F1C7F037D8D2}</Ref><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147467259</Num><Type>0</Type><DTime>12/20/2010 5:07:41 PM</DTime><Svr>THSERV52</Svr><File>CHsxServerImpl.cpp</File><Line>3503</Line><Ver>9.3.1.0.1502</Ver></ESec><ESec><Num>-2147467259</Num><Type>0</Type><DTime>12/20/2010 5:07:41 PM</DTime><Svr>THSERV52</Svr><File>CHsxServer.cpp</File><Line>1109</Line><Ver>9.3.1.0.1502</Ver></ESec><ESec><Num>-2147467259</Num><Type>0</Type><DTime>12/20/2010 5:07:41 PM</DTime><Svr>THSERV52</Svr><File>CHsxServer.cpp</File><Line>851</Line><Ver>9.3.1.0.1502</Ver></ESec></EStr>
          • 2. Re: HFM and IIS
            David Debish
            Hi foksh,

            Looks like your runnning HFM 9.3.1.

            Is this a new installation of HFM?
            What version of IE are you using?
            Are you able to logon onto HFM using the desktop client?
            What version of IIS is running on the Web/Report server?
            What platform/version of OS are you running on the Web/Report server?
            Was this working before and then suddenly stopped working?
            Why do you believe this is an issue with IIS?
            What errors are recorded in the HsvEventLog.log? (Found on the HFM application server. Hsveventlog.log. is the main log that is used to track most HFM activities. They include messages, warnings and errors)

            There are several troubleshooting suggestions in the HFM Installation Guide for 'Connectivity Issues'.

            Given the errors you posted I came accross two articles published by Oracle.
            It 's a shot in the dark without haveing more inoformation.

            Please read below 2 possible causes for the Event errors your posted.


            Possible Cause #1
            Error %0 When Creating A Financial Management Application [ID 784121.1]

            --------------------------------------------------------------------------------
            Modified 13-APR-2010 Type PROBLEM Status PUBLISHED
            --------------------------------------------------------------------------------
            Applies to:
            Hyperion Financial Management - Version: 4.1.0.0.00 to 11.1.1.1.00 - Release: 4.1 to 11.1
            Information in this document applies to any platform.

            Symptoms:
            Users are receiving error %0 when creating a Financial Management application.
            Users can see the Financial Management project from the Win-32 client but only fails during the application creation.
            Despite the application failing to be created in Financial Management the application does get added to Shared Services and listed in the Financial Manamgement project.
            The application is created in the following Wedav path ..../interop/content/files/products/HFM 9.x/Published but NOT in ..../interop/content/files/AdminProjects/HFM 9.x.
            Nothing is created in the Financial Management database (HSX_DATASOURCES table).
            The following is reported in the Windows EventViewer:
            1. "An unknown error has occurred in the HsxServer object."
            2. Error related to CHFMCASSecurity.cpp, CHsxServerImpl.cpp and CHsxServer.cpp in windows event viewer application log.

            The HsvEventLog.log of HFM reports the error below:
            "Error in SetDataBrokerURL()".

            Cause:
            Financial Management is not communicating properly with HSS. The %0 error is related to security.
            Possible causes are:
            1. The version of Financial Management is not compatible with the version of Shared Services.
            2. The css_version.jar file used by Financial Management is not compatible with the css_version.jar file of Shared Services.

            Solution:
            1. Make sure that the versions of Financial Management and Shared Services are compatible refering to Hyperion Support Matrix for more information.

            http://www.oracle.com/technology/products/bi/hyperion-supported-platforms.html

            2. The version of the CSS file used by the Financial Management and Shared Services can change through patch or service fix updates. Make sure that the css_version.jar file used by Financial Management is the same as the css_version.jar of Shared Services.

            The css_version used on each server is found under %HYPERION_HOME%/common/CSS/version/lib.

            Note that the css_version used by HFM is referenced by ClassPath registry key under "HKLM\Software\Hyperion Solutions\Hyperion Financial Management\Server\Authentication" on the Financial Management Application Server.

            3. Re-register Financial Management with Shared Services to ensure connectivity and correct registration.
            --------------------------------------------------------------------------------
            Products
            --------------------------------------------------------------------------------
            Middleware > Enterprise Performance Management > Financial Management > Hyperion Financial Management


            Possible Cause #2
            Creation of Classic Application in Workspace Fails with Error 'An Unknown Error Has Occurred in the HsxServerImpl Object' [ID 1077529.1]

            --------------------------------------------------------------------------------
            Modified 03-SEP-2010 Type PROBLEM Status PUBLISHED
            --------------------------------------------------------------------------------
            Applies to:
            Hyperion Financial Management - Version: 11.1.1.3.00 and later [Release: 11.1 and later ]
            Information in this document applies to any platform.

            Symptoms:
            Creation of classic application in workspace fails with following error message

            An unknown error has occurred in the HsxServerImpl object
            Additionally following errors may appear in HsvEventlog.log during start, creation or deletion of a Financial Management application

            ORA-12537: TNS:connection closed
            20:1092:Failed to initialize EPM System registry.

            File: HfmADOConnection.cpp Version: 11.1.1.3.0.2413 Line: 268 Error: (-2147467259)(0x80004005)(Unspecified error)
            File: CHsxSQLConnectionPool.cpp Version: 11.1.1.3.0.2413 Line: 375 Error: (-2147467259)(0x80004005)(Unspecified error)
            File: CHsxServerImpl.cpp Version: 11.1.1.3.0.2413 Line: 86 Error: (-2147467259)(0x80004005)(Unspecified error)

            Cause:
            Number of operating system user processes that can simultaneously connect to Oracle database is too low.
            PROCESSES setting specifies the maximum number of operating system user processes that can simultaneously connect to Oracle database. Because HFM only works with dedicated servers, each connection requires a process. Each HFM application requires a minimum of 20 database connections in addition to the number specified by the HFM database connection pool setting. For example, if the HFM database connection pool setting is 40, then each HFM application on each application server requires at least 60 Oracle database connections.

            Solution:
            Database administrator has to increase maximum number of operating system user processes that can simultaneously connect to Oracle database.
            For information on how to calculate the number of processes for Oracle database see
            Doc ID 1083460.1 - Hyperion Financial Management (HFM) Performance Tuning Guide, Fusion Edition

            References
            NOTE:1083460.1 - Hyperion Financial Management (HFM) Performance Tuning Guide, Fusion Edition

            Related
            --------------------------------------------------------------------------------
            Products
            --------------------------------------------------------------------------------
            Middleware > Enterprise Performance Management > Financial Management > Hyperion Financial Management
            Keywords
            --------------------------------------------------------------------------------
            TNS; WORKSPACE; INITIALIZING; CONFIGURATION; CONNECT TO DATABASE; OBJECT DATABASE; TNS CONNECTION CLOSED
            Errors
            --------------------------------------------------------------------------------
            ORA-12537; 86 ERROR; 375 ERROR; 268 ERROR

            Cheers,
            David

            -David

            A good place to start for Hyperion documentation is:
            http://www.oracle.com/technetwork/middleware/epm/documentation/epm-096302.html


            A good place for learning about the Hyperion products and their features is:
            http://www.oracle.com/technetwork/tutorials/index.html
            Hyperion specific tutorials:
            http://apex.oracle.com/pls/apex/f?p=9830:hyperion:1797489450022582::NO:::


            A good place to read about best practices and find white papers is:
            http://www.oracle.com/technetwork/middleware/bi-foundation/resource-library-090986.html


            A great place to get an excel macro that tells you what new product features have been added since the last version is:
            https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1092114.1

            My Oracle Support - Knowledge Base is a collection of articles, examples, illustrations, solutions, resources, and services.
            My Oracle Support is a service provided by Oracle
            My Oracle Support is available as part of your Oracle Premier Support subscription. To get started, visit oracle.com/support, click on My Oracle Support, and begin reaping the benefits of this exclusive Web support portal:
            https://support.oracle.com/
            • 3. Re: HFM and IIS
              foksh
              Thanks David for you valuable reply,

              yes it is fresh installation, using IE7, IIS 6
              yes I am able to log on web-client, but i receive an error when trying to create new application.

              I got my log error if it can help,

              Error*11*Hyperion*12/20/2010 17:07:41*CHFMCASSecurity.cpp*Line 502*<?xml version="1.0"?>

              <EStr><Ref>{36FB215F-9996-4244-B139-A25C147E9887}</Ref><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147467259</Num><Type>1</Type><DTime>12/20/2010 5:07:41 PM</DTime><Svr>THSERV52</Svr><File>CHFMCASSecurity.cpp</File><Line>502</Line><Ver>9.3.1.0.1502</Ver><ExErr>The system cannot find the path specified.</ExErr></ESec></EStr>


              Error*11*Hyperion*12/20/2010 17:07:41*CHsxServerImpl.cpp*Line 3503*<?xml version="1.0"?>
              <EStr><Ref>{1642EA18-1C37-45D9-9CC4-F1C7F037D8D2}</Ref><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147467259</Num><Type>0</Type><DTime>12/20/2010 5:07:41 PM</DTime><Svr>THSERVer</Svr><File>CHsxServerImpl.cpp</File><Line>3503</Line><Ver>9.3.1.0.1502</Ver></ESec></EStr>

              Error*11*Hyperion*12/20/2010 17:07:41*CHsxServer.cpp*Line 1109*<?xml version="1.0"?>

              <EStr><Ref>{1642EA18-1C37-45D9-9CC4-F1C7F037D8D2}</Ref><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147467259</Num><Type>0</Type><DTime>12/20/2010 5:07:41 PM</DTime><Svr>THSERV52</Svr><File>CHsxServerImpl.cpp</File><Line>3503</Line><Ver>9.3.1.0.1502</Ver></ESec><ESec><Num>-2147467259</Num><Type>0</Type><DTime>12/20/2010 5:07:41 PM</DTime><Svr>THSERV52</Svr><File>CHsxServer.cpp</File><Line>1109</Line><Ver>9.3.1.0.1502</Ver></ESec></EStr>

              *
              Error*11*Hyperion*12/20/2010 17:07:41*CHsxServer.cpp*Line 851*<?xml version="1.0"?>

              <EStr><Ref>{1642EA18-1C37-45D9-9CC4-F1C7F037D8D2}</Ref><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147467259</Num><Type>0</Type><DTime>12/20/2010 5:07:41 PM</DTime><Svr>THSERV52</Svr><File>CHsxServerImpl.cpp</File><Line>3503</Line><Ver>9.3.1.0.1502</Ver></ESec><ESec><Num>-2147467259</Num><Type>0</Type><DTime>12/20/2010 5:07:41 PM</DTime><Svr>THSERV52</Svr><File>CHsxServer.cpp</File><Line>1109</Line><Ver>9.3.1.0.1502</Ver></ESec><ESec><Num>-2147467259</Num><Type>0</Type><DTime>12/20/2010 5:07:41 PM</DTime><Svr>THSERV52</Svr><File>CHsxServer.cpp</File><Line>851</Line><Ver>9.3.1.0.1502</Ver></ESec></EStr>

              *
              Information*11*SYSTEM*12/20/2010 17:38:35*IOCPServer.cpp*Line 262*<?xml version="1.0"?>
              <EStr><Ref>{3257DFC0-4736-4804-AA96-A6326DCB2FAA}</Ref><User/><DBUpdate>1</DBUpdate><ESec><Num>291686</Num><Type>1</Type><DTime>12/20/2010 5:38:35 PM</DTime><Svr>THSERV52</Svr><File>IOCPServer.cpp</File><Line>262</Line><Ver>9.3.1.0.1502</Ver><PSec><Param>Hyperion FM-DME Listener service stopped on port: 9097</Param></PSec></ESec></EStr>

              *
              Information*11*SYSTEM*12/20/2010 17:38:35*DMEListener.cpp*Line 664*<?xml version="1.0"?>
              <EStr><Ref>{E24DEBA6-0B94-4D71-B135-C20841766F03}</Ref><User/><DBUpdate>1</DBUpdate><ESec><Num>291694</Num><Type>1</Type><DTime>12/20/2010 5:38:35 PM</DTime><Svr>THSERV52</Svr><File>DMEListener.cpp</File><Line>664</Line><Ver>9.3.1.0.1502</Ver><PSec><Param>Hyperion FM-DME Listener service stopped.</Param></PSec></ESec></EStr>

              *
              • 4. Re: HFM and IIS
                David Debish
                Hi foksh,

                I take it your running Hyperion Shared Services 9.3.1. In the previous article posted it stated that these type of errors can be found in cases where Shared Services was patched beyond a point supported by HFM 9.3.1.

                Were you able to confirm?:
                2. The version of the CSS file used by the Financial Management and Shared Services can change through patch or service fix updates. Make sure that the css_version.jar file used by Financial Management is the same as the css_version.jar of Shared Services.


                Otherwise you might want to checkout the following:

                Cannot open an FM Application from BI+ Workspace [ID 752456.1]

                --------------------------------------------------------------------------------
                Modified 23-APR-2010 Type PROBLEM Status PUBLISHED
                --------------------------------------------------------------------------------
                Applies to:
                Hyperion Financial Management - Version: 9.2.1.0.00 to 11.1.1.3.00 - Release: 9.2 to 11.1
                Microsoft Windows (32-bit)

                Symptoms:
                Error messages:

                1. From Workspace:

                "There was some communication error. Response is : http://<webserver>:19000/hfm/GlobalWorkspaceNav/bpm/modules/com/hyperion/hfm/web/appcontainer/Adf.asp"

                2. From FM Win32 client:

                Error Reference Number: {41D74618-8332-43D9-93EF-4D3454B421D0}
                Num: 0x800412c4;Type: 1;DTime: 11/13/2008 8:30:49 PM;Svr: SERVERNAME;File: ;Line: -1;Ver: 9.3.1.0.1502;DStr: Error in doesInstanceExist();
                Num: 0x800412c4;Type: 0;DTime: 11/13/2008 8:30:49 PM;Svr: SERVERNAME;File: CHFMCASSecurity.cpp;Line: 904;Ver: 9.3.1.0.1502;
                Num: 0x800412c4;Type: 1;DTime: 11/13/2008 8:30:49 PM;Svr: SERVERNAME;File: CHsxServer.cpp;Line: 1382;Ver: 9.3.1.0.1502;
                Num: 0x800412c4;Type: 0;DTime: 11/13/2008 8:30:49 PM;Svr: SERVERNAME;File: CHsxClient.cpp;Line: 2272;Ver: 9.3.1.0.1502;

                When users try to connect to FM cluster, application names are not displayed.

                Cause:
                FM Server is unable to access the Shared Services configuration information.

                Based on the error message, the issue is related to CHFMCASSecurity.cpp and CHsxServer.cpp, as the HsxServer.exe cannot initialise CASSecurity.exe process to make an connection to Shared Services.

                In the Windows Task Manager on the FM application server, only the HsxServer.exe and CASSecurity.exe Windows processes are running.

                In order to get SS configuration information, FM uses the link which specify in the ConnectionInfo registry key on the FM Application Server. Should the link fail, FM will open the HsxServer.exe and CASSecurity.exe processes but it will not be able to list FM applications when users click on connect to Server/Cluster.

                Solution:
                Verify that FM Application Server(s) can connect to SS configuration (CSS.xml) using the value of the FM Server registry key "ConnectionInfo" found in the registry key on the FM Application Server:

                HEY_KEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Financial Management\Server\Authentication.

                The parameter should look like:

                ConnectionInfo=http://<servername>:58080/interop/framework/getCSSCongFile

                When this link is working users will be able to access the FM applications


                Related
                --------------------------------------------------------------------------------
                Products
                --------------------------------------------------------------------------------
                Middleware > Enterprise Performance Management > Financial Management > Hyperion Financial Management


                Confirm your connection wiith interop from the app server and report back.

                G'Luck,
                -David