DX Application Performance Management

 View Only
Expand all | Collapse all

TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

  • 1.  TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Oct 17, 2019 02:52 AM

    Hello,

    I'm having issues on creating reports for APM (10.5.2.15) metrics in JasperStudio Pro 7.1.
    We have a cluster of a MoM and 3 Collectors in APM and we have set up JasperStudio Professional because our client has asked to create reports for APM into Jasper.

    I have set up the connection between JasperStudio (Pro 7.1.0) and APM (10.5.2.15) but when I construct the sql query and press Next I get message : "Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 ws-source: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error".

    I checked the relative documentation and I have performed the below actions to make it work.

    File IntroscopeEnterpriseManager.properties

    Added property introscope.apm.feature.enabled=true

    Removed # from line #introscope.enterprisemanager.restapi.sql.connectionLimit=5


    File APMSqlServer.properties

    Added property introscope.enterprisemanager.restapi.sql.connectionLimit=5


    http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/application-performance-management/10-7/installing/apm-installation/install-and-configure-apmsql-servers.html

    https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=15016

    I have also restarted APMSql service but not MoM and I still get the error.

    First of all the above actions are correct ?

    Secondly what would you suggest to do next ?

    Do I need to restart also MoM after setting these properties ?
    Thank you in advance.



    ------------------------------
    Infrastructure Software-Systems Engineer
    ------------------------------


  • 2.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Dec 20, 2019 03:52 AM
    Hi Evangelos,

    Is this issue already resolved? cause i'm having the same issue like this in my environment.
    How do you fixing this issue?

    Hopefully you answer my question.

    Thanks,


  • 3.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Dec 20, 2019 04:21 AM
      |   view attached
    Hello Zhahir,
    First of all please make sure that your Jasper server has network access to port 8081 of APM server.
    Secondly you can check the attached file with instructions that I have prepared for you and also the below links.

    Link 1
    Link 2

    Kindly let us know which action resolved your issue.

    ------------------------------
    Infrastructure Software-Systems Engineer
    ------------------------------

    Attachment(s)



  • 4.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Dec 20, 2019 05:05 AM
    Hi Evan,

    Thanks for your answer.

    Could you please help me with below question:

    First, our APM server already set to port 8444 (which is secure connection), Do I need to also set port 8081?
    Second, do I need add property introscope.apm.feature.enabled=true to IntroscopeEnterpriseManager.properties file and add property introscope.enterprisemanager.restapi.sql.connectionLimit=5 to APMSqlServer.properties file? cause currently I have not add this property in my environment.

    Thanks.


  • 5.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error
    Best Answer

    Posted Dec 20, 2019 05:10 AM
    If integration hasn't worked yet I would try setting those properties as well.

    ------------------------------
    Infrastructure Software-Systems Engineer
    ------------------------------



  • 6.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Jan 13, 2020 11:38 PM

    Hi Evan,

    Sorry i'm asking you again.

    I already follow the step that you provide but the issue still persist.

    Any other step that we can apply? or any parameter in EM properties which need to change?

    Thank you.



  • 7.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Jan 14, 2020 02:22 AM
    Hello,
    I would suggest you open a case to Broadcom Support team for further investigation.
    If possible please share also their feedback here.
    Kind regards

    ------------------------------
    Infrastructure Software-Systems Engineer
    ------------------------------



  • 8.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Jan 14, 2020 02:54 AM
    This is feedback from support:

    in the IntroscopeEnterpriseManager.log we see the following error resulting in the 500 error:

    1/09/20 12:29:57.476 AM ICT [ERROR] [qtp2043112053-513] [Manager.AppMap] Internal Server Error happened during controller invocation: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
     at sun.security.ssl.Alerts.getSSLException(Alerts.java:192)

    This looks to be a certificate issue like we saw in dev. I suggest you go through the same steps we used to resolve it there:

    Create a new certificate and this time, use the CN value without domain name (For eg: ibndev000279 instead of ibndev000279.bpc.broadcom.net)

    Then after importing it into cacerts, use the same common name everywhere -
    •  In IntroscopeWebView.properties, provide the value of introscope.webview.enterprisemanager.tcp.host as ibndev000279 instead of ibndev000279.bpc.broadcom.net
    •  In IntroscopeWebView.properties, provide the value of introscope.webview.enterprisemanager.rest.base as https://ibndev000279:8444/apm/appmap instead of https://ibndev000279.bpc.broadcom.net:8444/apm/appmap
    •  In APMSqlServer.properties, provide the value of com.ca.apm.sqlserver.em.host as ibndev000279 instead of ibndev000279.bpc.broadcom.net
    •  Now, access the TeamCenter url using the same common name - https://ibndev000279:8444/apm/appmap instead of https://ibndev000279.bpc.broadcom.net:8444/apm/appmap
    •  Then check if the problem still arises.
     
    But it still not working. While waiting for a reply from support, do you have any suggestion? is the issue already solved in your environment? If so, how did you solve it?




  • 9.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Jan 14, 2020 03:20 AM
    Hello,
    This is slightly different from my case because I didn't have use certificate.
    I just did the steps I described initially and restarted the EM.
    Kind regards

    ------------------------------
    Infrastructure Software-Systems Engineer
    ------------------------------



  • 10.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Jan 23, 2020 01:51 AM
    I found also this thread.
    You may find it useful.

    ------------------------------
    Infrastructure Software-Systems Engineer
    ------------------------------



  • 11.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Jan 23, 2020 02:50 AM
    Actually, this is my thread. Im opened a thread in community.
    But thank you for your attention.


  • 12.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Feb 18, 2020 05:05 AM
    Hello Zhahir,
    Did you manage to make the integration work ?
    How did you achieve it ?
    Kind regards
    Vaggelis

    ------------------------------
    Infrastructure Software-Systems Engineer
    ------------------------------



  • 13.  RE: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error

    Posted Feb 20, 2020 02:52 AM
    Hi,
    So far the errors did not occurrs again after disable the properties "introscope.enterprisemanager.webserver.jetty.configurationFile=em-jetty-config.xml" in EM.properties on each collectors, since we did not configured https for the collectors. 

    Also we have successfully showing the data/metrics for MOM in Grafana, but for the collectors still cannot showing the data. 
    Already opened support case.