Anonymous_User Absent Member.
Absent Member.
823 views

Problem after installation SP3


Hi,

After the installation of SP3 on all our components, we notice problems
in our SQL reports.
Before all data in the data-table was also in the archivedata-table (on
which our reports are run, untill we get everything in AC) - but we now
see that certain data streams are no longer kept in the archivedata
table, but is still being kept in the data table.

For instance for URL checks. We usually keep track of percent available,
download time and connection time. However from the moment we installed
SP3 - it stopped collecting download and connection time in the
archivedata table. So we're just left with the percent available
streams.
Has the architecture of the QDB changed in some way?


--
dirkoosterbosch
------------------------------------------------------------------------
dirkoosterbosch's Profile: https://forums.netiq.com/member.php?userid=4084
View this thread: https://forums.netiq.com/showthread.php?t=46622

0 Likes
1 Reply
Anonymous_User Absent Member.
Absent Member.

Re: Problem after installation SP3


Support pointed me to this :

NETIQKB70562

Can you check this though?
select * from globalpref where name = 'ArchiveData'

Check the results from the query, the Val column should contain a value
of "1" for ArchiveData. If the Val value is "0" you will need to run
the following query against the AppManager Repository to correct this
entry:

update globalpref set val = 1 where name = 'ArchiveData'

-----------------------------------------------------------------------

However in all my 4 QDB's this value is already correct. (just keeping
track of the steps here, so other people might benefit from this)


--
dirkoosterbosch
------------------------------------------------------------------------
dirkoosterbosch's Profile: https://forums.netiq.com/member.php?userid=4084
View this thread: https://forums.netiq.com/showthread.php?t=46622

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.