Not sure why vbr didn't restore the contents of dim_item during restore, but the dim_item table is a table that's rebuild 1/hour (upto 4x/hour depending on config). The job normally kicks off 15 mins past the hour and will take a few mins to gather data and rebuild it.
It's used for odata queries and some Portal RIB calls now. Same goes for etl tables for poll_item, groups, etc (which are build every few mins).
Original Message:
Sent: Aug 14, 2024 11:46 AM
From: ISAAC VELASCO
Subject: After loading a backup, some vertical tables were left empty.
Hello community.
I hope you can help me with the following problem that arose in my DX PM environment: after loading a vertical backup, the dim_item table became empty.
The detail is that the tables where I have the raw SNMP data are still normal.
The question is why the dim_item table was emptied, will it be repopulated or that data has already been lost.
Thank you very much for your support.
Isaac Velasco.