Service Virtualization

Expand all | Collapse all

Null values in COUNTS_DATE column

Jump to Best Answer
  • 1.  Null values in COUNTS_DATE column

    Posted 07-05-2017 02:53 PM

    I am trying to prepare a VS HitCount report for a particular month to show adoption of VS across organisation, but there are nulls values in column "COUNTS_DATE" under VSE_METRICS_TXN_COUNTS. This is happening with only few services and others has proper dates.


    Due to "null" in DATE column, I am unable to report exact service hit count for that particular month.


    Is there any solution to ensure system captures service hit DATE?



  • 2.  Re: Null values in COUNTS_DATE column

    Posted 07-05-2017 05:53 PM

    Hello Saikumar,


    Please, take a look at the link below: 

    There are some interesting details on the VSE Metrics table.


    Hope it helps.


  • 3.  Re: Null values in COUNTS_DATE column

    Posted 07-06-2017 01:05 PM

    Hi Heloisa, Thanks for sharing the link, Based on the given information it seems it keeps only historical value instead of each days count. 


    I am wondering is there a way to keep daily count so that it helps to report accurately.




  • 4.  Re: Null values in COUNTS_DATE column
    Best Answer

    Posted 07-12-2017 05:57 PM

    I performed some testing on my side and could verify the following behavior:
    . When you deploy a new service to the VSE, nothing gets updated in the VSE _METRICS_TXN_COUNT table.
    . When you send a transaction to the VSM, and the VSM is new - there are no rows with this same VSM name, two rows will be created, one row will contain COUNTS_DATE=null and the other row will contain the date you are exercising that VSM.
    . When you exercise a VSM on two different days, you will probably have 3 rows for that same service, one for each date and an additional row with COUNTS_DATE=null.
    . In the tests I performed, this last row (COUNTS_DATE=null) contains the total hit count for that VSM.


    The Server Console is documented and you can take the information from there to provide to others - by way of a screenshot, with DevTest 8.5, there is not an export option.


    With DevTest 10.1 you are able to access the VSE Metrics in DevTest Portal and export the metrics to a PDF file. 


    The database design is not part of the documented DEVTEST tool. We cannot prevent you using it but the database design may change from release to release.