DX Application Performance Management

 View Only
  • 1.  APMSQL - queries return no result error 500

    Posted Jan 14, 2020 12:21 AM
    Hello,

    Currently we are trying to integrate APMSQL with Existing Grafana. Below are the steps related to the integration:

    1. Copy APMSQL Server files from MOM to the APMSQL remote server (success)

    2. Install and configure APMSQL server on remote server (success)

    3. Setting up Grafana configuration for CA APM (success)

    4. Create a JSON Data Source in Grafana for CA APM (success)

    5. Test Data Source connection. (success)

    6. Create New Dashboard in Grafana for CA APM (success)

    7. Create New Panel in newly added Grafana Dashboard for CA APM (success)

    8. Create and test Query to get data from CA APM (failed when testing the query)

    When we try step number 8, there are many 500 Internal Server error recorded on the APMSQL logs and when I try to runing the queries in Squirrel I get message : "Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 ws-source: TEIID15005 Error Calling HTTP Service - 500 Internal Server Error"


    Do you guys have advise to what next?

    Thank you


  • 2.  RE: APMSQL - queries return no result error 500

    Broadcom Employee
    Posted Jan 17, 2020 02:52 PM
    Check out this. The error seems similar what you posted. https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=15016
    Thanks, Amir


  • 3.  RE: APMSQL - queries return no result error 500

    Posted Jan 20, 2020 02:42 AM
    I have checked this one, but I never set introscope.apm.feature.enabled to false in my environment, so default condition is already true.

    Do you have other suggestion?

    btw, thank you for your answer.


  • 4.  RE: APMSQL - queries return no result error 500

    Broadcom Employee
    Posted Jan 21, 2020 01:03 AM
    Did you make sure to also grab a copy of APMSqlServer.properties and did you place in the right location on the remote server?
    The file needs to be located in the exact same folder structure as if it was still on the EM.

    ------------------------------
    Custom Solution Architect
    Broadcom
    ------------------------------



  • 5.  RE: APMSQL - queries return no result error 500

    Posted Jan 21, 2020 02:59 AM
    Here the folder structure of APMSql in MOM machine


    Here the folder structure of APMSQL on APMSQL machine



  • 6.  RE: APMSQL - queries return no result error 500

    Broadcom Employee
    Posted Jan 22, 2020 11:22 AM
    Edited by Haruhiko Davis Jan 22, 2020 11:25 AM
    The APMSQL properties file should be located at same level as 'APMSqlServer'

    So it should be:
    APMSqlServer
    config

    ------------------------------
    Custom Solution Architect
    Broadcom
    ------------------------------



  • 7.  RE: APMSQL - queries return no result error 500

    Posted Jan 22, 2020 11:07 PM
    Here folder structure of APMSQL in our production environment.
    The APMSQL properties file is inside config folder.


    How do you think? I think it already right location.



  • 8.  RE: APMSQL - queries return no result error 500
    Best Answer

    Broadcom Employee
    Posted Jan 24, 2020 01:29 AM
    This is now correct.

    .\config\ApmSqlServer.properties needs to be configured to point to the EM where you are trying to pull data from.


    Make sure to generate a public token from Team Center to use in the configurations. You do not need the token if you're using Grafana since APMSQL will have the token in its configuration.

    ------------------------------
    Custom Solution Architect
    Broadcom
    ------------------------------



  • 9.  RE: APMSQL - queries return no result error 500

    Posted Jan 26, 2020 11:05 PM
    Yes, we already configured ApmSqlServer.properties file to point to the EM for pulling the data. And we using Grafana, so it do not need the token.


    Do you have other suggestion about this?
    I'm very confused and also the support seems confusing about this case.