Database count mismatch

Products

• Service Virtualization

Issue/Introduction

Select * from VSE_METRICS_TXN_COUNTS where VSE_NAME = 'tcp://devtestregistry5-qa.example.com:2013/VSE' order by VS_NAME,COUNTS_DATESelect * from VSE_METRICS_TXN_COUNTS where VS_NAME IN ('MQListener','dev-GDP-Region','GDP-Portal','GDP-Portal-API','GDP-Portal-Trob','GSTAR-Arena-Portal','GSTAR-Arena-Portal-Trouble') AND VSE_NAME = 'tcp://devtestregistry5-qa.example.com:2013/VSE'

 

Need some clarification on below observations wrt to DB Transactioncount mismatch

 

Issue1: 

There are certain records in Several registries in DB, where we can see only 1 entry corresponding to COUNTS_DATE as NULL with Transaction Total_Count > 0

 

Select * from VSE_METRICS_TXN_COUNTS where VSE_NAME = 'tcp://devtestregistry5-qa.example.com:2013/VSE' order by VS_NAME,COUNTS_DATE

 

Select * from VSE_METRICS_TXN_COUNTS where VS_NAME IN ('VS1',

'VS22') AND VSE_NAME = 'tcp://devtestregistry5-qa.example.com:2013/VSE'

 

Issue 2:  Datewise count of transactions are not matching with the total Transaction record having COUNTS_DATE as NULL.

Query : In [VSE_METRICS_TXN_COUNTS] table, when do the value of NODE_HITS column increment?

Environment

Release : 10.7.2

Resolution

 We have internal API call to retrieve transaction count for specific virtual service deployed. Details are given below. You can use this API call subject to following condition:

The API being unpublished, there is no guarantee about the Input/Output as well as future continuity

Customer may use this API at their own risk

 

REST API CALL: http(s)://<REGISTRY HOST>:1505/lisa-virtualize-invoke/api/v1/vses/<VSE NAME>/services/<VS NAME>/metrics/txnHitsMisses