Hi All,
I have developed query extension but getting error as :Connection exists but no metrics have been produced for endpoints" in SFM event and in extension datasource log it error as "java.sql.SQLException: Fail to convert to internal representation"
Below is yaml:
Expected output is : Market is OPEN or CLOSE
name: custom:oracle.db.query
version: 0.0.139
minDynatraceVersion: "1.303.0"
author:
name: Vibhash Mishra
sqlOracle:
- group: Market_Status
featureSet: ORDER
query: >
SELECT sp_Desc_EN
FROM fix_sysparam, trade_param
WHERE SP_Major = 'SymMktState'
AND SP_Minor = mkt_status
AND ROWNUM < 2
metrics:
- key: com.dynatrace.extension.sql-oracle.sp_Desc_EN
value: const:sp_Desc_EN
