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?

     

    Thanks



  • 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:

    https://communities.ca.com/thread/241700281#241731255 

    There are some interesting details on the VSE Metrics table.

     

    Hope it helps.

    Heloisa



  • 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.

     

    Thanks

    SaiKumar 



  • 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.
    https://docops.ca.com/devtest-solutions/8-5/en/using/using-ca-service-virtualization/using-the-workstation-and-console-with-ca-service-virtualization/virtualizing-a-service/vse-metrics

     

    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.