Operations Bridge Reporter User Discussions
cancel

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

Highlighted
Patelmc Contributor.
Contributor.

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

 

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

 

Patelmc Contributor.
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.