Service Operations Insight

  • Private Community
 View Only

  • 1.  CA eHealth DA data validation

    Posted Jun 30, 2015 10:24 AM

    Hi Guys

     

    I have been trying to to pull data from my eHealth data sources but I keep getting staging failed for the time range specified and then it results in staging load failing.

     

    My question is if there is way you can validate if there is data on that particular server for that particular date. Can I run an ehealth report to see if there is data in that particular source.

    Kip_Lambdupda03ashbyatxlimro02SurendranathKSJim.Tokarz

    Regards

    David !



  • 2.  Re: CA eHealth DA data validation

    Posted Jun 30, 2015 10:44 AM

    How far in the past are you trying to pull data?

    How many servers are you selecting to pull data from?

     

    Did you know that the eHealth SQL queries are available in clear text within the XML data adapter?

    - This means you can pull the SQL code into SQL Developer and run the query against the eHealth instance to see what data is returned.

     

    David




  • 3.  Re: CA eHealth DA data validation

    Posted Jul 02, 2015 09:43 AM

    Hi David

     

    I did try that but I cant seem to get data before the 28th of June.

     

    Regards

    David



  • 4.  Re: CA eHealth DA data validation

    Posted Jun 30, 2015 12:03 PM

    Hey David,

    Try these steps in eHealth to get a report of the data that we are looking for on that system:

     

     

       

    •   The eHealth ‘Trend’ reports are used to create CSV files for the physical servers:

       

    •   Click the ‘Run Reports’ tab and select the ‘Trend’ and ‘Standard’ option.

       

    •   Select the element type of System and select a server from the element list.

       

    •   Select the following ‘Variables’ using CTRL click to select multiple

          

    •   Physical Memory Used

          

    •   Physical Memory Utilization

          

    •   Total Bytes

          

    •   Total CPU Utilization

          

    •   Total Physical Memory

       

    •   Select the ‘Tabular Chart’ option and choose a time range of ‘Previous 3 Months’ and Run the report. The report will complete and then choose the ASCII button on the top right to save the report as a CSV file

     

    >KIP

     

    Kip Lamb

    Sr Principal Consultant, Presales

     

    CA Technologies | 13810 South East Eastgate Way Suite 500 | Bellevue, WA 98005

    Office: +1 512 776 0235 | Mobile: +1 425 591 4358 | Kip.Lamb@ca.com

    <mailto:Kip.Lamb@ca.com>[cid:image003.jpg@01D0B313.7955A1B0][cid:image002.png@01D0928A.5E056B60]

     

    <http://www.ca.com/us/default.aspx>

    <http://www.ca.com/us/default.aspx>



  • 5.  Re: CA eHealth DA data validation

    Posted Jul 02, 2015 09:45 AM

    Hi Kip

     

    Thanks I did try that and yes I do get data on eHealth trend reports. I have opened a case with your support team.

     

    Regards

    David