DX Application Performance Management

Expand all | Collapse all

No Metrics with JDBC Oracle 19.3 driver

Jump to Best Answer
  • 1.  No Metrics with JDBC Oracle 19.3 driver

    Posted 07-08-2020 08:15 AM
    Hello all folks,
    we start using Oracle 19 and use the JDBC 19.3 driver therefore.
    Unfortunately the APM 10.5.x and APM 10.7.x stop collecting metrics for the SQL Statements, some metrics for "Unknown SQL" collected only.

    Any one else are using the JDBC 19.3 or 19.7 driver for Java 8 with the APM 10.5.x or APM 10.7x Java agent.
    Based on the JDBC 12.2 driver and Java 8 every things works well, we changed the driver only.

    A question only,
    With regards,
    Lutz

    ------------------------------
    Finanz Informatik
    ------------------------------


  • 2.  RE: No Metrics with JDBC Oracle 19.3 driver

    Broadcom Employee
    Posted 07-09-2020 10:54 AM
    Hi Lutz,

    Have you reviewed this KB, discusses potential causes and fixes?
    https://knowledge.broadcom.com/external/article?articleId=17673#/

    Thanks,
    Yanna


  • 3.  RE: No Metrics with JDBC Oracle 19.3 driver

    Posted 07-13-2020 04:09 AM
    Hello,
    yes, I found this KB, from my of point this is not the problem.
    After we switch to the old Oracle 12.3 JDBC driver we got some metrics data, we have no prepare problems therefore, I think.
    With regards, Lutz

    ------------------------------
    Finanz Informatik
    ------------------------------



  • 4.  RE: No Metrics with JDBC Oracle 19.3 driver

    Posted 07-17-2020 05:54 AM
    Hello Yanna,
    is a documentation or KB available with a description how to find the right classes used by a prepareCall() and prepareStatemant() to add this classes to the sqlagent.pbd.
    With regards,
    Lutz

    ------------------------------
    Finanz Informatik
    ------------------------------



  • 5.  RE: No Metrics with JDBC Oracle 19.3 driver

    Broadcom Employee
    Posted 07-09-2020 12:28 PM
    I would suggest you open a support ticket for this and request a copy of our SaaS Java agent for your particular appserver to see if it's resolved by our newest agent.
    You will need to point the agent at 10.7 EM and configure to run the agent to run in compatibility mode:

    introscope.agent.connection.compatibility.version=10.7


    Place this in the agent profile.



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



  • 6.  RE: No Metrics with JDBC Oracle 19.3 driver

    Posted 07-13-2020 04:22 AM
    Hello,
    I open a ticket last week, the support try to investigate the problem.
    Unfortunately, the JDBC Oracle 19.x driver is no in the support matrix and not supported by the SaaS Java agent too.
    With regards,
    Lutz

    p.s.
    Today the APM Java agent support list does not contain the most of our used software releases. In the past this was not a problem, but CA/Broadcom drop to much old code from the APM (Java agent and Manager). And the new the functions does not fit to our environment now.

    ------------------------------
    Finanz Informatik
    ------------------------------



  • 7.  RE: No Metrics with JDBC Oracle 19.3 driver

    Broadcom Employee
    Posted 07-14-2020 01:04 AM
    Just because it's not officially supported, it does not mean that it may not resolve the issues you're currently experiencing.
    Sometimes we "field certify" solutions to let users know when we find something that works.

    The SaaS agents will have greater support for technologies in the field ahead of current 10.x solutions. As we move towards DX APM on-premise, things will have more parity.

    Your current issue may still require a custom extension, which could ultimately make its way into the product for official support. The agent has capabilities to extend. functionality is a somewhat easy manner, so follow up with your account team to see what solutions may be available to you.

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



  • 8.  RE: No Metrics with JDBC Oracle 19.3 driver

    Posted 07-14-2020 05:10 AM
    Hello,
    sometimes the Java agent works well in environments are not officially supported, but we get/got no support if something does not work well.

    > Just because it's not officially supported, it does not mean that it may not resolve the issues you're currently experiencing.
    > Sometimes we "field certify" solutions to let users know when we find something that works.

    In the past (CA) it was a problem to discuss problems like this with the support team,
    today (Broadcom) you get no help (sorry).

    > The SaaS agents will have greater support for technologies in the field ahead of current 10.x solutions.
    > As we move towards DX APM on-premise, things will have more parity.

    Maybe, but as long as the DX APM Java agents are not available via the software download, I can't use/test the Java agent.
    Unfortunately, Broadcom ship DX APM as a SaaS product only and we don't use SaaS products.

    Thanks for your suggestions,
    Lutz

    ------------------------------
    Finanz Informatik
    ------------------------------



  • 9.  RE: No Metrics with JDBC Oracle 19.3 driver
    Best Answer

    Broadcom Employee
    Posted 07-14-2020 10:33 AM
    The next version of APM will be SaaS, so asking for a copy of our current SaaS agent will be fine.
    Like I said previously, you can configure the SaaS agent to connect to your current APM 10.7 instance as long as it's patched to at least SP3.

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



  • 10.  RE: No Metrics with JDBC Oracle 19.3 driver

    Posted 07-17-2020 06:04 AM
    Hello Haruhiko,
    the SaaS Java Agent 20.6.0 is up and running.
    After I add then "introscope.agent.connection.compatibility.version=10.7" property and remove the "agentManager.credential=" property.

    Nice idea,
    but the new Agent (20.6.0.28 Build 990028) does not support JDBC Oracle 19.x drivers well too.
    SQL statements metrics collected for Dynamic|Query but Prepared|Query or Prepared|Update collect metrics for "Unknown SQL" only.

    With regards,
    Lutz

    ------------------------------
    Finanz Informatik
    ------------------------------