The community has a new login process
The community single sign-on system has been changed. Learn more about it HERE
Highlighted
Patelmc Valued Contributor.
Valued Contributor.
195 views

OBR 10.31 P2 reprts doen not show data from OA system managemnt CP

I have four OBR servers with 10.31 P2 and two of them shows data into the report for systems management CP for servers with OA. However other two does not show data into the reports. I have modified the collection policies to use views specific to region eg. US,UK,AP. The problem seems with  K_CI_System table which did not populated with all information and is missing keys for node name which is causing issue. I believe this table is populated with the information from OMi topology view,

dbadmin=> select count(*) from K_CI_System;

count

-------

   331

(1 row)

dbadmin=> select sourceId,source from K_CI_System;

sourceId | source

----------+--------

0        | 0

          |

          |

          |

          |

          |

          |

          |

          |

          |

 

dbadmin=> select * from K_CI_System;   à so looking at this table looks like it populated  331 rows but none of them are complete. Meaning they are missing key information like OMi server name, node name and others.  Any idea what could have cause this issue and how to fix it?

 

dsi_key_id |       modified_date        |       creation_date        | isdeleted | sourceId | source | checksum |   ext

raction_time   | Host_Key |   OS    | OS_Version | Serial_Number |  DNS_Name  | Host_Name  | Internal_Name |

     Model                  | Vendor | Manufacture | Server_Type | isvirtual | Processor_Architecture |     Phys_Mem_GB

    | CPU_Num | CPU_Num_Core | CPU_Speed_MHz | Disk_Num | VM_Num | Network_Num | Hypervisor_type | CPUUtil_Threshold  |

SwapUtil_Threshold | MemUtil_Threshold  |  RunQ_Threshold   | PageOut_Threshold  | StaticThresholdFlag | CPUFamily |

          CI_UID              | Display_Name | Name |    Creation_time    | Created_by |     Update_time     | Updated_b

y | Description | User_Key |    CPUUtil_STH1    |    CPUUtil_STH2    |    CPUUtil_STH3    |   SwapUtil_STH1    |   SwapU

til_STH2    |   SwapUtil_STH3    |  MemoryUtil_STH1   |  MemoryUtil_STH2   |  MemoryUtil_STH3   |     RunQ_STH1      |

   RunQ_STH2      |     RunQ_STH3      | Managed_By | Disk_Capacity_GB  | Total_Network_Speed | System_State | CPU_Unres

erved | Role  | UUID | ProcessorModel |  CPUCapacityGHz   | Datacentername | OSPatch | Memory_Unreserved | Cluster_Name

| Standalone_View | Hypervisor_View | OS_Type | System_temp1 | System_temp2 | System_temp3 | System_temp4 | System_temp5

| Phy_CPU_Socket_Num | CoresPerPhysCPU | CPUNumThreads | HT_MT_Enabled | NumActiveCPU |  Monitored_By   |     GMTOffset

     | CIT_Key | GlobalId

------------+----------------------------+----------------------------+-----------+----------+--------+----------+------

---------------+----------+---------+------------+---------------+------------+------------+---------------+------------

----------------------------+--------+-------------+-------------+-----------+------------------------+-----------------

----+---------+--------------+---------------+----------+--------+-------------+-----------------+--------------------+-

-------------------+--------------------+-------------------+--------------------+---------------------+-----------+----

------------------------------+--------------+------+---------------------+------------+---------------------+----------

--+-------------+----------+--------------------+--------------------+--------------------+--------------------+--------

------------+--------------------+--------------------+--------------------+--------------------+--------------------+--

------------------+--------------------+------------+-------------------+---------------------+--------------+----------

------+-------+------+----------------+-------------------+----------------+---------+-------------------+--------------

+-----------------+-----------------+---------+--------------+--------------+--------------+--------------+-------------

-+--------------------+-----------------+---------------+---------------+--------------+-----------------+--------------

-----+---------+----------

          1 | 1970-01-01 00:00:00        | 1970-01-01 00:00:00        |         1 | 0        | 0      | 0        | 1970-

01-01 00:00:00 | 0        | 0       | 0          | 0             | Unassigned | Unassigned | 0             | 0

                            | 0      | 0           | 0           | 0         | 0                      |   1.000000000000

000 |       1 |            1 |             1 |        1 |      1 |           1 | 0               |  1.000000000000000 |

1.000000000000000 |  1.000000000000000 | 1.000000000000000 |  1.000000000000000 |   1.000000000000000 | 0         | 0

                              | 0            | 0    | 1970-01-01 00:00:00 | 0          | 1970-01-01 00:00:00 | 0

  | 0           |        1 |  1.000000000000000 |  1.000000000000000 |  1.000000000000000 |  1.000000000000000 |  1.0000

00000000000 |  1.000000000000000 |  1.000000000000000 |  1.000000000000000 |  1.000000000000000 |  1.000000000000000 |

1.000000000000000 |  1.000000000000000 | 0          | 1.000000000000000 |   1.000000000000000 | 0            |

    1 | 0     | 0    | 0              | 1.000000000000000 | 0              | 0       | 0                 | Unassigned

|               1 |               1 | 0       | 0            | 0            | 0            | 0            | 0

|                  1 |               1 |             1 | 0             |            1 | 0               | 1.00000000000

0000 |       1 | 0

         18 | 2018-11-14 21:27:53.178562 | 2018-10-23 20:53:44.584271 |           |          |        |          |

               |          | Linux   |            |               |            |            |               | i686

                            |        |             |             | FALSE     | i686                   |   3.965820312500

000 |       8 |            8 |          2661 |        2 |        |           4 |                 | 80.000000000000000 |

70.000000000000000 | 70.000000000000000 | 5.000000000000000 | 10.000000000000000 |                     |           | 009

755f404b196e802d96006d0311cf8 |              |      |                     |            |                     |

--More--

  |             |          | 20.000000000000000 | 60.000000000000000 | 80.000000000000000 | 20.000000000000000 | 40.0000

00000000000 | 70.000000000000000 | 25.000000000000000 | 60.000000000000000 | 80.000000000000000 | 10.000000000000000 | 2

0.000000000000000 | 35.000000000000000 |            |                   |                     |              |

      | Stand |      |                |                   |                |         |                   |

|               1 |                 |         |              |              |              |              |

|                  2 |                 |               | Off           |            8 | OperationsAgent |

     |         |

         33 | 2018-11-14 21:27:53.178562 | 2018-10-23 20:55:19.326103 |           |          |        |          |

               |          | Linux   |            |               |            |            |               | x86_64

                            |        |             |             | FALSE     | x86_64                 |   3.868164062500

000 |       8 |            8 |          1996 |        2 |        |           4 |                 | 80.000000000000000 |

70.000000000000000 | 70.000000000000000 | 5.000000000000000 | 10.000000000000000 |                     |           | 013

5142e636042fdc80fc181677bffa0 |              |      |                     |            |                     |

  |             |          | 20.000000000000000 | 60.000000000000000 | 80.000000000000000 | 20.000000000000000 | 40.0000

00000000000 | 70.000000000000000 | 25.000000000000000 | 60.000000000000000 | 80.000000000000000 | 10.000000000000000 | 2

0.000000000000000 | 35.000000000000000 |            |                   |                     |              |

      | Stand |      |                |                   |                |         |                   |

|               1 |                 |         |              |              |              |              |

|                  2 |               4 |             1 | Off           |            8 | OperationsAgent |

     |         |

         84 | 2018-11-14 21:27:53.178562 | 2018-10-23 20:53:45.844261 |           |          |        |          |

               |          | Linux   |            |               |            |            |               | x86_64

                            |        |             |             | FALSE     | x86_64                 |  23.529296875000

000 |      16 |            8 |          2401 |        2 |        |           3 |                 | 80.000000000000000 |

70.000000000000000 | 70.000000000000000 | 5.000000000000000 | 10.000000000000000 |                     |           | 02d

4148b64011ebcd40acc75b14fb02f |              |      |                     |            |                     |

  |             |          | 20.000000000000000 | 60.000000000000000 | 80.000000000000000 | 20.000000000000000 | 40.0000

00000000000 | 70.000000000000000 | 25.000000000000000 | 60.000000000000000 | 80.000000000000000 | 10.000000000000000 | 2

0.000000000000000 | 35.000000000000000 |            |                   |                     |              |

      | Stand |      |                |                   |                |         |                   |

|               1 |                 |         |              |              |              |              |

|                  2 |               4 |             2 | On            |           16 | OperationsAgent |

     |         |

         88 | 2018-11-14 21:27:53.178562 | 2018-10-23 20:55:16.861453 |           |          |        |          |

               |          | Linux   |            |               |            |            |               | ProLiant DL

385 G7                      |        |             |             | FALSE     | x86_64                 | 126.002929687500

000 |      24 |           24 |          2501 |        1 |        |          10 |                 | 80.000000000000000 |

70.000000000000000 | 70.000000000000000 | 5.000000000000000 | 10.000000000000000 |                     |           | 02e

 

0 Likes
2 Replies
Micro Focus Expert
Micro Focus Expert

Re: OBR 10.31 P2 reprts doen not show data from OA system managemnt CP

Are the different OBRs integrated to same OMi RTSM or different? If different, please verify that the RTSM view (SM_PA) has all the relevant attributes exposed for collection (modeling studio, open the view, select each CI type and click on edit, and see whether the Element Layout includes the relevant attributes).

-Ankit

 

0 Likes
Patelmc Valued Contributor.
Valued Contributor.

Re: OBR 10.31 P2 reprts doen not show data from OA system managemnt CP

US,UK & AP OBR are integrated with one OMi server in US.

No issue with US & UK. Only AP OBR does not show data.

Anyway, I have ebabled ALL attributes for all of these Views.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.