DB2 Extension 2.0 throws warning - While polling for endpoint query have failed: db2 invalid objects Tag

[Das-Niharika]

Hi . I have created a DB2 custom extension 2.0 using custom extensions creator and Deployed that to Dynatrace using the certificate . It deployed successfully and connection is fine . But it gives me 2 warning message one after another .

1- While polling for endpoint query have failed: db2 invalid objects Tag

2- Connection exists but no metrics have been produced for endpoints

Kindly help

[AravindhanV]

Hi  @sdas,  

1. You need to update your query which you have configured whereas the Object which is in the query called "tag" is not properly handled. Check with your respective DB team and ensure you are getting the results in DB.
2. Since your query has been failing and though connection has been established  and still its not producing any data's.

Check your logs in the below location of your AG.

/var/lib/dynatrace/remotepluginmodule/log/extensions/datasources

Thanks

[Das-Niharika]

Thanks for responding Aravind . I have created the Extension using Custom Extension creator . and below is the content of my yaml. The text provided in the group (db2 invalid objects Tag
) shows in the Warn message. The query is working fine and I am getting result in DB .

name: custom:db2queryresult

minDynatraceVersion: 1.303.0

author:

  name: Custom Extensions Creator App

version: 0.0.2

sqlDb2:

  - group: db2 invalid objects Tag

    query: >

      SELECT substr(OBJECTSCHEMA,1,30) SCHEMA, substr(OBJECTMODULENAME,1,30)

      MODULENAME, substr(OBJECTNAME,1,45) NAME, substr(OBJECTNAME,1,45) ROUTINE,

      OBJECTTYPE, SQLCODE, SQLSTATE, INVALIDATE_TIME from syscat.invalidobjects

      with UR;

    metrics:

      - key: custom.test.db2.queryresult.schema

        value: col:SCHEMA

        type: gauge

      - key: custom.test.db2.queryresult.modulename

        value: col:MODULENAME

        type: gauge

      - key: custom.test.db2.queryresult.name

        value: col:NAME

        type: gauge

      - key: custom.test.db2.queryresult.routine

        value: col:ROUTINE

        type: gauge

      - key: custom.test.db2.queryresult.objecttype

        value: col:OBJECTTYPE

        type: gauge

      - key: custom.test.db2.queryresult.sqlcode

        value: col:SQLCODE

        type: gauge

      - key: custom.test.db2.queryresult.sqlstate

        value: col:SQLSTATE

        type: gauge

      - key: custom.test.db2.queryresult.invalidate_time

        value: col:INVALIDATE_TIME

        type: gauge

[AravindhanV]

hi @Das-Niharika, 

With the Query which you shared, I believe it would be good if you can revalidate the Object which you declared in the DB.  Use the below comment to validate, 

CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS();

Also check the dependencies of those objects would help as well. 

Did you validated the logs?

If you can share the SS for Custom Extension Configuration screen and the DB screen would helpful to further investigate.

Thanks

[Das-Niharika]

Hi Aravind ,

Here is the log screenshot. It connects initially then I believe while executing the query the timeout occurs .

Monitoring configuration

[
  {
    "value": {
      "enabled": true,
      "description": "malak02",
      "version": "0.0.2",
      "sqlDb2Remote": {
        "endpoints": [
          {
            "host": "malak02",
            "port": 3952,
            "databaseName": "USMODAT",
            "authentication": {
              "scheme": "basic",
              "useCredentialVault": true,
              "credentialVaultId": "CREDENTIALS_VAULT-8DD91FD61C808BC6"
            },
            "ssl": true
          }
        ]
      }
    },
    "scope": "ag_group-prometheus"
  }
]

[AravindhanV]

Hi @Das-Niharika, 

Seems a known issue from the DB side. Can you please validate the firewall if applicable and proxy if any.

And have a look at this page as well. Check you are in latest version.

Known Issue: DT167246

Thanks

[AravindhanV]

Added with above query please validate this also in your DB.

db2 "SELECT CAST(COUNT(*) AS INTEGER) FROM SYSCAT.INVALIDOBJECTS"