New Ranks & Badges For The Community!
Notice something different? The ranks and associated badges have gone "Star Fleet". See what they all mean HERE
Highlighted
Absent Member.
Absent Member.
517 views

SiteScope raw historical data is not available after upgrade from BAC 6.9 to BAC 7.3

Hi All,

We have the following issue, after the upgrade of from BAC 6.9 to BAC 7.3 which was finished successfully, SiteScope raw data older than one week is not available in BAC 7.3. Checking the DB confirms it, the data is not in DB.
Also "SM_RAWDATA_MEAS" value in "Data Partitioning and Purgind" (BAC 7.3) is set to 1 week and in BAC 6.9 "SM_RAWDATA_MEAS" set to 1 week. However in BAC 6.9 all SiteScope raw historical data is available.

Following those findings and in order to import the whole SiteScope historical data from 6.9 to 7.3, the "SM_RAWDATA_MEAS" value (in BAC 7.3) need to be set to "infinite" and rerun the upgrade process.

Any other ideas?

Please adivce,
thanks,
Michael

Labels (1)
0 Likes
1 Reply
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

I would think that the purging manager was not working correctly in your 6.9 installation, and as you say, I would have thought the only option is to re-import the old database, but before running the upgrade edit the management.dbo.PM_CONFIG table 'PM_RANGE, and PM_RANGE_UNITS for the SM_RAWDATA* tables to the required retention period. Otherwise as soon as the upgrade is complete the 7.3 partitioning and purging manager will kick in, and start purging data with the old PM_RANGE settings (3 months in your case).
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.