12 Replies Latest reply on Mar 16, 2014 10:11 PM by Krishan Kumar-Oracle

    HFM 11.1.2.3 unable to connect to Oracle DB

    1011648


      I have recentrtly applied a maintenance release from 11.1.2.2 to 11.1.2.3 and all the product configured just fine. When I tried to connect to an HFM application the error log viewer is throwing and TNS error as shown below "TNS:could not resolve the connect identifier specified".

      When I tried to connect to HFM via SQL Plus from the HFM server I get " invalid username/password logon denied" but I can connect to hss and other schemas from the same sqlplus session.

      I know that HFM configuration created a new location for tnsnames.ora under HFM instance\config\dbclient and the parameters are correct.

      Is there any additonal step I need to do to get this issue resolved.

      Any help is greatly appreciated.

       

      <?xml version="1.0" ?>
      <EStr>
          <Ref>{6CB3A426-2AE6-4135-992D-F1CF447DBDF7}</Ref>
          <User></User>
          <DBUpdate>32702792</DBUpdate>
          <ESec>
              <Num HEX=0x80004005>-2147467259</Num>
              <Description Src=HFM>Unspecified error</Description>
              <Type>1</Type>
              <DTime>3/15/2014 3:29:33 PM</DTime>
              <Svr>CBIGDC-DFPRH902</Svr>
              <File>HfmADOConnection.cpp</File>
              <Line>591</Line>
              <Ver>11.1.2.3.000.4045</Ver>
              <DStr>ORA-12154: TNS:could not resolve the connect identifier specified</DStr>
              <ExErr></ExErr>
          </ESec>
          <ESec>
              <Num HEX=0x80041700>-2147215616</Num>
              <Description Src=HFM>An unknown error has occurred in the HsxSQLHelper object.</Description>
              <Type>1</Type>
              <DTime>3/15/2014 3:29:33 PM</DTime>
              <Svr>CBIGDC-DFPRH902</Svr>
              <File>CHsxSQLConnectionPool.cpp</File>
              <Line>585</Line>
              <Ver>11.1.2.3.000.4045</Ver>
              <DStr></DStr>
              <ExErr></ExErr>
          </ESec>
          <ESec>
              <Num HEX=0x800415C0>-2147215936</Num>
              <Description Src=HFM>An unknown error has occurred in the HsxServerImpl object.</Description>
              <Type>0</Type>
              <DTime>3/15/2014 3:29:42 PM</DTime>
              <Svr>CBIGDC-DFPRH902</Svr>
              <File>CHsxServerImpl.cpp</File>
              <Line>8813</Line>
              <Ver>11.1.2.3.000.4045</Ver>
              <DStr></DStr>
              <ExErr></ExErr>
          </ESec>
          <ESec>
              <Num HEX=0x800415C0>-2147215936</Num>
              <Description Src=HFM>An unknown error has occurred in the HsxServerImpl object.</Description>
              <Type>0</Type>
              <DTime>3/15/2014 3:29:52 PM</DTime>
              <Svr>CBIGDC-DFPRH902</Svr>
              <File>CHsxServer.cpp</File>
              <Line>93</Line>
              <Ver>11.1.2.3.000.4045</Ver>
              <DStr></DStr>
              <ExErr></ExErr>
          </ESec>
          <ESec>
              <Num HEX=0x800415C0>-2147215936</Num>
              <Description Src=HFM>An unknown error has occurred in the HsxServerImpl object.</Description>
              <Type>1</Type>
              <DTime>3/15/2014 3:30:01 PM</DTime>
              <Svr>CBIGDC-DFPRH902</Svr>
              <File>CHsxServerImpl.cpp</File>
              <Line>229</Line>
              <Ver>11.1.2.3.000.4045</Ver>
              <DStr></DStr>
              <ExErr></ExErr>
          </ESec>
      </EStr>

        • 1. Re: HFM 11.1.2.3 unable to connect to Oracle DB
          Krishan Kumar-Oracle

          Hi,

           

          Can you please post your TNS entries from tnsnames.ora here - you might want to hide some info if needed () ?

           

          Thanks

          • 2. Re: HFM 11.1.2.3 unable to connect to Oracle DB
            1011648

            tnsnames for dbclient created by hfm config:

            HFMTNS =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = host.domain.com)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVICE_NAME = Service_name)

                  (SERVER = DEDICATED)

                )

              )

             

            Oracle client tnsnames.ora

            Service_name=

            (DESCRIPTION =

               (ADDRESS_LIST =

                 (ADDRESS = (PROTOCOL = TCP)(HOST = host.domain.com)(PORT = 1521))

               )

            (CONNECT_DATA =

               (SERVICE_NAME = service_name)

            )

            )

            • 3. Re: HFM 11.1.2.3 unable to connect to Oracle DB
              Krishan Kumar-Oracle

              Make sure you have the System Environment Variable TNS_ADMIN set to ..\hyperion\user_projects\config\dbclient

              And it's value as below:


              SID=
                (DESCRIPTION =
                  (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = DB host)(PORT = DB port))
                  )
                  (CONNECT_DATA =
                    (SERVICE_NAME = SID)
                  )
                )

              HFMTNS=
                (DESCRIPTION =
                  (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = DB host)(PORT = DB port))
                  )
                  (CONNECT_DATA =
                    (SERVICE_NAME = SID)
                  )
                )

               

              Thanks!

              • 4. Re: HFM 11.1.2.3 unable to connect to Oracle DB
                1011648

                Tried your suggestion but did not work. I still get the same error message

                Thanks,

                • 5. Re: HFM 11.1.2.3 unable to connect to Oracle DB
                  Krishan Kumar-Oracle


                  Also make sure you have TNS entries from tnsnames.ora at following locations:


                  \hyperion\dbclient64\network\admin
                  \hyperion\dbclient32\network\admin

                   

                  as below:

                   

                  SID =
                    (DESCRIPTION =
                      (ADDRESS_LIST =
                        (ADDRESS = (PROTOCOL = TCP)(HOST = DB host)(PORT = DB port))
                      )
                      (CONNECT_DATA =
                        (SID = ????)
                        (SERVER = DEDICATED)
                      )
                    )
                  Service_name =
                    (DESCRIPTION =
                      (ADDRESS_LIST =
                        (ADDRESS = (PROTOCOL = TCP)(HOST = DB host)(PORT = DB port))
                      )
                      (CONNECT_DATA =
                        (SID = ????)
                        (SERVER = DEDICATED)
                      )
                    )

                  • 6. Re: HFM 11.1.2.3 unable to connect to Oracle DB
                    1011648

                    TNS entries updated on both 32 and 64 clients but still cannot connect via sqlplus or udl file. HFM Errorlogviewer is showing the following different message: "No such interface supported" instead of complaining about TNS resolution

                    <?xml version="1.0" ?>
                    <EStr>
                        <Ref>{F55B32DF-5DB3-4024-B91D-AAF3071ABAEC}</Ref>
                        <User>admin@Native Directory</User>
                        <DBUpdate>79036856</DBUpdate>
                        <ESec>
                            <Num HEX=0x80004002>-2147467262</Num>
                            <Description Src=HFM>No such interface supported</Description>
                            <Type>0</Type>
                            <DTime>3/15/2014 6:03:16 PM</DTime>
                            <Svr>CBIGDC-DFPRH902</Svr>
                            <File>CHsxServerImpl.cpp</File>
                            <Line>2041</Line>
                            <Ver>11.1.2.3.000.4045</Ver>
                            <DStr></DStr>
                            <ExErr></ExErr>
                        </ESec>
                        <ESec>
                            <Num HEX=0x80004002>-2147467262</Num>
                            <Description Src=HFM>No such interface supported</Description>
                            <Type>0</Type>
                            <DTime>3/15/2014 6:03:23 PM</DTime>
                            <Svr>CBIGDC-DFPRH902</Svr>
                            <File>CHsxServerImpl.cpp</File>
                            <Line>2377</Line>
                            <Ver>11.1.2.3.000.4045</Ver>
                            <DStr></DStr>
                            <ExErr></ExErr>
                        </ESec>
                        <ESec>
                            <Num HEX=0x80004002>-2147467262</Num>
                            <Description Src=HFM>No such interface supported</Description>
                            <Type>0</Type>
                            <DTime>3/15/2014 6:03:23 PM</DTime>
                            <Svr>CBIGDC-DFPRH902</Svr>
                            <File>CHsxServerImpl.cpp</File>
                            <Line>6103</Line>
                            <Ver>11.1.2.3.000.4045</Ver>
                            <DStr></DStr>
                            <ExErr></ExErr>
                        </ESec>
                        <ESec>
                            <Num HEX=0x80004002>-2147467262</Num>
                            <Description Src=HFM>No such interface supported</Description>
                            <Type>1</Type>
                            <DTime>3/15/2014 6:03:23 PM</DTime>
                            <Svr>CBIGDC-DFPRH902</Svr>
                            <File>CHsxServer.cpp</File>
                            <Line>2086</Line>
                            <Ver>11.1.2.3.000.4045</Ver>
                            <DStr>OpenApplication: TESTAPP</DStr>
                            <ExErr></ExErr>
                        </ESec>
                        <ESec>
                            <Num HEX=0x80004002>-2147467262</Num>
                            <Description Src=HFM>No such interface supported</Description>
                            <Type>0</Type>
                            <DTime>3/15/2014 6:03:23 PM</DTime>
                            <Svr>CBIGDC-DFPRH902</Svr>
                            <File>CHsxClient.cpp</File>
                            <Line>2820</Line>
                            <Ver>11.1.2.3.000.4045</Ver>
                            <DStr></DStr>
                            <ExErr></ExErr>
                        </ESec>
                    </EStr>

                    • 7. Re: HFM 11.1.2.3 unable to connect to Oracle DB
                      Krishan Kumar-Oracle

                      Was this app working previously? Any idea what has changed since that point?

                      UDL connectivity must be working for HFM to function.

                       

                      You might run through below actions one after another:


                      1. Complete recycle of your environment + Rebooting the HFM server.
                      2. EPM Configurator must be run to correct undetected broken communication between HFM and DB.
                      3. Clear out the userparams table - backup the <appname>_USERPARMS table and either purge this table, or purge the table individually for USERNAME = 'x'.
                      4. If nothing helps, how about performing an App Copy on the broken app, run schema update on the app copy, registering the new copy of it, re-importing security?


                      If it's a big app and you want to do a quick test by limiting the app copy options so that it only copies one year's worth of data from 1 scenario. If that works, then do a full app copy.

                       

                      Thanks!

                      • 8. Re: HFM 11.1.2.3 unable to connect to Oracle DB
                        1011648

                        BTW I am to create an HFM application and able to login to it. HFM Error log view not throwing the error messages shown previously. The weird thing is am still not able to connect to DB from Server via SQLPLUS and getting this error "invalid username/password logon denied". The DBA confirmed that password am entering is correct and am able to connect to other schemas from the same server.

                        Thank you Ktishan fro your help

                        • 9. Re: HFM 11.1.2.3 unable to connect to Oracle DB
                          Krishan Kumar-Oracle

                          DB user credentials are correct but not getting autheticated as the services are out of Sync.

                          At this point I would restart all services of the environment to make sure that Services intercommunication is in Sync.

                           

                          Pls do mark the answer as helpful or correct as appropriate for everyone's benefit.


                          Thanks,

                          Krish

                          • 10. Re: HFM 11.1.2.3 unable to connect to Oracle DB
                            amith.madisetty

                            Hi ,

                             

                            Could you please suggest on below things.

                             

                            Are your HSS,Workspace,HFM etc componentes installed on same server ? If yes then its problem with your HFM username and password ..!! If No then could you please try connecting to HFM user from your HSS Configured Server ?

                             

                            If you are able to connect to other schema's HSS,workspace etc from HFM application Server then it proves your Oracle Client has no issues . (I Believe you have all your schemas in same database ).

                             

                            Thanks

                            Amith

                            1 person found this helpful
                            • 11. Re: HFM 11.1.2.3 unable to connect to Oracle DB
                              1011648

                              My HSS and HFM are installed on different servers and all the schemas are in the same database.

                               

                              Thanks,

                              Hassan

                              • 12. Re: HFM 11.1.2.3 unable to connect to Oracle DB
                                Krishan Kumar-Oracle

                                Having HSS and HFM on different servers (possible HSS on Linux and HFM on Windows) is the standard deployment practice.

                                 

                                Coming back to the issue - what status it is at? Did you recycle the environment ?