This discussion is archived
7 Replies Latest reply: Sep 12, 2013 2:07 PM by Sh!va RSS

Planning data sources management

salezian Newbie
Currently Being Moderated

Hi Everyone

I'm using Hyperion Planning 11.1.2.3.0.26. I've faced problem when tried to configure data source for EPM Planning Application. Data source creation wizard is always finish with failed status. Using the same parameters I'm able to create data source for classic application with no problems. I stuck and don't know what to do next.

I'd be greatful for any kind of help.

 

Regards

  • 1. Re: Planning data sources management
    JohnGoodwin Oracle ACE
    Currently Being Moderated

    Are you saying you can create a data source for a classic planning application but not able to create an EPMA application? Have you checked all the relevant logs?

     

    Cheers

     

    John

    http://john-goodwin.blogspot.com/

  • 2. Re: Planning data sources management
    salezian Newbie
    Currently Being Moderated

    I've checked EPMA log. And all I found there was:

    <html xmlns="http://www.w3.org/1999/xhtml">

    <head>

    <title>IIS 7.5 Detailed Error - 404.0 - Not Found</title>

    <style type="text/css">

    <!--

    body{margin:0;font-size:.7em;font-family:Verdana,Arial,Helvetica,sans-serif;background:#CBE1EF;}

    code{margin:0;color:#006600;font-size:1.1em;font-weight:bold;}

    .config_source code{font-size:.8em;color:#000000;}

    pre{margin:0;font-size:1.4em;word-wrap:break-word;}

    ul,ol{margin:10px 0 10px 40px;}

    ul.first,ol.first{margin-top:5px;}

    fieldset{padding:0 15px 10px 15px;}

    .summary-container fieldset{padding-bottom:5px;margin-top:4px;}

    legend.no-expand-all{padding:2px 15px 4px 10px;margin:0 0 0 -12px;}

    legend{color:#333333;padding:4px 15px 4px 10px;margin:4px 0 8px -12px;_margin-top:0px;

    border-top:1px solid #EDEDED;border-left:1px solid #EDEDED;border-right:1px solid #969696;

    border-bottom:1px solid #969696;background:#E7ECF0;font-weight:bold;font-size:1em;}

    a:link,a:visited{color:#007EFF;font-weight:bold;}

    a:hover{text-decoration:none;}

    h1{font-size:2.4em;margin:0;color:#FFF;}

    h2{font-size:1.7em;margin:0;color:#CC0000;}

    h3{font-size:1.4em;margin:10px 0 0 0;color:#CC0000;}

    h4{font-size:1.2em;margin:10px 0 5px 0;

    }#header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:"trebuchet MS",Verdana,sans-serif;

    color:#FFF;background-color:#5C87B2;

    }#content{margin:0 0 0 2%;position:relative;}

    .summary-container,.content-container{background:#FFF;width:96%;margin-top:8px;padding:10px;position:relative;}

    .config_source{background:#fff5c4;}

    .content-container p{margin:0 0 10px 0;

    }#details-left{width:35%;float:left;margin-right:2%;

    }#details-right{width:63%;float:left;overflow:hidden;

    }#server_version{width:96%;_height:1px;min-height:1px;margin:0 0 5px 0;padding:11px 2% 8px 2%;color:#FFFFFF;

    background-color:#5A7FA5;border-bottom:1px solid #C1CFDD;border-top:1px solid #4A6C8E;font-weight:normal;

    font-size:1em;color:#FFF;text-align:right;

    }#server_version p{margin:5px 0;}

    table{margin:4px 0 4px 0;width:100%;border:none;}

    td,th{vertical-align:top;padding:3px 0;text-align:left;font-weight:bold;border:none;}

    th{width:30%;text-align:right;padding-right:2%;font-weight:normal;}

    thead th{background-color:#ebebeb;width:25%;

    }#details-right th{width:20%;}

    table tr.alt td,table tr.alt th{background-color:#ebebeb;}

    .highlight-code{color:#CC0000;font-weight:bold;font-style:italic;}

    .clear{clear:both;}

    .preferred{padding:0 5px 2px 5px;font-weight:normal;background:#006633;color:#FFF;font-size:.8em;}

    -->

    </style>

     

    </head>

    <body>

    <div id="header"><h1>Server Error in Application "DEFAULT WEB SITE"</h1></div>

    <div id="server_version"><p>Internet Information Services 7.5</p></div>

    <div id="content">

    <div class="content-container">

    <fieldset><legend>Error Summary</legend>

      <h2>HTTP Error 404.0 - Not Found</h2>

      <h3>The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.</h3>

    </fieldset>

    </div>

    <div class="content-container">

    <fieldset><legend>Detailed Error Information</legend>

      <div id="details-left">

       <table border="0" cellpadding="0" cellspacing="0">

        <tr class="alt"><th>Module</th><td>IIS Web Core</td></tr>

        <tr><th>Notification</th><td>MapRequestHandler</td></tr>

        <tr class="alt"><th>Handler</th><td>StaticFile</td></tr>

        <tr><th>Error Code</th><td>0x80070002</td></tr>

       

       </table>

      </div>

      <div id="details-right">

       <table border="0" cellpadding="0" cellspacing="0">

        <tr class="alt"><th>Requested URL</th><td>http://Hipcio:80/HyperionPlanning/servlet/HspAppManagerServlet?action=changeapptype&app_name=samplapl&app_type=BPMA</td></tr>

        <tr><th>Physical Path</th><td>C:\inetpub\wwwroot\HyperionPlanning\servlet\HspAppManagerServlet</td></tr>

        <tr class="alt"><th>Logon Method</th><td>Anonymous</td></tr>

        <tr><th>Logon User</th><td>Anonymous</td></tr>

       

       </table>

       <div class="clear"></div>

      </div>

    </fieldset>

    </div>

    <div class="content-container">

    <fieldset><legend>Most likely causes:</legend>

      <ul> <li>The directory or file specified does not exist on the Web server.</li> <li>The URL contains a typographical error.</li> <li>A custom filter or module, such as URLScan, restricts access to the file.</li> </ul>

    </fieldset>

    </div>

    <div class="content-container">

    <fieldset><legend>Things you can try:</legend>

      <ul> <li>Create the content on the Web server.</li> <li>Review the browser URL.</li> <li>Create a tracing rule to track failed requests for this HTTP status code and see which module is calling SetStatus. For more information about creating a tracing rule for failed requests, click <a href="http://go.microsoft.com/fwlink/?LinkID=66439">here</a>. </li> </ul>

    </fieldset>

    </div>

     

     

    <div class="content-container">

    <fieldset><legend>Links and More Information</legend>

      This error means that the file or directory does not exist on the server. Create the file or directory and try the request again.

      <p><a href="http://go.microsoft.com/fwlink/?LinkID=62293&IIS70Error=404,0,0x80070002,7601">View more information &raquo;</a></p>

     

    </fieldset>

    </div>

    </div>

    </body>

    </html>

    com.hyperion.awb.web.common.BaseServiceException: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

    <html xmlns="http://www.w3.org/1999/xhtml">

    <head>

    <title>IIS 7.5 Detailed Error - 404.0 - Not Found</title>

    <style type="text/css">

    <!--

    body{margin:0;font-size:.7em;font-family:Verdana,Arial,Helvetica,sans-serif;background:#CBE1EF;}

    code{margin:0;color:#006600;font-size:1.1em;font-weight:bold;}

    .config_source code{font-size:.8em;color:#000000;}

    pre{margin:0;font-size:1.4em;word-wrap:break-word;}

    ul,ol{margin:10px 0 10px 40px;}

    ul.first,ol.first{margin-top:5px;}

    fieldset{padding:0 15px 10px 15px;}

    .summary-container fieldset{padding-bottom:5px;margin-top:4px;}

    legend.no-expand-all{padding:2px 15px 4px 10px;margin:0 0 0 -12px;}

    legend{color:#333333;padding:4px 15px 4px 10px;margin:4px 0 8px -12px;_margin-top:0px;

    border-top:1px solid #EDEDED;border-left:1px solid #EDEDED;border-right:1px solid #969696;

    border-bottom:1px solid #969696;background:#E7ECF0;font-weight:bold;font-size:1em;}

    a:link,a:visited{color:#007EFF;font-weight:bold;}

    a:hover{text-decoration:none;}

    h1{font-size:2.4em;margin:0;color:#FFF;}

    h2{font-size:1.7em;margin:0;color:#CC0000;}

    h3{font-size:1.4em;margin:10px 0 0 0;color:#CC0000;}

    h4{font-size:1.2em;margin:10px 0 5px 0;

    }#header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:"trebuchet MS",Verdana,sans-serif;

    color:#FFF;background-color:#5C87B2;

    }#content{margin:0 0 0 2%;position:relative;}

    .summary-container,.content-container{background:#FFF;width:96%;margin-top:8px;padding:10px;position:relative;}

    .config_source{background:#fff5c4;}

    .content-container p{margin:0 0 10px 0;

    }#details-left{width:35%;float:left;margin-right:2%;

    }#details-right{width:63%;float:left;overflow:hidden;

    }#server_version{width:96%;_height:1px;min-height:1px;margin:0 0 5px 0;padding:11px 2% 8px 2%;color:#FFFFFF;

    background-color:#5A7FA5;border-bottom:1px solid #C1CFDD;border-top:1px solid #4A6C8E;font-weight:normal;

    font-size:1em;color:#FFF;text-align:right;

    }#server_version p{margin:5px 0;}

    table{margin:4px 0 4px 0;width:100%;border:none;}

    td,th{vertical-align:top;padding:3px 0;text-align:left;font-weight:bold;border:none;}

    th{width:30%;text-align:right;padding-right:2%;font-weight:normal;}

    thead th{background-color:#ebebeb;width:25%;

    }#details-right th{width:20%;}

    table tr.alt td,table tr.alt th{background-color:#ebebeb;}

    .highlight-code{color:#CC0000;font-weight:bold;font-style:italic;}

    .clear{clear:both;}

    .preferred{padding:0 5px 2px 5px;font-weight:normal;background:#006633;color:#FFF;font-size:.8em;}

    -->

    </style>

     

    </head>

    <body>

    <div id="header"><h1>Server Error in Application "DEFAULT WEB SITE"</h1></div>

    <div id="server_version"><p>Internet Information Services 7.5</p></div>

    <div id="content">

    <div class="content-container">

    <fieldset><legend>Error Summary</legend>

      <h2>HTTP Error 404.0 - Not Found</h2>

      <h3>The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.</h3>

    </fieldset>

    </div>

    <div class="content-container">

    <fieldset><legend>Detailed Error Information</legend>

      <div id="details-left">

       <table border="0" cellpadding="0" cellspacing="0">

        <tr class="alt"><th>Module</th><td>IIS Web Core</td></tr>

        <tr><th>Notification</th><td>MapRequestHandler</td></tr>

        <tr class="alt"><th>Handler</th><td>StaticFile</td></tr>

        <tr><th>Error Code</th><td>0x80070002</td></tr>

       

       </table>

      </div>

      <div id="details-right">

       <table border="0" cellpadding="0" cellspacing="0">

        <tr class="alt"><th>Requested URL</th><td>http://Hipcio:80/HyperionPlanning/servlet/HspAppManagerServlet?action=changeapptype&app_name=samplapl&app_type=BPMA</td></tr>

        <tr><th>Physical Path</th><td>C:\inetpub\wwwroot\HyperionPlanning\servlet\HspAppManagerServlet</td></tr>

        <tr class="alt"><th>Logon Method</th><td>Anonymous</td></tr>

        <tr><th>Logon User</th><td>Anonymous</td></tr>

       

       </table>

       <div class="clear"></div>

      </div>

    </fieldset>

    </div>

    <div class="content-container">

    <fieldset><legend>Most likely causes:</legend>

      <ul> <li>The directory or file specified does not exist on the Web server.</li> <li>The URL contains a typographical error.</li> <li>A custom filter or module, such as URLScan, restricts access to the file.</li> </ul>

    </fieldset>

    </div>

    <div class="content-container">

    <fieldset><legend>Things you can try:</legend>

      <ul> <li>Create the content on the Web server.</li> <li>Review the browser URL.</li> <li>Create a tracing rule to track failed requests for this HTTP status code and see which module is calling SetStatus. For more information about creating a tracing rule for failed requests, click <a href="http://go.microsoft.com/fwlink/?LinkID=66439">here</a>. </li> </ul>

    </fieldset>

    </div>

     

     

    <div class="content-container">

    <fieldset><legend>Links and More Information</legend>

      This error means that the file or directory does not exist on the server. Create the file or directory and try the request again.

      <p><a href="http://go.microsoft.com/fwlink/?LinkID=62293&IIS70Error=404,0,0x80070002,7601">View more information &raquo;</a></p>

     

    </fieldset>

    </div>

    </div>

    </body>

    </html>

     

     

      at com.hyperion.awb.web.appmanager.AppManagerUtil.postAction(Unknown Source)

      at com.hyperion.awb.web.upgrade.UpgradeApplicationThread.changeApplicationType(Unknown Source)

      at com.hyperion.awb.web.upgrade.UpgradeApplicationThread.run(Unknown Source)

      at java.lang.Thread.run(Thread.java:662)

  • 3. Re: Planning data sources management
    Sh!va Pro
    Currently Being Moderated

    Looks like Connectivity issue between EPMA and planning wizard to me

     

      <table border="0" cellpadding="0" cellspacing="0">

        <tr class="alt"><th>Requested URL</th><td>http://Hipcio:80/HyperionPlanning/servlet/HspAppManagerServlet?action=changeapptype&app_name=samplapl&app_type=BPMA</td></tr>

        <tr><th>Physical Path</th><td>C:\inetpub\wwwroot\HyperionPlanning\servlet\HspAppManagerServlet</td></tr>

        <tr class="alt"><th>Logon Method</th><td>Anonymous</td></tr>

        <tr><th>Logon User</th><td>Anonymous</td></tr>

     

    it should be admin id for internal communication of EPM Components..Also can you check that you have proper privileges in Shared services for EPMA??

     

    Cheers!

     

    Sh!va

  • 4. Re: Planning data sources management
    salezian Newbie
    Currently Being Moderated

    Thanks for your answer. Can you point me how to check those permissions ? Where do you configure user for internal communication ?

  • 5. Re: Planning data sources management
    Sh!va Pro
    Currently Being Moderated

    First thing First ... Did you checked the access of your id which you are using to create DSN for EPMA application??

     

    Also, is there any EPMA application which has been Deployed to planning  successfully or its the first time trial?

     

     

    Cheers!

     

    Sh!va

  • 6. Re: Planning data sources management
    salezian Newbie
    Currently Being Moderated

    Hi

    Problem solved. I run EPMA configurator again and now everything works fine. I don't understand it but it works.

     

    Regards.

  • 7. Re: Planning data sources management
    Sh!va Pro
    Currently Being Moderated

    I told you that their may be configuration issues....Logs are nothing but important than God

     

    Cheers!

     

    Sh!va

Legend

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