This discussion is archived
3 Replies Latest reply: Sep 17, 2013 12:22 AM by NareshKumar RSS

Unable to create application

NareshKumar Newbie
Currently Being Moderated

     Hi,

We are getting error while creating HFM Application .

 

Error details are:

The following exception has occurred in .(): oracle.epm.fm.common.exception.HFMException with message: Error occurred while creating the application.

 

 

Please find HSvEnevt log file:

*
Error*11*naresh_mopala*09/16/2013 17:37:16*CHsvDataSource.cpp*Line 306*<?xml version="1.0"?>

<EStr><Ref>{31DA3DE0-BC81-4DA1-808F-C0FC41AB6DFB}</Ref><AppName/><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147467259</Num><Type>1</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>HfmADOConnection.cpp</File><Line>511</Line><Ver>11.1.2.2.000.3609</Ver><DStr>ORA-12520: TNS:listener could not find available handler for requested type of server</DStr></ESec><ESec><Num>-2147467259</Num><Type>0</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsxSQLConnectionPool.cpp</File><Line>375</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147467259</Num><Type>0</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsvDSSQL.cpp</File><Line>265</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147214847</Num><Type>1</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsvDataSourceImpl.cpp</File><Line>400</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147418113</Num><Type>0</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsvDataSourceImpl.cpp</File><Line>413</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147418113</Num><Type>0</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsvDataSourceImpl.cpp</File><Line>3701</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147214848</Num><Type>0</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsvDataSource.cpp</File><Line>306</Line><Ver>11.1.2.2.000.3609</Ver></ESec></EStr>

*
Error*11*naresh_mopala*09/16/2013 17:37:16*CHsxServerImpl.cpp*Line 5660*<?xml version="1.0"?>

<EStr><Ref>{31DA3DE0-BC81-4DA1-808F-C0FC41AB6DFB}</Ref><AppName/><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147467259</Num><Type>1</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>HfmADOConnection.cpp</File><Line>511</Line><Ver>11.1.2.2.000.3609</Ver><DStr>ORA-12520: TNS:listener could not find available handler for requested type of server</DStr></ESec><ESec><Num>-2147467259</Num><Type>0</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsxSQLConnectionPool.cpp</File><Line>375</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147467259</Num><Type>0</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsvDSSQL.cpp</File><Line>265</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147214847</Num><Type>1</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsvDataSourceImpl.cpp</File><Line>400</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147418113</Num><Type>0</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsvDataSourceImpl.cpp</File><Line>413</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147418113</Num><Type>0</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsvDataSourceImpl.cpp</File><Line>3701</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147214848</Num><Type>0</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsvDataSource.cpp</File><Line>306</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147214848</Num><Type>1</Type><DTime>9/16/2013 5:37:16 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsxServerImpl.cpp</File><Line>5660</Line><Ver>11.1.2.2.000.3609</Ver><DStr>SampApp</DStr><PSec><Param>admin@Native Directory</Param></PSec></ESec></EStr>

*
Error*11*naresh_mopala*09/16/2013 17:37:18*CHsxServerImpl.cpp*Line 5667*<?xml version="1.0"?>

<EStr><Ref>{E7A89D6D-447F-40A0-ACB1-DE861E0D8B84}</Ref><AppName/><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147220955</Num><Type>1</Type><DTime>9/16/2013 5:37:18 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsxServerImpl.cpp</File><Line>5667</Line><Ver>11.1.2.2.000.3609</Ver></ESec></EStr>

*
Error*11*naresh_mopala*09/16/2013 17:37:24*CHsxServer.cpp*Line 1285*<?xml version="1.0"?>

<EStr><Ref>{E7A89D6D-447F-40A0-ACB1-DE861E0D8B84}</Ref><AppName/><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147220955</Num><Type>1</Type><DTime>9/16/2013 5:37:18 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsxServerImpl.cpp</File><Line>5667</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147220955</Num><Type>0</Type><DTime>9/16/2013 5:37:24 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsxServer.cpp</File><Line>1285</Line><Ver>11.1.2.2.000.3609</Ver></ESec></EStr>

*
Error*11*naresh_mopala*09/16/2013 17:37:24*CHsxServer.cpp*Line 856*<?xml version="1.0"?>

<EStr><Ref>{E7A89D6D-447F-40A0-ACB1-DE861E0D8B84}</Ref><AppName/><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147220955</Num><Type>1</Type><DTime>9/16/2013 5:37:18 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsxServerImpl.cpp</File><Line>5667</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147220955</Num><Type>0</Type><DTime>9/16/2013 5:37:24 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsxServer.cpp</File><Line>1285</Line><Ver>11.1.2.2.000.3609</Ver></ESec><ESec><Num>-2147220955</Num><Type>0</Type><DTime>9/16/2013 5:37:24 PM</DTime><Svr>PUNITP259430D</Svr><File>CHsxServer.cpp</File><Line>856</Line><Ver>11.1.2.2.000.3609</Ver></ESec></EStr>

*
Error*11*naresh_mopala*09/16/2013 17:37:25**Line 0*<?xml version="1.0"?>

<EStr><Ref>{D54A598A-D0E9-44F1-A793-2249A4625C52}</Ref><AppName/><User>naresh_mopala</User><DBUpdate>1</DBUpdate><ESec><Num>-2147220955</Num><Type>1</Type><DTime>9/16/2013 5:37:24 PM</DTime><Svr>PUNITP259430D</Svr><File/><Line>0</Line><Ver/></ESec></EStr>

  • 1. Re: Unable to create application
    thanasis_agr Pro
    Currently Being Moderated

    Hi there,

     

    There seems to be an issue with your database.

     

    Have you successfully configured it?

     

    R

     

    Thanos

  • 2. Re: Unable to create application
    SDM Explorer
    Currently Being Moderated

    I see the below error from the provided log information:

     

    ORA-12520: TNS:listener could not find available handler for requested type of server

     

     

        Cause could be that the type of service handler requested by the client is incorrect or not registered for the requested SERVICE_NAME/INSTANCE_NAME, or the database instance is not registered with the listener.

     

     

        --> If you suspect the problem is the wrong type of service handler, perform these steps:

     

     

    1) If (server=value) is set is in the connect descriptor, ensure that the value is set to the appropriate service handler type for the database, that is, dedicated for dedicated server or shared for dispatchers. You can use the Listener Control utility SERVICES command to see what service handlers are currently registered with the listener.

     

    2) If USE_DEDICATED_SERVER is set to ON in the sqlnet.ora file, then ensure the database is configured to use dedicated servers. If it is not, set this parameter to off.

    3) Ensure that the database instance is running. If the instance not running, start it so that it can register with the listener.

  • 3. Re: Unable to create application
    NareshKumar Newbie
    Currently Being Moderated

    Hi,

    Thanks for the reply.

    Configuration with database was successful.

     

    I have following details fetched from Oracle Database server:

    C:\Users\naresh_mopala>lsnrctl services orcl

    LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 17-SEP-2013 12:43
    :22

    Copyright (c) 1991, 2010, Oracle.  All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HYDPCM308472D.ad.
    .com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.ad.c
    om)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established:0 refused:0
             LOCAL SERVER
    Service "orcl.ad.infosys.com" has 1 instance(s).
      Instance "orcl", status READY, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established:5257 refused:0 state:ready
             LOCAL SERVER
    Service "orclXDB.ad.infosys.com" has 1 instance(s).
      Instance "orcl", status READY, has 1 handler(s) for this service...
        Handler(s):
          "D000" established:0 refused:0 current:0 max:1022 state:ready
             DISPATCHER <machine: HYDPCM308472D, pid: 2892>
             (ADDRESS=(PROTOCOL=tcp)(HOST=HYDPCM308472D.ad.com)(PORT=62758))

    The command completed successfully

     

    and Details of TnsNames.ora file are

    C:\Users\naresh_mopala>lsnrctl services orcl

    LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 17-SEP-2013 12:43
    :22

    Copyright (c) 1991, 2010, Oracle.  All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HYDPCM308472D.ad.infosys
    .com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.ad.c
    om)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established:0 refused:0
             LOCAL SERVER
    Service "orcl.ad.infosys.com" has 1 instance(s).
      Instance "orcl", status READY, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established:5257 refused:0 state:ready
             LOCAL SERVER
    Service "orclXDB.ad.infosys.com" has 1 instance(s).
      Instance "orcl", status READY, has 1 handler(s) for this service...
        Handler(s):
          "D000" established:0 refused:0 current:0 max:1022 state:ready
             DISPATCHER <machine: HYDPCM308472D, pid: 2892>
             (ADDRESS=(PROTOCOL=tcp)(HOST=HYDPCM308472D.ad.com)(PORT=62758))

    The command completed successfully

     

    TnsNames.ora file

    # tnsnames.ora Network Configuration File: D:\app\naresh_mopala\product\11.2.0\dbhome_2\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    LISTENER_ORCL =
      (ADDRESS = (PROTOCOL = TCP)(HOST = HYDPCM308472D.ad.com)(PORT = 1521))


    ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
        (CONNECT_DATA =
          (SID = CLRExtProc)
          (PRESENTATION = RO)
        )
      )

    ORCL =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = HYDPCM308472D.ad.com)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl.ad.com)
        )
      )

     

    Please advise if tnsnames.ora is correct or not. I have not worked Oracle database administartion side.

     

    Thanks,

    Naresh Mopala.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points