DX Application Performance Management

Expand all | Collapse all

show passed values to a SQL query

Jump to Best Answer
  • 1.  show passed values to a SQL query

    Posted 09-09-2016 05:56 AM

    Dear all,

     

    I need to show the values of SQL information passed to a SQL request, I changed  #introscope.agent.sqlagent.sql.rawsql=false to introscope.agent.sqlagent.sql.rawsql=true

     

    in one application JAVA/J2EE (deployed in Jboss) I can get the passed values:

     

    but in another application also developed in JAVA/J2EE (deployed in Jboss) I can't se e the passed values I still get "?" instead of values:

     

    please can someone help what can be the issue, why I can't see the passed values in second application?

     

    BR

    RADOUANE Mohamed



  • 2.  Re: show passed values to a SQL query
    Best Answer

    Posted 09-09-2016 06:01 AM

    Please open a CA Support ticket and ask for the SQLAgent With Parameters for Java Agents.



  • 3.  Re: show passed values to a SQL query

    Posted 09-09-2016 10:24 AM

    Hi,

     

    As Haruhiko suggested, please open a case as this will require extensive investigation.

     

    Thanks,

    Matt



  • 4.  Re: show passed values to a SQL query

    Posted 09-11-2016 01:05 PM

    Please share the results of the case to this thread to help others.



  • 5.  Re: show passed values to a SQL query

    Posted 09-12-2016 07:50 AM

    Marking as answered since next step is to open a case and there were no further replies.You are of course welcome to post related questions if needed



  • 6.  Re: show passed values to a SQL query

    Posted 09-14-2016 10:54 AM

    still working with support to fix the issue:

     

    support give me the fieldpack SQL agent still not tested:

     

    "ca.apm.fieldpacks.agent.SQLParamAgent.20160309"



  • 7.  RE: Re: show passed values to a SQL query

    Posted 01-14-2020 05:20 AM
    Hello,
    Coming back to this thread since I face the same issue even after setting introscope.agent.sqlagent.sql.rawsql=true in an APM 10.7 agent for a Weblogic application.
    I found that there is also property introscope.agent.sqlagent.normalizer.regex.key1.replaceFormat and I changed it
    from
    #introscope.agent.sqlagent.normalizer.regex.key1.replaceFormat=?
    to
    introscope.agent.sqlagent.normalizer.regex.key1.replaceFormat=

    Then I restarted the monitored application so that APM agent will be also restarted but still I see the ? in the queries.
    Do I miss something ?

    Kind regards
    Vaggelis

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