Thanks for prompt help @Satish.Muddam It helped hinting to root cause. I used the below mentioned config.yml from @Bhuvnesh.Kumar using encryptionKey: "abcd" at the end. dbServers: - displayName: "Instance1" connectionUrl: "" driver: "" connectionProperties: user: "" password: "" encryptedPassword: "" #Needs to be used in conjunction with `encryptionKey`. Please read the extension documentation to generate encrypted password. https://community.appdynamics.com/t5/Knowledge-Base/How-do-I-use-Password-Encryption-with-Extensions/ta-p/29397 queries: - displayName: "Active Events" queryStmt: "Select NODE_NAME, EVENT_CODE, EVENT_ID, EVENT_POSTED_COUNT from Active_events" columns: - name: "NODE_NAME" type: "metricPathName" - name: "EVENT_ID" type: "metricPathName" - name: "EVENT_CODE" type: "metricValue" - name: "EVENT_POSTED_COUNT" type: "metricValue" - displayName: "TRANSACTION DATABASE" queryStmt: "SELECT TARGET_BOX, REACH_DURATION, ROUTER_DURATION FROM ASG_TRANSACTIONS WHERE TARGET_BOX IN ('target1','target2','target3','target4','target5')" columns: - name: "TARGET_BOX" type: "metricPathName" - name: "REACH_DURATION" type: "metricValue" - name: "ROUTER_DURATION" type: "metricValue" - displayName: "Node Status" queryStmt: "Select NODE_NAME, NODE_STATE from NODE_STATES" columns: - name: "NODE_NAME" type: "metricPathName" - name: "NODE_STATE" type: "metricValue" properties: convert: "INITIALIZING" : 0 "UP" : 1 "DOWN" : 2 "READY" : 3 "UNSAFE" : 4 "SHUTDOWN" : 5 "RECOVERING" : 6 # Replaces characters in metric name with the specified characters. # "replace" takes any regular expression # "replaceWith" takes the string to replace the matched characters metricCharacterReplacer: - replace: "%" replaceWith: "" - replace: "," replaceWith: "-" numberOfThreads: 5 #Run it as a scheduled task instead of running every minute. #Configure it. refer: https://community.appdynamics.com/t5/Knowledge-Base/Task-Schedule-for-Extensions/ta-p/35414#Configuration #taskSchedule: #numberOfThreads: 1 #taskDelaySeconds: 120 controllerInfo: controllerHost: "controller" controllerPort: 8090 account: "customer1" username: "admin" password: "admin" encryptedPassword: "" controllerSslEnabled: false enableOrchestration: false uniqueHostId: "" accountAccessKey: "" machinePath: "" simEnabled: true applicationName: "" tierName: "" nodeName: "" encryptionKey: "abcd"
... View more