Reporting/DB issue

Products

• DX NetOps
• CA Performance Management - Usage and Administration

Issue/Introduction

Historical CPU Data missing after upgrade to 20.2.10 

CPU data missing 

No data for CPU after upgrade to 20.2.10 

Cisco CPU revised vendor certification no historical data after upgrade 

Cisco CPU (Revised) vendor certification no historical data after upgrade 

Cause

The "Cisco CPU (Revised)" Vendor certification was updated and this caused a new name and element to be created. This orphans the older data and CPU element. The newly created element  only has data from after the upgrade. This only occurs on the "Cisco CPU (Revised)" Vendor certification

Environment

Release : 20.2

Component : IM Certifications

Resolution

To fix the CPU type/name and have the data from before the upgrade.

Note: Data collected after the upgrade and before applying the fix will be lost for the CPU. 

Download the attached file CPU_certification.xml to /tmp on the DA and then run the following command:

curl -v -X PUT -H "Content-Type: application/xml" http://127.0.0.1:8581/typecatalog/certifications/snmp/CiscoCPUMibRev -d @"/tmp/CPU_certification.xml"

Additional Information

You can also do a put using a REST client of the following .xml to http://<DA_SYSTEM>:8581/typecatalog/certifications/snmp/CiscoCPUMibRev 

<?xml version="1.0" encoding="UTF-8"?>
<DataModel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" namespace="http://im.ca.com/certifications/snmp" xsi:noNamespaceSchemaLocation="SNMPCertificationFacet.xsd">
<Version>1.31</Version>
<Author>CA</Author>
<FacetType descriptorClass="com.ca.im.core.datamodel.certs.CertificationFacetDescriptorImpl" name="CiscoCPUMibRev">
    <Documentation>Supports CPUs based on the Cisco CPU Total table representing utilization per processor.</Documentation>
    <FacetOf name="Item" namespace="http://im.ca.com/core"/>
    <Protocol>SNMP</Protocol>
    <MIB>CISCO-PROCESS-MIB</MIB>
    <DisplayName>Cisco CPU (Revised)</DisplayName>
    <AttributeGroup external="true" list="true" name="cpmCPUTotalTable">
      <Attribute name="cpmCPUIndex" type="ObjectID">
        <IsKey>true</IsKey>
        <IsIndex>true</IsIndex>
        <Source>1.3.6.1.4.1.9.9.109.1.1.1.1.8</Source>
        <Polled>true</Polled>
      </Attribute>
      <Attribute name="cpmCPUTotalPhysicalIndex" type="int">
         <IsKey>false</IsKey>
         <NeedsDelta>false</NeedsDelta>
         <Source>1.3.6.1.4.1.9.9.109.1.1.1.1.2</Source>
        </Attribute>
      <Attribute name="cpmCPUTotal5min" type="Long">
        <IsKey>false</IsKey>
        <Source>1.3.6.1.4.1.9.9.109.1.1.1.1.5</Source>
        <Polled>true</Polled>
      </Attribute>
      <Attribute name="cpmCPUTotal5minRev" type="Long">
        <IsKey>false</IsKey>
        <Source>1.3.6.1.4.1.9.9.109.1.1.1.1.8</Source>
        <Polled>true</Polled>
      </Attribute>
      <Attribute name="cpmCPUTotal1minRev" type="Long">
        <IsKey>false</IsKey>
        <Source>1.3.6.1.4.1.9.9.109.1.1.1.1.7</Source>
      </Attribute>
      <Attribute name="cpmCPUTotal5secRev" type="Long">
        <IsKey>false</IsKey>
        <Source>1.3.6.1.4.1.9.9.109.1.1.1.1.6</Source>
      </Attribute>
                        <!-- US27008 Start -->
            <Attribute name="cpmCPUMonInterval" type="Long">
                <IsKey>false</IsKey>
                <Source>1.3.6.1.4.1.9.9.109.1.1.1.1.9</Source>
            </Attribute>
            <Attribute name="cpmCPUTotalMonIntervalValue" type="Long">
                <IsKey>false</IsKey>
                <Source>1.3.6.1.4.1.9.9.109.1.1.1.1.10</Source>
            </Attribute>
            <Attribute name="cpmCPUInterruptMonIntervalValue" type="Long">
                <IsKey>false</IsKey>
                <Source>1.3.6.1.4.1.9.9.109.1.1.1.1.11</Source>
            </Attribute>
                        <!-- US27008 End -->
    </AttributeGroup>
    <Expressions>
      <ExpressionGroup destCert="{http://im.ca.com/normalizer}NormalizedCPUInfo" name="CiscoNRMCpuDS">
        <Expression destAttr="Indexes">cpmCPUIndex</Expression>
        <Expression destAttr="Names">"CPU " + cpmCPUIndex</Expression>
        <Expression destAttr="Descriptions">"Revised Cisco CPU Statistics " + (isdef(cpmCPUTotalPhysicalIndex)?cpmCPUTotalPhysicalIndex:cpmCPUIndex)</Expression>
        <Expression destAttr="Utilization">cpmCPUTotal5minRev</Expression>
                                <!-- US27008 Start -->
                                <Expression destAttr="CPUUtilizationAverage5Seconds">cpmCPUTotal5secRev</Expression>
                                <Expression destAttr="CPUUtilizationLastMin">cpmCPUTotal1minRev</Expression>
                                <Expression destAttr="cpuUsageMonitoringInterval">cpmCPUMonInterval</Expression>
                                <Expression destAttr="cpuBusyPercInLastCpmCPUMonInterval">cpmCPUTotalMonIntervalValue</Expression>
                                <Expression destAttr="cpuBusyPercInInterruptCpmCPUMonInterval">cpmCPUInterruptMonIntervalValue</Expression>
                                <!-- US27008 End -->
      </ExpressionGroup>
    </Expressions>
  </FacetType>
</DataModel>